So - here where I work - they have generally stayed away from using MEMO
Fields in the FoxPro system they have. This old guy that worked here for
YEARS - he would Insist that they not be used in the system. Well, he's
been gone for like 1.5 years by now.
Well, recently - in 2 different client
On 2/8/12 12:50 PM, Kurt Wendt wrote:
> Any advice? Should I re-write their systems to NOT use Memo fields???
Rewrite the systems to use a backend database server and connect to it with
ODBC,
which Microsoft recently re-blessed.
Paul
___
Post Messag
Unless you really need that kind of space for storing unformatted text, do
the rewrite.
This will continue to happen every time there is a ungracefull shit down of
the app.
Rick Q
quilh...@gmail.com
On Wed, Feb 8, 2012 at 3:50 PM, Kurt Wendt wrote:
> So - here where I work - they have genera
1 Beware of babies and bathwater
2 Memos can be very useful and to avoid them can be more effort than
they're worth
3 There are some extremely good data recovery tools out there
4 Why not look to see what caused the problem. The corruption is a
result, not a cause
S
On Thu, Feb 9, 2012 a
thing! But, needless to say - TOO
Much work - and not a viable option...
-K-
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
On Behalf Of Paul McNett
Sent: Wednesday, February 08, 2012 3:54 PM
To: profoxt...@leafe.com
Subject: Re: USAGE Of
the extra data fields on the fly when needed...
-K-
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
On Behalf Of Richard Quilhot
Sent: Wednesday, February 08, 2012 3:55 PM
To: profoxt...@leafe.com
Subject: Re: USAGE Of Memos, Stability &
-K-
>
>
> -Original Message-
> From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
> On Behalf Of Richard Quilhot
> Sent: Wednesday, February 08, 2012 3:55 PM
> To: profoxt...@leafe.com
> Subject: Re: USAGE Of Memos, Stability & an Error!
>
d 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 captu
ssage -
From: Kurt Wendt
To: profox@leafe.com
Cc:
Sent: Wednesday, February 8, 2012 3:50 PM
Subject: USAGE Of Memos, Stability & an Error!
So - here where I work - they have generally stayed away from using MEMO
Fields in the FoxPro system they have. This old guy that worked here for
YEARS -
>
> -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 o
a client.
- Original Message -
From: Kurt Wendt
To: profox@leafe.com
Cc:
Sent: Wednesday, February 8, 2012 4:21 PM
Subject: RE: USAGE Of Memos, Stability & an Error!
FYI - for that EDI Data storage - that anywhere from like 20 lines (each
20 to 100 chars's) to 100 lines or M
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
&g
On 2/8/12 1:42 PM, Fred Taylor wrote:
> Yep, we used to have a client in a very rural part of Connecticut. Their
> power was so bad that every time the phone rang, the lights would dim! It
> did take the power company coming out and showing them they were only
> getting ~103 volts from the wall b
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Michael Madigan
Sent: Wednesday, February 08, 2012 4:29 PM
To: profoxt...@leafe.com
Subject: Re: USAGE Of Memos, Stability & an Error!
We've been using memo fields for th
I break into a rash every time someone mentions EDI.
From: Richard Quilhot
To: ProFox Email List
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 tab
ruary 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,
Kurt Wendt
To: profox@leafe.com
Sent: Wednesday, February 8, 2012 5:14 PM
Subject: RE: USAGE Of Memos, Stability & an Error!
Michael,
As for item #1 - I asked my Tech here - and he didn't know (we don't do any HW
or Network support for this particular client).
For 2 - he says the
On Wed, Feb 8, 2012 at 3:03 PM, Paul McNett wrote:
> On 2/8/12 1:42 PM, Fred Taylor wrote:
> > Yep, we used to have a client in a very rural part of Connecticut. Their
> > power was so bad that every time the phone rang, the lights would dim!
> It
> > did take the power company coming out and s
Every store does EDI differently, so how the hell is it a standard anyway?
From: Richard Quilhot
To: ProFox Email List
Sent: Wednesday, February 8, 2012 5:50 PM
Subject: Re: USAGE Of Memos, Stability & an Error!
It is a PITA!
Rick Q
quilh...@gmail
I have clients that say, "You're the expert, I'm going to trust your
recommendations", and I have clients who think they know it all.
- Forwarded Message -
From: Fred Taylor
To: ProFox Email List
Sent: Wednesday, February 8, 2012 6:06 PM
Subject: Re: USAGE Of M
On 02/08/12 12:54, Richard Quilhot wrote:
> Unless you really need that kind of space for storing unformatted text, do
> the rewrite.
> This will continue to happen every time there is a ungracefull shit down of
> the app.
>
> Rick Q
> quilh...@gmail.com
>
Is this an older version of VFP? I use m
nesday, February 8, 2012 5:50 PM
> Subject: Re: USAGE Of Memos, Stability& an Error!
>
> It is a PITA!
>
> Rick Q
> quilh...@gmail.com
>
>
>
>
> On Wed, Feb 8, 2012 at 5:48 PM, Michael Madiganwrote:
>
>> I break into a rash every time someone mentions ED
True. Most of our clients are running the system via VFP 7 and not 9.
-K-
On 2/8/2012 7:45 PM, Dan Covill wrote:
> On 02/08/12 12:54, Richard Quilhot wrote:
>> Unless you really need that kind of space for storing unformatted text, do
>> the rewrite.
>> This will continue to happen every time ther
8 PM, Michael Madigan >wrote:
> >
> >> I break into a rash every time someone mentions EDI.
> >>
> >>
> >>
> >>From: Richard Quilhot
> >> To: ProFox Email List
> >> Sent: Wednesday, Fe
I hated EDI with a passion. Hopefully the guy who invented it is burning in
Hell right now.
From: "Kurt @ VR-FX"
To: profox@leafe.com
Sent: Wednesday, February 8, 2012 9:08 PM
Subject: Re: USAGE Of Memos, Stability & an Error!
U guys crack
An EDI specialist using Foxpro. I hope the people who pay your salary realize
how specialized that actually is. LOL
From: Richard Quilhot
To: ProFox Email List
Sent: Wednesday, February 8, 2012 10:09 PM
Subject: Re: USAGE Of Memos, Stability & an E
On Wed, Feb 8, 2012 at 9:09 PM, Richard Quilhot wrote:
> Don't get me wrong, I'm fine working with EDI. But, like you said each
> trading partner
> has it's own take on how the standards are used.
Standards? We have upped our so up yours.
I have a whole collection of la
Quilhot
Sent: 08 February 2012 20:55
To: ProFox Email List
Subject: Re: USAGE Of Memos, Stability & an Error!
Unless you really need that kind of space for storing unformatted text, do the
rewrite.
This will continue to happen every time there is a ungracefull shit down of the
app.
Rick Q
quilh
On Thu, Feb 9, 2012 at 3:40 AM, Dave Crozier wrote:
> Rick,
> I assume that the comment "... every time there is a ungracefull shit down of
> the app" was unintentional, even though it does describe the event
> perfectly!!! *grin*
>
> Yes, after many years working on Mainframe EDI systems in the
Hey Sytze - in regards to your comment #3 below - can you make any
suggestions? I hate to admit - that they are TOO Cheap here - so, FREE
is best!
The problem our client is having continues to persist - but, in a way I
did NOT Expect! Now, they tried to reporting on records with Today's
date - tha
On 2/8/2012 3:53 PM, Paul McNett wrote:
> Rewrite the systems to use a backend database server and connect to it with
> ODBC,
> which Microsoft recently re-blessed.
LOL! Yeah...that's hilarious. MS Rep 1: "Well, ODBC still works good,
and will work great with this new stuff, unlike our OLE pr
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Kurt Wendt
Sent: Thursday, February 09, 2012 12:37 PM
To: profoxt...@leafe.com
Subject: RE: USAGE Of Memos, Stability & an Error!
Hey Sytze - in regards to your comment #3 below - can
On 2/8/2012 3:54 PM, Richard Quilhot wrote:
> This will continue to happen every time there is a ungracefull shit down of
> the app.
Somehow I think you meant to say it exactly that way! (instead of "shut
down")lol
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software
Wal-Mart would do it completely different than K-Mart. Very, Very
frustrating.
From: Dave Crozier
To: ProFox Email List
Sent: Thursday, February 9, 2012 4:40 AM
Subject: RE: USAGE Of Memos, Stability & an Error!
Rick,
I assume that the com
: "profox@leafe.com"
Sent: Thursday, February 9, 2012 12:53 PM
Subject: RE: USAGE Of Memos, Stability & an Error!
You need to find out immediately if any of the issues related to SMB/SMB2,
hardware/OS caching or oplocks settings are affecting this client site. And
based on the d
On Thu, Feb 9, 2012 at 7:24 PM, Michael Madigan wrote:
> Better to go to a backup to recover the memo files.
>
> I had a program that would look for non-standard characters in a memo field,
> which implied corruption, if it found it, then it would replace that memo
> field with one from backup.
digan
Sent: Thursday, February 09, 2012 2:24 PM
To: profoxt...@leafe.com
Subject: Re: USAGE Of Memos, Stability & an Error!
Better to go to a backup to recover the memo files.
I had a program that would look for non-standard characters in a memo field,
which implied corruption, if it found it,
lf Of Paul Hill
Sent: Thursday, February 09, 2012 3:02 PM
To: profoxt...@leafe.com
Subject: Re: USAGE Of Memos, Stability & an Error!
On Thu, Feb 9, 2012 at 7:24 PM, Michael Madigan
wrote:
> Better to go to a backup to recover the memo files.
>
> I had a program that would look for non-s
On 02/09/12 09:37, Kurt Wendt wrote:
> So - anyway I can get the FPT file fixed - without losing all the data
> in the file?
>
Try PACK MEMO .
(Make a copy of the .fpt first, of course)
Dan
___
Post Messages to: ProFox@leafe.com
Subscription Maintenanc
after you're done, perhaps a "pack memo" command to further clean up the mess
should be run.
From: Kurt Wendt
To: profox@leafe.com
Sent: Thursday, February 9, 2012 3:41 PM
Subject: RE: USAGE Of Memos, Stability & an Error!
In this situa
Thank you both Dan & Michael for that suggestion. Since they generally NEVER
Work with Memo fields here - until my recent usages - I hadn't even thought of
running Pack Memo.
If what I am trying to do today does NOT work - I will have my QA Tech run that
command at night when all the users are
On 2/10/2012 3:55 AM, AndyD wrote:
> that's good news about ODBC (Paul, do you have a link?) - but I presume
> the blessing doesn't go as far as offering a VFP driver?
http://leafe.com/archives/msg/466188
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http:
You use whatever driver the backend database needs. If you have a MySQL
backend, you
use the (mysql-provided) odbc driver. If you have a VFP backend (why would you
do
that?) you use the Microsoft-provided VFP odbc driver. I know it exists because
I've
used it before. Not sure how current it i
On 2/10/2012 12:39 PM, Paul McNett wrote:
> You use whatever driver the backend database needs. If you have a MySQL
> backend, you
> use the (mysql-provided) odbc driver. If you have a VFP backend (why would
> you do
> that?) you use the Microsoft-provided VFP odbc driver. I know it exists
> bec
This is stretching the little grey cells a bit further than they want to
go - but iirc it's only the record count that gets corrupted so you can
check the count in the dbf and patch the fpt to match, llfs or even
TextPad in Hex format will do this. The internal file formats are
available somewh
that's good news about ODBC (Paul, do you have a link?) - but I presume
the blessing doesn't go as far as offering a VFP driver?
AndyD 8-)₹
On 19:59, Paul McNett wrote:
> On 2/8/12 12:50 PM, Kurt Wendt wrote:
>> Any advice? Should I re-write their systems to NOT use Memo fields???
> Rewrite the
I'm happy to see that I might actually have started one of the longest
discussion threads for the Month of February. Of course, its always exciting to
see my name or one of my own Message Subject higher up in the Stats - come the
end of the Month!
Well - I ended up writing some cool code yester
47 matches
Mail list logo