Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select-sql on a modified view doesn't show changes!?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00312560
Message ID:
00316059
Views:
20
>I'd be very interested to get a general view on this behaviour... the fact that 'Workarounds' have to be employed indicates a good reson for defining this as a 'Bug' rather than a 'Design Feature'
>
>regards,
>

Gerard,

I would disagree with you on this. SQL SELECT is supposed to get data from the table on disk, the result set is supposed to reflect the data in the table at the time of the SELECT execusion. Buffered changes have not been committed to the table (they may ultimately be committed or rejected) and therefore cannot be considered as the values in the table.

If the SELECT were to use the buffered data then two stations could run the same SELECT statement at the same time and get different results. I wouldn't call this a bug at all.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform