[Gambas-user] sqlite gambas table info?

[ML]

On 16/06/17 14:48, PICCORO McKAY Lenz wrote:
> its there some code to get BEFORE send the query the fields of the table?
>
> i mean, in the following code example i already know the column name, but i
> need firts detect column name to send amount of filters
>
> sCriteria *=* "id = &1"iParameter *=* *1012*$hConn*.*Begin' Same as
> "SELECT * FROM tblDEFAULT WHERE id = 1012"hResult *=*
> $hConn*.*Edit*(*"tblDEFAULT"*,* sCriteria*,* iParameter*)*
>
>
> in this case, the column "id" was previously knowed! but in my case i need
> to detect all the column names firts before send the filters/parameters
> criteria
>
> please any help?
>
> Lenz McKAY Gerardo (PICCORO)
> http://qgqlochekone.blogspot.com
Piccoro,

Does this help?

  Dim fld as Field
  For Each fld In Result.Fields
    ... do whatever with field names
  Next

zxMarce