[Gambas-user] Unknown field -- Case sensitive fields?

[fvegaf]

I'm using mysql database.


fvegaf wrote:
> 
> I'm getting the error "unknown field: codigo"
> 
> This os the code:
> '-----------------
> cQuery = "Select Empleado, Codigo from Empleado where empleado=101010"
> resEmp = con1.Exec(cQUery)
> 
> FOR EACH resEmp
>   var = resEmp!codigo
> NEXT
> '-----------------
> The line os on the line: "var = resEmp!codigo", changing to "var =
> resEmp!Codigo" the error goes away.
> 
> This used to work on gambas 1 (1.0.18), bur now in gambas2 (2.8) is
> complaining about the exact case as defined in the query, or if I use
> "select *" as defined in the Table.
> 
> Is there a way to make it "case insensitive"?
> 
> Thanks in advance for your valuable time.
> 
> ps. I'm using Ubuntu 8.04 32 bits.
> 
> 

-- 
View this message in context: http://old.nabble.com/Unknown-field----Case-sensitive-fields--tp32674413p32675906.html
Sent from the gambas-user mailing list archive at Nabble.com.