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, 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>, 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
> > > >
> > > >
> > >
> >
> >
>