>Hi again Aleksey, and once more thank you for your reply.
>
>You say that I have to set the UpdateCmdDataSource and UpdateCmdDataSourceType etc for the deletecmd to work, however, the documentation on datasource states the following:
>
>"If the CursorAdapter InsertCmdDataSourceType, UpdateCmdDataSourceType, and DeleteCmdDataSourceType properties are empty, the CursorAdapter DataSource property overrides the CursorAdapter InsertCmdDataSource, UpdateCmdDataSource, and DeleteCmdDataSource properties."
>
>Is this incorrect when using the deletecmd property?
>
>Thanks,
>
>Eyvind.
Hi Eyvind,
There is an exception in ADO case. What is the DataSource property set to in ADO case? It is set to Recordset. Is Recordset something that should be used to execute commands?
This exception is documented in "Data Access Management Using CursorAdapters" topic:
When using this method, you should configure the CursorAdapter
object as follows:
THIS.UpdateCmdDataSourceType="ADO"
THIS.UpdateCmdDataSource=NewADODBCommandObject
Setting THIS.DataSourceType="ADO" does not apply when using this method.
Thanks,
Aleksey.