Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How Do I Create This Procedure?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01116731
Message ID:
01117179
Vues:
32
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform