>Good Afternoon,
>
>I have a free table used to store Daily Transactions until the Day's activity is finalized when they are appended to a Table which stores the history.
>
>I have an autoincrementing integer field on this Transaction table that I would like to reset to 0 when the day is finalized and the table is zapped.
>
>Is there a way to do this short on dropping the column and readding it.
>
>Any assistance would be greatly appreciated.
>
Michael,
The Alter Table command has been enhanced for VFP 8. Try to use the Alter column clause and specify a new NEXTVALUE and STEP.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao