Re: Bound column and serial datatype question - Mailing list pgsql-odbc

From lothar.behrens@lollisoft.de
Subject Re: Bound column and serial datatype question
Date
Msg-id 426AA836.10599.250D1A8@localhost
Whole thread Raw
In response to Re: Bound column and serial datatype question  (Marko Ristola <marko.ristola@kolumbus.fi>)
List 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 by date:

Previous
From: "Joel Fradkin"
Date:
Subject: Re: [PERFORM] Joel's Performance Issues WAS : Opteron vs Xeon
Next
From: Typing80wpm@aol.com
Date:
Subject: Ambiguities in ODBC Install Parameters