Exe retaining old data

[shawnwmorris]

I have built an EXE that will pull some data and put the data into some text boxes. I use this small exe to help make changes where I need to by updating some tables on my own, then recheck the values. The problem I am encountering is that when I update the tables and check the exe again the old data is still present.

If I close the exe and reopen it I still get the old data.

If I attempt to modify the form in the IDE and run the form there the new values are posted to the textboxes as they should be.

IT has been suggested that I have more than one copy of the tables but have ensured that this isn't true.

 

[Tore Bleken]

If you have included the table(s) into the exe, then the exe won't use the external tables, only the "internal" ones. These tables would then be read-only, but the error message may be overridden by your code.

 

[shawnwmorris]

I haven't included any tables in the program.

 

[Tore Bleken]

I suggest that you start both the exe and VFP at the same time. Then you can easily open the table in VFP and see if anything happens to the tables. Another thing to check, is that all the different Set values are identical in the exe and the IDE. Add a List Status To File Somefilename.txt to both programs (different file names), and compare the two files. Make sure to Use the table(s) in question first, so that you can double check that you really work with the same tables.

 

[Mike Lewis]

Are the tables buffered? And, if so, are you sure the data in the buffers is being committed?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[shawnwmorris]

The tables are not buffered.

 

[Tore Bleken]

Did you try my List Status procedure? I have read numerous cases similar to yours, and nearly all was solved that way.