aqno is intger rfrnc is varchar
I tried another format of case statement like: update mngrnt set rfrnc = case aqno when 50001 then '155' when 50002 then '166' end I got same SQL error but unknown token is aqno Regards. --- In [email protected], Alan J Davies <Alan.Davies@...> wrote: > > What is aqno? An integer or character field? > If its an integer try without ' ' > Is it in the same table as rfrnc? > Otherwise there is nothing wrong with the code. > Alan > > Alan J Davies > Aldis > > > > On 02/07/2012 07:40, mahdoom_a wrote: > > 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] > > <mailto:firebird-support%40yahoogroups.com>, 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 > > > > > > > > > > > > > > > >
