Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing primary keys to a View with an in filter
Message
From
17/07/2002 13:04:24
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00679658
Message ID:
00679680
Views:
23
Have you tried it this way?
strRange = "'17','66','89'"
SELECT * FROM youthbase!ygprojects WHERE Ygprojects.pj_primary IN (&strRange)
>Hi - is it possible to use a view to return records that match the primary keys in a list?
>I have a view with this SQL
>
>SELECT *;
> FROM youthbase!ygprojects;
> WHERE Ygprojects.pj_primary IN (?vRange)
>
>
>I have tried passing it...
>strRange = "17,66,89"
>vRange = &strRange
>vRange = evaluate(strRange)
>but neither work - sometimes I get an error and sometimes I just get the first record returned
>
>If I put the values directly in the view I get the 3 records back OK
>
>Any ideas greatly appreciated
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform