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!
Printable View
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.
Yes, this seems to work :)Quote:
Originally posted by moinkhan
VB Code:
Debug.Print "This field is Nullable"
Try this code...
And for the "allow zero length"?
Thanx!
Don't remember exactly but try the constant
adFldMayBeNull