Retrieve a Certain number of records

[Fulumirani]

Can I select a certain number of records be returned in a query via Pervasive SQL. The following is what I would do in SQL Server or Access. Does Pervasive offer something like this statement?


SELECT TOP 10 *
FROM [dbo].[tkHistory]

 

[Linda84]

The TOP functionality is support in Pervasive.SQL v8, soon to be released. A Release Candidate is available for download from the Pervsive web site. Linda
Pervasive Software Support

 

[Fulumirani]

Linda,

Thanks for your response. However, I am still at a loss. I don't have version 8 and it is not in the near future at my customers site. Is there any other alternative solution that you can propose?

 

[JBBJWS]

I am having the same problem, anyone else have any ideas?

 

[TRAXIC]

Has anyone found a solution for this? Using Pervasive.SQL 2000 not V8.