This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have a siutation where I need to insert one parent and many lines to it. My problem is when i try to insert one line it works fine with the following code. but when i try to insert more then one line i get the following error which is due to the BEFORE INSERT trigger FOR EACH ROW which is getting fired on lineItems table.
where objLineItems is a populated line data object
Also the relationship i have defined is as follows :
Can you tell me if there is a way in which we can insert multiple lines with trigger on the child table.