I am using ADO via MS-Access VBA to connect QODBC:
Set cn = CreateObject("ADODB.Connection") cn.Open "DSN=Quickbooks Data;OLE DB Services=-2;"
I can check if this is successful by testing adStatus, no problem there.
Then I am adding bill line items through an INSERT statement with cn.Execute
How may I then determine if the INSERT worked? Do I check the number of records affected?
The format of the Execute Command is as follows. Do you recommend any Options?
connection.Execute CommandText, RecordsAffected, Options
One other question:
When I am inserting serveral bill line items, should I use the ADO transaction/rollback or should I use the batch SP's provided by QODBC or both?
Thanks
|