Ado multi-step error

[enigma333]

Need a work around for this

I want to create a recordset with this data:

Select Isnumeric(ID) as NID, Description FROM Table

and edit it.

current when i try to edit the NID field i get an error
Multi-step operation produced errors. Check each status value.

How can i make this editable

p.s. I do not need to update it to the database it is used only in the App.

Thanks in advance

 

[chiph]

You're using the IsNumeric function, the result of that function is non-editable. If you want to edit the ID column, you'll have to select it separately.

Chip H.

 

[chiph]

BTW, it sounds like you're using a recordset you got from the database as temporary storage for your program. I would suggest that this is a bad idea. If you want to pass records around within your program I'd copy them to a collection, and provide a way to update the database with the contents of your collection.

Chip H.

 

[enigma333]

Can you provide a simple example of how i would use a collection to do this?

 

[enigma333]

Also the reason i'm using a recordset is that i am databinding with a datasource object. The isnumeric boolean denotes whether it exists or not.