>Greetings
>
>I it possible to insert a record at the pointer (ie: between two existing records)in a buffered table? It seems that all append commnads add new records to the end of a table.
>
>TIA
>Frank
Frank,
The old xBase command INSERT did this but it is only supported for backward compatibility now. What is the requirement for this?
If you simply want it for display purposes, then you can order the SQL result any way you want and display that. If you want to order the physical table, Stonefield Database Toolkit (SDT) will do this during its reindex process.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao