Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How Do I Create This Procedure?
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01116731
Message ID:
01117179
Views:
31
Make it PRIVATE:
PRIVATE nCheckOutId
nCheckOutId = 0
ThisForm.SQLCommand("EXEC sp_GenerateSystemId 'result_batch', ?@nCheckOutId")
...
>Sergey, I have a follow up question on this.
>
>I created a class to wrapper all my SQL procedures. The class is instantiated in the App object
>and stored to a property on it.
>
>In my base form, I then created a wrapper method to hard code the data session id.
>
>
>** METHOD SQLQuery
>LPARAMETERS cQuery, cCursor
>RETURN oApp.oSQLProcs.SQLQuery(cQuery, cCursor, ThisForm.DataSessionId)
>
>** METHOD SQLCommand
>LPARAMETERS cCommand
>RETURN oApp.oSQLProcs.SQLCommand(cCommand)
>
>
>Here's the problem. In the OpenBatch method on the form to get the data, I have
>
>
>** Generate a new check out batch id
>nCheckOutId = 0
>ThisForm.SQLCommand("EXEC sp_GenerateSystemId 'result_batch', ?@nCheckOutId")
>		
>** Store the id
>.nCheckOutId = nCheckOutId
>
>
>Problem is, the variable 'nCheckOutId' is out of scope anywhere but this method, so I get
>prompted for the parameter.
>
>Any ideas on this?
>
>
>Thanks!
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform