I have 3 parameters I am trying to pass to a stored procedure
They are date fields in the parameters, not date time.
The SP variables are string.

Is this the correct syntax in Foxpro 9?
I am not getting a cursor to be generated.
The SP works when I enter 01/01/2009 and 02/01/2009 in QA

ldStartDate={}
ldEndDate={}
ldStartDate=thisform.startdate.value
ldEndDate=thisform.enddate.value

lcSQLCMD="exec get_invoices ?ldStartDate,?ldEndDate"
SQLEXEC(gnConnect,lcSQLCMD,'jobcost')


the parameters in the SP are this

Alter PROCEDURE get_invoices
@ldStartDate Char(12) = '',
@ldEndDate Char(12) = ''
AS