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. ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user