Hi All,

I'd like to be able to pass a date to a Package. The following works:

lcSqlStatement = "{call GetShopHours.ReturnDaysWorked(" + TRANS(THISFORM.nEmpPersNo) + ", ?ldWorkWeek)}"

lnHandle = SQLEXEC(gnSatHandle, lcSqlStatement, 'Week_Hrs_Cursor')

How can I pass the date without the '?' in the statement? Neither of the following work.

"{call GetShopHours.ReturnDaysWorked(" + TRANS(lnEmpPersNo) + ", " + DTOC(ldWorkWeek) + ")}"
"{call GetShopHours.ReturnDaysWorked(" + TRANS(lnEmpPersNo) + ", TO_DATE('" + DTOC(ldWorkWeek) + "', 'MM/DD/YYYY'))}"

I could probably change the actual procedure to accept the date as a character. Is that my only recource?

TIA
Mike

P.S. VFP6 SP5 Oracle 8i