>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.

If you were using SQLEXEC() The SQL statement would be something like

SELECT * FROM oracletable WHERE AR_Number = ?lnAR_Number

You can create the same effect in the view designer by utilizing the Filter Tab

Just make sure that lnAR_Number has a value when you USE yourView. If not, you will see a dialog box asking to supply a value for the parameter.

(It will speed things up to have an index on AR_Number, but that's an issue to bring up with the DBA)