Have you tried. set var vcommand text = (‘SSQL UPDATE patinfo_dup set scandate = ‘ & (ctxt(.#date)) & ‘where patnumbr = ‘ & (ctxt(.vpnum)))
&vcommand Dan Goldberg From: Michael J. Sinclair Sent: Monday, August 15, 2011 3:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - SSQL Syntax Hi All, Can somebody help me with some syntax? I am trying to update an Rbase database that I have connected to using the SCONNECT command. I want update a date field The command that I tried is... SSQL UPDATE tablename SET column_name1 = .#date WHERE column_name2 = .vreal or to be specific SSQL UPDATE patinfo_dup SET scandate = .#date WHERE patnumbr = .vpnum I don't get an error message, but the value of the column scandate does not change. What am I doing wrong? Mike
