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.

>I compile to different directories, but after that I always copies the three versions to d:\mis\kundresk.app and runned it from there. So I always have the same datasource and all settings are the same every time, but still I get different results. My settings is: SET ANSI ON and SET EXACT ON. So is there anything more that could give me these problems?
>
>/Mårten Törnquist
>
>>I can understand the reporting of different file sizes on different drive types [local, floppy, server, etc.]. This depends on block size, OS, etc. It is curious though that you got 2 different file sized on the M drive but in different folders. Did you refresh [F5 function key] the Windows Explorer list after recompiling?
>>
>>What are your settings for SET EXACT, SET ANSI? Do you have the same rights on all the drives/folders? Are you selecting data from the same source? Did you check the Recompile All the first time you rebuilt your app under this new release? Recompile all your classes? This has nothing to do with your problem, but remember to COMPILE DATABASE MYDB if it has any stored procedures.
>>
>>>I don't know if it's becouse of Visual Studio Service Pack 3 or not but since i've installed it my VFP has not been the same... Diffrent kind of strange error appears all the time and this is the last one who has destroyed a couple of hours for me...
>>>
>>>The following select sql code: (runned from a form)
>>>
>>>select faktdatum, idnr from mds!faktura into array Thisform.aList where connectnr = '10.000001' and typ = 2 order by 1
>>>
>>>gives three differens result depending on where I builded my application...
>>>
>>>1.
>>>Built file : d:\mis\kundresk.app (local drive)
>>>File size : 274 959
>>>Error : The select - sql command missed some records.
>>>Error msg : -
>>>
>>>2.
>>>Built file : m:\mis\src\kundresk.app (network drive, the project file is here)
>>>File size : 274 915
>>>Error : No error. Gives the right result.
>>>Error msg : -
>>>
>>>3.
>>>Built file : m:\mis\software release\kundresk.app (network drive)
>>>File size : 274 955
>>>Error : The select - sql command missed some records.
>>>Error msg : Error instantiating cursor object... when I run the form.
>>>
>>>What is this???? Why is this happening???? I'm building the same project three times with three different results, is that even possible????
>>>
>>>/Mårten Törnquist