Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax error in SQL SELECT
Message
From
03/10/2000 20:07:51
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Syntax error in SQL SELECT
Miscellaneous
Thread ID:
00424467
Message ID:
00424467
Views:
49
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
Next
Reply
Map
View

Click here to load this message in the networking platform