Parameter data_cad not found

[htiuk]

i have this message 'Parameter data_cad not found' in the code:

TMyQuery1.Close;
TMyQuery1.SQL.Clear;
TMyQuery1.SQL.Add('UPDATE clientes1 SET ('data_cad=:dt_cad,
'data_alt = :dt_alt');
TMyQuery1.Execute;

Delphi 2007 and MyDac 5.10.0.10

[htiuk]

i have this message 'Parameter data_cad not found' in the code:

TMyQuery1.Close;
TMyQuery1.SQL.Clear;
TMyQuery1.SQL.Add('UPDATE clientes1 SET data_cad=:dt_cad,
'data_alt = :dt_alt');
TMyQuery1.ParamByName('dt_cad').AsDate := Date;
TMyQuery1.ParamByName('dt_alt').AsDate := Date;
TMyQuery1.Execute;

Delphi 2007 and MyDac 5.10.0.10

[eduardosic]

i have this message 'Parameter data_cad not found' in the code:

TMyQuery1.Close;
TMyQuery1.SQL.Clear;
TMyQuery1.SQL.Add('UPDATE clientes1 SET data_cad=:dt_cad,
'data_alt = :dt_alt');
TMyQuery1.ParamByName('dt_cad').AsDate := Date;
TMyQuery1.ParamByName('dt_alt').AsDate := Date;
TMyQuery1.Execute;

Delphi 2007 and MyDac 5.10.0.10

Hi htiuk, myDac Works Fine... see you database script and your code..

incorrect:
TMyQuery1.SQL.Add( 'UPDATE clientes1 SET data_cad=:dt_cad,
'data_alt = :dt_alt');

correct:
TMyQuery1.SQL.Add( 'UPDATE clientes1 SET data_cad=:dt_cad, data_alt = :dt_alt' );


i made a simple example for you..
http://www.drdsistemas.com/util/bugmyda ... Update.zip

[Antaeus]

To htiuk:
Has the eduardosic's example helped you so solve this problem?