SERIAL with TTable in cbuilder

Поиск
Список
Период
Сортировка
От Baurjan Ismagulov
Тема SERIAL with TTable in cbuilder
Дата
Msg-id 20020930233904.GB684@gantek.com
обсуждение исходный текст
Ответы Re: SERIAL with TTable in cbuilder
Список 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 по дате отправления:

Предыдущее
От: Mike Sosteric
Дата:
Сообщение: Re: [SQL] arrays
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Query optimization