fields)
Joe
-----Original Message-----
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 29, 2004 9:19 PM
To: CF-Talk
Subject: Can you reset row numbers in a DB after deleting all rows?
MS Access
CF 5
Can you reset rows numbers back to starting at row number 1 in a DB, after
deleting all rows?
The goal is to totally erase and restore DB, on the fly, from time to
time.
New info will have the same columns, but a different number of rows each
time. The Delete Row function of a CFQUERY will do this, but the new row
number starts where the delete row numbers left off. We will eventually
run
out of row numbers.
Or is there another way to do this, e.g., delete and regenerate the table
anew on the fly?
Thanks,
Nick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
