My data is stored in SQL Server 6.5. On SQL Server I have created a view that pulls records for the year 1996 only. In VFP 5.0 I have created a remote view to accept parameters-for instance, I want to pare down the records to only 1 particular quarter of 1996.
Here is the problem. If I try to 'select' records from the remote view, I get ALL records no matter what I specify. For instance, I may say: SELECT incident, incid_date FROM remote_view WHERE incid_date > CTOD('12/01/96')
What I get from this is every field and every record. Am I missing something here?
George
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe