Select top with SQL-92 of Progress 9.1D

[ejanakieff]

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

 

[tomeng01]

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

 

[Casper]

Upgrade to 10.1B, there top is implemented .

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

Casper.

 

[ejanakieff]

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

 

[Casper]

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.