Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create new recordset
Message
De
20/09/2001 13:39:42
Alex Zhadanov
Computer Generated Solutions
New York City, New York, États-Unis
 
 
À
20/09/2001 12:35:57
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00558808
Message ID:
00558840
Vues:
17
>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform