Error 7511

[jcom]

Hello evrybody.

I access to a Progress Database with PHP through an OpenEdge ODBC Driver.
My connection is good, I can make request. But I have problems with request on several tables.
The following request works :

"select [B]count(Daccords.codoi_)[/B] from pub.Daccords, pub.Dorgasoc 
 Where Daccords.codoi_ = Dorgasoc.codoi_ 
 ";

BUT the following does not work :

"select [B]Daccords.codoi_[/B] from pub.Daccords, pub.Dorgasoc 
 Where Daccords.codoi_ = Dorgasoc.codoi_ 
 ";

In fact, it works only with a 'distinct' or 'count' clause, but not when I want to select fields name as in the second request.
I have this error :

[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Le curseur ne peut être ouvert (7511), SQL state S1000 in SQLExecDirect in...

Thank you in advance !
I don't understand...

 

[tamhas]

Have you tried it with the pub. qualifier on all references?

 

[jcom]

Have you tried it with the pub. qualifier on all references?

Yes, that doesn't affect the result . I think too much cursors are open, even if there is a where condition that reduce the number of rows at 1.