access first 10 rows

[dille]

Does anyone know how to access the first 10 rows of a table in a progress 9d database??

select * from table_name where rownum <= 10 does not work, I get the error that this feature is not yet supported, but is there any other way to accomplish this?

 

[Lee Curzon]

You can't do it directly through SQL92.

Lame workarounds from the knowledgebase:

KB P13258
Title: "Is the SELECT TOP option supported in Progress SQL-92?"

http://tinyurl.com/ee7xf

HTH

 

[dille]

thanx,

I've read something it might be possible with a cursor and a fetch in sql-92??? Does someone know how?

 

[Lee Curzon]

You would need to issue your SELECT, then iterate through the first ten rows of the result set in whatever language you are calling the SQL from (eg. VB).

I don't use SQL, so haven't got an example, maybe someone else has.