Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CA hard limit
Message
 
To
06/02/2005 13:14:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
Database:
MS SQL Server
Miscellaneous
Thread ID:
00984318
Message ID:
00984654
Views:
21
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform