[MSDE] What is the command to truncate the logs?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Upgrade Time I am finally going to get a shiny, new computer; one that was built in this millennium. The same goes with VFP. I will shortly be using VFP 9. (If you are thinking of joking that this is a sure sign that VFP 10 and 11 will be released RSN, I thought of it first. Neener, neener!) My question, which is not answered by the Microsoft Website as far as I could see, is is VFP 6 sufficient in order to order the VFP 9 upgrade? Lee Mitchell, I might have gone with VFP 9 sooner if there were a clear statement that VFP 9 development works on a Windows 98 machine. (Tying software upgrades to hardware upgrades can delay the software upgrade, something a software company should think about not doing.) Sincerely, Gene Wirchenko Tag: [MSDE] What is the command to truncate the logs? Tag: 225890
  - 2
    - VFP 9 Reports v's Crystal I have a series of reports in VFP 7 that have a large number of fields in the cursor they are based upon. Segments of these fields are printed in specific detail bands on the report. They are a little difficult to maintain and also present some paging issues. I am considering moving them to use either Crystal Reports or the VFP 9 report writer. The typical format of these reports are: report header detail band 1 detail band 2 detail band 3 report footer The data in the detail bands all have a key field that references the data in the report header and are simply linked so a query like select * from table where linknumber = header.linknumber would get the data required. Are reports like this easily implemented in VFP 9? Will I be able to get rid of my monolithic cursors? thanks Tag: [MSDE] What is the command to truncate the logs? Tag: 225889
  - 3
    - Mixed databases I have a free tables database in my application (currently in VFP 7). I need to integrate the application with another application that uses an SQL/Server database. I will need to execute some queries and stored procedures on the SQL database. Can I do that from VFP 7 or do I need to move to VFP 9? thanks pete Tag: [MSDE] What is the command to truncate the logs? Tag: 225888
  - 4
    - VFP 6 (and ?): Lazy Parsing I just corrected a bug where VFP could have parsed better. I had a do case. Somehow, I left off the case keyword on the two cases. There were no compilation or run-time errors. Here is the corrected code with the correction in caps: do case CASE cwhoshad.stnbusy="L" busymsg="Station is busy (Local use)." CASE cwhoshad.stnbusy="R" busymsg="Station is busy (Remote use)." otherwise busymsg=; "Station is busy. The access type is unknown ("+cwhoshad.stnbusy+")." endcase Shades of * This is a comment; ? "and so is this." Sincerely, Gene Wirchenko Tag: [MSDE] What is the command to truncate the logs? Tag: 225887
  - 5
    - Searching for a good ARJ and PAR compression activex or dll Hi, I would like to add ARJ and PAR to our VFP based backup software. All the stuff I've found on google so far has been C++ libraries or stuff for Borland Delphi etc. Thanks Tristan BackPack Product Manager www.backpackpro.com Tag: [MSDE] What is the command to truncate the logs? Tag: 225886
  - 6
    - How to enable Print Preview in Editing Window and Form Designer? I'm using Visual FoxPro 9 SP1. How can I enable Print Preview in Editing Window and Form Designer? Thanks. Tag: [MSDE] What is the command to truncate the logs? Tag: 225882
  - 7
    - DBSETPROP - IdleTimeout documentation error? Hi there, I'm comparing the MSDN for DBSETPROP "IdleTimeOut" to the tooltip that comes up in the IDE. MSDN says that the value is in minutes, but the tooltip says the value is in seconds. Tag: [MSDE] What is the command to truncate the logs? Tag: 225881
  - 8
    - strange behaviour - MODIFY FILE VFP8 SP1 I have an error handling routine I would like to popup a box that the user can type into to say what they were doing at the time of the error. The file is then emailed to us. When the MODIFY FILE command finishes I get this message "Session number is invalid" repeated many times CANCEL IGNORE & HELP buttons are available, cancel fixes the problem and the email is generated. cReasonFile = TRANSFORM( INT(rand()*10^8) ) + ".txt" STRTOFILE(CRLF + CRLF + CRLF + "[Please include a brief description of how the error occurred]", cReasonFile) MODIFY FILE (cReasonFile) *** Seems to occur here after the Modify completes but before the fileToStr() executes. cReason = FILETOSTR(cReasonFile) ERASE (cReasonFile) If I use the debugger to step through the code the problem doesn't occur. The only way I have been able to determine where the error occurs is through "wait window ..." Any ideas - I am stumped, it could be the error being reported is wrong. Tag: [MSDE] What is the command to truncate the logs? Tag: 225867
  - 9
    - SQL result difference between VFP8 and VFP9 CREATE CURSOR cur1 (field1 c(1) NULL) INSERT into cur1 VALUES (.Null.) SELECT field1 as field2, field1 from cur1 INTO CURSOR cur2 VFP 8 shows field2 - blank field1 - .Null. VFP9 shows field2 - .Null. field1 - .Null. Any setting can fix it? Tag: [MSDE] What is the command to truncate the logs? Tag: 225865
  - 10
    - Using Setup Wizard 6.0 Using Setup Wizard (VFp 6.0) how do i create a Desktop icon to run my application and also to place it on the Start Menu (i.e Start...>Programs...> MyApp). plz help. Tag: [MSDE] What is the command to truncate the logs? Tag: 225863
  - 11
    - problem with Fsize Fsize() returns an error "File does not exist" for hidden files Tag: [MSDE] What is the command to truncate the logs? Tag: 225861
  - 12
    - Add money to your Paypal account with OPRAH Hlt8* Read this message until the end, and you will find out how the money flows in easy !!!!. Follow the steps and it WILL work. Trust me !!!!!. It's NOT illegal and it is NOT a scam !!!!!. PROVEN ON OPRAH! Reported in the Wall Street Journal!!!! The only thing you need is : - E-MAIL ACCOUNT - PREMIER (FREE) or BUSINESS PAYPAL ACCOUNT - $6 on this account (The only investment) - 30 minutes of your time There is no limit on how much money you can recieve, and you haven't got anything to lose with this Business program. I will explain how it works !!!!!. Follow these 4 easy steps and it WILL work !!!!!. STEP 1 : SIGN UP FOR A FREE PAYPAL ACCOUNT !!!!!. Paypal is a free and safe way to pay and receive money on the Internet. Creating a account is as easy as creating a MSN account. Copy and paste the next line in your Internet browser and sign up. HTTP://WWW.PAYPAL.COM Be sure to sign up for a FREE Premier or Business account and not for a Personal account. You cannot receive CREDITCARD payments with a Personal account and we can't have that. Do we !!!!!. STEP 2 : SENT $6 TO YOUR PAYPAL ACCOUNT This is your only investment to receive the money with ease. With your Paypal account, send $1 to each e-mailadres listed below. !!!!! IMPORTANT !!!!! Be sure to use this SUBJECT : *PLEASE PUT ME ON YOUR EMAIL LIST* when you send the money. 1) martine@pilote.net 2) dexxatol@netcourrier.com 3) armygirl8568@hotmail.com 4) comjii@starband.net 5) sinnek@bellsouth.net 6) nsi@nelasat.com STEP 3 : PUT YOUR E-MAIL ADDRESS ON THE BOTTOM OF THE LIST After you have send $1 to each e-mail address, put your e-mail address on the 6th place. Remove e-mail address number 1, and move each e-mail address 1 step up the ladder. !!!!! IMPORTANT !!!!! BE SURE THAT THE E-MAIL ADDRESS YOU USE IS THE SAME AS YOU USED TO SIGN UP AT PAYPAL. Remember that this is LEGAL. You are creating a service : an e-mail servicelist. STEP 4 : UPLOAD OR COPY THIS MESSAGE TO NEWSGROUPS, FORUMS ETC AND EMAIL IT TO ALL YOUR FRIENDS! There are 32,000 newsgroups. Upload or copy this message to at least 200 newsgroups or forums etc, but ........ remember that the more your upload the more people will see your message and the MORE MONEY WILL FLOW IN. How to upload to newsgroups and forums? : After you have followed step 1,2,3 and 4, save this message (and copy so you can use it again). Use your Internet browser and Outlook Express or another newsreader and try to find FORUMS, NEWSGROUPS, BULLETIN BOARDS, DISCUSSION GROUPS, CHAT SITES and ONLINE COMMUNITIES. Use GOOGLE or use a NEWSERVER. Use every option to post this message. Download PostXpert to send 1 message to more NEWSGROUPS at the same time. !!!!! REMEMBER !!!!! The more you post this message the more MONEY WILL FLOW IN. Why does this Business program work so well !!!!!. Lets asume that from the 200 (or more) messages that you have posted, only 5 people respond, you will have your $6 back that you have invested. Those 5 people will each send at least 200 messages with your e-mailadres on number 4. That's 6 x 6 x $1 = $36. The next 25 people will also send 200 messages with your adres on number 3. That's 36 x 6 x $1 = $216. The next 216 people also send 200 messages with your name on number 2. That's 216 x 6 x $1 = $1296!. Those 1296 people again also send 200 messages with your name on number 1. That will give us a total of 1296 x 6 x $1 = $7,776. Now the last tier! 7776 x 6 x $1 = $46,656!!!!!! This is only a EXAMPLE with 6 reactions. You WILL get MORE responses than that. Remember that most newsservers will leave the posted messages on there servers for about 2 weeks. If you will post your message again, it WILL again start from the beginning. So you can repeat this over and over again. Everyday MILLIONS of people are ONLINE and reading these messages, JUST LIKE YOU RIGHT NOW. I also was sceptical in the beginning and have read a lot of these messages. I also thought that it was bullshit. Until I thought : What the hell!, only $6. What's $6 and a couple of minutes of my time to solve my money problems. !!!!! REMEMBER !!!!! Follow every step, and IT WILL WORK, TRUST ME. !!!!! !!!!! BEST WISHES AND GOOD LUCK !!!!! w)O>+;)<9UVS;F>qaGL<Uq#v`V6(F]- rM;$g+!4IIQ*827?H4 Tag: [MSDE] What is the command to truncate the logs? Tag: 225860
  - 13
    - Who has file open in Netware Hi, I need to know who as a particular file open. The file is on a Netware server and it's possible that several users have the file open at the same time (not exclusively of course). Gplib used to be great for this but AFAICS there is no version of gplib for VFP. Any ideas how to do this? Thanks, Frank Tag: [MSDE] What is the command to truncate the logs? Tag: 225855
  - 14
    - Usability question? Hi, I'm developing multiple projects in VFP 9.0 and I'm wondering if it is possible to have a shortcut on my desktop that launches a specific project in the development environment? That way I could have a shortcut to each project that would have the correct startup folder and all. Does that make sense? Is it possible? How do you handle developing multiple projects on the same system? Thanks in advanced, Linn Tag: [MSDE] What is the command to truncate the logs? Tag: 225851
  - 15
    - print with word97 I have an exe I think was originally created in vfp 5 , has been upgraded to 8 and then to 9. It creates a word document and populates it with variables created in same exe. The problem is it will only print correctly if word 97 is the only version of word on the computer running it. The part that doesn't print properly is a variable that uses chr(13)+chr(10). The newer versions of word do not have the carriage return . Only a space. I don't know what to look for ? thanks sherry Tag: [MSDE] What is the command to truncate the logs? Tag: 225843
  - 16
    - Connection Handle Disconnect? This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6BFE4.B675A5D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I am creating a connection to MySQL with the code below and using it in = my CursorAdapter classes. lnConnectionHandle =3D SQLSTRINGCONNECT(lcConnectionString,.T.) Testing the application, I noticed that if I left one of my forms open = without any user activity for some period of time the connection gets = lost. What am I missing here? --=20 Edhy ------=_NextPart_000_0006_01C6BFE4.B675A5D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am creating a connection to MySQL = with the code=20 below and using it in my CursorAdapter classes.</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2> <P>lnConnectionHandle =3D </FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2>SQLSTRINGCONNECT</FONT><FONT face=3D"Courier New"=20 size=3D2>(lcConnectionString,.T.)</P></FONT></DIV><FONT face=3DArial = size=3D2> <DIV>Testing the application, I noticed that if I left one of my forms = open=20 without any user activity for some period of time the connection gets=20 lost.</DIV> <DIV> </DIV> <DIV>What am I missing here?</DIV> <DIV><BR>-- <BR>Edhy</DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C6BFE4.B675A5D0-- Tag: [MSDE] What is the command to truncate the logs? Tag: 225825
  - 17
    - How to import data from text file created from List Memory or Obje I want to import data from text files created from List Memory or List Object in VFP SP1. Is there any tools available for such import? Thanks Tag: [MSDE] What is the command to truncate the logs? Tag: 225821
  - 18
    - VFP How do I determine table buffering setting. I want to be able to determine if cursorsetprop has been used to set buffering to something besides 1 for a free table. How do I do that? Help says you can find out by using cursorsetprop but doesn't tell how. Tag: [MSDE] What is the command to truncate the logs? Tag: 225812
  - 19
    - Case studies in VFP Trying to submit a case study to MS, The Case study is for a 80GB 100% pure VFP 9 application. The site is not very helpful. Anybody know the procedure? Thanks Mohammed Tag: [MSDE] What is the command to truncate the logs? Tag: 225799
  - 20
    - Clipper to VFP Anybody done this? What should I be aware of? Is it easy? Used to use Clipper as a compiler for dBase, did some programming in it when they broke away, Lost track of it over the years. Any and all information, Tips etc would be greatly appreciated. Thanks Mohammed Tag: [MSDE] What is the command to truncate the logs? Tag: 225798
  - 21
    - The buffer overrun problem I encounted. It's the projecthook class. If I unhooked it, nothing would go wrong. If I ever tried to hook it up again, it would keep crashing even if you unhooked it after a failed compile. It seemed that the project builder would remember something that could bring about the crash. I believe my codes in projecthook.beforebuild and projecthook.afterbuild are clean and simple (mainly about hacking the report forms). Even if I just added some comments into these 2 events, the compile would still crash. -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 12:22:01 up 5 days 17:18 0 users load average: 1.11 1.10 1.07 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: [MSDE] What is the command to truncate the logs? Tag: 225794
  - 22
    - Indexing a table on multiple fields with a date field in descending order I have a table with the following fields: id, date, testrecord. What I want to do is to order the table so that the records are ordered as follows: id by date by testrecord. I want id to be in ascending order, but date and testrecord in descending order. I created an index file called testdata with the expression: id+dtoc(date,1)+testrecord. Id and testrecord are character fields.This index file will sort in ascending order. My question is: what do I need to do to get the table sorted as I want it - that is id in ascending order, but date and testrecord in descending order? Tag: [MSDE] What is the command to truncate the logs? Tag: 225790
  - 23
    - If I was to submit the test case Could I request M$ to sign an Non-Disclosure Agreemnt? :) Ok, I knew our stuffs aren't that mission-critical, but ....it's still my company's property. -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 22:12:01 up 5 days 3:08 0 users load average: 1.02 1.03 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: [MSDE] What is the command to truncate the logs? Tag: 225786
  - 24
    - Winsock Control Help Thanks in advance for the help. I'm trying to build messaging into my app using the Winsock control and there is something that I don't quite understand. I need each instance of the app to act as both a client and a server so that it can receive messages from anywhere and so that it can send messages to anywhere. Do I need two controls? Do I listen and send on different ports? Has anyone ever built this type of app using this control? Thanks, Jeff Tag: [MSDE] What is the command to truncate the logs? Tag: 225769
  - 25
    - Confused by sample code Hello and thanks for the help. I am looking at some sample code which works but there is an element of the syntax which is confusing. The code is: ThisForm.tcpServer.Object.LocalPort = 1001 ThisForm.tcpServer.Object.Listen where tcpServer refers to an instance of the Winsock control. Why is the .Object in this code? What is the difference between Thisform.tcpServer.Object.LocalPort and Thisform.TcpServer.LocalPort? Thanks again, Jeff Tag: [MSDE] What is the command to truncate the logs? Tag: 225764
- Next
  - 1
    - Append general error Just trying to append a .jpg file and get an error I haven't had before. When using Append general photofield from temp.jpg I get "OLE error code 0x80070002. The system cannot find the file specified" Is there something wrong with my VFP9 installation? ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: [MSDE] What is the command to truncate the logs? Tag: 225758
  - 2
    - Sending Control G to serial port In the code below I want to send CTRL G as the output. How do I do it or what is the code I need to enter. ***Program code*** PUBLIC ComForm ComForm = CREATEOBJECT('Form') ComForm.AddObject("Testcom","Olecontrol","MSCOMMLib.MSComm") ComForm.Testcom.CommPort = 2 && Use Comm2, The second Serial Port. ComForm.Testcom.Settings = "14400,N,8,1" && 14.4 Kbaud, No Parity, && 8 data Bits, 1 Stop Bit ComForm.Testcom.PortOpen = .T. ComForm.Testcom.Output = "ATDT555-1234" + chr(13) && Dialing the number * The chr(13) is needed to complete the modem command sequence ComForm.Testcom.PortOpen = .F. ***** End Code ***** Rusty Tag: [MSDE] What is the command to truncate the logs? Tag: 225751
  - 3
    - TIF Files I have been using the kodak image viewer to open TIF files from my foxpro applications and it has been giving me memory errors since the last patch to Windows XP. Kodak image viewer is no longer supported. I was wondering if anyone else had another view they were working with. I have Adobe 7 but have not figured out how to initiate the program from within Foxpro. Any ideas? Tag: [MSDE] What is the command to truncate the logs? Tag: 225745
  - 4
    - Converting Tabs to Spaces Does anyone know of command to convert Tabs into Spaces? of course a STRT will do the trick, except for the tabs that are less than the characters specified in the STRT. There is a VB command which I've seen referenced although I don't know if it will address the problem above. Edit.ConvertTabsToSpaces -- Thank You, Louis Tag: [MSDE] What is the command to truncate the logs? Tag: 225744
  - 5
    - Need URGENT help with interactivechange with 2 combo boxes I am unable to change selection in 1st combo box when I try to clear the value of the 2nd combo box in the interactivechange area. Here is a little better explanation: I have 2 combo boxes on my form. Both combo boxes get populated using a select statement. Everything worked fine until I decided that I want to clear the value of the second combo box if the first one changes to force the user to make a new selection so I put this in the first combo box in the interactivechange event: thisform.cmbBox2.value = "" Now when you try to change the selection in the 1st combo box, the 2nd combo box does get cleared, but the first combo box doesn't change like it is supposed to. When I remove this line from the interactivechange event you can change the 1st combo box and the new selection appears. What am I missing? Is there another way to force them to make new selections in corresponding comboboxes when one changes the primary one? Thanks in advance for any help you can give me. Tag: [MSDE] What is the command to truncate the logs? Tag: 225741
  - 6
    - Damaged/Corrupted DBF I have a corrupted .dbf file that can not be opened. What are my best options for getting this file repaired? The file does not have a .fpt associated with it. I know there are many utilities that can be purchased, but which one. I can't believe Microsoft hasn't included a utility to repair damaged files within VFP. I don't like the thought of paying $199 for a utility that I almost never need. I have this one client that seems to come up with a damaged file every six months or so. Any clues of why this is happening? They are running the application off of a Citrix server, meaning it is accessed via Citrix and actually loaded on the Citrix server. I have many apps that have been running for years and years without any corruption? All my apps are running on file servers? VFP9 / Windows XP Tag: [MSDE] What is the command to truncate the logs? Tag: 225738
  - 7
    - Speaking of code generator using Foxpro... Mr. Ed Leafe didn't use Foxpro to generate python codes for his Dabo Framwork as well.. :) I wondered whether Dabo could generate PHP code.... -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8 ^ ^ 21:18:01 up 3 days 2:14 0 users load average: 1.01 1.02 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: [MSDE] What is the command to truncate the logs? Tag: 225734
  - 8
    - How to get the complextype data return from a web services? Hi I am actually testing how to use web services using VFP8. I have written a sample code (see below) to consume the web service on the link below: http://www.webservicex.net/WS/WSDetails.aspx?CATID=12&WSID=64 --------------------------------------------------------------------------------------------------------- LOCAL oWS AS "XML Web Service" LOCAL loGeoIP TRY oWS = CREATEOBJECT("MSSOAP.SoapClient") oWS.MSSoapInit("http://www.webservicex.net/geoipservice.asmx?WSDL") loGeoIP = oWS.GetGeoIPContext() CATCH TO oErr MESSAGEBOX(oErr.Message) ENDTRY IF VARTYPE(oWS) = "O" RELEASE oWS ENDIF --------------------------------------------------------------------------------------------------------- The method GetGeoIPContext() return a complextype GeoIP. Below is the GeoIP extract portion from the WSDL file. - <s:complexType name="GeoIP"> - <s:sequence> <s:element minOccurs="1" maxOccurs="1" name="ReturnCode" type="s:int" /> <s:element minOccurs="0" maxOccurs="1" name="IP" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="ReturnCodeDetails" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="CountryName" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="CountryCode" type="s:string" /> </s:sequence> </s:complexType> Does anyone know how to extract the complextype data in VFP8? Appreciate your help. Tham Tag: [MSDE] What is the command to truncate the logs? Tag: 225720
  - 9
    - How to determine the input method for the textbox control? Hi I have a PC with a barcode scanner and keyboard attached to its PS/2 plug using the Y cable. In my VFP8 application, I want to control the type of input method for a textbox control in a form. That means that I want the data to be input to a textbox control ONLY from the barcode scanner, NOT from the keyboard. Is there a way to determine or control the input method for textbox control? Appreciate your help. Tham Tag: [MSDE] What is the command to truncate the logs? Tag: 225718
  - 10
    - License If I bought Visual Foxpro via Amazon.com from Hong Kong, is the license valid? Not many shops in Hong Kong sell VFP... -- SoftMedia Technology Co., Ltd. Website: http://www.softmedia.hk Tel: (852)2743 4228 * TryEasy Accounting/POS/Trading/ERP solutions Tag: [MSDE] What is the command to truncate the logs? Tag: 225717
  - 11
    - project file The project that I have been working on for some months loads fine in the vfp 9 ide. It looks like all the forms and code are present. When I try to build the project it says the memo file, name.pjt, is missing or invalid. I see that yes, the file is present where it should be. Is there some way that I can regenerate this file? Tag: [MSDE] What is the command to truncate the logs? Tag: 225711
  - 12
    - Need help with combobox Hi everyone. I need some help with using a drop down combobox. I have a table (physicians) that contains physician's names and phone numbers. I want to be able to create a drop down menu where users can click on the drop down menu and select the physician. Once the usr selects the physician, I want a text box to display the physician's phone number automatically. How would I go about doing this? I am using VFP 8 with SP2. Thank you in advance. Arvin Tag: [MSDE] What is the command to truncate the logs? Tag: 225710
  - 13
    - VFP 9 Local Drag and Drop Is there a way to drag the contents of a control on a form to another control? IE. drag contents of a textbox to another textbox. My specific need is to drag the contents of a cursor cell to a cell in another cursor. I have gotten it to work using a right click to copy and then paste but would like it to be a little more elegant. Jim Tag: [MSDE] What is the command to truncate the logs? Tag: 225705
  - 14
    - SBT/Vision Point 10 with VFP 6.0 Anyone out there using SBT/Vision Point 10 in Windows XP, along with Visual FoxPro 6.0 (actually, any version of VFP)? My client has source, and I'm doing extensive revisions to non-Laser printing output, bypassing the Report Generator code and the .FRM/.FRX files, and getting FoxPro "C0000005" error. Researched that on Google, found only one guy who seemed to really know anything about it, and he suggested downloading the latest Service Pack (SP5) which I did. Still, no joy. Wondering if anyone else is doing something similar. Many thanks for your input. Tag: [MSDE] What is the command to truncate the logs? Tag: 225702
  - 15
    - VFP build version Hi, Is there a way to find what version of VFP I used to build an executable? I'm sure I've seen an (MSDN?) article on it before, but can't seem to find it anywhere. Any help much appreciated. Tag: [MSDE] What is the command to truncate the logs? Tag: 225700
  - 16
    - VFP 9: Help with sending/receiving XML via FTP Hello, Looking for resources which will help me understand XML via FTP. The same application is used by both the sender and recipient. Here is what I do (sender): Insurance claim is created (single record). The record is converted to XML. The XML file is uploaded to specific FTP directory for the specific insurance company. At the other end (recipient): Recipient checks FTP folder for contents. Recipient is prompted to download the claims. The claims are downloaded and exported to table. Confirmation is returned to sender. I have the concept of how it will work, but I need a good book or suggestions from you on how to actualy deploy the idea. Thanks for the input. JD Tag: [MSDE] What is the command to truncate the logs? Tag: 225698
  - 17
    - Running BAT file via ShellExecute I kick off a BAT file from within my VFP7 app with something like this... lcPath = "C:\MyPath" lcFile = "MyFile.BAT" CD (lcPath) ShellExecute( 0, "open", lcFile, "", "", 2 ) All works OK. However, if lcPath has a value of [\\MyPC\c\MyPath] the ShellExecute doesn't seem to work. SYS(5) + SYS(2003) return the expected value of [\\MyPC\c\MyPath] at that point. FILE(lcPath + "\" + lcFile) returns .t. Any ideas? Brian Tag: [MSDE] What is the command to truncate the logs? Tag: 225684
  - 18
    - Serial Cash register drawer I posed this issue before and was steered to the microsoft site for using mscomm32 to send output to a serial port. The cash register is on com1 and the drawer opens pressing CTRL G. Can I just save the code below as a program. Call the program at the time the receipt button is pressed and edit the following code to read as follows to work? ComForm.Testcom.CommPort = 1 ComForm.Testcom.Output = 7 ( the appropriate code to send the CTRL G to the serial port?) ComForm.Testcom.Settings = "9600,N,8,1" Do I have to run the setup tool and include the mscommlib for the application to work for my customer also? ***Program code*** PUBLIC ComForm ComForm = CREATEOBJECT('Form') ComForm.AddObject("Testcom","Olecontrol","MSCOMMLib.MSComm") ComForm.Testcom.CommPort = 2 && Use Comm2, The second Serial Port. ComForm.Testcom.Settings = "14400,N,8,1" && 14.4 Kbaud, No Parity, && 8 data Bits, 1 Stop Bit ComForm.Testcom.PortOpen = .T. ComForm.Testcom.Output = "ATDT555-1234" + chr(13) && Dialing the number * The chr(13) is needed to complete the modem command sequence ComForm.Testcom.PortOpen = .F. ***** End Code ***** Rusty Tag: [MSDE] What is the command to truncate the logs? Tag: 225682
  - 19
    - vfp 2.6 Getting user name from machine Does anyone know if it is possible to get the user name from the machine in Visual FoxPro 2.6? I have a routine I use in versions 6.0 and up, but it won't compile in 2.6 : lpbuff = space(40) declare long GetUserNameA in advapi32.dll string @ str1, long @ lval kint = GetUserNameA(@lpbuff, 25) ? lpbuff clear dlls TIA, Marc Miller Tag: [MSDE] What is the command to truncate the logs? Tag: 225675
  - 20
    - Detecting an Excel File Hello and thanks in advance for the help. This may be the wrong place for this question but if anyone has any ideas I'd be grateful. I am working with Excel spreadsheets and using the following code to open a spreadsheet: oExcel = CREATEOBJECT("Excel.Application") && Start Excel oExcel.Workbooks.Open(lcSpreadsheet) where lcSpreadsheet contains the name of the spreadsheet file. The problem is that these are uploaded files and sometimes they don't upload Excel files even though they are supposed to. Sometimes this code is executing on my web server which doesn't like Excel file open errors. My question is: 1. Is there a way to detect whether or not a file is an Excel spreadsheet before calling Workbooks.Open? Thank you very much. Jeff Tag: [MSDE] What is the command to truncate the logs? Tag: 225662
  - 21
    - Update Views problem I use a view to fill a grid. To add an additional row in the grid I provide a button on the form which adds a row in the view, enters some predefiened data and send an update to the view with: =TABLEUPDATE(1,.t.,'view') and put the focus onto the grid. After entering data, closing the form, reopening it again the predefined data are there but the manually entered data are lost! In the grid in every text and combo box I put in the Valid Methods the code: =TABLEUPDATE(1,.t.,'view') The problem occurs only if a new row is added to the grid/view. Please could someone give me an advice how to avoid the data loss. Wolfgang Tag: [MSDE] What is the command to truncate the logs? Tag: 225661
  - 22
    - PS file generation error after VFP8 upgrade to VFP9 Hi All, After i upgrade from VFP8 to VFP9(with SP1), the Adobe Distiller can not convert the ps file to pdf successfully. The problem is due to the ps files store the printer setting. I have fixed it by checking "Printer Environment" in every report forms, (since all report forms are checked it in VFP8), however, it is too time consuming. Any other methods to solve it? many thanks! Tag: [MSDE] What is the command to truncate the logs? Tag: 225651
  - 23
    - Keeping Focus in a TextBox I have a textbox at the top of a form and a grid below. I want to stay in the textbox and enter data - hit return and update the grid - and then go right back to the textbox. Don't want to leave it until I click out of it. I use valid to test the data in the textbox and return(.t) just after updating the grid. If not valid I return .f. and tell the user and the focus stays in the textbox. I want it to stay there even if I return .t. Return .t causes focus to go to the next object. I don't want that. When the user is done entering data and updating the grid data then they can click out of the textbox. Using VFP 9. XP Pro. Any Ideas would be very appreciated. TIA Tag: [MSDE] What is the command to truncate the logs? Tag: 225648
  - 24
    - Table Sorting / Indexing VFP9 I want to sort a table by the 'Group' C(20) and the 'Total' N(12,2) fields . How can I sort the table by group+total. There many duplicate groups and within the group I want it sorted by total. The totals range from .01 to 100.00. Thanks Tim Tag: [MSDE] What is the command to truncate the logs? Tag: 225645
  - 25
    - Insertion point, active window highlight: not I've got a situation in which the vfp insertion point is not visible and the title bars of active windows are no longer highlighted. This has nothing to do with set cursor or sys(2002), but it *may* be related to the fact that I have a large number of tables open (aprox 110) and some of those tables have a large number of fields (eg 250) with an index tag on about every field. Has anyone else seen this? -Lew Tag: [MSDE] What is the command to truncate the logs? Tag: 225639

The size of my database is growing. There is no need to backup anything
and I could stop the server anytime.

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 19:04:01 up 10 days 0 min 0 users load average: 1.02 1.02 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

Top

Re: [MSDE] What is the command to truncate the logs? by Graham

Graham
Thu Aug 17 11:40:29 CDT 2006

Isn't there a DBCC SHRINKFILE command you could use?

"Man-wai Chang" <toylet.toylet@gmail.com> wrote in message
news:Ob3tX0ewGHA.2232@TK2MSFTNGP05.phx.gbl...
>
> The size of my database is growing. There is no need to backup anything
> and I could stop the server anytime.
>
> --
> .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
> / v \ Simplicity is Beauty! May the Force and Farce be with you!
> /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
> ^ ^ 19:04:01 up 10 days 0 min 0 users load average: 1.02 1.02 1.00
> news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

Top

Re: [MSDE] What is the command to truncate the logs? by Man-wai

Man-wai
Fri Aug 18 08:14:10 CDT 2006

Graham Dobson wrote:
> Isn't there a DBCC SHRINKFILE command you could use?

The size of the two files didn't quite shrink...I used:

dbcc shrinkdatabase("tryeasy_db", TRUNCATEONLY)

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 21:13:01 up 11 days 2:09 0 users load average: 1.00 1.01 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

Top