Linux - Live Free or Die.
From: fvegaf
To: gambas-user@lists.sourceforge.net
Sent: Wednesday, October 19, 2011 7:16 PM
Subject: Re: [Gambas-user] Unknown field -- Case sensitive fields?
Why did it change from gambas 1 to Gambas 2?
The same code was working
Le 20/10/2011 01:16, fvegaf a écrit :
>
> Why did it change from gambas 1 to Gambas 2?
>
> The same code was working fine in Gambas 1.
>
This was an error to do that in Gambas 1, because fields are actually
case sensitive in some of the underlying database servers.
--
Benoît Minisini
-
2011/10/20 fvegaf :
>
> Why did it change from gambas 1 to Gambas 2?
>
> The same code was working fine in Gambas 1.
>
and there is change from gb2 to gb3... in other case we are never evolve
gb1 is really old for us
>
> fvegaf wrote:
>>
>> I'm getting the error "unknown field: codigo"
>>
>> This
Why did it change from gambas 1 to Gambas 2?
The same code was working fine in Gambas 1.
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(cQ
2011/10/19 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
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 Employ
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
> '
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", chang