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.