Hi,
I would like to know the best method for creating sequence number. I am using SQL Server2000 as back-end and VB6 as fornt-end.
Thanks in advance
Kiran
Aum Namah Shivaya
Printable View
Hi,
I would like to know the best method for creating sequence number. I am using SQL Server2000 as back-end and VB6 as fornt-end.
Thanks in advance
Kiran
Aum Namah Shivaya
When defining your column in SQL set the identity property. This will cause the database engine to increment that field for each new record created. Sort of like a MSAccess Autonumber field.
Craig