Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CA hard limit
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
Database:
MS SQL Server
Divers
Thread ID:
00984318
Message ID:
00984654
Vues:
20
Hi Fabio,

You can change SelectCmd only before calling CursorFill method. Every subsequent CursorRefresh will use same select command (and you should agree that if you change selected fields in your select command this would lead to a big mess).
So what you can do in your case is to write a "compound" where clause
WHERE (?ThisForm.Checkbox.Value AND tagField IS NULL) OR (?!ThisForm.Checkbox.Value AND tagField IS NOT NULL)
This is just the idea, but not a tested code, so you should play arrownd it.

Regards
Venelina Jordanova

Outsourcing IT Services Ltd.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform