Passing Date To Stored procedure for Delphi application as INPUT paramater...
Posted on 2006-07-08
I am calling interbase/firebird stored procedures from my delhi apllication to post entries to tables, OR to lookup data for reports.
MY problem is as follows when I SOMETIMES call a stored procedure and pass a date as input paramater then my delphi application falls over.
I get invalid date ("20/05/2005") or other invalid date errors.
My stored procedure recieve a Date Type Varaiable..
WHAT is the correct way to call a stored procedure and to pass a DATE to a stored procedure.
I am currently doing the following..
sQry := Format('execute procedure SP_GetEmployees "%s", //The procedure recieve one Date variable as input paramter
Please I am not sure which is the correct way to pass a Date, and which is the safest way without delphi falls over.