Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Table Buffering
Message
From
03/10/2001 15:14:41
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
03/10/2001 15:02:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00563798
Message ID:
00563805
Views:
23
>Can someone please tell me if there's a way to use information that has been stored in a table, but not yet committed. In other words, if I have a table that is buffered and I add records with quantities, then I do a SQL - SELECT for a sum of quantities, I only get quantities BEFORE buffering has been turned on. Actually, I want quantities (INCLUDING any changes which haven't been committed)...And, I need them before doing a TABLEUPDATE b/c I still want option to revert table to original state.
>
>I'm sure there should be a way, but can't figure it out.
>
>Thanks,
>
>Victor

Victor,

Are you using views based on the table? The view would contain the uncommitted changes prior to a TableUpdate. FYI, if you're using record-level buffer an update will occur if the record pointer for the view changes.

If you're not using a veiw then someone else will need to jump in here...

Renoir
Previous
Reply
Map
View

Click here to load this message in the networking platform