I've got a bit of a problem.
I want to retrieve the names of the fields in a table. ( Simple ).
To do this I'm using ADOX.
I've got something like this.
Public Function GetFieldName(intFieldNo As Integer) As String
GetFieldName = ocat.Tables(mstrTableName).Columns(intFieldNo).Name
The problems is the fields are returned in Alphabetical order!!!!!
I want them in the same order as they are set in the DB.
Anyone got any ideas.????