Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can select records where in a cursor
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00615512
Message ID:
00615533
Views:
17
This message has been marked as the solution to the initial question of the thread.
>>
... where fk_task_id in (select TaskID from tasks)
>
>I Knew that. I was wondering if I could replace the (select TaskID from tasks) with only the cursor name. So the select doesn't have to execute.

Nope. The only alternate is to put all the possible values there:

in ('val1', 'val2', ...)
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform