>> Hi I have a Table with Automatic ID numbers...
In access I delete All records [sic] by hand. When I add new record
[sic] with delphi (SQL) the number ID of record count begin with last
record+1 [sic] and not with 0 <<
Rows are not records; columns are not fields and tables are not files.
What about leaving the max number in the table?
DELETE FROM Tickets
WHERE ticket_nbr < (SELECT MAX(ticket_nbr) FROM Tickets);
I assume that you are using "(SELECT MAX(ticket_nbr) FROM Tickets) + 1"
to get the next number.
This woudl avoid the proprietary, non-relational, non-deterministic
IDENTITY "feature" in T-SQL.
--CELKO--
===========================
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!