>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
In that case, all you need is an index on the invoice date to keep your data sorted. IOW, just add the records at the end.
Also, if it is for a report you can:
select * from invoices;
order by invoicedate;
into cursor Temp
and then run the report.
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)