Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting records by field content
Message
From
11/02/2005 16:47:10
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Selecting records by field content
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00986164
Message ID:
00986164
Views:
54
I have a table that collects reason codes for Drawing changes. The reason codes are three numbers, one each for a respective category. Example: Category I value is 1, Category I value is 2, Category I value is 3 the reason code would be 123. I am trying to come up with an efficient way to report the code combinations, displaying the Category options that were originally offered. Suppose I want all the records that have a 1 in the first position, a 2 inthe second position and anything in the third position. I know there must be an easy way to do this, better than my Do Case scheme.
Next
Reply
Map
View

Click here to load this message in the networking platform