>Vladimir
>
>I now have a connection to Oracle, V8, from VFP7 and it all works fine except for 1 problem.
>
>
>On a client PC: (Dell, 1.6ghz, 256mb)
>When I perform a refresh on a Remote SQL, I only get the first 300 records. If I refresh again, this time I get 700. After several refreshes I get the correct number of records.
>On my laptop: (Sony, 1ghz, 256)
>I get the full 776 records every time. Occasionaly I'll get a resource error, but when I run the refresh again, I'll get the correct number of records.
>
>Any ideas?
You may be set mode for sqlmore results
Go to tool/option/remote data, look your sets, Oracle is not clue here
Vladimir