TOdbcConnection Documentation / Tutorial
lazarus / 16-Databases

----------------------------------------------------------------------
stunz · 2008-04-06 20:55

Hi All,

does anybody know where I can find documentation for TODBCConnection,
or a tutorial, or maybe even somebody here may be able to help.

I'm communicating with the accounting package MYOB, so getting a
premade library doesn't appear to be an option.

I've tried all manners of combinations for inserting/updating data,
but it requires Transaction.Commit and I can't for the life of me find
a way to go from an SQL query to commiting the transaction, and it
working.

And the driver's OK, it does have an auto-commit option, and I can
call ODBCConnection.ExecuteDirect and it works, problem is to enable
auto-commit you have to edit an obscure ini file, which you don't
really want your end clients to have to edit to run the software.

Thanks in advance