Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create new recordset
Message
From
20/09/2001 13:39:42
Alex Zhadanov
Computer Generated Solutions
New York City, New York, United States
 
 
To
20/09/2001 12:35:57
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00558808
Message ID:
00558840
Views:
15
>>Hi everyone.
>>I have main recordset with column ID, where ID is record identifier (primary key).
>>Than i have separate one dimentional array of those Ids.
>>What i need is to create new recordset from main recordset which only have records with those Ids,or may be exists other way to filter main recordset.
>>Thank you
>>Alex
>
>You could go back to the database to request this RS like so: (syntax not tested)
>
strList = Join(myArray, ",")
>myRS.Open "Select * From myTable Where col_id In (" & strList & ")", myConnection
>HTH
Thank you.
Previous
Reply
Map
View

Click here to load this message in the networking platform