Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Including a logical field into an index
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Including a logical field into an index
Miscellaneous
Thread ID:
00275876
Message ID:
00275885
Views:
19
>Convert the logical to character with the IIF() function:
>
>index on ... + iif(MyTable.LogicalField, 'T', 'F') tag mytag


Duhh....I should have figured that one out...Someday I will have this language mastered :-)

Thanks,
Paul
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform