Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Confused again!!!
>>
>>I have a table GROUP, w/primary key GROUPID. The primary key is assigned as the default value of GROUPID, w/a call to a GetKey( "GROUP" ) routine. Another table, PACSEA, has one or more entries w/a foreign key of GROUPID.
>>
>>I need to have the value for GROUPID before I write any records in PACSEA. This must be a common thing that people do, yet I'm having trouble figuring out the sequence.
>>
>>I am trying to use views to update both tables and am having trouble when creating a new group. Where should the GetKey call be? in the view or in the underlying table, or both?
>>
>
>I put mine in the table, and when appending a new record into a view, call the NewID function manually, and place the results in the view record. The primary key field in the view must be set to updatable for this to work.
Thanks Erik...it all works fine now, w/your suggestion. This has been bothering me for a long time and now, the solution seems so simple! J
Précédent
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