P
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?
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?