I am trying to create an updateable local cursor to SQL Server using this:
ol=SQLCONNECT('RDB') && RDB is an ODBC datasource
SQLEXEC(ol,"select cat,type,descr,data from types",'t1')
CURSORSETPROP("Tables",'types','T1')
CURSORSETPROP("UpdatableFieldList",'cat,type,descr,data','T1')
CURSORSETPROP("KeyFieldList",'cat, type','T1')
CURSORSETPROP("SendUpdates",.t.,'T1')
SELECT T1
BROWSE
When I change a field in the cursor T1 I get the message
'No update tables are specified. Use the Tables property of the cursor.'
I know I can create a remote updateable view but it has to be stored in a local db and for other reasons I do not want to have any local fox db, even temporary.
I am using VFP7 and SQL Server 2000 Service pack 3.
ol=SQLCONNECT('RDB') && RDB is an ODBC datasource
SQLEXEC(ol,"select cat,type,descr,data from types",'t1')
CURSORSETPROP("Tables",'types','T1')
CURSORSETPROP("UpdatableFieldList",'cat,type,descr,data','T1')
CURSORSETPROP("KeyFieldList",'cat, type','T1')
CURSORSETPROP("SendUpdates",.t.,'T1')
SELECT T1
BROWSE
When I change a field in the cursor T1 I get the message
'No update tables are specified. Use the Tables property of the cursor.'
I know I can create a remote updateable view but it has to be stored in a local db and for other reasons I do not want to have any local fox db, even temporary.
I am using VFP7 and SQL Server 2000 Service pack 3.