Will load all data when SQLQuery1.Active = True

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
Eden0928
Posts: 44
Joined: Sun 22 Apr 2012 14:08

Will load all data when SQLQuery1.Active = True

Post by Eden0928 » Tue 14 Feb 2017 02:41

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

azyk
Devart Team
Posts: 1010
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

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

Post by azyk » Wed 15 Feb 2017 08:32

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.

Eden0928
Posts: 44
Joined: Sun 22 Apr 2012 14:08

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

Post by Eden0928 » Fri 17 Feb 2017 00:49

Thank you for your introduction!

ViktorV
Devart Team
Posts: 2123
Joined: Wed 30 Jul 2014 07:16

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

Post by ViktorV » Wed 22 Feb 2017 10:40

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.

Post Reply