SERIAL with TTable in cbuilder

From: Baurjan Ismagulov <ibr(at)ata(dot)cs(dot)hun(dot)edu(dot)tr>
To: pgsql-general(at)postgresql(dot)org
Subject: SERIAL with TTable in cbuilder
Date: 2002-09-30 23:39:04
Message-ID: 20020930233904.GB684@gantek.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-09-30 23:41:03 Re: cursors
Previous Message Jeff Davis 2002-09-30 23:13:08 composite types in 7.3