Cannot Get Field Nullable Property

[Paul Eaton]

Hi

I am using asp/vbscript/ado/mssql.

I am able to get the nullable property OK when generating a recordset
with a simple SQL statement such as "select Fld1,Fld2 from Table1" and
then looping thro' the fields and :-

Response.Write(rs.fields(x).attributes and adFldIsNullable)

When I use the following statement all fields are erroneously reported
as nullable:-

"Select B.Fld2, B.Fld3 From Table1 A Left Join Table2 B On
A.Fld1=B.Fld1"

Is this normal?

[Bob Barrows]

This recordset may not even be updatable, and you're worried about whether
or not the fields are nullable?

If you set the Unique Table dynamic property, you may get the true results
for the fields. You can only set this property if you use a client-side
cursor (adUseClient). I have no idea if this will work. I've never tried to
update a recordset whose source was a multi-table select statement.

Bob Barrows

Paul Eaton wrote:

Hi

I am using asp/vbscript/ado/mssql.

I am able to get the nullable property OK when generating a recordset
with a simple SQL statement such as "select Fld1,Fld2 from Table1" and
then looping thro' the fields and :-

Response.Write(rs.fields(x).attributes and adFldIsNullable)

When I use the following statement all fields are erroneously reported
as nullable:-

"Select B.Fld2, B.Fld3 From Table1 A Left Join Table2 B On
A.Fld1=B.Fld1"

Is this normal?

[Aaron Bertrand - MVP]

Do you need to get the *data* in order to get the metadata? How about
grabbing the column names and whether they are NULL or not from the I_S
view:

sql = "SELECT COLUMN_NAME, IS_NULLABLE " & _
" FROM INFORMATION_SCHEMA.COLUMNS " & _
" WHERE TABLE_NAME='Table1'"
set rs = conn.execute(sql)
do while not rs.eof
response.write rs(0) & " nullable? " & rs(1) & "<br>"
rs.movenext
loop

"Paul Eaton" <pe****@pt.lu> wrote in message
news:13**************************@posting.google.c om...

Hi

I am using asp/vbscript/ado/mssql.

I am able to get the nullable property OK when generating a recordset
with a simple SQL statement such as "select Fld1,Fld2 from Table1" and
then looping thro' the fields and :-

Response.Write(rs.fields(x).attributes and adFldIsNullable)

When I use the following statement all fields are erroneously reported
as nullable:-

"Select B.Fld2, B.Fld3 From Table1 A Left Join Table2 B On
A.Fld1=B.Fld1"

Is this normal?