No I don't think that's the problem. My select - sql should only have about 100 elements or so... But want's strange is that this is a new form created for this table and the first time I runned the form the table got 37 records and now I have 46 records. The application version that makes wrong selects only 37 records every time and when I have the right application version I get all the records I should have.
/Mårten Törnquist
>The maximum number of elements per array is 65,000. What if you changed your query to select in to a cursor. If you get more than 32,500 records (times 2 fields), you exceed the max array size. Your error could be inconsistent.
---( Mårten Törnquist )---