Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem with TABLEUPDATE when saving an existing record
Versions des environnements
Network:
Windows 2008 Server
I have a work order form that allows users to enter work order info and to populate two child tables (via grids) in order to specify labor and materials. The form uses local views. The child labor and materials views have optimistic table bufffering set (5). The "parent" single record work order local view has optimistic row buffering set (3).
If i add a NEW work order and enter in child labor and material records, i can save the work order and its child information. However, when i try to EDIT an EXISTING record, by changing something in the labor or material grid, the TABLEUPDATE(.t., .t., "v_worklab",laError) fails with the error message of "syntax error". This is nothing else stored in the error array.
Any ideas?
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