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

[Fabien Bodard]

2011/10/19 fvegaf <fvegaf at ...67...>:
>
> 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

:)

Codigo is not codigo

SQL is case sensitive

so
var = resEmp!Codigo


>> '-----------------
>> 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.
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2d-oct
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>



-- 
Fabien Bodard