Back again 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)) Sample: UPDATE VariableValues SET Var_Value = 'http://<@CGIPARAM NAME=SERVER_NAME>' FROM VariableValues v1, Variables v2 WHERE ((v1.SiteID = 1) AND (v2.Var_Name = 'AppRootUrl') AND (v1.Var_ID = v2.Var_ID)) Works from R> in R:Base. Updates fine. Doesn't work in Direct DBMS Action in R:Tango. Get the following errors: 2059 [RBTI][Oterro ODBC Driver][CatSite]-WARNING- No rows exist or satisfy the specified clause. (2059) S1000 2043 [RBTI][Oterro ODBC Driver][CatSite]-ERROR- Conditions must be combined with AND, AND NOT, OR, OR NOT. (2043) S1000 -101 General error during data source operation. Thanks Steve -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL Help David, Just figured it out. Had to remove the v1. from v1.Var_Value Thanks for looking at it. Steve -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL Help David, Thanks for the reply. I am getting -ERROR- Var_Value is an undefined table. (2038). Then it says no rows exist. Var_Value isn't a table. Not sure what is wrong. Thanks Steve -----Original Message----- From: David M. Blocker [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL Help Steve The update command looks valid. Is it not working? David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 3:13 PM Subject: [RBASE-L] - SQL Help > Need a little help with an SQL command. I use the following: > > update VariableValues set v1.Var_Value = 'test' from VariableValues v1, > Variables v2 where (v1.SiteID = '1' and v2.Var_Name = 'Title' and (v1.Var_ID > = v2.Var_ID)) > > I want to update the column Var_Value in table VariableValues, but the only > row values I have are SiteID from VariableValues and Var_Name from > Variables. Var_ID in VariableValues is a Foreign Key from Var_ID in > Variables. > > Any help would be appreciated. > > Thanks > > Steve Fogelson > Internet Commerce Solutions > >
