Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What should we use?
Message
 
 
To
16/10/2008 18:31:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01355472
Message ID:
01355524
Views:
26
>I'd be tempted to consider keeping the codes in a table and just using a subquery for the condition. It would be pretty flexible, wouldn't have the limitations of a string and the subset of codes could be parameterized in whatever way necessary and the cursor used for the subquery.
>

It was already a table and I converted values to string first. I may just go straight with the table. For now I decided to just check directly against the codes in my code below the select statement.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform