How to get a field value after and AddNew command SQL 7.0 and VB 6
I would like to get the value from the "id" field (SQL 7 generated "identity") once the new record is added, but the message box show it blank.
SQL = "Select * from contact "
DE.rsSQLAccountPopUpContact.Open SQL, DE.SalesPro
DE.rsSQLAccountPopUpContact.AddNew
DE.rsSQLAccountPopUpContact!address = "321 Address"
DE.rsSQLAccountPopUpContact.Update
mContactId = DE.rsSQLAccountPopUpContact!id
But the mContactId shows blank, I know that SQL 7 created the unique Id, but I can't figure out why I cannot get the value?
Any Ideas
_________________________________
God Bless
Marco Napoli
Little Helpers of Our Loving Mother
Official Web Site for Nancy Fowler (visionary) in Conyers, GA USA
http://www.*-*-*.com/
