G'Day,
Can anyone give me some SQL which will give me x records without using a
cursor. Say the first batch of 50 and then the next batch of 50
ie
SELECT * FROM TableName WHERE Count(*) <= 50
SELECT * FROM TableName WHERE Count(*) > 50 AND Count(*) <= 100 etc.
Assuming this can be done. Could it be done in a desktop DB such as Paradox
or would it have to be a MS SQL Server etc.
TIA
------------------------------------------------------------------------
--Donovan
Donovan J. Edye [www.edye.wattle.id.au]
Namadgi Systems, Delphi Developer
Web: www.namsys.com.au E-Mail: [EMAIL PROTECTED]
Voice: +61 2 6285-3460 Fax: +61 2 6285-3459
TVisualBasic := Class(None);
------------------------------------------------------------------------
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
