Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get records
Message
From
29/08/2004 18:05:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
29/08/2004 17:57:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00937427
Message ID:
00937444
Views:
12
>hi,
>
>thank you,
>but i get error message(Table has no index order set )
>
>
>CLOSE all
>use aliq
>INDEX ON  no TO no
>set order to "no"
>for i = 1 to 20 && assume 20 values for flag
>  seek i  &&Table has no index order set
>  copy next 5 to temp while no = i
>use aliq1
>  append from temp
>next
>
Also: you should index the table only once, outside of individual programs like this:
index on no tag no
TAG will create a permanent index, one that gets opened automatically with the table, and updated every time you add records.

Then, in individual programs, you would only need:
set order to "no"
but you would no longer need the INDEX command.
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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform