General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Refresh table buffers
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only