Re: Bound column and serial datatype question
От | lothar.behrens@lollisoft.de |
---|---|
Тема | Re: Bound column and serial datatype question |
Дата | |
Msg-id | 426AA836.10599.250D1A8@localhost обсуждение исходный текст |
Ответ на | Re: Bound column and serial datatype question (Marko Ristola <marko.ristola@kolumbus.fi>) |
Список | pgsql-odbc |
Am 23 Apr 2005 um 9:57 hat Marko Ristola geschrieben: I have solved the problem by shortly unbind the affected column. The problem, that will stay, is that I do not know, how to detect such a column by an ODBC call like SQLDescribeCol. Lothar > > If you remove the NOT NULL definition from the CustomerNr, > you can put there a NULL value too. > > The SQL email list is better for these questions, because they have > more knoledge of these kinds of problems ... > > (The CustomerNr and ID columns seem to have redundant information.) > > Regards, > Marko Ristola > > lothar.behrens@lollisoft.de wrote: > > >Hi, > > > >I have a table like this: > > > >CREATE TABLE Kunden > >( > > ID serial NOT NULL, > > CustomerNr serial NOT NULL, > > Name CHAR(100), > > ... > >); > > > >Using bound columns in a form to show the customer data I don´t like to let the user > >updating the CustomerNr field. This is because, a normal data field is not > >autogenerated, but these 'serial' data fields. > > > >But I like to show the CustomerNr field in the form. Therefore, I simply made the > >field readonly in the form. But if I insert a new row, the fields data (defaults to 0) > >would be used as the new value in the table. > > > >How to avoid this ? > > > >Thanks > > > >Lothar > > > >-- > >Lothar Behrens www.lollisoft.de > >Rosmarinstr 3 My public project: > >40235 Düsseldorf http://sourceforge.net/projects/lbdmf > > > > > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 8: explain analyze is your friend > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Lothar Behrens www.lollisoft.de Rosmarinstr 3 My public project: 40235 Düsseldorf http://sourceforge.net/projects/lbdmf
В списке pgsql-odbc по дате отправления: