RE: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread Bill Arnold
Mike, I think you have to consider that the implications of the corruption may extend beyond the obvious. How about restoring a recent backup to work table A, then repairing the corrupted table into work table B, and then comparing A and B to produce a report of changes made to the data since

Re: [NF] Windows XP Service Pack 3

2008-08-05 Thread Alan Bourke
On Mon, 4 Aug 2008 11:05:30 -0400 (EDT), MB Software Solutions General Account [EMAIL PROTECTED] said: M$ is wanting to push this to me via the Automatic Updates. Has anyone else installed this yet and cares to comment on it? I haven't had any issues on the 3 machines that use VFP that I

Re: [OT] Pelosi's Planet

2008-08-05 Thread Pete Theisen
Michael Madigan wrote: That being said, I think that the rise in Autism is caused by something in the food supply. Hi Michael! Or . . . perhaps something that is NOT in the food supply, but should be. I think we are starving for nearly all minerals and some of the lesser known vitamins.

Re: [NF] Windows XP Service Pack 3

2008-08-05 Thread Charlie Coleman
At 11:37 AM 8/4/2008 -0400, MB Software Solutions General Account wrote: Stephen Russell wrote: On Mon, Aug 4, 2008 at 10:05 AM, MB Software Solutions General Account [EMAIL PROTECTED] wrote: M$ is wanting to push this to me via the Automatic Updates. Has anyone else installed this yet

[OT] Just put another cover on it, 20 years and the tech is failing.

2008-08-05 Thread Stephen Russell
http://tinyurl.com/66nlke This is why I am against nukes. We think we know it all but nature is far more powerful than we understand. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 ___ Post Messages to:

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread Stephen Russell
On Mon, Aug 4, 2008 at 9:50 PM, MB Software Solutions General Account [EMAIL PROTECTED] wrote: VFP9SP1 We've got a scenario where a 3rd party has polluted our memo fields, and I'd like to write a cleanup that takes the value of the memo field and does a STRTRAN to get rid of garbage.

[NF] T-Bird mail Q

2008-08-05 Thread Stephen Russell
I have folders set up for various groups that send out mail, some like this list. In T-Bird I have set up the rules to move [bittorrent] to folder Bittorrent, but it fails to parse down the subject line. So a Re. [bittorrent] fails to get moved. In Outlook I had a rule option for sent to

Re: [OT] Just put another cover on it, 20 years and the tech is failing

2008-08-05 Thread richmondeagle
http://tinyurl.com/66nlke This is why I am against nukes. We think we know it all but nature is far more powerful than we understand. 1. Who would go work in that area? 2. Why would you compare that aged Soviet technology to what we can do today in our over-regulated environment. Why even

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread Garrett Fitzgerald
On Mon, Aug 4, 2008 at 22:50, MB Software Solutions General Account [EMAIL PROTECTED] wrote: We've got a scenario where a 3rd party has polluted our memo fields, and I'd like to write a cleanup that takes the value of the memo field and does a STRTRAN to get rid of garbage. Straight forward

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread MB Software Solutions General Account
Garrett Fitzgerald wrote: On Mon, Aug 4, 2008 at 22:50, MB Software Solutions General Account [EMAIL PROTECTED] wrote: We've got a scenario where a 3rd party has polluted our memo fields, and I'd like to write a cleanup that takes the value of the memo field and does a STRTRAN to get rid of

Re: [OT] Pelosi's Planet

2008-08-05 Thread MB Software Solutions General Account
Michael Madigan wrote: If you look at the protests all over the country against Savage, you will realize that they were printed with the same fonts and the same styles. The attack was coordinated by the Democrats to try to get a conservative commentator off the air. It also comes down to

Re: [OT] Just put another cover on it, 20 years and the tech is failing.

2008-08-05 Thread MB Software Solutions General Account
Stephen Russell wrote: http://tinyurl.com/66nlke This is why I am against nukes. We think we know it all but nature is far more powerful than we understand. I was amazed when a very well qualified doctor told me (circa 2001) that doctors only really understood maybe 20% of how the human

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread MB Software Solutions General Account
Bill Arnold wrote: Mike, I think you have to consider that the implications of the corruption may extend beyond the obvious. How about restoring a recent backup to work table A, then repairing the corrupted table into work table B, and then comparing A and B to produce a report of changes

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread MB Software Solutions General Account
Paul McNett wrote: MB Software Solutions General Account wrote: VFP9SP1 We've got a scenario where a 3rd party has polluted our memo fields, and I'd like to write a cleanup that takes the value of the memo field and does a STRTRAN to get rid of garbage. Straight forward enough, right? No,

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread MB Software Solutions General Account
Kristyne McDaniel wrote: Have you tried enclosing the memo field with [] at the point you copy it over? It seems to me that enclosing the excessive quote marks would take care of it. No, it's that the field really has tons and tons of single quote marks, hence why I was trying to STRTRAN them

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread MB Software Solutions General Account
Matthew Jarvis wrote: VFP9SP1 REPLACE comments with STRTRAN(comments,replicate(['],1000),[]) all in MyTable Have you tried it w/o having VFP doing all the heavy lifting? Something like: do while not EOF() lcString = alltrim(comments) lcReplaceString =

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread MB Software Solutions General Account
Malcolm Greene wrote: Mike, I would scan through your original table, exporting out its contents to another table. Perform your export by inserting a blank row in the export destination table and then loop through all the fields in your source record, doing a field by field replace.

Re: [OT] CEO pay out of control (was Re: [OT] Drill now Exxon can beat another record only if we DRILLLLLLLLLL!!!!)

2008-08-05 Thread MB Software Solutions General Account
Michael Madigan wrote: 200x seems a little low. A clerk making $20,000 a year would cap the CEO at $4,000,000 even though the company had 10 billion in profits. LOL! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] Windows XP Service Pack 3

2008-08-05 Thread MB Software Solutions General Account
Charlie Coleman wrote: At 11:37 AM 8/4/2008 -0400, MB Software Solutions General Account wrote: Stephen Russell wrote: On Mon, Aug 4, 2008 at 10:05 AM, MB Software Solutions General Account [EMAIL PROTECTED] wrote: M$ is wanting to push this to me via the Automatic Updates. Has anyone else

Re: [NF] Windows XP Service Pack 3

2008-08-05 Thread Stephen Russell
On Tue, Aug 5, 2008 at 9:05 AM, MB Software Solutions General Account [EMAIL PROTECTED] wrote: Charlie Coleman wrote: At 11:37 AM 8/4/2008 -0400, MB Software Solutions General Account wrote: Stephen Russell wrote: On Mon, Aug 4, 2008 at 10:05 AM, MB Software Solutions General Account [EMAIL

Ignoring deleted records in a view

2008-08-05 Thread John J. Mihaljevic
Hi all, Something strange happened in a system we have that I can't figure out. I have a view (BACKLOG) that references three base tables (ORD_LINE, ORD_HEAD, CUSTOMER). It used to ignore records in the base tables that were marked for deletion, but suddenly isn't doing that anymore. All

Re: Ignoring deleted records in a view

2008-08-05 Thread MB Software Solutions General Account
John J. Mihaljevic wrote: Hi all, Something strange happened in a system we have that I can't figure out. I have a view (BACKLOG) that references three base tables (ORD_LINE, ORD_HEAD, CUSTOMER). It used to ignore records in the base tables that were marked for deletion, but suddenly isn't

RE: Ignoring deleted records in a view

2008-08-05 Thread John
If you are pulling the records with a SQL statement, I think you have to include and not deleted(). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions General Account Sent: Tuesday, August 05, 2008 9:52 AM To: ProFox Email List Subject:

Re: Ignoring deleted records in a view

2008-08-05 Thread MB Software Solutions General Account
John wrote: If you are pulling the records with a SQL statement, I think you have to include and not deleted(). No, you shouldn't have to do that unless you're SET DELETED is OFF. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: Ignoring deleted records in a view

2008-08-05 Thread John J. Mihaljevic
And SET DELETED is ON in the session where the view is open/created? SET DELETED ON is one of the very first lines of code in the system. Hmmm.local view (all VFP tables), right? Yes. And the strange thing is, I honestly can't recall making any changes in the system that would've done

Vista user getting DBC internal consistency error (VFP9SP1)

2008-08-05 Thread MB Software Solutions General Account
I've got a client who's on a Vista workstation trying to connect to the Windows XP box (another workstation that her coworker uses---he's got the VFP9 database on his machine) on her p2p network. It had worked fine in the past, but for some reason, something happened as of a week ago and now when

RE: Ignoring deleted records in a view

2008-08-05 Thread MB Software Solutions General Account
On Tue, August 5, 2008 11:04 am, John J. Mihaljevic wrote: And SET DELETED is ON in the session where the view is open/created? SET DELETED ON is one of the very first lines of code in the system. Hmmm.local view (all VFP tables), right? Yes. And the strange thing is, I honestly

Re: Ignoring deleted records in a view

2008-08-05 Thread Ted Roche
On Tue, Aug 5, 2008 at 11:04 AM, John J. Mihaljevic [EMAIL PROTECTED] wrote: And the strange thing is, I honestly can't recall making any changes in the system that would've done this. It was fine before, and is suddenly not fine. I'm assuming I must've made some change that caused this

Re: [NF] T-Bird mail Q

2008-08-05 Thread Vince Teachout
Stephen Russell wrote: I have folders set up for various groups that send out mail, some like this list. In T-Bird I have set up the rules to move [bittorrent] to folder Bittorrent, but it fails to parse down the subject line. So a Re. [bittorrent] fails to get moved. Are you using the

RE: Vista user getting DBC internal consistency error (VFP9SP1)

2008-08-05 Thread Tracy Pearson
You are probably hitting one of the Vista complaints. If the box Vista is connecting to does not run the newer security it falls back to the older processes. I suspect VFP isn't getting enough information back through the pipe due to other processes slowing down the network pipes and or threads on

RE: Ignoring deleted records in a view

2008-08-05 Thread John J. Mihaljevic
Remember that SET DELETED is scoped to the current data session. I've seen this kind of thing when people change classes from CUSTOM (or other) to SESSION. That's why I suggested checking the setting of DELETED right before you open/requery the local view. Thanks for mentioning requerying

RE: Ignoring deleted records in a view

2008-08-05 Thread David Stevenson
I'll ask again to reinforce what others have asked already... Is SET DELETED ON in the datasession where you are opening the view? Are you in a form with a private datasession? Just because you SET DELETED ON in the first line of the program does not mean that your programs always run with that

RE: Ignoring deleted records in a view

2008-08-05 Thread John J. Mihaljevic
REQUERY() fixed the problem, but for those who are curious: I'll ask again to reinforce what others have asked already... Is SET DELETED ON in the datasession where you are opening the view? I only SET DELETED ON in one of the first lines of code in the PRG that calls the rest of the system.

RE: Vista user getting DBC internal consistency error (VFP9SP1)

2008-08-05 Thread John
Check your firewall settings. JH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions General Account Sent: Tuesday, August 05, 2008 10:17 AM To: profox@leafe.com Subject: Vista user getting DBC internal consistency error (VFP9SP1) I've

Re: Ignoring deleted records in a view

2008-08-05 Thread MB Software Solutions General Account
John J. Mihaljevic wrote: Remember that SET DELETED is scoped to the current data session. I've seen this kind of thing when people change classes from CUSTOM (or other) to SESSION. That's why I suggested checking the setting of DELETED right before you open/requery the local view.

Re: Vista user getting DBC internal consistency error (VFP9SP1)

2008-08-05 Thread MB Software Solutions General Account
Tracy Pearson wrote: You are probably hitting one of the Vista complaints. If the box Vista is connecting to does not run the newer security it falls back to the older processes. I suspect VFP isn't getting enough information back through the pipe due to other processes slowing down the

RE: Vista user getting DBC internal consistency error (VFP9SP1)

2008-08-05 Thread Tracy Pearson
Someday when you want to see, check out what Norton does with SysInternals ProcMon tool. On, Off, Ignore, still puts a finger on the file. Tracy -Original Message- From: MB Software Solutions General Account Sent: Tuesday, August 05, 2008 12:05 PM Tracy Pearson wrote: You are probably

RE: Vista user getting DBC internal consistency error (VFP9SP1)

2008-08-05 Thread Gil Hale
Good points...thanks, Tracy! I'll ask them to configure the A/V (I think it's Norton) to ignore the DBC/DCX/DCT/DBF/FPT/CDX files and hopefully that will fix it. This is one of the first tings I do with any AV solution. Also, if you are using Symantec AntiVirus Corporate (and this may hold

Re: [OT] Pelosi's Planet

2008-08-05 Thread Michael Madigan
Based on what he said or based on what they said he said? Accountability. What he said was way beyond what could be argued. He should be held responsible for his comments and the ensuing action appropriate. ___ Post Messages to: ProFox@leafe.com

Re: [OT] Pelosi's Planet

2008-08-05 Thread MB Software Solutions General Account
Michael Madigan wrote: Based on what he said or based on what they said he said? Accountability. What he said was way beyond what could be argued. He should be held responsible for his comments and the ensuing action appropriate. Start a hearing and get to the facts. (Oh greatmore

Re: [OT] Just put another cover on it, 20 years and the tech is failing

2008-08-05 Thread Jean Laeremans
On Tue, Aug 5, 2008 at 3:40 PM, [EMAIL PROTECTED] wrote: http://tinyurl.com/66nlke 2. Why would you compare that aged Soviet technology to what we can do today in our over-regulated environment. Why even the French can get it right and use nukes safely.

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread Paul McNett
MB Software Solutions General Account wrote: Paul McNett wrote: MB Software Solutions General Account wrote: VFP9SP1 We've got a scenario where a 3rd party has polluted our memo fields, and I'd like to write a cleanup that takes the value of the memo field and does a STRTRAN to get rid of

Re: [OT] Just put another cover on it, 20 years and the tech is failing

2008-08-05 Thread Pete Theisen
Jean Laeremans wrote: On Tue, Aug 5, 2008 at 3:40 PM, [EMAIL PROTECTED] wrote: http://tinyurl.com/66nlke 2. Why would you compare that aged Soviet technology to what we can do today in our over-regulated environment. Why even the French can get it right and use nukes safely.

Time to argue about long vs short methods

2008-08-05 Thread Whil Hentzen
So I'm working on this gig with a customer. The customer's rep is one of these POOP folks, very anal about stuff that I'm somewhat more pragmatic about. One of their pet peeves regards method length. Somewhere they read in a book that methods shouldn't be longer than 20 characters. I've got

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread MB Software Solutions General Account
Paul McNett wrote: A bazillion quote marks, or 1000 like your REPLACE command? Bazillion. I figured if I used 1000 in my STRTRAN that I could knock off most and just leave the last 1000 in there. It would be ideal to remove all of the extra crap, and I think I chose the 1000 instead of

Re: Time to argue about long vs short methods

2008-08-05 Thread MB Software Solutions General Account
Whil Hentzen wrote: So I'm working on this gig with a customer. The customer's rep is one of these POOP folks, very anal about stuff that I'm somewhat more pragmatic about. One of their pet peeves regards method length. Somewhere they read in a book that methods shouldn't be longer than 20

Re: Time to argue about long vs short methods

2008-08-05 Thread Paul McNett
Whil Hentzen wrote: So I'm working on this gig with a customer. The customer's rep is one of these POOP folks, very anal about stuff that I'm somewhat more pragmatic about. One of their pet peeves regards method length. Somewhere they read in a book that methods shouldn't be longer than

RE: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread Michael Donald Goslin
Have you looked at FILETOSTR() and STRTOFILE(); both can handle large strings. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions General Account Sent: Monday, August 04, 2008 10:51 PM To: ProFox Email List Subject: Variable only

Re: Time to argue about long vs short methods

2008-08-05 Thread MB Software Solutions General Account
Paul McNett wrote: Unfortunately, VFP doesn't allow nested functions, so it isn't easy to do this cleanly anyway (why put a ProcessConditionOne() method at the class level if it is only going to ever be used by MyMethod() - it pollutes the API). Huh? I must be misunderstanding you. VFP

RE: Time to argue about long vs short methods

2008-08-05 Thread Tracy Pearson
Not the way Python can. Object.Method().Method().value -Original Message- From: MB Software Solutions General Account Sent: Tuesday, August 05, 2008 4:06 PM Paul McNett wrote: Unfortunately, VFP doesn't allow nested functions, so it isn't easy to do this cleanly anyway (why put a

Re: Time to argue about long vs short methods

2008-08-05 Thread Paul McNett
MB Software Solutions General Account wrote: Paul McNett wrote: Unfortunately, VFP doesn't allow nested functions, so it isn't easy to do this cleanly anyway (why put a ProcessConditionOne() method at the class level if it is only going to ever be used by MyMethod() - it pollutes the API).

Re: [NF] Pictures of the Large Hadron Collider

2008-08-05 Thread Whil Hentzen
The Universe started with a Big Bang – but we don’t fully understand how or why it developed the way it did. Depending on which website you read, they already know how the universe came to be, no theory about it. This is expensive project only to flesh out the details of an already

RE: Time to argue about long vs short methods

2008-08-05 Thread Rick Schummer
Put the weapons away. Discuss. Geez, such rules. Hold on... List of weapons removed from the email in case it is sniffed by the gov't department of snoopers. g I also agree with your associate, especially if there is a possibility for subclassing and overriding one of the smaller methods. I

Re: Time to argue about long vs short methods

2008-08-05 Thread Matthew Jarvis
If he's paying you by the hour, just smile all the way to the bank since he's causing extra work! I'm w/ MB on this one (and I guess you too Whil)... This sounds like an Okay - whatever you want decision that isn't worth getting yer panties in a wad over... -- Matt Jarvis Eugene, Oregon USA

Re: [NF] T-Bird mail Q

2008-08-05 Thread Stephen Russell
On Tue, Aug 5, 2008 at 10:18 AM, Vince Teachout [EMAIL PROTECTED] wrote: Stephen Russell wrote: I have folders set up for various groups that send out mail, some like this list. In T-Bird I have set up the rules to move [bittorrent] to folder Bittorrent, but it fails to parse down the

[OT] Odd Renaming

2008-08-05 Thread Ed Leafe
San Antonio will continue to be a happy place to live, but it will no longer be gay. 1200 WOAI news reports that on Thursday, City Council is expected to approve changing the name of Gay Street to Second Baptist Way. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

RE: [OT] Odd Renaming

2008-08-05 Thread John
No, it would be the non-Baptist way. JH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: Tuesday, August 05, 2008 5:03 PM To: ProFox Mailing List Subject: [OT] Odd Renaming San Antonio will continue to be a happy place to live, but it will

Re: [OT] Odd Renaming

2008-08-05 Thread Pete Theisen
John wrote: No, it would be the non-Baptist way. snip ( -or- http://tinyurl.com/5893s5 ) OK, you want to rename the street. But Second Baptist Way? I mean, if being straight is the first choice for Baptists, wouldn't gay be the second Baptist way? Hi Ed! Second Baptist is a landmark on

RE: [OT] Odd Renaming

2008-08-05 Thread John
I will have to admit to having lesbian tendencies, though.VBG JH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pete Theisen Sent: Tuesday, August 05, 2008 5:36 PM To: ProFox Email List Subject: Re: [OT] Odd Renaming John wrote: No, it would be the

Re: [OT] Odd Renaming

2008-08-05 Thread Pete Theisen
John wrote: I will have to admit to having lesbian tendencies, though.VBG Hi John! I tried that line on some practicing lesbians. Turns out there are two kinds, male tolerant and male bashers. The bashers demanded that I have surgery to be like them. Good thing they weren't in power. OK,

[NF] Remote Control Software

2008-08-05 Thread Jeff Johnson
I have been using Unlimited Conferencing for conference software and accessing client computers. It is Java based. I am trying to help a corporate client and they can't install Java in order to allow them to share their desktop so I can help them. Looking at Webex, Gotomeeting, and a couple

Re: [NF] Remote Control Software

2008-08-05 Thread Paul McNett
Jeff Johnson wrote: I have been using Unlimited Conferencing for conference software and accessing client computers. It is Java based. I am trying to help a corporate client and they can't install Java in order to allow them to share their desktop so I can help them. Looking at Webex,

Re: [NF] Remote Control Software

2008-08-05 Thread Paul McNett
Jeff Johnson wrote: I have been using Unlimited Conferencing for conference software and accessing client computers. It is Java based. I am trying to help a corporate client and they can't install Java in order to allow them to share their desktop so I can help them. Looking at Webex,

Re: [NF] Remote Control Software

2008-08-05 Thread Jeff Johnson
No. I have virtual clients! ;^) Just kidding. When I log on to the network I use Citrix. Once I am in I am basically on a virtual PC. Virtual PC's do not allow remote desktop connection to physical PC's. They have on occasion given me rights on a physical PC so I could remote desktop in,

RE: [NF] Remote Control Software

2008-08-05 Thread Efren Pedroza
The better I think is www.logmein.com Try it. -Original Message- From: [EMAIL PROTECTED] on behalf of Jeff Johnson Sent: Tue 8/5/2008 18:13 To: [EMAIL PROTECTED] Subject: [NF] Remote Control Software I have been using Unlimited Conferencing for conference software and accessing

Re: [NF] T-Bird mail Q

2008-08-05 Thread Stephen Russell
On Tue, Aug 5, 2008 at 10:18 AM, Vince Teachout [EMAIL PROTECTED] wrote: Stephen Russell wrote: I have folders set up for various groups that send out mail, some like this list. In T-Bird I have set up the rules to move [bittorrent] to folder Bittorrent, but it fails to parse down the

Re: Time to argue about long vs short methods

2008-08-05 Thread Stephen Russell
On Tue, Aug 5, 2008 at 2:20 PM, Whil Hentzen [EMAIL PROTECTED] wrote: So I'm working on this gig with a customer. The customer's rep is one of these POOP folks, very anal about stuff that I'm somewhat more pragmatic about. One of their pet peeves regards method length. Somewhere they read in

[OT] Religulous

2008-08-05 Thread Helio Wakasugui
http://www.lionsgate.com/religulous/ Looks like fun! HW -- Corruptissima re publica plurimae leges. - Tacitus, The Annals of Imperial Rome. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

Re: [OT] Religulous

2008-08-05 Thread Ed Leafe
On Aug 5, 2008, at 9:51 PM, Helio Wakasugui wrote: http://www.lionsgate.com/religulous/ Looks like fun! Agreed - I posted it to Twitter. -- Ed Leafe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: