Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Type Error Message is wrong
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Data Type Error Message is wrong
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01474680
Message ID:
01474680
Views:
94
I have an error message coming up that says that the Data Types are different yet when I check them, they are both Date data types. The comparisons are both between DATE Data Types. Why then the error?
		CASE .cboOrder.ListIndex = 5	&& Quote Date (dQuote)
			LOCAL ldQuote AS Date
			ldQuote = CTOD(ALLTRIM(UPPER(.txtSearchBy.Value)))
			SELECT ;
					RECNO() AS Rec_No, ;
					QuoteID, ;
					CustPartNo, ;
					Proj_Name, ;
					Cust_Name, ;
					dQuote, ;
					Material1 ;
				FROM Quotes ;
				WHERE UPPER(dQuote) = ldQuote ;
				INTO CURSOR tmpQuotes2
			
			SELECT tmpQuotes
			ZAP IN tmpQuotes
			APPEND FROM DBF("tmpQuotes2")
			LOCATE
		
	ENDCASE
	.grdFindQuote.Refresh()
	.grdFindQuote.SetFocus()
ENDWITH
Next
Reply
Map
View

Click here to load this message in the networking platform