Hi Gary
Ok so if I understand you correct I do not use views for Local SQL PT cursors but I do use them for MS SQL/ODBC.

This is working except for one 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 Setrelation line 16
"m.cSourceTable = CURSORGETPROP('Tables', .cWorkarea)"
Property is invalid for table cursors.

Call Stack:
6 Contactman2v.Contactdata.Cmdataaccess.Setrelation (..\common50\cmdataa.vct)
5 Contactman2v.Contacts.Addchild (..\common50\cmdata.vct)
4 Contactman2v.Openall (..\common50\cmdata.vct)
3 Frmform.Load (..\common50\cmforms.vct)
2 Frmdataform.Load (..\common50\cmforms.vct)
1 Formcontactman22001.Load (source\contactman.sct)

If I ignore this error the data is displayed. However, changes to the data is not saved.
In my csource propery I used the following:

select * from (cdatadir + 'client')

Where:
cnum=?pccnum


>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