>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
I don't know whether any of the following is relevant, but here goes:
APP and BLOCK are reserved words (they appear blue in the syntax highlighter). Perhaps you can try to rename them (at least to see whether the error still appears.
The part after INNER JOIN...ON lists the tables in reverse order. Try to change the order.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)