I break into a rash every time someone mentions EDI.
________________________________
From: Richard Quilhot <quilh...@gmail.com>
To: ProFox Email List <profox@leafe.com>
Sent: Wednesday, February 8, 2012 4:27 PM
Subject: Re: USAGE Of Memos, Stability & an Error!
Those EDI elements that repeat could be put into a child table(s) with as
many rows as needed.
Same thng with the tracking numbers.
Rick Q
quilh...@gmail.com
On Wed, Feb 8, 2012 at 4:21 PM, Kurt Wendt <kurtwe...@waitex.com> wrote:
> FYI - for that EDI Data storage - that anywhere from like 20 lines (each
> 20 to 100 chars's) to 100 lines or MORE!
>
> And - as another update. My buddy told me the client had a server Crash.
> {NOT very shocking when he told me their server has 3GB of RAM - while
> the system the other day reported usage of 7GB of RAM - i.e. Virtual
> RAM.} Seems the client is being TOO CHEAP - since they are our Biggest
> client - and they ARE a BIG Co. - and they should have a Hefty Server
> w/16GB or RAM!
>
> A Server for running a BIG business should NOT be the place to cut
> Pennies...
>
> Well, that's IMHO and YMMV.
> -K-
>
> -----Original Message-----
> From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
> On Behalf Of Sytze de Boer
> Sent: Wednesday, February 08, 2012 4:10 PM
> To: profoxt...@leafe.com
> Subject: Re: USAGE Of Memos, Stability & an Error!
>
> In my opinion, if a field has to capture data from 2 to 150 chars, I
> would use a text field
> Then I would consider a memo field
>
> S
>
>
>
> On Thu, Feb 9, 2012 at 10:06 AM, Kurt Wendt <kurtwe...@waitex.com>
> wrote:
> > In the one instance - it had to do with the saving of Shipment
> Tracking
> > numbers for an Invoice. It could be as few as 2 numbers, or up to 20
> or
> > more. So - the Memo field seemed the most obvious method - as well as
> a
> > Quick & Dirty solution.
> >
> > For the other project - it happens to do with EDI data - and a
> > particular trading partner that is making the whole processing of
> THEIR
> > Data nearly impossible. Instead of adding a TONS of new fields into
> our
> > DBF system - instead, I store most of the EDI 850 (Order) data lines
> > into a Memo field attached to the Order. This way - I can simply
> > re-retrieve the extra data fields on the fly when needed...
> >
> > -K-
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/1328741323.89444.yahoomail...@web125603.mail.ne1.yahoo.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.
