>>I have a public variable that I use to store my connection handle for SQL Passthrough. The variable is used in a number of forms, and was working fine until I came to a form that is telling me "Connection Handle is invalid."
>>
>>Why wouldn't the connection handle work for a particular form? I have checked to make sure that the variable does actually contain a valid handle, but for some reason, this one form won't use it. Can anyone explain this?
>>
>>Thanks!
>
>The variable can have a valid handle but the connection could be closed for some reason. How did you get the handle? SQLConnect? Opening a view with a shared connection?

I get the handle from a procedure that is run when the application starts. Right after I issue the opendatabase() command, I declare a public variable, use a view from the open database, and issue a cursorgetprop("ConnectionHandle") on that view.

I believe the view is opened with the shared connection option.