Alan Dear,


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 ?


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