After write the sql sentence, I go in tab SQL generator and click in Generate SQL. The updateSQL , deleteSQL receive the code below:
******************
UPDATE tbl_geral_combustiveis
SET
CODIGO = :CODIGO, DT_SISTEMA = :DT_SISTEMA, HR_SISTEMA = :HR_SISTEMA, OPERADORID = :OPERADORID, NOME = :NOME
WHERE
CODIGO IS NULL
**********************
DELETE FROM tbl_geral_combustiveis
WHERE
CODIGO IS NULL
*******************************
Look.. the where clause codigo is null.. Why?
tanks !
MySQL server version: 5.1.22-rc-community
MySQL client version: Direct
MyDAC 5.50.0.34
Delphi 2007 build 11.0.2804.9245