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 17:02:49
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00679658
Message ID:
00679793
Views:
19
It would seem there should be some work around for this. If you discover anything I would be interested in seeing how you made it work.

Thanks
John


>Thanks John for your reply - yes I have tried that (although slightly different as I did not put the single quotes around number) and it works when I select into a cursor but not in a view...
>ie.
>
>strRange = "15,16,17"
>select * from events where ev_primary in (&strRange) into cursor curTemp
>
>but when I try to pass strRange to a view I either just get the first record returned or an error
>Thanks again
Previous
Reply
Map
View

Click here to load this message in the networking platform