[Kexi-devel] drv_lastInsertRowID()

[Hîthwen Fëadûr]

On Fri, Aug 8, 2008 at 8:58 PM, Jaroslaw Staniek <js at iidea.pl> wrote:
>
> [Let's use (obsolete but working for now) kexi-devel at kde.org list. I am
> responding there.]
>
> How about using one sequence per table? (otherwise, one commos sequence
> would not create values starting from 1, what's exactly what users expect
> sometimes.


>
> beh->ROW_ID_FIELD_NAME logic is not compatible with our case, I am afraid,
> so unless I have missed something, KexiDB has to be altered: we need special
> case in the code where sequence is used. If you can provide one, we could
> refactor it later using new DriverBehaviour flag.
>
> How do you like this?
>
> In the end we've just added a "ROW_ID" column to every table using
drv_afterInsert and drv_createTable with a sequence so nothing more is
needed to be changed on KexiDB.
For the moment we can create tables (without pk) and insert data on them.

Regards,
Julia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.kde.org/pipermail/kexi-devel/attachments/20080811/6b946c43/attachment.html