Need some help...
I have a grid in my program that is filled from a read-only ADO SQL Query. On the grid there is a checkbox column I want the user to be able to click on to select/deselect a row. The checkbox does not have a corresponding field in the view, is is just defined as "0 as ChkBox" in the query.
When I try to click the checkbox at runtime and change its value from 0 to 1 it causes an error, looks like because the query is read-only.
I think what I'd like to do is copy the ADO recordset to another that isn't directly linked to the database view, so I can make changes to it that won't be reflected in the view.
Is this as simple as cloning the recordset or is there something else I have to do?
Thanks for any help you can provide.
I have a grid in my program that is filled from a read-only ADO SQL Query. On the grid there is a checkbox column I want the user to be able to click on to select/deselect a row. The checkbox does not have a corresponding field in the view, is is just defined as "0 as ChkBox" in the query.
When I try to click the checkbox at runtime and change its value from 0 to 1 it causes an error, looks like because the query is read-only.
I think what I'd like to do is copy the ADO recordset to another that isn't directly linked to the database view, so I can make changes to it that won't be reflected in the view.
Is this as simple as cloning the recordset or is there something else I have to do?
Thanks for any help you can provide.