NetTalk Central

Author Topic: MSSQL Delete child record in browse  (Read 3250 times)

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
MSSQL Delete child record in browse
« on: May 01, 2009, 04:09:19 AM »
Hi All,

I’m on PR34 using MSSQL2005 as backend.

I have a strange problem where I have a parent form with a child browse embedded in it.

When I click delete on one of the child browses it deletes the parent record which cascades to delete all the data in the child browse.

I just modified the accounting example app by allowing del on browse line items and del on morebrowseline items (as this is pretty close to my setup with a parent in the form and child records in a browse) and it does not seem to have the same prob although it does not show the correct line items when you return to the invoicebrowse screen. Only when you go to a different page and return to that record does it display the correct details which is not my problem but I thought I would point it out.

So am I doing anything wrong or is this a MSSQL2005 problem? I tried a couple more things to break the example but I cannot replicate the effect I am getting.

Cheers,

Kev

Alberto

  • Hero Member
  • *****
  • Posts: 1873
    • MSN Messenger - alberto-michelis@hotmail.com
    • View Profile
    • ARMi software solutions
    • Email
Re: MSSQL Delete child record in browse
« Reply #1 on: May 01, 2009, 04:54:17 AM »
How is your child browse Table Sequematic?
Alberto
-----------
Regards
Alberto

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: MSSQL Delete child record in browse
« Reply #2 on: May 01, 2009, 06:27:22 AM »
I'm trying to set up a duplicate Kev.

Cheers
Bruce