Devart Forums

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

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.