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]