Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refresh table buffers
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Refresh table buffers
Miscellaneous
Thread ID:
00358494
Message ID:
00358494
Views:
52
What is the correct method to refresh table buffers (using vfp5 and optimistic buffering)

I have an app that after it saves a record, it updates a counter in a separate table.

select emp
insert into emp (empid,name) values (thisform.text1.value,thisform.text2.value)
select status
replace status.numemp with status.numemp+1

Someone else may have already incremented status.numemp so I need to refresh the
status table buffer. It looks like I need to use CURVAL() but I'm not sure how.

Thanks for any tips!
Next
Reply
Map
View

Click here to load this message in the networking platform