Serial Auto Increment Field and Borland C Builder

From: PostgreSQL Admin <postgres(at)Firewall(dot)Mythos(dot)Org>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Serial Auto Increment Field and Borland C Builder
Date: 1999-04-26 23:11:28
Message-ID: 19990426191128.A30822@Gateway.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 "users", 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.

Now the question:

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message PostgreSQL Admin 1999-04-26 23:13:20 Borland C++ builder and Serial Fields
Previous Message PostgreSQL Admin 1999-04-26 23:02:32 Serial Auto Increment