Retrieving the default-value for a field in an Access-table

  • Thread starter Thread starter Olaf Rabbachin
  • Start date Start date
O

Olaf Rabbachin

Hi folks,

I'm looking for a way of retrieving the default-value of a table's field
within an Access 2003 MDB.
Any hints on how to accomplish this from ASP.Net?

Thanks,
Olaf
 
Hi,

Olaf said:
I'm looking for a way of retrieving the default-value of a table's field
within an Access 2003 MDB.
Any hints on how to accomplish this from ASP.Net?
Click to expand...

got it (although not all too satisfying - see below).
Here's some code that'll display all columns within a given table along
with their default-values:

--- 8< ---
Dim cn As New OleDbConnection
cn.ConnectionString = "Whatever ..."
cn.Open()

Dim tbl As DataTable
tbl = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, _
New Object() {Nothing, Nothing, "Name of Table", Nothing})

For Each r As DataRow In tbl.Rows
Response.Write _
r("COLUMN_NAME") & ": " & _
r("COLUMN_DEFAULT") & "<br />"
Next
--- 8< ---

If anybody has a more appropriate way of retrieving this by a column's name
(rather than looping through all columns), let me know!

Cheers,
Olaf
 
Back
Top