Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Essentially I have a form which are tied to several tables. For instance I have an orders and client table which are related thru clientid id. When I want the user to add a new record I do the following. I add a new record to the client table which get an id from a stored procedure in the dbc. Then I do an insert into the orders table replace the clientid in the orders with the id from the clients table. There is also a stored procedure in the orders table that put in a new id in the orders table that for an order number. I then select the orders table get the recno number skip and then go back to record number I've saved. This is where the table/field validation gets fired. I am using row buffering on the orders table and table buffering on the client table. Actually one order can only have one client. Any thought you have are appreciated. As far as what is in the dbc for each table - I have it so that a particular field can't be empty.
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