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