Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have two table in the database environment with a relation set between them I have row buffering on one and table buffering on the other. With each of the tables I have a stored procedure in the database that check each table to check that certain fields are completed in each of the tables. The problem that I am having is that when I go to add a new record the stored procedure fires. On the clients table I append a new record which get an id from a stored procedure and then I insert into the orders table the id from the clients table plus it puts in an id also from the stored procedure. After some checking out I have discovered that the apparently the relation is causing me the problem. Would it be best to delete the relationship append the record and after I save reestablish the relationship. Thanks
Previous
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