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

[fvegaf]

This is the Mysql results shown in a terminal:


mysql> select Empleado, Codigo from Employees where empleado=9316;
+----------+--------+
| Empleado | Codigo |
+----------+--------+
|     9316 |   2917 |
+----------+--------+


And this is the Structure of the table
mysql> show columns from Employees;
+------------+------------------+------+-----+---------+-------+
| Field      | Type             | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| Empleado   | int(11)          | NO   | PRI | NULL    |       |
| Codigo     | int(11)          | NO   | MUL | 0       |       |
+------------+------------------+------+-----+---------+-------+




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--tp32674413p32681946.html
Sent from the gambas-user mailing list archive at Nabble.com.