Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select and arrays
Message
From
08/04/2005 11:58:36
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Select and arrays
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01002656
Message ID:
01002656
Views:
67
I have an array that contains the key values I want. I wanted to perform a select statement that looks into the array the only thing I can think of is ASCAN but Rushmore optimization returns none. So is there a better way.

Here's what I have
SELECT * FROM table WHERE ASCAN(la_list, keyfield) > 0
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Next
Reply
Map
View

Click here to load this message in the networking platform