Sorry to be a stick in the works, but has it been questioned whether this is really a good idea?
This might be good 9 times out of 10 - but if you permanently remove data that might be useful in a sale, that doesn't sound good. It sounds like you want a big red self-destruct button on the quote.
If they are duplicating an old quote but want to save time, then they've asked the wrong question.
If they are dramatically changing a live quote then I have to question why. Why not issue a new quote.
It could be that there is a great business case for what they are asking - but sometimes things are difficult for a reason.
K.
This might be good 9 times out of 10 - but if you permanently remove data that might be useful in a sale, that doesn't sound good. It sounds like you want a big red self-destruct button on the quote.
If they are duplicating an old quote but want to save time, then they've asked the wrong question.
If they are dramatically changing a live quote then I have to question why. Why not issue a new quote.
It could be that there is a great business case for what they are asking - but sometimes things are difficult for a reason.
K.
--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> You have to get the dataset from the BO
> Mark the row deleted and run an update. Here is a sample with a different
> table
>
>
> UD102DataSet ud102DS = ud102.GetByID(leafID, "", "", "", "");
> foreach (UD102DataSet.UD102ARow r in ud102DS.UD102A)
> {
> if (r.ChildKey1 == ddI.Uid)
> {
> r.Delete();
> }
> }
> ud102.Update(ud102DS);
>
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Wed, Jan 26, 2011 at 1:30 PM, Aaron <aaronmclements@...> wrote:
>
> >
> >
> >
> >
> > Understood. The BO that's hit is Update. I don't understand how to make
> > Update accomplish the delete. Here's the trace:
> >
> > <tracePacket>
> > <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> > <methodName>Update</methodName>
> > <returnType>void</returnType>
> > <localTime>01/26/2011 13:27:56:3148859 PM</localTime>
> > <executionTime>531.2534</executionTime>
> > <parameters>
> > <parameter name='ds' type='Epicor.Mfg.BO.QuoteDataSet' ><QuoteDataSet
> > xmlns="http://www.epicor.com/Mfg/100/BO.Quote/Quote" /></parameter>
> > </parameters>
> > <paramDataSetChanges>
> > <paramDataSet name='ds' useDataSetNbr='0' >
> > <deletedRow tableName='QuoteDtl' rowState='Deleted' rowNum='1'/>
> > <deletedRow tableName='QuoteQty' rowState='Deleted' rowNum='1'/>
> > </paramDataSet>
> > </paramDataSetChanges>
> > </tracePacket>
> >
> >
> > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Waffqle
> > <waffqle@> wrote:
> > >
> > > Can't say that I've done it before. However, as long as you use the
> > business
> > > objects to remove the lines, you shouldn't have to worry about orphan
> > > records. The BOs will add/remove entries in other tables automatically as
> > > needed.
> > >
> > > On Wed, Jan 26, 2011 at 1:12 PM, Aaron <aaronmclements@> wrote:
> > >
> > > >
> > > >
> > > > My Sales team is asking for an easier way to delete all lines off of a
> > > > quote. Basically a big easy button to strip a quote back to just the
> > header
> > > > information.
> > > >
> > > > Has anyone here done this? There are quite a few tables that link to
> > > > QuoteDtl. I'm concerned about data integrity and orphaned rows.
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>