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