Select top with SQL-92 of Progress 9.1D

E

ejanakieff

New Member
Hi.

I would select the first n records from a table.
I know that the SQL-92 of Progress 9.1D does not support this.
Can you explain how I can build a select equivalent?

Thank you,
Eva Janakieff
 
Sorry for the lack of help, but I too have been unable to perform such actions on a Progress database. And I sure cannot use a cursor ;p
 
Upgrade to 10.1B, there top is implemented :).

It's about time to move up from 9.1D.

Casper.
 
Thanks.

Do you know if 10.1B version supports distributed transactions?
We have two database servers: Progress and SQL Server.
We are interested to make distributed transaction between them, from .Net.

Thanks,
Eva Janakieff
 
No, distributed transactions are not supported.
It is possible though to connect to more then 1 Progress database with the same driver, but only one of them can be updated.


Casper.
 
You must log in or register to reply here.
Back
Top