Hi there,
I'm using the MYOB ODBC driver to export some job and charging details from a custom application. Is there any way to update an existing invoice using ODBC, or can I only insert new ones?
A:
I donot think you can by using the import_xxxx tables via the MYOB ODBC Driver, you can only import by using the MYOB Import wizard.
schrodinger's code
2009-11-11 23:28:15
Yep, this is the case, unfortunately :(
Brent
2009-11-12 05:12:23
Hi Brent,I asked MYOB, they replied me that it is possible by adding IDENTIFY_BY parameter in the connection string, such as IDENTIFY_BY = CARD_NAME or IDENTIFY_BY = CARD_ID or IDENTIFY_BY = RECORD_ID. Hope it is helpful.
schrodinger's code
2009-11-16 11:46:52