I in Delphi code is as follows:
Query1. Cose;
In query1.sql. Text:="insert into table1_bak select * from table1 '
Query1. ExecSQL;

Why table1 only 20000 data is submitted to the timeout?

In query analyzer to perform insert into table1_bak select * from table1 is normal,

Is there a way to solve the timeout problems?

CodePudding user response:

Use stored procedures.

CodePudding user response:

Database Connection control Connection timeout setting longer!
Ha ha!

CodePudding user response:

Query1. Close;
In query1.sql. Text:='select top 1 * from table1';
Query1. Open;

Code will be a problem, to ensure that the database connection correct first.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Perform the above, if also timeout, then take a look at your connectionstring write to the no.

Query1. Close;
In query1.sql. Text:="insert into table1_bak select * from table1 ';
Query1. ExecSQL;