koledb

← →
boguslaw (2009-05-13 19:58) [0]

Hello,

Do you know that koledb support transaction at least for MS Access provider ?
Simply by using "begin transaction","rollback" and "commit" as query text.

But I really wanted to ask how to retrieve last inserted value of primary key column of row.It was automatically generated by Access but I don"t know if simple select max(id) from table is good enough due to two programs working with the same database.

Any ideas ?

Boguslaw

← →
boguslaw (2009-05-13 20:53) [1]

I have found "select @@Identity" which should work as mentioned in MSDN returning last inserted id (value of autoincrement primary key) per connection
but it always returns zero for koledb with connection to jet 4.0 provider

Why ?

It should return zero only in case when each TQuery executed in separate connection . Is that the way koldb TQuery.execute and open method work ?

← →
boguslaw (2009-05-13 21:11) [2]

OK.It maybe works but I"m using Access 97 database and it"s marked as unsupported. It might work for Access 2000 and uppser using jet 4.0 :-(

У меня всегда в TDataSource.Destroy строка

if Initialized then CheckOLE(fIDBInitialize.UnInitialize);

выводит "OLE DB Error 80040E05". Даже пример в комплекте с KOLEdb по Free выдает тоже самое. Что при UnInitialize не то - не пойму.

koledb Найти похожие ветки