Results 1 to 3 of 3

Thread: Deleting a record from a child-table (ADODC)

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2001
    Location
    Sweden
    Posts
    10

    Question Deleting a record from a child-table (ADODC)

    I am trying to create a small simple applikation in VB 6.0 that connects to an Access 2000 database. Everything works, except when i´m trying to delete a record from a child-table.
    I have created a cascade on delete from the parent-table, and it works without any problems.
    When a deletebutton is pressed the following function is called:

    Function Delete_Snake (dat as ADODC)
    Dim YN as Integer
    YN = MsgBox ("Warning! Do You really want to delete this record?", vbYesNo+vbCritical,"Warning!")
    If YN = 6 Then
    dat.Recordset.Delete
    End If
    End Function

    There is no problem deleting a child-record within Access.
    Rem. I have 5 ADODC "children" controls on the same form and one master. I don´t have any problem in inserting new records to the children...

    Please help....

    P.S.
    I´m using textboxes for displaying the attributes (including PK)
    D.S.
    Last edited by Nurse; May 22nd, 2001 at 05:52 PM.

  2. #2
    Addicted Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    134

    Hi

    Could u tell me what is the exact error ur getting while deleting the record.
    Pavan Kumar

  3. #3

    Thread Starter
    New Member
    Join Date
    May 2001
    Location
    Sweden
    Posts
    10

    Question Have no idea...

    Right now i am working x-tra at the hospital, but if i remember it right i´ll get a message like "can't delete, mising update..."
    The last three days have been busy, so i didn´t have time for the project itself, but i´ve thought a lot of the problem.
    My ADODC-controls refer to a self-built SQL-question, and i don´t know if the problem lies there....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width