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

2014-10-14 Thread Jorge Carrión
Ok. Thanks a lot. Regards. 2014-10-14 14:58 GMT+02:00 Benoît Minisini : > Le 14/10/2014 11:10, Jorge Carrión a écrit : > > Nobody answer this question, but I want add what I've found in hope that > it > > helps someone who same problem: > > > > If your SQL sentence uses a Mysql function > > So y

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

2014-10-14 Thread Benoît Minisini
Le 14/10/2014 11:10, Jorge Carrión a écrit : > Nobody answer this question, but I want add what I've found in hope that it > helps someone who same problem: > > If your SQL sentence uses a Mysql function So you use MySQL. You didn't tell that in your first mail, how can we guess? > as mid, or sub

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

2014-10-14 Thread Jorge Carrión
Nobody answer this question, but I want add what I've found in hope that it helps someone who same problem: If your SQL sentence uses a Mysql function as mid, or substring or date_format or whatever, then table name is added to regular resultfields name (with or without alias) and fields who uses

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

2014-10-13 Thread 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