Bill, 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))
WORKED!!!!!!!!!!!!!!!! Thanks a bunch. I'm going to mess around with that <@sql> tag. Looks like a good debugging tool. Have a great weekend. Steve -----Original Message----- From: Bill Downall [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 5:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL Help On Fri, 12 Dec 2003 16:53:10 -0600, Fogelson, Steve wrote: >Got the same error. Steve, Try removing the line breaks, and do the command on a single line:
