Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Command buttons
Message
 
To
09/11/1999 14:44:23
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00288729
Message ID:
00289199
Views:
26
And that syntax error would be?????????????????????

>When I use TableUpdate(1, .T., 'MyTableName') in the click event, I get a syntax error.
>
>
>
>>Ok, this is the quick overview.
>>
>>Unless you use buffering VFP tables get updated as soon as you change them. IOW if you bind a textbox to a field in the table, and change the contents of the textbox the field value gets changed. Putting code in a save doesn't do anything because it's already saved.
>>
>>You will need to use table buffering to be able to save and revert changes the user makes on a form. Buffering just means that the changes made on the form are temporarily held in memory until you tell VFP to save the changes to the table.
>>
>>Try this. Go into the DE for you form. Change the BufferModeOverride for your table to 5-Optomistic Table. Now in the OK button click put TableUpdate(1, .T., 'MyTableName'), in the Cancel button put TableRevert(.T., 'MyTableName)
>>
>>TableUpdate tells VFP to flush the changes in the buffer to the actual table (ie. Save the changes). TableRevert tell VFP to discard the changes in the buffer (ie. Cancel the changes).
>>
>>Look TableUpdate and TableRevert up in the help to see what they do and what the parameters mean.
>>
>>I know it is confusing now, was for me to when I tried to learn it. John's article is excellent, and should help you understand how buffering works.
>>
>>hth
>>
>>>I read the article - still a bit over my head. Didn't know about the example; I'll get it now.
>>>
>>>JD
>>>
>>>
>>>>Did you read the article on Buffering here on the UT? Did you download the DESI example?
>>>>
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform