Re: SERIAL with TTable in cbuilder

On Tue, 1 Oct 2002, Baurjan Ismagulov wrote:

> Hello,
>
> Sorry for a slightly off-topic posting, writing in hope that some of you
> might have encountered and solved the problem I'm experiencing. I've
> searched cbuilder and postgres archives, but couldn't find anything
> relevant.
>
> I'm trying to insert records from a dialog box using TTable (Windows
> client, ODBC). I don't have a control for my SERIAL field. When I
> Table1->Post(), Borland classes raise an exception saying smth. like
> "field xxx should have a value", since the autoincremented field is
> declared NOT NULL. I don't want to read the sequence from the client. Is
> there a way to have TTable not insert a value for that field? I've also
> tried an updatable TQuery where I select all fields except the SERIAL,
> but that didn't work either.

Try using the value DEFAULT with no ' marks around it. like this:

insert into table (dat,nam,id) values ('2000-02-02','Marlowe',DEFAULT);

That should work