How to assign and assign a specific serial number to a new record in the DBGrid?

Question

Delphi

What would be assigned to each new record a specific serial number by which it would be possible to find the entire row of the table by search. The base was made in Access 2003. I work with it through Delphi 7. Is it possible to bind the entire row of the table to this ordinal number? column number, last name and first name?

Answer 1

You can add an "autoincrement" column.
In general, there is no concept of a record number in a database. The DB stores them as it sees fit. When receiving, always in the SQL query, you must write the phrase order by.