Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select SQL doesn't see the data changes
Message
 
 
To
03/05/2005 14:29:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01010567
Message ID:
01010570
Views:
19
Don't seem to make a difference :(

>Try sys(1104) or FLUSH FORCE
>
>>Hi everybody,
>>
>>I'm running into the problem, where Select SQL doesn't see updates.
>>
>>Here is the scenario:
>>
>>One form with private DS calls another very complex form with private DS. The user makes changes on the second form. As long as changes saved, the first form should be refreshed. Originally I was using views and everything worked. I switched to using direct select sql commands and now my data are not refreshed properly. However, then I close the first form (the whole application) and re-start it, I see data refreshed.
>>
>>What can I do to rectify the problem? We're going to switch to VFP9 in few days, but presently we're working with VFP8.
>>
>>Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform