Hello, > I dont know whats wrong, Thats why I asking, its simple and should work easly. > > I tried to use IBexpert V2.5.0.49 and RazorSQL V5.6.3 to excute the command > and still getting the same error msg. also I copied the sql you just sent to > me as it is and still giving the same error msg > when is invalid. > > my firebird server is V1.0.3.973 maybe its old thats why ?
Yes. The CASE construct has been added in V1.5. Regards, Thomas > Regards. > > Ahmad sarhan > > > --- In [email protected], Alan J Davies<Alan.Davies@...> > wrote: >> >> Hi mahdoom_a, I've just created this table MNGRNT (like yours) >> >> RFRNC AQNO >> 50001 >> 50002 >> 50003 >> >> I then ran this code: >> update mngrnt >> set rfrnc= >> case >> when aqno = 50001 then '155' >> when aqno = 50002 then '166' >> when aqno = 50003 then '1331' >> end >> >> This is the message - successful update >> Plan >> PLAN (MNGRNT NATURAL) >> >> 3 record(s) was(were) updated in MNGRNT >> >> This is the table after update >> RFRNC AQNO >> 155 50001 >> 166 50002 >> 1331 50003 >> >> You must be doing something that you're not telling us because this >> "just works" and is as simple as it gets really. >> >> What else are you trying to do? >> Regards >> Alan >> >> Alan J Davies >> Aldis >> >> On 02/07/2012 16:23, mahdoom_a wrote: >>> 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] >>> <mailto:firebird-support%40yahoogroups.com>, 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> >>> > > <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 > > >
