Hi,
I am trying to use a classic navigation because my tables are growing
and I can't filter queries effectively.
I expected, that if I specify maxRows=40, only 40 records would be read.
Yes, I don't know how the select command should look like generally for
any database. But for MS SQL it is "select top 40 * from myTable".
Let say myTable is ordered by myTableId which is 1, 2, 3, 4.... It seems
that in the classic navigation after next button following selects are used:
select * from myTable where myTableId > 40
select * from myTable where myTableId > 80
select * from myTable where myTableId > 120
and I would like to get
select top 40 * from myTable where myTableId > 40
instead.
I think it is a problem for everyone who works with classic navigation
and therefore there might be a known way to solve my problem? Maybe via
an interceptor?
Thank in advance
Best Regards
Pavel
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
