Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Updating .Null. values in a View
Versions des environnements
Network:
Windows 2000 Server
Hey,
I would like a view to insert a key value and update the views
modified field (which is .null.).
The view I have is composed of 2 free tables.
FROM Table_A LEFT OUTER JOIN Table_B ;
ON Table_A.KeyValue = Table_B.KeyValue
The view has "Send SQL Updates" checked, key fields marked for Table_A and Table _B, "SQL UPDATE" is checked as well as "Key and modified fields".
Some of the records retrieve .Null. values for table_b,
since there are no matching records in table_b to table_a.
If I edit the .Null. value in the view and move the record
pointer I get an error "Update Conflict".
Is is possible to get the View to update by inserting
the keyvalue into table_b and then updating the modified field?
I searched the thread through and through.. but can't find a solution...
thanks,
Daniel
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