Devart Forums

I show my code first:

q.sql.text := 'select * from table1';
q.open;
while not q.eof do begin
q1.sql.text := 'insert into table2 (.....) ' +
'values (...)'; // values from q
q1.execute;
q.next;
end;

record in q is about 3000 records.
When i run this code, It shown error:
SOCKETEXCEPTION WITH MESSAGE ""
then shown again
CANNOT CONNECT TO SQL SERVER DURING QUERY....
then shown again
ASSERTION FAILURE (...\mydac\source\viotcp.pas)

This produce error not in a certain record. For first run it may raise error at 100th record, for second run it raise error at 105th record

Is my socket connection error? Tmyconnection is use myTCP Protocol
In my another project with looping for 5000 records, this similar code didn't raise error.
I use mydac 3.55

Please Help, Guys !

We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it and include script to create and fill table1 and table2.

Also supply us following information

- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC (3.55.XX.XX). You can see it in History.txt file
- Exact version of MySQL server and MySQL client.
You can see it in Info sheet of TMyConnection Editor