use uniloader on auto increase column

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
allegro
Posts: 8
Joined: Wed 15 May 2013 06:56

use uniloader on auto increase column

Post by allegro » Fri 21 Jun 2013 02:13

When I insert record into Oracle with uniloader, How to use auto increase column?
eg, sql: insert tab_a (id, name) value (id.nextval, 'tom');

DemetrionQ
Devart Team
Posts: 271
Joined: Wed 23 Jan 2013 11:21

Re: use uniloader on auto increase column

Post by DemetrionQ » Fri 21 Jun 2013 10:45

Hello.

Sequence cannot be used in TUniLoader. To solve the problem, you should create a trigger, that will fill in the "auto increase" column (using sequence) when inserting a new record.

Post Reply