[progress Communities] [progress Openedge Abl] Forum Post: Re: Good Practice: Always Define...

[Lars Neumeier]

I would always use a FOR FIRST instead of a FIND or FIND FIRST (no need to use NO-ERROR). At least for MSSQL connected databases through the dataserver FOR FIRST include the SELECT ... TOP 1 phrase compared to a simple FOR, which result in a performance benefit. community.progress.com/.../sql-statement_generated_from_for_buffer_should_contain_top_1

Continue reading...