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 > > > > > > > > > > ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
