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?
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!!
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
Return to “ZeosLib 7.0 Beta Forum”
Jump to
- Links
- ↳ Bugtracker
- ↳ Downloads
- ↳ Subversion
- ↳ GitHub
- ZEOS Library - General
- ↳ Announcements
- ↳ Downloads
- ↳ Documentations
- ↳ Tutorials
- ↳ ZDBC (ZEOS Database Connectivity)
- ↳ User Contributions
- ↳ Feature Requests
- ↳ User Patches
- ZEOS DBO v8.x
- ↳ ZeosLib 7.3/8.0 Forum
- ZEOS DBO v7.x
- ↳ ZeosLib 7.2 Forum
- ↳ ZeosLib 7.1 stable Forum
- ↳ ZeosLib 7.0 Stable Forum
- ↳ ZeosLib 7.0 Beta Forum
- SQL Servers and Databases
- ↳ ADO
- ↳ DB2
- ↳ Firebird
- ↳ Interbase
- ↳ MS SQL Server
- ↳ MySQL
- ↳ Oracle
- ↳ OleDB (Microsoft Windows)
- ↳ ODBC
- ↳ PostgreSQL
- ↳ SQLite
- ↳ Sybase ASE
- Compiler related
- ↳ CBuilder / C++
- ↳ Lazarus / Freepascal
- ZEOS DBO V 6.x
- ↳ 6.6 - stable
- ↳ 6.5.1 (alpha) - 6.6.x (beta)
- ↳ 6.1.5
- ↳ Other 6.x Versions
- ↳ Bug Reports
- ZEOS DBO V 5.x
- ↳ 5.x Versions
- Software projects using ZeosLib
- ↳ SQLite Administrator
- Other and Non-Technical
- ↳ Off Topic