HI, in SQL SERVER i can do this stuff in one script named "UPDATE.sql":
UPDATE <table> SET <fieldname>=data1
UPDATE <table> SET <fieldname>=data2
.
.
.
UPDATE <table> SET <fieldname>=datan
how can i do the same in Firebird, using IBManager? when i tried to do it it shows:
fmSQLEditor.Query:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 2, char 1.
update.
i've already tried semicolons at the end of each UPDATE stament.
thanks
