MySQL Forums

Hello, first, sorry by my English... i am from Argentina, and i have this error..

Sep 25 00:51:23.641 2009@LM_DEBUG@(3038837648) (9896738) OPENDB::query - SQL <CREATE TEMPORARY TABLE tt_posnet_c SELECT t.*, c.Cuotas, c.TipoCuotas FROM compras c INNER JOIN transacciones t ON c.CodigoEmpresa = t.CodigoEmpresa AND c.CodigoSucursal = t.CodigoSucursal AND c.CodigoCaja = t.CodigoCaja AND c.CodigoAutorizador = t.CodigoAutorizador AND c.NumeroUnico = t.NumeroUnico WHERE t.EstadoDeEnvio = 'OFF' AND t.CodigoDeRespuesta = 0 AND t.CodigoAutorizador = 3 AND t.Estado = 0 LIMIT 50>
Sep 25 00:51:23.644 2009@LM_INFO@(3038837648) TaskEnvioOff::svc - SQLException errorCode 0 sqlState <07005> Message <Error fetching numeric attribute: [MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-24+lenny2]No result set>
Sep 25 00:51:23.644 2009@LM_DEBUG@(3038837648) (9896738) OPENDB::query - SQL <Select * from tt_posnet_c >
Sep 25 00:51:23.645 2009@LM_DEBUG@(3038837648) (9896738) OPENDB::query - sql_row 0 TIME 0


I'm trying to create a temporary table, when i execute this in the console, it works fine, but in the program doesn't.

i'll access to the DB, with "isql -v prueba" command, and try it and works fine too... so the driver isn't the problem.

I'm with Debian Lenny.

Thanks..!!!
Luis.