dbEditAddSQL and Stored procedures

[martin]

Is it possible to use a stored procedure as the dbEditAddSQL?

The stored proc I wrote performs an insert on a parent table and then several
inserts on two child tables.

This is what I tried to set the dbEditAddSQL property to:
db.dbEditAddSQL = "spSandBoxDetailAdd ,8,55,238,362,106,0,0,0,0,0,0,0,0,0,'Success 2!',0"

And the error message I got was:
Error: Update record field values cannot be all blank
(which I think is just because the database doesn't think it's getting any values and it knows it has one or more fields that can't be null)

Thank you very much for your time!

[Frank Kwong]

how do you feed back for know that the edit action is successful ? So, you want to feed in the parameters of the INPUTs to the SP via parameters ? If it is multiple tabkes, how can youspecifu the type of the inputs tothe SP ?

Frank


------------
martin at 2/22/2002 12:00:02 PM


Is it possible to use a stored procedure as the dbEditAddSQL?

The stored proc I wrote performs an insert on a parent table and then several
inserts on two child tables.

This is what I tried to set the dbEditAddSQL property to:
db.dbEditAddSQL = "spSandBoxDetailAdd ,8,55,238,362,106,0,0,0,0,0,0,0,0,0,'Success 2!',0"

And the error message I got was:
Error: Update record field values cannot be all blank
(which I think is just because the database doesn't think it's getting any values and it knows it has one or more fields that can't be null)

Thank you very much for your time!