>In VFP, v8 ~ Have tried running the following query against a 'remote view' cursor (created using the VFP view designer and incorporating only the specific database table to be 'viewed') of data gathered from a single table in an MS SQL database and found that the query returns EVERY record in the original 'view' cursor without discriminating as if the 'WHERE' clause in this query has no effect. There are 3,138 records in the 'view' and the same 3,138 records are returned by the select query (written as below). Note: These 3 parameters are 'key' fields in the table of data origin.
>
>hosp_id = '+ÙF€ÞmÙF€ÞŠì'
>mom_id = ',¢>Žt]¢>Žt‰õ'
>pat_id = '001340RWZUB'
>
>SELECT bc.* FROM babychg_basic_view1 bc ;
> WHERE bc.pat_id = ?pat_id and bc.hosp_id = ?hosp_id
>
Is it only these criteria that fails this way?
What is your sql statement in your view? i.e.,
Activate Window "debug output"
Debugout DBGETPROP("babychg_basic_view1", "view", "sql")
Insanity: Doing the same thing over and over and expecting different results.