I don't see where you're creating a view. Your select is run against local VFP data and VFP7 doesn't have CAST() function. You can try CTOT() or DATETIM() instead.

>I'm trying to create a view based on a string and using the Execscript function, but it's not working and I don't know why. The error message is Syntax Error on the execscript function. Please take a look...
>
>

>	LOCAL lcScript, lcStartDate, lcEndDate
>	IF USED("deliveries")
>		SELECT deliveries
>		USE
>		DROP VIEW deliveries
>	ENDIF
>	lcStartDate = ALLTRIM(STR(YEAR(Session.startdate))) + "-" + 
ALLTRIM(STR(MONTH(Session.startdate))) + "-" + 
ALLTRIM(STR(DAY(Session.startdate))) + ' 00:00:00'
>	lcEndDate = ALLTRIM(STR(YEAR(Session.EndDate))) + "-" + 
ALLTRIM(STR(MONTH(Session.EndDate))) + "-" + 
ALLTRIM(STR(DAY(Session.EndDate))) + ' 00:00:00'
>	lcScript = "SELECT * FROM Deliveries WHERE Deliveries.deliverydate >= cast('" + 
ALLTRIM(lcstartdate) + "' as datetime) AND deliveries.deliverydate <= cast('" + 
ALLTRIM(lcenddate) + "' as datetime)"
>	EXECSCRIPT(lcScript)
>	IF !USED("deliveries")
>		USE deliveries IN 0
>	ENDIF
>