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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only