Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing an array to the VB DataEnvironment

Status
Not open for further replies.

Fritz21

Programmer
Feb 5, 2003
2
CA
I need to create a query using SQL in the VB DataEnvironment to be used by a VB DataReport. I only want records that match a specific list of IDs to be selected. The number of IDs and ID values will change each query. I, therefore, need to pass these these values to the DataEnvironment as a parameter from the VB application. Since the number of values is various each query, I cannot use multiple parameters. I was wondering if it is possible to pass an array to the DataEnvironment and somehow use the "IN" operator to match each element in the array.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top