Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cecil Champenois
  Where is Cecil Champenois?
 Little Elm
 Texas - United States
 Cecil Champenois
 Tags
Subject: SQL statement error
Thread ID: 345261 Message ID: 345261 # Views: 37 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, May 21, 2012 7:57:39 PM         
   


I keep getting the error, "Function name is missing )."

I will show only the part of the SQL statement that seems to have an issue:
		CAST(IIF(cv.Status<>"T","20120401", SPACE(8)) AS Character 8) AS PremBegin, ;
		CAST(IIF(cv.Status<>"T","20120430", SPACE(8)) AS Character 8) AS PremEnd, ;
		CAST(ICASE(in.Bill_Mode="M", "12", ;
			  in.Bill_Mode="A", "01", ;
			  in.Bill_Mode="S", "02", ;
			  in.Bill_Mode="Q", "04") AS Character 2) AS Pmt_Mode ;
	FROM GRPEXTIN in ;
	JOIN GRPEXTDP dp ON in.GrpNum = dp.GrpNum ;
	JOIN GRPEXTCV cv ON in.GrpNum = cv.GrpNum ;

There is more, of course to the above statement but I've put in the part of the code where it won't work. I had to put in the CAST() function in order to keep the field width at 8 characters in the first two fields (PremBegin and PremEnd). AS for the ICAST(), it seems to be okay, but there is still a problem here. Don't know what it could be yet.

Cecil Champenois, Jr.

ENTIRE THREAD

SQL statement error Posted by Cecil Champenois @ 5/21/2012 7:57:39 PM
RE: SQL statement error Posted by Anil Sharma @ 5/21/2012 8:08:05 PM
RE: SQL statement error Posted by Cecil Champenois @ 5/21/2012 8:12:55 PM
RE: SQL statement error Posted by Anders Altberg @ 5/21/2012 8:46:54 PM