Page 1 of 1

Will load all data when SQLQuery1.Active = True

Posted: Tue 14 Feb 2017 02:41
by Eden0928
I have a 5463785 record in Table.

Set 'SELECT * FROM TABLE' in SQLQuery1.SQL property

Click Active is True.

My IDE is hold. It loading all data in my SQLQuery1.

But, dbExpress is forward direction DataSet!

My dbExpress version is 7.2.4
Delphi XE
Windows XP
SQL Server 2008 R2

Re: Will load all data when SQLQuery1.Active = True

Posted: Wed 15 Feb 2017 08:32
by azyk
If you need to fetch not all the records from the table immediately, then in TSQLConnection set the extended driver option 'FetchAll' to 'False'. You can read more about the extended driver option 'FetchAll' in the Readme.html file which is in the folder where dbExpress driver for SQL Server was installed.

Re: Will load all data when SQLQuery1.Active = True

Posted: Fri 17 Feb 2017 00:49
by Eden0928
Thank you for your introduction!

Re: Will load all data when SQLQuery1.Active = True

Posted: Wed 22 Feb 2017 10:40
by ViktorV
Thank you for your interest to our product.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.