Maybe this is it:
THIS.lnHandle = SQLSTRINGCONNECT(lcConnStrAUSD)
Then you refer to a different property, THIS.lnHandleERCA, here:
lSuccess=SQLEXEC(THIS.lnHandleERCA,"SELECT * FROM myData","cMyData")
Assuming this last line is where the error is occurring, where do you define THIS.lnHandleERCA?
---J
>myForm.Load():
>
>lcConnStrAUSD="DRIVER={Microsoft Visual FoxPro Driver};" + ;
>"SourceDB=C:\Projects\mydata.dbc;SourceType=DBC;UID=;PWD=;"
>
>THIS.lnHandle=SQLSTRINGCONNECT(lcConnStrAUSD)
>
>IF THIS.lnHandleERCA>0
> lSuccess=SQLEXEC(THIS.lnHandleERCA,"SELECT * FROM myData","cMyData")
> IF lSuccess=1
> SET MULTILOCKS ON
> CURSORSETPROP('Buffering',3,'cMyData')
> CURSORSETPROP('TABLES','erca','cERCA')
> CURSORSETPROP('UPDATABLEFIELDLIST','myField','cMyData')
> CURSORSETPROP('KeyFieldList','myField','cMyData')
> CURSORSETPROP('UpdateNameList','myField,'cMyData')
> CURSORSETPROP('FetchMemo',.T.,'cMyData')
>CURSORSETPROP('SendUpdates',.T.,'cERCA')