Best Practice ADO

P

Pat Garard

G'Day All,

I want to create a New record using ADO (with which I do not have a
great deal of experience).

One of the fields ("ItemUniqueID") is an AutoNumber field, and I would
like to determine its value as early as possible.

Are there any pros/cons relating to:
1. rs.AddNew
intNewID=rs("ItemUniqueID")
rs.("ItemDescription")="Whatever"
:
:
rs.Update

2. rs.AddNew
rs.("ItemDescription")="Whatever"
:
:
intNewID=rs("ItemUniqueID")
rs.Update OR

3. rs.AddNew
rs.("ItemDescription")="Whatever"
:
:
rs.Update
intNewID=rs("ItemUniqueID")

ALSO

If the new Record is to be a duplicate (apart from the AutoNumber), is
there a "smart" way to assign a "block" of values at once, or do I need to
cycle through all the fields as above.
 
Top