>>Hi
>>
>>I am connecting to an AS/400 using VFP and Netsoft's ODBC Driver. I notice that whenever the remote file is accessed, the whole file needs to be read before VFP will respond or display any results. Is there any setting that I can set to control this as the files I am accessing are very large files.
>>
>>Also, there seems to be a limit on the number of fields on a remote file ... 256 ? An error was returned stating that the number of fields in a view cannot exceed 256. Is there a way to overcome this ?
>>
>>Thanks in advance.
>
>VFP will implement a "progressive fetch." By default the first 100 rows will be brought down from the server before VFP will release your program. Then the rest of the rows will be fetched in the background. Are you limiting the amount of data that is being returned?
>
>As for the 256 column limit, this is VFP. A table can only have 255 columns.
>
>-Mike


So you have to bring down just the fields you need or bring down as two different views.
I talked to Mr. Green at dev-con about this problem, and he said to bad. No plans on exspanding in the near future.

Jeff