When I am trying to add a new record, then get the new SQL 7.0 generated ID field, I get the error shown below.

SQL = "Select * from contact WHERE id = 0"
DE.rsSQLContact.Open SQL, DE.SalesPro
DE.rsSQLContact.AddNew
DE.rsSQLContact.Update
DE.rsSQLContact.MoveLast
mContactId = DE.rsSQLContact!id

But I get an error:

"Run-time error 3021"
"Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."

Any Idea's ?

--
_________________________________
God Bless
Marco Napoli
Little Helpers of Our Loving Mother
Official Web Site for Nancy Fowler (visionary) in Conyers, GA USA
http://www.*-*-*.com/

There are 2 things:
1. Identity fields are not seen until after you .Requery the recordset.
The drawback of requery is that the pointer is no longer on the last
added record so you have to reposition to the record you just added. So
if "id" that you use is an identity or autonumber field, you cannot see
it with your code
2. Pay attention to the query you generated:
SQL = "Select * from contact WHERE id = 0"
That means it only selects those records that have an id=0; probably
none of them meet the criteria, so don't expect to see any records.

Sorry, found the answer, the RecordSet was set to read only.

  When I am trying to add a new record, then get the new SQL 7.0 generated ID field, I get the error shown below.

  SQL = "Select * from contact WHERE id = 0"
  DE.rsSQLContact.Open SQL, DE.SalesPro
  DE.rsSQLContact.AddNew
  DE.rsSQLContact.Update
  DE.rsSQLContact.MoveLast
  mContactId = DE.rsSQLContact!id

  But I get an error:

  "Run-time error 3021"
  "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."

  Any Idea's ?

  --
  _________________________________
  God Bless
  Marco Napoli
  Little Helpers of Our Loving Mother
  Official Web Site for Nancy Fowler (visionary) in Conyers, GA USA
  http://www.ourlovingmother.org