On Thu, Jul 18, 2013 at 10:47 PM, Paul McNett <[email protected]> wrote:
> On 7/18/13 8:15 AM, Stephen Russell wrote: > > Would you write to 30+ tables or would you write the XML to one? > > Depends. With raw table access you have far more control, but it will take > a lot of > time to understand how not to seriously mess things up. XML saves you a > lot of time > because things are all messed up to begin with. > ------------------------ The XML is just a Data structure for any particular piece of business such as Sales Order of A/P Invoice. Load up the keys and data. Set the flag that you want the beast to perform [CRUD] and it just does it. Granted the # of keys the SO doc needs is horrendous. I just have to read an outside document and find all that pertain and place in correct position. Write the XML to a "listener" table and it just does the voodoo so well, or so we will see. :) If successful this project will push more conversions to generate demand data within our system, something sorely lacking today. I see making a reader for the various spreadsheets we get from current customer systems. Each office manager will be able to input the daily emails input and it will read it or set up a helper screen to tie what we need to what she has. Can anyone say a never ending project? -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmykqpwmn02geauyb99k4h_j279yniq1l5ul_zxey9gp...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

