Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I have a view open in the DE made up of 3 tables. If I append a new record, but only enter data for one of the tables and issue a tableupdate(), what happens.........?
>>1. Just that table gets a record appended
>>2. all tables get records appended, two of them blank
>>3. update errors occur
>>
>>Thanks
>>JD
>
>If you make all 3 tables updatable and have defined Key field for all three, then all 3 get a new record. So, however many of the tables in the view you have defined a key field for get updated.
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.
Should the 'Send SQL Updates' checkbox be marked, or will that scramble my data when just browsing?
Précédent
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