Jump to content

Delete with depth = 1

  • Please log in to reply
2 replies to this topic

#1 Guest_kittisoongswang_*

  • Guests

Posted 14 October 2005 - 07:23 AM

I tried to delete customers record and related orders record by using the following code.

objFactory.Delete(objInfo, 1)

I did not delete the customer and related orders. I tried to step through code. It seem the code work. But I found that after the code finished running and the Winform show. I can open table to see record in SQL Server. It seem that the transaction not release. If I close the WinForm App, I can open it in SQL Server.

Please check this out. And if there is the way to fix this please let me know.

Thank you.

#2 Guest_Paul_*

  • Guests

Posted 14 October 2005 - 01:34 PM

Thank you for your valuable feedback. I just went through and reproduced this at my end. If you look at the implementation of DeleteChildren in factory class you will find that a Transaction open is not closed at the end.

Please do the following to fix this issue. (Note this issue is only in VB template)

1. You can find the VB Factory ComponentFactory_vb.ts template at
%Installation Directory%\TierDeveloper .Net 5.0\Patterns\PrePackaged\VBComponent\Source\Components

2. go to line number 3151 and add the following line after "End If"


3. Save the template, Go to TierDeveloper and generate the components and application again. It will work fine.

#3 Guest_kittisoongswang_*

  • Guests

Posted 14 October 2005 - 05:11 PM

Thank you for infromation.

I will tried it. If anything not work well, I will inform you.

Thank you

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users