Received: from Mythos.Org (IDENT:postgres@clt93-008.carolina.rr.com
	[24.93.93.8]) by hub.org (8.9.3/8.9.1) with ESMTP id RAA77654
	for <pgsql-interfaces@postgresql.org>;
	Mon, 26 Apr 1999 17:05:40 -0400 (EDT)
	(envelope-from postgres@Mythos.Org)
Received: (from postgres@localhost) by Mythos.Org (8.8.7/8.8.7) id TAA31044
	for pgsql-interfaces@postgresql.org; Mon, 26 Apr 1999 19:11:28 -0400
Message-ID: <19990426191128.A30822@Gateway.mythos.org>
Date: Mon, 26 Apr 1999 19:11:28 -0400
From: PostgreSQL Admin <postgres@Firewall.Mythos.Org>
To: pgsql-interfaces@postgresql.org
Subject: Serial Auto Increment Field and Borland C Builder
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Mailer: Mutt 0.93.2

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