Re: O$ Statement don't retrieve all records

[Andrew Stolarz]

Jacques,

Just as a test, if you add a LIMIT to your sql statement (lets say 2000), does it return all 2000 values?

I ran into a similar issue a number of years ago, except it was my fault as I had built a drop down filter that limited the returned records ;)

Im not aware of any default limits in Omnis that would restrict this. I would check your SQL database settings for starters.

Andrew

On 17 February 2015 at 05:47, Jacques Zemron <ja...@aec-ri.com> wrote:

Hi all,

I have a statement like this :

Do tSessionObj.$newstatement('LI') Returns lStatementObj
Do lStatementObj.$execdirect("select * from F_LETTRE_INFORM where FL_OBJET like '%.rtf'") Returns #F
Do lStatementObj.$fetch(lRow,1) Returns lStatus
While lStatus=kFetchOk
        my treatment
        Do lStatementObj.$fetch(lRow,1) Returns lStatus
End While

does somebody knows why it only retrieve 1000 records ?

Cordialement,

Jacques ZEMRON



2, Impasse du Marechal Ferrant
14540 SOLIERS
Tel : 02 31 72 73 54
Fax : 02 31 26 94 72
Portable : 06 82 68 60 08
Mailto:ja...@aec-ri.com





_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com