Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
No index order?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
No index order?
Divers
Thread ID:
00793725
Message ID:
00793725
Vues:
62
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform