henryreynolds
asked on
Passing Date To Stored procedure for Delphi application as INPUT paramater...
Hi
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
[FormatDateTime('yyyy/mm/d d',Now())) ;
Please I am not sure which is the correct way to pass a Date, and which is the safest way without delphi falls over.
Thank you
henry
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
[FormatDateTime('yyyy/mm/d
Please I am not sure which is the correct way to pass a Date, and which is the safest way without delphi falls over.
Thank you
henry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry for this :
TheRealLoki --->
https://www.experts-exchange.com/questions/21881726/Problem-with-winsock-client-server-URGENT-500pts.html
Please reply, you havent replied in almost a month...
Peace Scay7
TheRealLoki --->
https://www.experts-exchange.com/questions/21881726/Problem-with-winsock-client-server-URGENT-500pts.html
Please reply, you havent replied in almost a month...
Peace Scay7
YYYY-MM-DD