Great Alan, I tried this
update mngrnt set rfrnc= case when aqno = '50001' then 155 when aqno = '50002' then 166 when aqno = '50003' then 1331 end I got SQL error Invalid token. Dynamic SQL Error. SQL error code = -104. Token unknown - line 4, char 1. when. 'when' is identified(in bold black)but I don't know why its invalid. Best Regards Ahmad Sarhan --- In [email protected], Alan J Davies <Alan.Davies@...> wrote: > > update T1 > set Col1 = > case > when Col2 = No1 > then Val1 > when Col2 = No2 > then Val2 > when Col2 = No3 > then Val3 > end > > > Alan J Davies > Aldis > > > > On 01/07/2012 17:53, Hans wrote: > > Using the SQL CASE in your update statement may work. > > > > Best Regards > > Hans > > > > Sent from my iWatuski > > > > On 2012-07-01, at 9:17 AM, "Ahmad F. Sarhan" <mahdoom_a@... > > <mailto:mahdoom_a%40yahoo.com>> wrote: > > > > Hey everyone, > > I need your help in one of 2 questions please, > > > > 1st. > > > > i need to update my table with multi values , each value has its own > > condition > > I mean > > update T1 > > set Col1 = Val1 where Col2 = No1 > > set Col1 = Val2 where Col2 = No2 > > set Col1 = Val3 where Col2 = No3 > > . > > . > > . > > Set Col1 = Val 600 where Col2 = No600 > > > > and so on. I tried the simple lines as I wrote above but its not working. > > > > 2nd. > > > > I want to update my Table from excel sheet how can firebird read from > > excel sheet. > > > > Thanks > > > > ~{ Ahmad F. Sarhan }~ > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > > > Visit http://www.firebirdsql.org and click the Resources item > > on the main (top) menu. Try Knowledgebase and FAQ links ! > > > > Also search the knowledgebases at http://www.ibphoenix.com > > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Yahoo! Groups Links > > > > >
