Andy,

What data type is thisform.startdate.value and thisform.enddate.value?



>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