Information générale
Titre:
Send updates using SPT to SQL Server
TableUpdate() returns .T. but my remote table isn't updated, somethimes the error 'No update tables are specified' is in the AERROR().
I am new in this stuff so could please someone tell me why this code doesn't update my remote table? (VFP 5.0 & SQL Server 7.0)
SET MULTILOCKS ON
n=SQLCONNECT('Crime')
sqlsetprop(n,'DispWarnings',.T.) &&I don't get errormessages
SQLSETPROP(n,'Transactions',1)
SQLSETPROP(n,'BatchMode',.F.)
SQLSETPROP(n,'Asynchronous',.F.)
var=sqlexec(n,"select * from titles where titDescr like '%PIRATE%'","test")
var=sqlmoreresults(n)
replace titDescr with 'testestestest'
brow &&Replacement in cursor succeeded
var=cursorsetprop('Buffering',5,'test')
var=cursorsetprop('sendupdates',.t.,'test')
var=cursorsetprop('tables','titles','test')
var=cursorsetprop('keyfieldlist','titId','test')
var=cursorsetprop('updatenamelist','titDescr titDescr','test')
var=cursorsetprop('updatablefieldlist','titId, titDescr','test')
if tableupdate()
messagebox('update succeeded!!!') &&update always succeeds
endif
sqlcommit(n)
var=sqlexec(n,"select * from titles where titDescr like '%PIRATE%'","test2")
sqlmoreresults(n)
if grpnaam = 'testestestest'
messagebox('updated in remote table')&&Never seen this messagebox working
endif
brow
use in test
use in test2
sqldisconnect(n)
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement