>Need to prevent delay
>I have a view created in the view designer to get three fields from an Oracle Server. The conection works fine, but it takes a minute or more to return any information and the record count continues incrementing while the initial browse displays. I can stop the increment with SQLCANCEL(1) There are over a million records in this table. What I really only need is the 10 or less records for one field item (AR_Number). Is there a way to programatically modify the view so the return of the data doesn't take so long?
>
>I tried creating the view in a method of the form but that takes just as long to get the data connection.
>
>Any help would be appreciated.
There was an interesting discussion on this topic (in Russian)
http://forum.foxclub.ru/read.php?29,275449,276775#msg-276775Not sure, if this is in any way helpful, though.
If it's not broken, fix it until it is.
My Blog