El 18/2/25 a les 14:49, Michael Van Canneyt via fpc-pascal ha escrit:
On Tue, 18 Feb 2025, Luca Olivetti via fpc-pascal wrote:
Hello,
I need to copy a table between an mssql database and a postgresql one.
I used a query to obtain the data, a datasource ponting to it and
another query using
On Tue, 18 Feb 2025, Luca Olivetti via fpc-pascal wrote:
Hello,
I need to copy a table between an mssql database and a postgresql one.
I used a query to obtain the data, a datasource ponting to it and another
query using the datasource, the sql being
INSERT INTO table (f1,f2,f3...) value
Hello,
I need to copy a table between an mssql database and a postgresql one.
I used a query to obtain the data, a datasource ponting to it and
another query using the datasource, the sql being
INSERT INTO table (f1,f2,f3...) values (:f1,:f2,:f3,)
and then doing
OrigTable.Open;
P