Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
This a bug or a limitation - select qry not discriminati
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00856410
Message ID:
00856445
Vues:
20
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform