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: [email protected] [mailto:[email protected]]
On Behalf Of Sytze de Boer
Sent: Wednesday, February 08, 2012 4:10 PM
To: [email protected]
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 <[email protected]>
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-
_______________________________________________
Post Messages to: [email protected]
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/289ea162f5642645b5cf64d624c66a140b7ce...@us-ny-mail-002.waitex.net
** 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.
