This week's book giveaway is in the Testing forum. We're giving away four copies of The Way of the Web Tester: A Beginner's Guide to Automating Tests and have Jonathan Rasmusson 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.