Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to add a temporary field to an ADO rs
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00517413
Message ID:
00517538
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform