I am trying to update a SQL Server Table but get an error.
No update tables are specified. Use the Tables property of the cursor (Error 1491). Can anybody help.. below is the code I'm using..
TIA
********************************************************************
nc= sqlconnect("CollinsBackOffice","sa","")
lcSQL = [Select * from PUBLISHER order by name]
SQLEXEC(NC,lcSql,'test')
select test
SQLSETPROP(nc,"Transactions",2)
SQLSETPROP(nc,'BatchMode',.F.)
SQLSETPROP(nc,'Asynchronous',.F.)
CursorSetProp('SendUpdates',.T.,'test')
CursorSetProp('Tables','PUBLISHER','test')
CursorSetProp('UpdateType', 1,'test')
CursorSetProp('BatchUpdateCount', 1,'test')
CursorSetProp('KeyFieldList','publisherid','test')
CursorSetProp('UpdateNameList','publishercode publishercode','test')
CursorSetProp('UpdatableFieldList','publishercode','test')
CursorgetProp('Tables','test') && PUBLISHER
tableupdate(.t.)
cursorgetProp('Tables','test') && PUBLISHER
Fred Besterwitch, MCP
The harder you work. The luckier you get.