Dear Thomas, I have update the FB server to 2.5 ,,,, Same problem :(
Regards, ahmad sarhan --- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote: > > 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 firebird-support@yahoogroups.com, 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 firebird-support@yahoogroups.com > >>> <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 firebird-support@yahoogroups.com > >>> <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 > > > > > > >