General information
Category:
Coding, syntax & commands
Don't buffer the tables when using views, since views are really just a buffer for your tables. If you buffer your tables, you will need to issue 2 TableUpdate(), one for the view (first) and one for the tables (second). It's best just to open the table unbuffered and to issue a single TableUpdate() in the view.
HTH
>I am using a view that gets data from two tables and when I update it does not get to the table. Both tables have buffering enabled. The view has the SQL update checked and the fields that need to be updated are also checked. On the form the buffermode is set at 2 - Optimistic and the DE on the form has the bufferoverride set at 5 - Optimistic table. This form actually has two views associated with it the payment views updates just fine but the trip info doesn't. The payments are in a grid and trip info is in various text and edit boxes. The code to update is the same:
>Select lv_name
>=tableupdate()
>Select tablename
>=tableupdate()
>
>I really don't know why one view would send the update thru and the other doesn't. one other thing while I was trying to track this down I put in a getfldstate on one of the fields for the trip info and
>I get back a 1 even when I chage the field.
Previous
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