Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No index order?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
No index order?
Miscellaneous
Thread ID:
00793725
Message ID:
00793725
Views:
60
Whenever I run the following select statement I get the error "TABLE HAS NO INDEX ORDER SET."
What is wrong with the query? 'lnStart' is a unique check number. Any help would be appreciated. TIA.

SELECT checks.*, ;
app.sa_num, app.title_num, app.county, app.section, app.block, app.lot ;
from checks ;
INNER JOIN app ON app.sa_num==checks.sa_number;
WHERE checks.chkno==lnStart ;
INTO CURSOR curCheckToPrint
Next
Reply
Map
View

Click here to load this message in the networking platform