>I'm building my first remote view of an Oracle database, and am able to set up local tables corresponding with the Oracle tables. However, when I open the local table of the view (for example 'customer'), it starts retrieving every record, and there are many.
>
>Is there a way to open the local table to see only a snapshot of 'n' number of records, with other records retrievable on demand, such as paging through a BROWSE? (MS Access does this quite well.) Or, does each view of what I want need to be specified with SQL?
Huh? You have local tables corresponding to the Oracle tables? Or do you mean remote views corresponding to the Oracle tables? The view is what you open like a local table, but it retrieves the data from the Oracle table.
To limit the number of records retrieved, parameterize the view. In the view designer, click the FILTER tab, and select a field [e.g. LASTNAME] to equal some value. For the value, type in ?cLastName for example. Then --
Use MyView NODATA
When you are ready to retrieve some data --
cLastName = 'Smith'
requery('MyView')
All records that have a LastName value of 'Smith' [case sensitive] will be returned to the view.
Mark McCasland
Midlothian, TX USA