Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to add a temporary field to an ADO rs
Message
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00517413
Message ID:
00517538
Vues:
22
This message has been marked as a message which has helped to the initial question of the thread.
>Hi,
>
>I need to add an extra field to a recordset for display purposes in a grid control. I want to grab the rs from the table spin through and populate this extra field with custom data for the display. The custom data is just discarded when it's done.
>
>I tried closing the rs, adding a field to the rs with ors.fields.append, but when I called .open on rs the new field disappeared.
>
>I also tried creating the rs via SQL with "Select '' as DisplayName, * from MyTable", which gives me the rs but when I do rs!DisplayName = "SomeText" I get the error: Multiple step operation generated errors. Check each status value.
>
>Anybody know how to do this?

Can this help you: http://support.microsoft.com/support/kb/articles/Q223/7/71.ASP
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform