Visual Basic

Brice Craig wrote:

need of a solution in VB6

Nilish wrote:

How should i display the records , so that the screen may not turn white

SELECT TOP 50 *
FROM tTable 
ORDER BY UniqueKey ASC

SELECT TOP 50 *
FROM tTable 
WHERE UniqueKey > (last result set's MAX(UniqueKey))
ORDER BY UniqueKey ASC

SELECT TOP 50 *
FROM tTable 
WHERE UniqueKey NOT IN (SELECT TOP [PageCount*50] *
                        FROM tTable 
                        ORDER BY UniqueKey ASC
                        )
ORDER BY UniqueKey ASC