Bill, I should mention that I have Win2K server with R:Tango 2000 and I changed the Direct DBMS action to the following:
UPDATE VariableValues SET Var_Value = <@sq><@var local$VarValue><@sq> FROM VariableValues v1, Variables v2 WHERE ((v1.SiteID = <@var local$Site[1,SiteID]>) AND (v2.Var_Name = <@sq><@var local$VarName><@sq>) AND (v1.Var_ID = v2.Var_ID)) Got the same error. I have never used the <@sql> tag. I placed <@sql> in the results html of the DBMS action and saved the taf with the "Debug File" Attribute. Didn't seem to print anything out besides the usual debug stuff. Maybe because I have the DBMS error. I would like to learn how to use this tag. I checked t4server.ini and NOSQLENCODING=false. Should I do any encoding with the <@var 's in the DBMS? Thanks Steve -----Original Message----- From: Bill Downall [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL Help Steve, Witango is probably "doubling" your explicit single quotes, defaulting to SQL encoding. Check to see for sure by turning on debugging, or putting the <@SQL> tag in your results html while you debug. Replace the explicit quotation characters with the <@SQ> tag: >UPDATE VariableValues > SET Var_Value = <@SQ><@var local$VarValue><@SQ> > FROM VariableValues v1, Variables v2 > WHERE ((v1.SiteID = <@var local$Site[1,SiteID]>) > AND (v2.Var_Name = <@SQ><@var local$VarName><@SQ>) > AND (v1.Var_ID = v2.Var_ID)) Bill On Fri, 12 Dec 2003 16:05:51 -0600, Fogelson, Steve wrote: >Direct DBMS Action in R:Tango. VarValue is TEXT, SiteID is INTEGER, VarName >is TEXT, Var_ID is INTEGER. >UPDATE VariableValues > SET Var_Value = '<@var local$VarValue>' > FROM VariableValues v1, Variables v2 > WHERE ((v1.SiteID = <@var local$Site[1,SiteID]>) > AND (v2.Var_Name = '<@var local$VarName>') > AND (v1.Var_ID = v2.Var_ID))
