How to make an insert in mysql with data coming from a SimpleDataSet

Question

Navigation

#1 by (2 votes)

1

I have a SimpleDataset with data from a Firebird location.

I have to make a Insert in Mysql .

How do I do this?

Other SqlConnect and another SimpleDataSet ?

How to do insert with data from this SimpleDataSet ( firebird ).

mysql delphi firebird

asked by anonymous 14.07.2016 / 01:56

1 answer

Delete last blank line txt php Separate content from an RSS in two divs

score 2 · Accepted Answer

I do not know how this component works, but in general you make a loop in DataSet doing insert of each item of it!

It works as if it were an importer!

Ex:

NomeDataSet.First
while not NomeDataSet.Eof do
begin
  //aqui seu Código SQL para efetuar o Insert
  NomeDataSet.Next
end;

And yes, you will need the two connections!