CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> .NET

 Stored Procedure SQL

Print topic Send  topic

Author Message
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

View profile  Send private message
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?
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 http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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