Hi Gary
Thanks for the speedy reply.

I took my SQL data class that is working perfectly and copied it (I am using the same named views for Fox and MS SQL, just in seperat tables). I then changed my navigation table to LSQLPT (not using a view but a select). This worked fine excpet that I had to modify the _valuetochar function in cmDataaccesslsqlpt class as it was converting logical values to either 1 or 0 which is used for MS SQL. I then got to my first data table view. All I changed was the ctype from SQLPT to LSQLPT.

Properties as follow:
Top = 199
Left = 56
Width = 130
Height = 22
cforeignkeyfield = cnum
lqueryremotepk = .F.
cdatabase = mls_1\agent.dbc
ctype = LSQLPT
cworkarea = ContactData
cparent = Contacts
cparentkeyfield = cnum
csource = Clientdata
lnodataonload = .T.
cwhere = cnum=?pccnum
lautopk = .F.
lshareconnection = .F.
nnonupdateablemode = 2
nbuffermode = 1
Name = "ContactData"

Thanks in advance

>Hi Willie,
>
>I am unsure what is causing your error message but I can confirm that I have used Local SPT cursors in Codemine, without problem, for some considerable time now. Maybe you can post your cursor object property settings here and we can take a look.
>
>Best
>
>
>>Any Codemine developers got the Local SQL Passthrough cursors working as yet?
>>
>>I am getting the following error:
>>Visual FoxPro 07.00.0000.9465 for Windows [Jan 4 2002 02:58:33] Product ID 55181-015-6059796-03084
>>CodeMine 7.1.02
>>Error #1468 in Restoreproperties line 11
>>"CURSORSETPROP('BatchUpdateCount', THIS.nBatchupdatecount, .cWorkarea)"
>>Property is invalid for table cursors.
>>
>>Call Stack:
>>5 Contactman2v.Contactprop.Cmsqlproperties.Restoreproperties (..\common50\cmdata.vct)
>>4 Contactman2v.Contactprop.Cmdataaccess.Requery (..\common50\cmdataa.vct)
>>3 Contactman2v.Contactprop.Accessrequery (..\common50\cmdata.vct)
>>2 Contactman2v.Contactprop.Requery (..\common50\cmdata.vct)
>>
>>
>>The SQL Passthrough cursors works very nice. The problem is that I dont want to create to sets of forms for SQL users and Fox users and I am running out of time...:(
>>
>>Thanks