How to get the maximum index number:

Category: Delphi -> VCL/Component Author: ddsdsdds Date: 2003-06-13 16:36:46
 
ddsdsdds
2003-06-13 16:36:46
I created the database ID field, each plus an ID plus one, when I was in the middle of the table to delete a record at the time, the corresponding record is deleted, I add a record in the table when the ID is the largest recorded number plus Id First, I want to get the ID number of the largest in the table, how to do.
aa450aa
2003-06-13 16:52:38
select max (ID) from <table>
wocaozhanzhangdemama
2003-06-13 16:56:34
Why do not automatically increase the type, all by the database to get