SELECT statement limitations

[RobboRobson]

Hi

I want to read through a large file containing about 10 milion records

I've used the following command:

Select Fields(*ALL) From_File(LDGP010) Io_Error(*NEXT) Val_Error(*NEXT)

But when running the form I'm getting the following error message appearing:

(0222) - Selection Record Limit of 10000 exceeded

I thought the limit for records only applied to lists and grids not actually looping through a large file?

Regards


Paul

[RobboRobson]

Please ignore someone had used the Connect_File in the program