Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refreshing DataEnvironment???

Status
Not open for further replies.

goatsaregreat

Programmer
Mar 21, 2001
82
GB
I have a DE that is bound to a table that is created at run-time. I have a grid on a separate form that is supposed to show the results of a query. It is within that query that I create the table. However, the DE does not seem to refresh itself. I have tried loading it by code, I've tried the DE.requery, etc... Maybe I'm putting them in the wrong order or something, but if you could help me?? I use another SQL statement to delete the table when the program closes. I know the first "search" query works, because I tested it by removing the 2nd SQL, and looking in the DB itself. I then ran the program, and the DE seemed to be updated then. It does not update during the running of the program, however. If you need more detail, please let me know.

PS. I have had success using the DE.requery before, but it does not work this time. TIA for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top