SQL > SQL dialog > SQL tab capacity

Text capacity of the SQL statement tabs

With vers. 5.6 all the SQL tabs do have a practically unlimited text capacity exceeding the previous 65.000 characters limit (~ 300-500 lines).
However, slow execution must be expected with extensive SQL scripts due to the need for pre-processing to have BDE/Paradox process SQL scripts, as BDE generically cannot handle transaction blocks or plain scripts.

The SQL script processing has been tested with scripts of more than 90.000.000 characters inserting more than 80.000 records and tested with Windows 7 32-bit as well Windows 10 64-bit.
For SQL INSERT INTO scripts of limited size (1000 records) do prepare for a processing speed of about 100-200 INSERT INTO lines per second, depending also on the your harddisk speed.

Auto save limitation

Scripts are autosaved in the per user Registry, but for more extensive scripts, the manual [Open] and [Save] function to retrieve and save large SQL scripts is recommended.