copy mysql data to firebird
Posted: 28.08.2006, 22:52
actually my problem is:
i want to "copy" some columns of an mysql (5.x) server to an firebird database.
for that i have the following little script:
while not mysqlquery.eof do
begin
iboqry.params.clear;
iboqry.sql.clear;
sql:="insert into tmp(id,date) values (:id,:date);";
iboqry.sql.add(sql);
iboqry.parambyname('id').asinteger:=mysqlquery.fieldbyname('id').asinteger;
(some more params following after that-doesnt matter here)
mysqlquery.next;
iboqry.execsql;
end;
well everything works fine to the first dataset, but afterwards the 2nd dataset, an error occurs (strange things like "'2' is not an valid format" or something...)
seems like the NEXT method doesnt working correct, as the resultdataset is veeery confusing (from 5 sets to over 30!)
issnt it possible to execute an seperatet sqlstatement with depending params in this loop?
does anyone have an idea?for my part an other solution for copy from mysql to firebird?
big thanks in advance!
regards!
i want to "copy" some columns of an mysql (5.x) server to an firebird database.
for that i have the following little script:
while not mysqlquery.eof do
begin
iboqry.params.clear;
iboqry.sql.clear;
sql:="insert into tmp(id,date) values (:id,:date);";
iboqry.sql.add(sql);
iboqry.parambyname('id').asinteger:=mysqlquery.fieldbyname('id').asinteger;
(some more params following after that-doesnt matter here)
mysqlquery.next;
iboqry.execsql;
end;
well everything works fine to the first dataset, but afterwards the 2nd dataset, an error occurs (strange things like "'2' is not an valid format" or something...)
seems like the NEXT method doesnt working correct, as the resultdataset is veeery confusing (from 5 sets to over 30!)
issnt it possible to execute an seperatet sqlstatement with depending params in this loop?
does anyone have an idea?for my part an other solution for copy from mysql to firebird?
big thanks in advance!
regards!