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