Dear visitor, welcome to Jabaco - Community.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
Resultset - field names
Hello again,
How can I retrieve the field names from a Resultset?
Thanks
RE: Resultset - field names
How can I retrieve the field names from a Resultset?
|
Jabaco Source
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
Database1.ConnectMDB("D:\db1.mdb")
Dim myResultSet As ResultSet = Database1.ExecuteStatement("Select * From Table1")
Dim myResultSetMetaData As java#sql#ResultSetMetaData = myResultSet.getMetaData
Dim colCounter As Integer
For colCounter = 1 To myResultSetMetaData.getColumnCount
List1.AddItem myResultSetMetaData.getColumnName(colCounter)
Next
myResultSet.close
|
Greetings ... Peter
RE: RE: Resultset - field names