Will load all data when SQLQuery1.Active = True

Will load all data when SQLQuery1.Active = True

Postby 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
Eden0928
 
Posts: 44
Joined: Sun 22 Apr 2012 14:08

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

Postby 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.
azyk
Devart Team
 
Posts: 850
Joined: Fri 11 Apr 2014 11:47

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

Postby Eden0928 » Fri 17 Feb 2017 00:49

Thank you for your introduction!
Eden0928
 
Posts: 44
Joined: Sun 22 Apr 2012 14:08

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

Postby 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.
ViktorV
Devart Team
 
Posts: 1651
Joined: Wed 30 Jul 2014 07:16


Return to dbExpress driver for SQL Server