>I have 2 questions concerning retrieving data via ODBC.
>(I am using VFP 3.0b)
>
>1. Is there a way to fetch data quicker? I have a remote view against a Sybase database. I pass it 2 parameters, year and week. The view takes about 2 minutes to retrieve the 25000 records. Is there a way to get at this quicker. Unfortunately, this is just the first step. I then need to run another query off this data set, therefore I need it to fetch all records before proceding.

Was the table indexed on year and week? Does it take 2 minutes to get the data over the wire, or 2 minutes for the query to execute prior to sending data?

>2. Rather than using remote views, are there any ways to access the Sybase tables directly and not use a view.


You can use SQL passthru... see the docs!

>Thanks in Advance.
>
>Scott

BOb