Post problem Delphi 2010

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

Locked
pttk
Junior Boarder
Junior Boarder
Posts: 37
Joined: 24.03.2006, 15:07

Post problem Delphi 2010

Post by pttk »

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?
PTTK
Locked