Re: error sintax

[mauro rr]

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE IF NOT EXISTS `histacoes` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`titular` varchar(8) NOT NULL,
`ativo` varchar(8) NOT NULL,
`data` date NOT NULL DEFAULT '0000-00-00',
`nota` varchar(8) NOT NULL,
`agente` varchar(10) NOT NULL,
`hist` varchar(4) NOT NULL,
`quant` int(11) NOT NULL DEFAULT '0',
`cota` decimal(10,2) NOT NULL DEFAULT '0.00',
`vrativo` decimal(10,2) NOT NULL DEFAULT '0.00',
`corret` float(10,2) NOT NULL DEFAULT '0.00',
`emol` decimal(8,2) NOT NULL DEFAULT '0.00',
`vrliquidocompra` float(10,2) NOT NULL,
`saldocompras` float(10,2) NOT NULL,
`vrliquidovenda` float(10,2) NOT NULL,
`precomedio` float(10,2) NOT NULL,
`custodia` decimal(8,2) NOT NULL DEFAULT '0.00',
`taxas` decimal(4,2) NOT NULL DEFAULT '0.00',
`baseir` decimal(10,2) NOT NULL DEFAULT '0.00',
`ir` decimal(10,2) NOT NULL DEFAULT '0.00',
`saldoqtd` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;



tabelas.THist.Open;
tabelas.THist.Insert;
tabelas.THistsaldoqtd.Value := eqsaldo;
tabelas.Thist.Post;
tabelas.Thist.Close;

'you have an error in your SQL sintax. Check the manual that corresponds to your mysql server version for the right sintax to use near "at line '.

I receive the error message when eqsaldo=0 (zero).