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
Will load all data when SQLQuery1.Active = True
Re: Will load all data when SQLQuery1.Active = True
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
Thank you for your introduction!
Re: Will load all data when SQLQuery1.Active = True
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.
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.