gummio
Posts: 11
|
Posted: 01/15/2009, 4:11 PM |
|
Hi
I have a stored procedure that takes in parameter and return a ID for a new record.
I am using it on a form and thats work OK the record is inserted to SQL by the Custom Insert on the form.
But how can i get the return value from the procedure ??
I want to get the ID and to show that has been insert for the user
|
|
|
dragoon
|
Posted: 01/16/2009, 3:22 PM |
|
AfterInsert event on one hand
and output parameter for SQL stored procedure on the other... http://msdn.microsoft.com/en-us/library/ms378108(SQL.90).aspx
_________________
Bucharest, Romania
---------------------------------------
Sent from YesSoftware forum http://forums.codecharge.com/
|
|
|
gummio
Posts: 11
|
Posted: 01/19/2009, 3:38 PM |
|
How do i get the return value from the SP to a variable ??
Something like this?
//Record Form STF_Event_Registration AfterInsert tail @2-06929D2
int rvalue = 0;
rvalur = NameOfRecordDatasourseNameOfField.Value;
This should by easy but i dont see how this is gonna work.
Can any show me examble?
|
|
|