Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using IN operator in parameterized remote view.
Message
From
18/06/2001 13:08:38
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00520273
Message ID:
00520667
Views:
12
Glad you have it working. One of the suggestions showed the list as character values, which is why I was asking about integers.


>Cindy,
>
>The numbers are the primary keys stored as integers. I had this working just like you have somewhat described by inserting the values into a table and then doing an "... IN (Select * from selections where cTableName = ?.cTableName and dExecuted = ?.dExecuted)" which worked just fine. However, I just wanted to check to see if someone may have been able to get the IN operator to work by using a parameter with a comma-delimited list of values. Daniel had the solution so it looks like I can discard my table idea.
Previous
Reply
Map
View

Click here to load this message in the networking platform