Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL code error
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQL code error
Miscellaneous
Thread ID:
00827987
Message ID:
00827987
Views:
55
I keep getting an error that says "Object RFRefFil not found". I don't understand what is happening. I have the tables open, RFRefFil and ARCusFil. Yet VFP interprets the table as an Object?

What is happening?
SELECT ;
		RFRefFil.Ref_No, ;
		RFRefFil.PO_No, ;
		RFRefFil.Phone1, ;
		RFRefFil.Phone2, ;
		RFRefFil.Phone3, ;
		RFRefFil.Map_Page, ;
		RFRefFil.City_Area, ;
		RFRefFil.Shp_City, ;
		RFRefFil.Shp_State, ;
		ARCusFil.Cust_Name, ;
		ARCusFil.Cust_Add1, ;
		ARCusFil.Cust_City, ;
		ARCusFil.Cust_State, ;
		ARCusFil.Cust_Zip, ;
		ARCusFil.Cust_Phone, ;
		RFRefFil.LEFT(Instr1,30) AS Instruc1, ;
		RFRefFil.SUBSTR(Instr1,31,30) AS Instruc1a, ;
		RFRefFil.LEFT(Instr2,30) AS Instruc2, ;
		RFRefFil.SUBSTR(Instr2,31,30) AS Instruc2a, ;
		RFRefFil.LEFT(Instr3,30) AS Instruc3, ;
		RFRefFil.SUBSTR(Instr3,31,30) AS Instruc3a,;
		RFRefFil.LEFT(Instr4,30) AS Instruc4, ;
		RFRefFil.SUBSTR(Instr4,31,30) AS Instruc4a;
	FROM ;
		RFRefFil, ;
		ARCusFil ;
	WHERE ;
		RFRefFil.Ref_No=lnRef_No AND ;
		RFRefFil.Customer=ARCusFil.Customer ;
	INTO CURSOR tmpRPRTSCR

	SELECT tmpRPRTSCR
	REPORT FORM rprtscr PREVIEW
	REPORT FORM rprtscr TO PRINTER PROMPT
Next
Reply
Map
View

Click here to load this message in the networking platform