stephanelux
Posts: 7
|
Posted: 07/22/2004, 9:25 AM |
|
Hi,
how can in create an autoincrement in codecharge for a primary key. I am unsing postgresql.
Kind regards
Stépbane
|
|
|
Anton Hinxman
|
Posted: 07/26/2004, 5:30 AM |
|
CREATE TABLE yourtable (
theautopk SERIAL PRIMARY KEY,
yourothercolumn INTEGER);
INSERT INTO yourtable VALUES(default,1234);
So the trick is to 'convince' CCS to supply the 'default' text against the PK value. You may have to do this in BeforeBuildInsert so that you can change the SQL build parameter for the PK?
|
|
|
|