Hi Willie,

>I had to modify the _valuetochar function in cmDataaccesslsqlpt class

The above is a big No-No. You shouldn't never change any framework methods. The methods starting with an underscore ie., _valuetochar are internal methods used by the framework and should not be touched.

Looking at your property list, the obvious problem is that in your "cSource" property, you have specified 'Clientdata' which I assume is a view? In a local SQL passthru cursor, you specify the SQL select statement in cSource - you only specify a view name when you are using a view :)

You can input your SQL select statement in the builder which is a little easier to use than directly typing into the property sheet.

HTH

>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