CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> .NET

 Stored Procedure SQL

Print topic Send  topic

Author Message

Posts: 11
Posted: 01/15/2009, 4:11 PM


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

View profile  Send private message
Posted: 01/16/2009, 3:22 PM

AfterInsert event on one hand
and output parameter for SQL stored procedure on the other...
Bucharest, Romania
Sent from YesSoftware forum

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?
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.