VFP remote views have update options-with timestamp
But views works more slow, then sqlexec
How to use timestamps in update sqlexec.
I tryed to get this field type on client VFP part before editing record
(It seems to be binary code)
Before update I tryed to test this field, was it changed
to detect, did other user changed it?.
SQLexec with select using variable I took before editing gave
wrong result. SQL server was not able to recognize binary code
My code was like this
Before editing record
=sqlexec(con,'select * from mytable','cur')
m.idt=cur.dt !!-this gets field dt of datestamp type
m.idd=cur.idd !! table primary key field
....
work on the form with record editing
=sqlexec(con,'select idd from mytable where idd=?m.idd and dt=?idt','checkcur')
I hoped this operation helps me to detect, was record changed by other user, when I have lost time on editing same record
On some reason this did not produce correct result.
It seems to me , server did not recognized dt timestamp variable, I have picked to client part into m.idt before editing record.
Thanks in advance, Vladimir
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.