Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Calling a function from a SP |
Tue, Dec 15 2009 4:49 PM | Permanent Link |
"Jim Garrity" | I want to call a function previously created from a stored procedure.
I thought it would just be declare X integer; Set X = fnGetNextID (). But that does not compile in the stored procedure. Jim |
Tue, Dec 15 2009 5:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jim,
<< I want to call a function previously created from a stored procedure. I thought it would just be declare X integer; Set X = fnGetNextID (). But that does not compile in the stored procedure. >> Functions and procedures are a special beast - they cannot be created in a procedure in which they are called later. They have to exist before the procedure can be compiled. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |