Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending Confusion
Message
From
17/07/2000 15:07:25
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00393400
Message ID:
00393455
Views:
18
>>>>So If I only define a key field for the table I want to update in the view, that's the only table that gets an appended record? Sounds simple enough.
>>>
>>>That is correct.
>>>
>>>>Should the 'Send SQL Updates' checkbox be marked, or will that scramble my data when just browsing?
>>>
>>>Check the box. If you do not, you can define key fields and fields to update, but no updates will be sent unless you check the Send Updates box.
>>
>>Then all I really have to do is:
>>
>>SET MULTILOCKS ON
>>=CURSORSETPROP("Buffering", 3, "inventory")
>>
>>APPEND BLANK
>>
>>Then:
>>
>>=TableUpdate() &&Code in the "Save" button.
>
>Yes. Or use table buffering [5] instead of row.


Multiuser environment, so I prefer row. Is there a reason I should use table?

Thanks for your advice, Mark, I can't tell you how much I appreciate it. Hopefully someday soon I can help you with a problem (ha, ha).

Thanks again
JD
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform