Post problem Delphi 2010
Posted: 08.06.2010, 17:04
Hi,
I use Zeos lib 7.0.0 with delphi 2010 when : ZQuery_Gastos.Post send syntax
error ¿?. The SQL string is ok
Select * from Gtos_Gastos
Order By Gto_Fecha
Only en INSERT mode, when modified register work OK
When debug with ZSQLMonitor the SQL instruction is BAD, all field name is incorrect.
2010-06-17 16:16:52 cat: Execute, proto: mysql-5, msg: INSERT INTO comuni84_pttk.Gtos_Gastos (Gto_ ,Gto_F ,Gto_M ,Gto_Desc ,Gto_Ti ,Gto_ ,Gto_C_tipo) VALUES (53,'2010-06-17',2131,'zcvxcv',2,NULL,NULL), errcode: 1054, error: Unknown column 'Gto_' in 'field list'
All field name is truncate.
I view all data the in dbGrid and use DbNavigator for insert/save
Any idea?
I use Zeos lib 7.0.0 with delphi 2010 when : ZQuery_Gastos.Post send syntax
error ¿?. The SQL string is ok
Select * from Gtos_Gastos
Order By Gto_Fecha
Only en INSERT mode, when modified register work OK
When debug with ZSQLMonitor the SQL instruction is BAD, all field name is incorrect.
2010-06-17 16:16:52 cat: Execute, proto: mysql-5, msg: INSERT INTO comuni84_pttk.Gtos_Gastos (Gto_ ,Gto_F ,Gto_M ,Gto_Desc ,Gto_Ti ,Gto_ ,Gto_C_tipo) VALUES (53,'2010-06-17',2131,'zcvxcv',2,NULL,NULL), errcode: 1054, error: Unknown column 'Gto_' in 'field list'
All field name is truncate.
I view all data the in dbGrid and use DbNavigator for insert/save
Any idea?