SERIAL with TTable in cbuilder - Mailing list pgsql-general

From Baurjan Ismagulov
Subject SERIAL with TTable in cbuilder
Date
Msg-id 20020930233904.GB684@gantek.com
Whole thread Raw
Responses Re: SERIAL with TTable in cbuilder
List pgsql-general
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.

I would appreciate any help.

Thanks in advance,
Baurjan.

P.S. Please cc to me, I'm not subscribed.

pgsql-general by date:

Previous
From: Mike Sosteric
Date:
Subject: Re: [SQL] arrays
Next
From: Richard Huxton
Date:
Subject: Re: Query optimization