Devart Forums

Try

Proc1.StoredProcName := 'UpdatePunchFromHoro';
Proc1.Prepare;
begin
Proc1.ParamByName('LookDate').AsDate := now;
Proc1.ParamByName('Empl').asInteger := strTOInt(edit1.text) ;
Proc1.ParamByName('ClockTime').asDateTime:= Now;

Proc1.Execute;
end
finally
PRoc1.UnPrepare;
end;
Nothing with this code
I assign value in params default values and execute from the tMyStoredProc dialog button
all is ok
what'is wrong

Please specify what problem have you encountered.

If I Put
Proc1.parambyNAme('lookdate').asString = Format('yyyy/mm/dd',Now)
Al is ok

Proc1.ParamByName('LookDate').asDate = Now
My Application break

Why

We could not reproduce the problem.
Please send us (evgeniyD*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.

Also supply us following information
- Exact version of Delphi or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor