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

TIA
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Next
Reply
Map
View

Click here to load this message in the networking platform