Answer Questions

• psykota Why my VFP exe file cannot be launched?

  I complied my program under VFP6 into an exe file in the program folder. But it cannot be launched. I believe there is nothing wrong with the code, because I just made a minor change. The funny thing is that if I copied the file to other folders on the same drive, it works! And even more wear is that some old version VFP exe files could not be launched from within that program folder, either. I have to copy them out to test. It only happens to VFP exe files. Other exe files are OK. It did the same with VFP9. Any idea what could be the problem Copy the files "over" from a locations where the "exe" file is working. Or just put runtime files for installat ...Show All

• Deepu.MI OleDb provider and unc path

  I make ASP page for internet access and i need to read & write data from visual foxpro tables. These tables use new fields type (of last versions of foxpro) like autointeger fields so i can't use ODBC driver. The tables aren't on the sane server where is localized the web server and i need to use the oledb provider and insert this connection string Provider=VFPOLEDB;Data Source=\\DataServer\Application\Data\;Collating Sequence=Machine When i try to access the data i receive an error : Invalid path or file name..... There are problems using OLEDB and unc path names Why there is not an updated odbc driver from Microsoft for newer versions of Foxpro ! !! ! Thanks ...Show All

• nivanov Where does the code go when adding to a grid

  My grid is programatically created. I would like to "fire" the Thisform.grditem.column1.text1.programaticChange event , however It does not exist visualy to do so. The value of the text box is altered but I do not know how to change the main table. Where would the code go My goal has been to change the value in the main table from a select statement cursor. Any help would be appreciated. Richard You are most welcome. Thanks for the help, that is exactly what I did to make it work. thanks again for your help. Richard, When you are working with a grid, you are working with the grid's underlying cursor.  (Note that a cursor ha ...Show All

• John R. Garrett REPORT FORM TO A WORD FILE

  Somebody knows how can I send an output of a REPORT FORM to a Word File. I mean a file .DOC. I have to preserve fonts, size, etc. It is to send documents by mail. Dont work only ASCII. Thanks in advance http://equeus.netfirms.com/ : Equipment for the Non-Ferrous Metals Industries Yes, FRX2Any is a shareware If you want to try a free solution, check Foxite Downloads section for newly loaded Frx2RTF solution by Vladimir Zhuravlev. It works in VFP9 only, I haven't tested it myself. if i not mistake xrftoany is a shareware. >> Somebody knows how can I send an output of a REPORT FORM to a Word File Check out XFRX at ...Show All

• Eric-NZ VFP and Word Merge

  I am adding word automation to our VFP application. I like the ease of use of Bookmarks and have no problems navigating thru a document that has existing bookmarks. My problem is that users will need to create new documents and add bookmarks into the appropriate places of the new documentation. How do I provide the user with a pick list that will allow them to insert the available bookmarks. Is this a good approach for a mail merge or have people been using word fields Stuart The drawback that you bring up is a very good one and eliminates the possibility of me using bookmarks. I will review the materials that you have indicated. Appreciate the feedback! Stuart ...Show All

• Babax Join

  Hi gurus I hope this is an easy one, what is the max join statement that you can use in one giving time Thanks guys In VFP9 the limits on JOINs has been removed. The maximum number of joins per SELECT statement is nine. ...Show All

• iceshadow625 Will VFP6 work with Windows Vista

  My company operates a series of VFP6 runtime databases successfully in the Windows XP environment. We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Can VFP6 work in the Windows Vista environment How can this problem be overcome Many thanks in anticipation. AndyKr thank you for your reply. I passed your suggestion plus another received in answer to my question to our systems administrator to test but without any luck. It very much looks as though an upgrade to version 9 is the only solution. >> We currenly have one PC loaded with Windows Vista. When the runtime ...Show All

• Andy Perkins Backup Options for newbie to VFP9

  Can someone please advise me on how to perform backups to either a CD or a memory stick from a menu choice Referring to a previous thread re the zip libraries, how would I call these libraries then actually perform the physical backup to the CD or memory stick The users want VFP9 to completely run this routine for them without any intervention except either inserting a CD or placing the memory stick in the USB. Previously, the 2.6 app used the run pkzip then copied the file to a disk drive. Thanks Sammy32 You can use an external ZIP library. Generally using an ActiveX or DLL that does the ZIP seamlessly is a better idea. I use DynaZip (See http://fox.wikis.com/wc.dll Wiki~DynaZi ...Show All

• jnquinn Convert ADO recordset to a Foxpro DBF free table

  Hi,     I currently have a need to convert an ADO recordset to a DBF. I've seen some posts here on how to create and write to a DBF using C# in conjunction with the VFPOLEDB provider. I mocked some code up in VB6 similar to the example and I am able to open the dbf in VFP6 no problem. However, I'd like to find out what ADO to Foxpro field type conversions would work. The ADO recordset comes as a result of a query from SQL Server 2000, so there are bound to be some datatypes that will not convert natively. I've come up with this matrix so far based on some MSDN Library materials.     SQL DataType              ADO DataType   &nb ...Show All

• Dragan Jankovic Expression Builder

  Hi, just a quick question on Expression Builder. I have a few Read-only textboxes on a form. The values of these textboxes are populated via a local view. Values can be either .NULL. or strings. I would like to change the DisabledBaclColor property to red when the values are NOT .NULL. I tried to use the following statement in the Expression Builder of the DisabledBaclColor property but it doesn't work. IIF(IsNULL(This.Value), This.DisabledBackColor = 16777215, This.DisabledBackColor = 8421631) The error message was "Data Type is invalid for this property". Any ideas/suggestions/comments will be deeply appreciated. Thank you, Danny. >> IIF(IsNULL(This.Value), T ...Show All

• cdolor DSN Creation

  Hello I need to create a System DSN ODBC for SQL. I have seen a lot of solutions using DSN-less solutions but that does not work for me. I have to use this DSN from a third-party application where I don't have its source code. What I want with this simple code is to execute it before the third-party application, just to change some ODBC attributes (using the same DSN name) like Server same, user, password, etc... I have been able to delete the DSN, but no Create or Modify it. I am using SQLConfigDataSource function in this way: #define ODBC_ADD_DSN 1 &&' Add data source #define ODBC_ADD_SYS_DSN 4 &&' Add data source #define ODBC_CONFIG_SYS_DSN 5 &&' Configure (edit) data source #define ODBC_REMOVE_SYS_D ...Show All

• ckrepps Visual foxpro 9 watch hang

  I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and I deleted all the directory from program file . I reinstald Visual FoxPro 9 and the same think happends. I posted a screen copy of the event to www.bluejeans.lx.ro if you want to see it. What can I do    In the watch window I tested this UPPER ( ALLTRIM ( INPUTBOX (DVDLOGIN_LOC,DVDLOGINCAP_LOC))) it permanently genereit an ...Show All

• Jon Stalnaker Transactions, buffering questions...

  Hi all! I do have a code were I open a table, store it on a cursor like: select name,surname,address from myTable into cursor myCursor readWrite and I display it on a grid. Then what I do is to let the user select a record, click on an " EDIT " button and edit the specific record (on another form), and after he clicks on a " SAVE " button to commit the changes to the table. So far everything is fine! My main problem/question is that I need this software to be a multiuser application and run over a LAN. So all the tables are shared (so the database is) and I try to use BEGIN TRANSACTION , END TRANSACTION and ROLLBACK commands. But suppose I have 2 users, user A and user B. If user A and user B are both viewin ...Show All

• GrandpaB A problem overwritting a temporary cursor

  I have the following code in a procedure that is called from a combo box. The first time trhough everything works great. when I call it a second time I get "Alias name already in use." I need to redo the temporary cursor baised on the selection of the combo box. Any ideas Thanks in advance. ThisField = ALLTRIM(CGames.DataField) SELECT date,&ThisField,ball1num,ball2num FROM btldata INTO CURSOR CGridCursor READWRITE if used('CGridCursor') use in 'CGridCursor' endif ThisField = ALLTRIM(CGames.DataField) SELECT date,&ThisField,ball1num,ball2num FROM btldata INTO CURSOR CGridCursor READWRITE Worked great thanks. I dont know why I didnt think of that so ...Show All

• yanivpinhas Cursoradapter Browse - Enter Key Doesn't Work

  Hi, In VFP8, I have a cursoradapter and do a browse. Users noticed that sometime when the edit a field it doesn't get saved. We narrowed down to discover that if you change a field value and press Enter and then Ctrl-W, the change is NOT saved. If, however, instead of pressing Enter, you mouse click on another row or cursor up/down to another row, then the change DOES get saved. Why doen't Enter (or Tab also has same behavior) followed by Ctrl-W work for saving changes Thanks, Rob I think the problem is neither with cursoradapter nor enter/tab but a coding error. CursorAdapter data is buffered, right, by default row buffered If you press Enter/Tab you don't leave the row and thus implicit tableupdate doesn't kick in. Ca ...Show All