[ADO] field property

[neodatatype]

Hi all!

someone can tell me how can I do to know if a field is NULLABLE and ALLOW_ZERO_LENGTH?

With ADODB, not ADOX.

Thank you!

[IROY55]

You may get Recordset.Fields("Field1").Type but it's probably not what you need.

[moinkhan]

If MyRec.Fields(1).Attributes And adFldIsNullable Then\
 
  Debug.Print "This field is Nullable"
End If

Try this code...

[IROY55]

Yea, Attributes - forgot all about it.

[neodatatype]

Originally posted by moinkhan

Debug.Print "This field is Nullable"

Try this code...

Yes, this seems to work

And for the "allow zero length"?

Thanx!

[moinkhan]

Don't remember exactly but try the constant
adFldMayBeNull