Previous - dbRsOpenQuery Section Home - Database Next - dbRsRowCount


dbRsFieldNames ( )

Obtains a list of fields (column heading) in the active recordset

Usage:

dbRsFieldNames (object me)

Parameter:

None

Returns:

( list of strings ) - a list of column field names for a particular table

Example:

xtRose = xtra("Rosetta").new( )
xtRose.dbOpen( "Provider=MSDASQL;ExtendedAnsiSQL=2;DRIVER={Microsoft Access Driver (*.mdb)};Dbq="&the moviepath&"main" )
xtRose.dbRsOpen( 2, "Select * from Test" )
strListFields = xtRose.dbRsFieldNames( )

Notes:


Previous - dbRsOpenQuery Section Home - Database Next - dbRsRowCount