[ADO] field property

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!

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

VB Code:

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

Try this code...

Yea, Attributes - forgot all about it.

Quote:

---

Originally posted by moinkhan

VB Code:

Debug.Print "This field is Nullable"

Try this code...

---

Yes, this seems to work :)

And for the "allow zero length"?

Thanx!

Don't remember exactly but try the constant
adFldMayBeNull