Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New records in buffered table
Message
 
 
To
18/12/2007 20:36:58
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01276536
Message ID:
01276537
Views:
25
Not in VFP8. In any VFP version prior to VFP9, a query cannot see uncommited records. You'll have to use non-sql commands to access them. In VFP9 SELECT-SQL has a new clause WITH (BUFFERING = .T.) that tells it to look into buffered data.

>Working with MySQL I have pulled down a data set, set the Tables, etc properties and set Buffering to 5.
>
>I then APPEND BLANK and replace a couple of fields.
>
>If I then do a
SELECT * FROM bufferedcursor
the newly appended records do not show up.
>
>Is there some setting which would make these records visible?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform