2011/10/19 fvegaf <[email protected]>: > > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Fabien Bodard ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
