Subject Re: [firebird-support] update statement Excel Sheet
Author Hans
Using the SQL CASE in your update statement may work.

Best Regards

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,


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.


I want to update my Table from excel sheet how can firebird read from excel sheet.


~{ Ahmad F. Sarhan }~

[Non-text portions of this message have been removed]



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links