>I have an application I built using DBF files in the DBC. I now need to create the database in Sybase. How do I make use of the indexes from the Sybase database through remote views? Do I need to create my own indexes on the remote views?
>
>I tried a sample form using a remote view on a particular table. I referenced the Sybase table's index in the Order property in the data environment for the view and received an error.
>
>Thanks in advance.
>
>Scott
You can get remote view ordered using order option of View designer, however there is no way to use backend indexes on front-end side. You can index remote view recordset as any other table using INDEX ON ... TAG ... (cursor should be in row buffering mode, buffering=3)
Edward Pikman
Independent Consultant