Marc:
For updates and inserts you pass as arguments the value in each field of the table your updating. In the stored procedure, you recieve these values as parameters which are then used in T-SQL code.
For selects and deletes, pass in a primary key.
I have created a framework of special data classes that automatically handle all the parameter passing and procedure calling. When I create my SQL Server database, I also create an update, insert, delete and select stored procedure for each table. On the fox side, the data classes handle the rest.
Charlie
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only