>I have an SQL SELECT statement that executes FINE from the command window, yet give me a Syntax error when run from a .prg.
>
>dRptStart and dRptEnd are the beginning and end of a date rage, and have valid date values, since they are used in other places in the prg before this statement is selected (they also look ok in the debugger).
>
>

SELECT Defendants.defendantsID FROM CaseRelations, InCaseStatus, Defendants ;
>	INTO CURSOR cChargesFiled ;
>	WHERE InCaseStatus.StatusCode = 11 AND ;
>		INcaseStatus.IndefendantsID = CaseRelations.IndefendantsID AND ;
>		Defendants.DefendantsID = CaseRelations.DefendantsID AND ;
>		InCaseStatus.StatusDate <= dRptEnd AND ;
>		( EMPTY( Defendants.Closed ) OR BETWEEN( Defendants.Closed, dRptStart, dRptEnd ) )

>
>I can even put a breakpoint in the code just before this statement is to be executed, go to the command window and execute it, and it works...but in the code it fails w/a Syntax error.
>
>I'm missing something! but what? TIA for any input...J

Looks fine, but I would put into cursor (cChargesFiled) and the end of SQL statement and surround cChargesFiled with ().