Just what I was about to send to you!! Glad you got it
David 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 4:36 PM 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 > > > > > >
