Answer Questions

• kwihu.hau older scatter gather, and VFP.

  Hi; I have a form which the user fills. The info the user enters need to be added as a record in a table. In the Foxpro2.6 world I used to do this by letting the user edit empty memory vars, and then append blank / gather from memvar. I am wondering if there is a better way to do this in VFP9 I know I can use buffering then tableupdate(), but that requires that I would append blank FIRST before I let the user edit the fields. ...Show All

• JulieMcB I have a corrupted table. Is there a simple, FREE way of repairing or recovering the data?

  I have a corrupted table. Is there a simple, FREE way of repairing or recovering the data Thanks, Jim Jim, (Make sure you have adequate backups before you proceed!) What version of VFP If you know what you are doing and it's just a mismatch between the number of records in the file and what the table header says there should be the hexedit() app will let you modify the header. You might want to chec ...Show All

• Rodrigo Kassab Working Folder

  With VFP 3.0 I always checked whether the EXE folder sys(16,0) existed in the same folder as the current working folder set("default") + curdir() . If they did not match then I knew that CONFIG.FPW would not be read. So I would exit and display a message telling the user to modify their shortcut. Is there any way in VFP 6.0 and newer to make sure CONFIG.FPW is read regardless of the current folder or method used to start the program ======= ...Show All

• Danut Prisacaru Resource File is Not Valid

  What would cause this error message When launching the program from a 2nd workstation, the user gets the error message "Resource File is Not Valid". The 1st user was able to login fine. Is this an access rights issue We tried deleting the foxuser.dbf & foxuser.fpt and logging back in. Thanks for the help in advance. This error is related to VFP runtime version on client computer. I hav ...Show All

• AJMurray Additional fields in table exported to txt

  Hello, I need to output from a VFP 6 table to a text file. When I use "copy to mytext.txt delimited with ," I get an additional field before and after each of the original fields from the table. This means that in my new text file, fields 1,3,4,6,7,9,10,12,13 etc are empty fields that were not present in the table and fields 2,5,8,11,14 etc are the fields with data. Can anyone tell me how to avoid these "extra" field ...Show All

• Markus Losoi Questions regarding connecting to an ADP server

  I would like to use VFP as a frontend to reach in and pull data from our company's ADP server. I know the addressing ( IP and port ) used by the ADP client software and have administrative access on the User level ( I'm the sys admin), but am unsure where to begin. I do see a Reflection for Unix and Digital OLE control listed... is this related  The goal is to be able to automate the execution of ADP english statement scripts to extract dat ...Show All

• stwenter optimize sql

  hi i am trying to optimize my aplication and for what i have seen in the net the SYS(3054) tells me if an sql statment is optimized or not. but when i do the foloing: SELECT acodigo, edescri, afamn1, afamn2, afamn3, &campo ; , agrupo1, agrupo2, agrupo3, agrupo4, agrupo5, agrupo6, ASTOCK AS stkt ; FROM thisform.ficheiros(1,1), thisform.ficheiros(2,1), ('tabart' + ano_chr2) ; WHERE acodigo = ecodart AND tacodart = ac ...Show All

• mindserve Grids are readOnly. How do I put text in them?

  Hi there. Kind of embarrassing asking simple question when other people post such advanced requests. I am new here. I got as far as creating a form with two grids and other controls I need. There is a Pageframe that switches between pages and I have each grid on the corresponding page. All the way I am making comparisons with dBASE stuff which I hope soon will be a thing in the past. Anyway, when I run the form all rows in grids appear to be rea ...Show All

• Anvar UPDATE vs REPLACE record locking

  The VFP 9.0 Help file shows the following: UPDATE - SQL Command ,Remarks, Tip: "When updating multiple records in a table opened for shared access, SQL UPDATE uses record locking, unlike the REPLACE command." Locking Data, REPLACE: Current record and all records from aliased fields UPDATE - SQL: Entire table These statements seem to conflict. The first leads one to believe that the UPDATE - SQL command would lock records and i ...Show All

• Ayman Shoukry Importing Text File to a Table

  hi everyone, i hope somebody can help me figure out how to import a text file such as this one below and save it in a table. the 999.999.999.99 should be placed in the first column and the date should be on the second, the third which is the time should be placed in the third column, the GET should be placed in the fourth. 999.999.999.99 - - [01/Jan/2006:11:43:36 -0600] "GET /Images/Product/Sign_in.gif HTTP/1.1 ...Show All

• ashish1482 EDSETENV

  I want to set up runtime environment as far as the way memo fields are displayed in the editor. I tried to use the code I found in Help: SET LIBRARY TO EDSETENV = EDSETENV("x") First, there is no library file by this name, at least I could not find it. Second, the whole thing is not recognizable by the compiler. How do I define string "x " Do I have to write a C++ module to do it But my first concern is to make the f ...Show All

• shorinsamurai How to know where a class is being used.

  Is there a way to know where in an app a certain class is being used thx. The Code References tool can be useful here. Tamar ...Show All

• tizzdale27 =SYS(1037) on VFP90 no longer allows printer changes

  Can anyone tell me how to work around the changes in SYS(1037)   I used to call this with =SYS(1037) before printing in a batch (checks and invoices) and it no longer allows my customers to change the printer in VFP90 (no 'apply' button).  The 'prompt' option in REPORT FORM works just perfect too, but I don't want to call it in a loop (too repetative.)  Any ideas Thanks In VFP9 both the "Print" and "Page Setup" dialogs wer ...Show All

• RameshPa_MSFT Foxisapi won't launch COM application

  Here is my situation: I am running with XP PRO. http://localhost/common/Foxisapi.dll/RESET & STATUS work properly COM server is out-of-process exe COM server can be loaded directly from Fox with: o = create("bulkm.x2") o.testServer()            && This works But when I try to launch it from within IE I get "page cannot be displayed" http://localhost/common/foxisapi.dll/bulkm. ...Show All

• Azael order of table fields is reshuffled

  I want to use this occasion to thank everyone who has been helpting me with their advice. I still have to study some of the comments in depth to get the maximum out of them. HOWEVER, I just ran my first successful execution which converted a Visual dBASE table into a VFP table. I have a form with two (unrelated) tables on it and an external .prg file with a function with 170 lines of VFP source code. It all worked. Very cool! Perhaps before the ...Show All