Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Table won't update from view
Hi,
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.
Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement