From: | "Brien R(dot) Givens" <ic3b3rg(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2818: ADO Field.Attributes reports NULL on NOT NULL fields |
Date: | 2006-12-08 18:51:53 |
Message-ID: | 200612081851.kB8IprCj021515@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2818
Logged by: Brien R. Givens
Email address: ic3b3rg(at)gmail(dot)com
PostgreSQL version: 8.2
Operating system: Win XP
Description: ADO Field.Attributes reports NULL on NOT NULL fields
Details:
In ADO, the nullability of a field can be tested against its Attributes
property. Another option is to examine the Schema. As shown below, the
Attributes property of a NOT NULL field indicates it is nullable while the
Schema reports that it is not.
ADO Code:
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={PostgreSQL
ANSI};Server=localhost;Database=clinic;UID=clinic;PWD=c0nner99"
conn.Execute "DROP TABLE test"
conn.Execute "CREATE TABLE test (f1 INT NOT NULL)"
Set rs = Server.CreateObject("ADODB.recordset")
rs.Open "test", conn, adOpenStatic, adLockReadOnly, adCmdTableDirect
Response.Write ((rs(0).Attributes And adFldIsNullable) = adFldIsNullable) &
"<br>"
rs.Close
Set rs = conn.OpenSchema(adSchemaColumns,Array(Empty,Empty,"test","f1"))
Response.Write rs("IS_NULLABLE")
rs.Close
conn.Close
-- OUTPUT --
True
False
From | Date | Subject | |
---|---|---|---|
Next Message | David Lee Lambert | 2006-12-08 22:46:42 | "Julian day" date format is off by 12 hours |
Previous Message | Juan Pablo Yañez | 2006-12-08 16:00:39 | unsubscribe |