Devart Forums

Hi every body

How is best way to use parameter in statement sql?

My example doesn work i dont understand How or where have i set the parameter...

QryStorico.Prepare;
QryStorico.SQLInsert.Add('INSERT INTO storico(COD_STOR, DESC_STATO, MOTIVO_STATO) VALUES (:COD_STOR, DESC_STATO, :MOTIVO_STATO) WHERE(COD_STOR= :OLD_COD_STOR');

QryStorico.parambyname('COD_STOR').AsInteger :=1;
QryStorico.parambyname('DESC_STATO').AsString := 'wwwwwww';
QryStorico.parambyname('MOTIVO_STATO').AsString :='dddddddd';
QryStorico.execute;


thanks a lot

The WHERE part of the INSERT isn't valid. You can't use a WHERE in an INSERT statment. The rest looks well.

Regards

I already tried without WHERE.....
i have this errore "column count doesn't match value count at row 1"
what does it mean?


dmSajob.QryStorico.Active := false;
dmSajob.QryStorico.SQL.Text := 'insert into storico (COD_STOR, DATA_ASSEGN_STOR, ASSEGN_DA_STOR) values(:COD_STOR, :DESC_STATO_STOR)' ;

dmSajob.QryStorico.Params.ParamByName('COD_STOR').Value := '1';

dmSajob.QryStorico.Params.ParamByName
('DESC_STATO_STOR').Value := 'ddddddd';
dmSajob.QryStorico.Execute;

>>> 3 fields
>>> 2 values

Each fields must match to a value.