>How do I SELECT the new records from a buffered table?
>
>TIA
>
>Richard
The SELECT - SQL command doesn't have a specific option to select new or modified records.
You can get the recno() of the next modified or new record with GetNextModified(). recno() will be a negative number for new, uncommited records. To find out what changes were made, see GetFldState().
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)