How to call mysql stored procedure with where clause as in parameter using Delphi 7 ADO

Question

I have a mySQL stored procedure:

PROCEDURE `update_table_set_where_datefield`(
in p_date_time datetime)
BEGIN
  UPDATE table SET onefield = 1
  WHERE datefield = p_date_time;
END

I try to call the stored procedure above, using Delphi 7 ADO, but the data is not changed. Why is this?

score 0 · Answer 1 · answered Aug 16 '17 at 12:43

0

you need to use params on AdoStoredProcedure,

ADOStoredProc1.ParamByName('PARAM').AsInteger := variable;

ADOStoredProc1.Open;

answered Aug 16 '17 at 12:43

Saulo Nunes

But p_date_time parameter is a datetime data type, not integer. – EdiPurwa Aug 19 '17 at 01:05
Why use ADOStoredProc1.Open? The mySQL stored procedure is not return a result set. – EdiPurwa Aug 19 '17 at 01:06
it was an example, you should use ADOStoredProc1.ParamByName('PARAM').AsDateTime, And you can try ADOStoredProc1.ExecSql; – Saulo Nunes Aug 21 '17 at 11:27

1 Answers1