Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Insert
Miscellaneous
Thread ID:
00655018
Message ID:
00655719
Views:
29
>Because I have a table with 10 invoices from
> April. But now I need to isert invoices
> from march too.
> These invoices have to go before the first
> record.
>
> Moises

Moises,

No they don't. You can create an index on invoice date and use that to order the records. The physical position of the records is meaningless when you use indexes.
USE Invoice
INDEX ON InvDate TAG InvDate
Do the above once and then whenever you want to see the invoices in date order you;
USE Invoices ORDER InvDate
BROWSE
Previous
Reply
Map
View

Click here to load this message in the networking platform