Resetting autoincrement fields

Resetting autoincrement fields

Post by Daniel Varela Santoal » Wed, 23 Oct 1996 04:00:00



        Hello everybody at the newsgroup.

        I have a little question for you.

        I'm using a Paradox 7.0 table and I'm filling it with records while
testing the program. But when I delivered the program I would like it to
be empty and with autoincrement fields=0. If I simply delete all the
records it doesn't start with 1 when appending new ones.

        Ah, another question. ?Is anybody using GORTA mSQL ODBC
driver? I can't find the way to make it work. The Schema viewer works
perfectly, so it isn't a TCP/IP connection problem.

        Thanks in advance.

        Daniel Varela  
        Lugo-Galicia-Spain

 
 
 

Resetting autoincrement fields

Post by Jay Schwis » Fri, 25 Oct 1996 04:00:00



Varela Santoalla), the following was written:

Quote:

> Hello everybody at the newsgroup.

> I have a little question for you.

> I'm using a Paradox 7.0 table and I'm filling it with records while
> testing the program. But when I delivered the program I would like it
> to be empty and with autoincrement fields=0. If I simply delete all
> the records it doesn't start with 1 when appending new ones.

How about creating a new one for distribution?

God Bless,

--

10/23/96 19:37
---------
Using: OUI PRO 1.5.0.2 from http://www.dvorak.com

 
 
 

Resetting autoincrement fields

Post by Diogo Assunc » Sat, 26 Oct 1996 04:00:00


Hi Daniel


Quote:>        I'm using a Paradox 7.0 table and I'm filling it with records while
>testing the program. But when I delivered the program I would like it to
>be empty and with autoincrement fields=0. If I simply delete all the
>records it doesn't start with 1 when appending new ones.

The method I use is to create a new table and borrow the structure
from the table I used in testing. I usually keep an empty version of
the tables I work with in a different folder, wich I distribute with
the final version of the software.

Quote:>        Thanks in advance.

You're wellcome, hope this helps

>        Daniel Varela  
>        Lugo-Galicia-Spain


Diogo Assuncao

http://members.tripod.com/~DiogoAssuncao

ConTar - Electronica Industrial, Lda.
PORTUGAL

 
 
 

Resetting autoincrement fields

Post by Nick Spurrie » Sun, 27 Oct 1996 04:00:00


Paradox tables keep the "next" autoinc number in the table header. You
will have to empty the table, restructure it by changing the autoinc
field to longint, saving the structure and then restructure it again
with the longint field changed back to autoinc.

Nick Spurrier (MoDESoft, UK)

 
 
 

1. Resetting autoincrement fields (Pdox 5.0)

Is there a way to reset the values in autoincrement fields? I have tried
emptying the table, packing the table, renaming the table, etc., and the
value in the field is never reset to 1. I have scoured the available
documentation and have been unable to find an answer to this, short of
borrowing the fields and creating a new table altogether. I appreciate the
help.

Jim Lee

============================================================================
James D. Lee                    
Sr. Research Associate          The ninety and nine are with dreams content
University of Arizona             But the hope of the world made new,
Department of MIS               Is the hundredth man who is grimly bent
Phone: (602) 621-8670             On making those dreams come true.
FAX: (602) 621-2641                                             anonymous

============================================================================

2. recorvering from crushed mssql server 6.5 master table

3. How to reset autoincrement field ??

4. ENOMEM / MAXMEM Problem -- tuning?

5. How to reset autoincrement field?

6. Disconnected Recordset Maximum Size?

7. How to reset autoincrement field value

8. constraint errors

9. SQL anywhere 5.5 Autoincrement field resetting

10. RESETTING PDOX AUTOINCREMENT FIELDS

11. Autoincrement fields: how to reset the counter

12. How do I reset the autoincrement field?

13. HELP: autoincrement field reset