Deprecated FIND statement (Dataserver - Oracle)

[dominickdm]

We have issues with FIND statements in combination with Oracle databases (using the progress Dataserver). To mimic progress behavior, the dataserver must keep multiple cursors open. Because of that, we always use OPEN QUERY or FOR FIRST instead.

A rule for this could be very usefull.

[gquerret]

Is there any Progress documentation or KB entry on that ?

[stefandrissen]

I only know of performance problems with the SQL DataServer, we use FOR FIRST instead of FIND at compile time based on database type, but we've never had to do this for Oracle DataServer for performance reasons.

https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmsql%2Freplacing-find-first-for-performance.html