Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table has no index order set
Message
From
22/12/2002 00:58:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Table has no index order set
Miscellaneous
Thread ID:
00735218
Message ID:
00735218
Views:
40
Hi, All

I was trying to run my old program in VFP 8.0beta. I found one form always reported "Table has no index order set" error, while I running in VFP7.0 without any error message. That's why? The select command of following code is the erorr located. And all the table has index set. Is that a bug of VFp 8.0 or some new rules I didn't got known.
lsDBF_Name=SUBSTR(SYS(2015),3)
SELECT Receive_Note.Receive_Note_ID AS Note_ID,Receive_Note.Receive_Note_Date As Note_Date, Suppliers.Supplier_Name As Factory_Name,Receive_Note.PO_No,;
	   Receive_Item.Product_ID,Products.Product_Name,Receive_Item.Quantity,Receive_Item.Price,Receive_Item.Amount,;
	   Receive_Note.Total_Amount,000000 AS Total_Page,Users.User_Name As Response_Person;
From Receive_Note,Receive_item,Products,Suppliers,System!Users;
WHERE ALLTRIM(Receive_Note.Receive_Note_ID)==ALLTRIM(Receive_Item.Receive_Note_ID) AND ALLTRIM(Receive_Item.Product_ID)==ALLTRIM(Products.Product_ID) AND ;
	  ALLTRIM(Receive_Note.Supplier_ID)==ALLTRIM(suppliers.Supplier_ID) AND ALLTRIM(Users.User_ID)==ALLTRIM(Receive_Note.Receive_Person) AND ALLTRIM(Receive_Note.Receive_Note_ID)=ALLTRIM(lsNote_ID);
Into DBF (lsDBF_Name)
Next
Reply
Map
View

Click here to load this message in the networking platform