No. I found it.
My SQL properties are stored in an INI, and I had the Disconnect turned on, so it
was disconnecting after each query.
Thanks anyhow.
>>I'm opening a connection to SQL in VFP 9.
>>
>>SQLSTRINGCONNECT() is returning 1.
>>
>>Later, when I attempt to do a SQLEXEC(), I get "Connection Handle Is Invalid".
>>
>>It's still 1, so I'm not sure what's wrong.
>>
>
>Are you using VFP9SP1 beta by any chance? There was a bag in it that made handle invalid under some circumstances. It has been fixed in SP1-final.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people