Home »
Public Forums »
archive »
Dataminer: LOCK TABLES does not work (myodbc)
| Dataminer: LOCK TABLES does not work (myodbc) [message #36356] |
Fri, 05 September 2003 04:07 |
Olaf Stetzer
Messages: 39
Registered: September 2001
|
Member |
|
|
Hello,
I am currently writing function/procedure
which writes data to a mysql-table
(using myodbc on Win2000). I want
to do it as correct as possible and tried
LOCK TABLES (with: dbobj->ExecuteSQL) for
the first time.
Unfortunately I got an error message that
I cannot write to the table afterwards because
it is locked! I used the same database object
for locking and writing of course. I am not
sure if myodbc or dataminer is to blame but
it seems, that for both SQL-statements individual
database-threads are started. LOCKING is only
working inside the same thread, though!
Anyone having experience in these issues? I have
once again the feeling that the dataminer is only
providing a very minimum of database functionality
for a very high price! :-(
Olaf (a little bit disappointed)
|
|
|
|
Current Time: Wed Oct 08 13:48:12 PDT 2025
Total time taken to generate the page: 0.00522 seconds
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
