Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot determine data type of the expression
Message
From
23/09/2008 20:49:50
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cannot determine data type of the expression
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01350076
Message ID:
01350076
Views:
73
UPDATE: Doh! I forgot the last condition in the ICASE.

I'm getting an error "Cannot determine data type of the expression." on the SQL below.
CLOSE DATABASES

USE c:\fmsrun\prompt\EligAct IN 0

m.DOSBegin = DATE() -30
m.DOSEnd = DATE()

SELECT ;
	ICASE(;
		MONTH(DOSBegin)= 1,'Jan',;
		MONTH(DOSBegin)= 2,'Feb',;
		MONTH(DOSBegin)= 3,'Mar',;
		MONTH(DOSBegin)= 4,'Apr',;
		MONTH(DOSBegin)= 5,'May',;
		MONTH(DOSBegin)= 6,'Jun',;
		MONTH(DOSBegin)= 7,'Jul',;
		MONTH(DOSBegin)= 8,'Aug',;
		MONTH(DOSBegin)= 9,'Sep',;
		MONTH(DOSBegin)=10,'Oct',;
		MONTH(DOSBegin)=11,'Nov',;
		MONTH(DOSBegin)=12,'Dec') AS MonthName, ;
	COUNT(*) AS DOSCnt ;
 FROM EligAct ;
	WHERE BETWEEN(EligAct.DOSBegin,m.DOSBegin,m.DOSEnd) ;
	GROUP BY MonthName ;
	INTO CURSOR ReportCursorSummary

BROWSE LAST 

CLOSE DATABASES
Next
Reply
Map
View

Click here to load this message in the networking platform