[Gambas-user] A question about SQL field's names in gambas

[Jorge Carrión]

When I do a call to my_conexion.exec method, like this.

myresult=myconexion.exec("select
`idactuacion`,`iddocumentos`,`fecha`,concat(`nombre`,`extension`) as
`Nombre` from `documentos` where `idactuacion`= 288)

(Two first fields ar integer, third a date and the rest strings.)

Sometimes I receive a result wich have the Fields name as I defined in sql
sentence and sometimes I receive a tableName.Fieldname as field name and
not even in every field of same sql sentence...

I always thought that tablename.fieldname where returned as desambiguation
of similar names but that's not so since in the sql there isn't ambiguities.

Same sql sentence in phpmyadmin, by example, works fine...


How can be controled the fieldsname to be returned?

Regards