Update more than one record using tableupdate

[thawatwong]

Hi,
I used local view as DataEntry,then I want to append all record in view to Mytable.I try to use TABLEUPDATE() command,but it just append one record.Have anybody give me a good suggestion? thank for all response
thawatwong@msu.ac.th

 

[Scott24x7]

Thawatwong,
While I don't use views much myself, if it works the same way, you need to specify a couple of things. First, that you are using Table buffering (either optimistic or pessimistic), and second, in the TABLEUPDATE() function, there are a number of parameters that can be passed to it. I think you need this:

TABLEUPDATE(1,.T.)

The 1 says, commit all records changed, and the .T. says, force the change. You may not need the force, but you will certainly need the 1. For other information, from the Fox command window, enter:

HELP TABLEUPDATE()

It will give you the full syntax, and what the items mean for TABLEUPDATE().

Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[thawatwong]

Thak you for your kind Scott.Your response is helpfull for me.
I used TABLEUPDATE(2,.T.), ok it's work Thank
Best Regards,
thawatwong