-
With SQL database and using ADO, is there anyway to access in VB, the default values of particular fields in the database?
The field object of a recordset doesn't seem to have a 'defaultvalue' property and ADOX seems to have the same limitation.
Any ideas attall would be appreciated?
Simon.
-
TableDef
Simonm,
It is actually straightforward. Code ....
Dim tbldefs As TableDef
Set tbldefs = dbs.TableDefs!<table name>
With tbldefs
c = .Fields(0).Size
End With
msg=msgbox(c)
___________
-
Unfortunately...
That's not quite what I'm looking for.
Firstly, ADO doesn't have 'Tabledef' objects.
Secondly, I want the 'DEFAULT VLAUE' and not the 'SIZE' property of the field.
Thanks anyway.