From: | PostgreSQL Admin <postgres(at)Mythos(dot)Org> |
---|---|
To: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Serial Auto Increment |
Date: | 1999-04-26 23:02:32 |
Message-ID: | 199904262302.TAA30762@Mythos.Org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Let me give a simple example of what I am trying to do:
CREATE SEQUENCE "usernumber" start 0 increment 1;
Create table users (
name varchar(255),
userid int4 DEFAULT nextval ( 'usernumber' ) NOT NULL);
);
>From Borland C++ Builder I create a form with a
link to the table userid and a navigator bar and a DBedit object linked
to the field userid.
When I post new record, an error is returned that users.name cannot be
null, which is true. Is there a way to make Borland C++ Builder only
update the field "name" and let Postgresql take care of the
updating the serial field "userid"
Thanks,
Travis
From | Date | Subject | |
---|---|---|---|
Next Message | PostgreSQL Admin | 1999-04-26 23:11:28 | Serial Auto Increment Field and Borland C Builder |
Previous Message | H.P.Heidinger | 1999-04-26 22:36:55 | PGSQL on AIX (4.3) ... |