VB Forum / Database Access / July 2003

I've tried to respond several times, but my response never gets posted. So I
re- posted.

AddressID is a long, and although a foreign key, the relationship is not
setup.  In the VB DLL
I broke out and hand entered a value for AddressID, PeopleID (long) and
PhoneType (Small Int), while Phone.number already had a value.  It continued
on with the Insert.  I then queried with Query Analyzer and both AddressID
and PeopleID were null, while Number and PhoneType had data.  No error was
reported.

VB6, msSql 7.0, update routine in ntier dll.
This is a disconnected recordset passed by the client:
The debug print looks perfect, but when I fetch the records using Query, the
addressID is Null.
Thanks in advance for your help.

If rsPhone.RecordCount Then

       rsPhone.MoveFirst
       Do While Not rsPhone.EOF
           rsPhone!addressID = rsAddress!addressID
           rsPhone.Update
           rsPhone.MoveNext
       Loop

    ' debug - print out results
      rsPhone.MoveFirst
      Do While Not rsPhone.EOF
           Debug.Print rsPhone!addressID, rsPhone!Number
           rsPhone.MoveNext
       Loop

      'Update it
      Set rsPhone.ActiveConnection = cn
      rsPhone.UpdateBatch
      Set rsPhone.ActiveConnection = Nothing
   End If

Len
Email  len@lynxmedia.com

--
*************************************
Len Latimer, President
Lynx Media, Inc.
Voice 1-800-451-5969 x107
Fax    1-818-761-5859
Email  len@lynxmedia.com
Web  www.lynxmedia.com
12501 Chandler Blvd #202
Valley Village, CA 91607