[Gambas-user] table name from db object result

[PICCORO McKAY Lenz]

in sqlite or odbc how can extrat the table name, due i try to autodetect
the field name from a result:

For indexcol = 0 To rsObj.Fields.Count - 1
      rsObj.Fields[indexcol].Name
next

but in sqlite case i get string: "tablename.colname" event "colname"

so there's some property or method that can showme the table,

NOTE: i know that i made the select so the tablename must be.. but there's
another way? its for a dataexporter between databases

Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com