[thelist] ASP/VBSCRIPT: best way to verify successful record insertion

[Chris W. Parker]

> -----Original Message-----
> From: David.Cantrell at Gunter.AF.mil
> [mailto:David.Cantrell at Gunter.AF.mil]
>
> What DBMS are you using? Access and SQL Server both support
> automatically-generated IDs. Just create a new field in the
> table with an
> auto-number or auto-id and set it as the primary key, and you
> are guaranteed
> that no two records will be "identical" as far as the DBMS is
> concerned,
> even though they may have the exact same information byte-for-byte.

i already do this. it keeps each record unique, but it doesn't tell me
that a record has been successfully inserted.


chris.