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)