GetOleDbSchemaTable DATA_TYPES?
Jun 8, 2011
I'm writing a little program that will synchronize two access database schema's. It works,to a point.My problem is, I'm unable to identify whats an AutoNumber and whats a Long Integer.Both DATA_TYPES are 3, same with COLUMN_FLAGS, both are 90. a Long Integer that doesn't allow nulls COLUMN_FLAGS will be 90 and its DATA_TYPE will be 3n AutoNumber will also be COLUMN_FLAGS = 90 and DATA_TYPE = 3all other fields I can test by are also identical. etc NUMERIC_PRECISION
View 3 Replies
Apr 22, 2010
It is not so hard to get the field names from a database via GetOleDbSchemaTable and OleDbSchemaGuid.Columns. It works fine. The field names come i alphabetical order though. I really need them in the correct field no order.
Used code:
connection.Open()
Dim schemaTable As DataTable = _
connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, tblname, Nothing})
[Code].....
View 4 Replies
Oct 7, 2011
dt = GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Indexes...
dt.Rows(i).Item("Index_Name") ==> gives the index name
dt.Rows(i).Item("Column_Name") ==> gives the column name on which we created the index
[code]....
View 4 Replies
