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 > >
