ODAC to MyDAC conversion insert issue
Posted: Wed 29 Jan 2020 22:07
Using Rio Update 3 and latest MyDAC components as of today.
I am in the process of slowly moving programs from Oracle to MySQL at work.
I finished converting one of my long running programs that have used Devart's ODAC component set.. 10 years old or so...
Went mostly smoothly.. just rename some components from ODAC to MyDAC and tweak a few SQL statements to use the MySQL version of an Oracle call.
Anyways, the only big thing I ran into was inserts.
When I do inserts with the MyDAC, after execsql's ... I then need to do a Commit SQL Statement.
With the ODAC components, I didn't need the Commit calls....
I don't use transactions or anything, as almost everything I work with is either just add it to existing tables or truncate it and refill it all with new stuff. Few gb of data nightly of stuff... nothing to crazy.
Hate to be that guy, but am I missing something in the TMyConnection or TMyQuery properties... or just how MySQL likes to work.
I've been using ODAC for 10 years roughly, so been very use to how that works and in all the years, I think I reported 1 bug/issue...
I am in the process of slowly moving programs from Oracle to MySQL at work.
I finished converting one of my long running programs that have used Devart's ODAC component set.. 10 years old or so...
Went mostly smoothly.. just rename some components from ODAC to MyDAC and tweak a few SQL statements to use the MySQL version of an Oracle call.
Anyways, the only big thing I ran into was inserts.
When I do inserts with the MyDAC, after execsql's ... I then need to do a Commit SQL Statement.
Code: Select all
qInsertSomething.SQL.Text := 'Insert Into Blah......';
qInsertSomething.execsql;
qInsertSomething.SQL.Text := 'Commit;
qInsertSomething.execsql;
I don't use transactions or anything, as almost everything I work with is either just add it to existing tables or truncate it and refill it all with new stuff. Few gb of data nightly of stuff... nothing to crazy.
Hate to be that guy, but am I missing something in the TMyConnection or TMyQuery properties... or just how MySQL likes to work.
I've been using ODAC for 10 years roughly, so been very use to how that works and in all the years, I think I reported 1 bug/issue...