I have this code:
SET CENTURY ON
SET MULTILOCKS ON
nConnHandle = SQLCONNECT('RDB','sa','')
SQLEXEC(nConnHandle,'selec
t * from sqltable')
CURSORSETPROP('Buffering',
5, 'sqlresult')
UPDATE sqlresult;
SET data = DATETIME(1910,1,1,IIF(SUBS
TR(RTRIM(L
TRIM(data1
)),5,2)='A
M',0,12)+V
AL(SUBSTR(
RTRIM(LTRI
M(data1)),
1,2)),VAL(
SUBSTR(RTR
IM(LTRIM(d
ata1)),3,2
))) ;
WHERE Day = .t.
TABLEUPDATE(.t.)
SQLCOMMIT(nConnHandle)
And I want to commit this changes to the data column on sqltable. All changes get suscessfull on the VFP buffer but cannot commit to the sql server, why?
What I have to do to commit the table on VFP buffer to an sql server database?
This question is easy, but I need urgent assintance. I have searched this site, to find something that give an idea what's wrong and why it doesn't commit, but haven't found anything.
Start Free Trial
