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.
Date of registration: Nov 24th 2008
Location: Cologne, Germany
Occupation: Second Vice President of Distributed Junk and Trash Development
Friday, February 6th 2009, 12:51am
RE: Resultset - field names
Quoted from "frankp"
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
Similar threads
-
General topics, questions and discussions »-
Connect to MySQL database
(Jan 27th 2009, 4:41am)
-
- General topics, questions and discussions »
-
Accessing Excel Files
(Feb 3rd 2009, 1:34pm)
-
- Allgemeine Themen, Fragen und Diskussionen »
-
Datenbank anbinden
(Nov 28th 2008, 10:27pm)