Error in Post Zquery

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

Error in Post Zquery

Post by pttk »

Hy

I have very extraneous error, when try post this Zquery:

select * from LegalFlash_Responsables
Where Res_CodigoUsuario=:n_Usuario

Send any scribbles and not save the record.

All another Zquery word OK.

Any idea?

PTTK
You do not have the required permissions to view the files attached to this post.
PTTK
pttk
Junior Boarder
Junior Boarder
Posts: 37
Joined: 24.03.2006, 15:07

Post by pttk »

The error is : Column count doesn't match value count at row 1

I use Zquery for update data grid

Any idea?
PTTK
bravecobra
Junior Boarder
Junior Boarder
Posts: 29
Joined: 31.10.2005, 00:09
Location: Antwerp
Contact:

Post by bravecobra »

What Delphi version are you using?
Brave Cobra
bravecobra.com
jeremicm
Senior Boarder
Senior Boarder
Posts: 61
Joined: 18.10.2006, 17:07
Contact:

Post by jeremicm »

i had same error when i tried to make access frontend some time ago...

check if your database field names are correct in your code. i made that mistake...
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

Another thing you should do to debug this is add a TZSQLMonitor component and record the exact SQL sent to the server. That way we might see what zeoslib tries to send to the database.

Mark
Image
Locked