RE: Problem with dynamicbackcolor in grid

2010-02-05 Thread Dave Crozier
Alan, Would it not be easier to do an "SQL Select" on the stats table into a separate cursor say "curStats" and then populate the grid with this "copy" whenever you need to update the stats. That way you will be in control and you can call a method "Refresh_curStats" whenever you see fit. Dave Cro

OT -> Blogs

2010-02-05 Thread Bill Arnold
A last mention ... I've grown accustomed to blogging instead of OT, this way I get whatever it is off my chest. I feel obliged to report on my observations to "humanity", but I have no interest in banging heads - or violence in any form, for the matter. For the like-minded, we should connect our

VFP 9 install on Windows 7

2010-02-05 Thread Dave Crozier
I am upgrading my machine this week with a new installation of Windows 7 Ultimate as opposed to running the final RC version from September time. When I tried this last night I also installed VFP9 SP2 and all was well. Then I tried to uninstall VFP it just to see if everything was OK and despite m

RE: OT -> Blogs

2010-02-05 Thread Virgil Bierschwale
http://www.KeepAmericaAtWork.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Bill Arnold Sent: Friday, February 05, 2010 2:44 AM To: profox@leafe.com Subject: OT -> Blogs A last mention ... I've grown accustomed to blogging instead o

Re: [OT] How big is $1.9 trillion?

2010-02-05 Thread Publius Maximus
On Thu, Feb 4, 2010 at 9:34 PM, Geoff wrote: > ORCHESTRATED CRISIS??? > > Delusions must really plague you badly nowadays. http://bit.ly/ce1dHD - - - The Strategy was first elucidated in the May 2, 1966 issue of The Nation magazine by a pair of radical socialist Columbia University professors, R

Re: VFP 9 install on Windows 7

2010-02-05 Thread Malcolm Greene
Dave, I'm on Windows 7 Professional and had a similar problem with other applications. I now install all my applications to folders off the root which seems to work fine. At some point I'll get my act together (been saying that for awhile) and will create a root folder for all my programs simila

Re: [OT] How big is $1.9 trillion?

2010-02-05 Thread Ricardo Aráoz
I didn't get it Could you explain it further? And please cite some more things from the web? Minimus Dickus wrote: > On Thu, Feb 4, 2010 at 9:34 PM, Geoff wrote: > >> ORCHESTRATED CRISIS??? >> >> Delusions must really plague you badly nowadays. >> > > http://bit.ly/ce1dHD > > - - - > The

Re: VFP 9 install on Windows 7

2010-02-05 Thread Alan Bourke
On Fri, 05 Feb 2010 09:09 -0500, "Malcolm Greene" wrote: > suggest. BTW: For you guys across the pond, shouldn't that be Programmes > vs. Programs? Only in the realm of television, i.e. your 'show' = our 'programme'. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___

Re: Problem with dynamicbackcolor in grid

2010-02-05 Thread Alan Bain
Dave, Interesting! One option I haven't looked at enough. I have been focusing on the detail form. I never considered changing the controlsource on the grid. Sometimes you get so deep into the issue you can't see the forest for the trees. >>call a method "Refresh_curStats" whenever you see fit.

Re: VFP 9 install on Windows 7

2010-02-05 Thread Malcolm Greene
Alan, Thanks! What's the saying? "Two countries separated by a common language?" Mal ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listi

Re: Parsing a text field?

2010-02-05 Thread Ted Roche
On Thu, Feb 4, 2010 at 11:23 PM, Paul McNett wrote: > > I can't remember: does VFP's SELECT-SQL allow for searching using regular > expressions? Because your problem just calls for a regex solution. > > Paul I don't believe it supports RegEx, but it does support wildcards, so SELECT * FROM MyTab

Re: Parsing a text field?

2010-02-05 Thread Ricardo Aráoz
Francis Coppage wrote: > Gentlemen . > > > > I have records that contains part numbers and other data. > > Multiple records may contain the same part number > > . (don't worry, other fields make the record unique J .) > > > > PartNumber C(24) > > > > 12A456789-123 > > 12A456789-123? > > 12A4

Re: [NF] How MS conspires to stifle its own innovation.

2010-02-05 Thread Michael Madigan
This is probably why they should just spin off a company when new technology like that arises. If the Office leader doesn't want to create a tablet version, then the spin-off company uses a different word processor and competes with Office. --- On Thu, 2/4/10, MB Software Solutions, LLC wr

Re: Parsing a text field?

2010-02-05 Thread Ted Roche
2010/2/5 Ricardo Aráoz : > > I think you overlooked ChrTran(). > Or UNION and IsAlpha() SELECT * FROM MyTable where PartID = '12A456789-123' UNION SELECT * FROM MyTable where PartID LIKE '12A456789-_123' AND ISALPHA(SUBSTR(PartID,11,1)) UNION SELECT * FROM MyTable where PartID LIKE '12A456789-123

RE: Parsing a text field?

2010-02-05 Thread Richard Kaye
Or use Craig Boyd's regexp.fll and then you can use regex in a VFP query, albeit by calling a UDF. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday, February 05, 2010 11:54 AM To: profoxt...@leafe.com Subj

Re: [NF] How MS conspires to stifle its own innovation.

2010-02-05 Thread Stephen Russell
On Fri, Feb 5, 2010 at 10:44 AM, Michael Madigan wrote: > This is probably why they should just spin off a company when new technology > like that arises.  If the Office leader doesn't want to create a tablet > version, then the spin-off company uses a different word processor and > competes wi

Re: Parsing a text field?

2010-02-05 Thread Stephen Russell
On Fri, Feb 5, 2010 at 10:54 AM, Ted Roche wrote: > 2010/2/5 Ricardo Aráoz : >> >> I think you overlooked ChrTran(). >> > > Or UNION and IsAlpha() > > SELECT * FROM MyTable where PartID = '12A456789-123' > UNION > SELECT * FROM MyTable where PartID LIKE '12A456789-_123' AND > ISALPHA(SUBSTR(PartID

RE: [NF] How MS conspires to stifle its own innovation.

2010-02-05 Thread Virgil Bierschwale
When they become dependent on code generators and their dependency on them, that is the end of innovation and the beginning of the end of what made them a success to start with. Virgil http://www.IneedBookkeepingHelp.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-b

Re: [OT] This one is for Jean

2010-02-05 Thread Jean Laeremans
2010/2/5 Ricardo Aráoz : > Publius Maximus wrote: >> http://bit.ly/dtE2QO As fake as the wmd reports A+ jml ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http

Re: [NF] How MS conspires to stifle its own innovation.

2010-02-05 Thread Stephen Russell
On Fri, Feb 5, 2010 at 11:19 AM, Virgil Bierschwale wrote: > When they become dependent on code generators and their dependency on them, > that is the end of innovation and the beginning of the end of what made them > a success to start with. - Can I get an AME

How to find out why UPDATE SQL statement is failing

2010-02-05 Thread Steve Ellenoff
I have a biz object that is occasionally failing to save data and I'm trying to understand why. Here's an example of the SQL command it generates: UPDATE webaccess SET lastmod={^2010-02-05 15:07:11}, nloginfail=0 WHERE uniqueid=='_2UX13CCKE' AND nloginfail==1 The biz object uses _TALLY when hit

RE: VFP9: mousewheel and combobox - Spam detected - Spam detected

2010-02-05 Thread Jack Skelley
Stephen: The combobox behavior on the URL you listed is what I would like in the VFP combobox. But that is not the case. Thanks! Regards, Jack From: profoxtech-boun...@leafe.com [profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell [srussell...@gma

Re: Swiss Guy about Guns

2010-02-05 Thread Gene Wirchenko
At 12:16 2010-02-04, Ed Leafe wrote: >On Feb 4, 2010, at 1:43 PM, Gene Wirchenko wrote: > > > And what happens if someone does not? I and others get to > > spend our time sifting through the garbage to get what we subscribed > > to the list for. Free speech at our expense. > > I apo

Re: Swiss Guy about Guns

2010-02-05 Thread Jean Laeremans
On Fri, Feb 5, 2010 at 11:01 PM, Gene Wirchenko wrote: >      I would like to see a list that is not so dysfunctional.  You > call it whining. > This is OTT not OT A+ jml ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.co

RE: Swiss Guy about Guns

2010-02-05 Thread Virgil Bierschwale
When a person drives down the highway, they pass a multitude of billboards that have nothing to do with the highway and actually detract from the highway, yet that is a reality, just as spam is. For myself, I don't set up any rules because I don't want to take a chance of missing something that mi

[OT] No, he can't

2010-02-05 Thread Publius Maximus
http://bit.ly/bO3NaP - - - WASHINGTON – No, maybe he can't. President Barack Obama, who insisted he would succeed where other presidents had failed to fix the nation's health care system, now concedes the effort may die in Congress. The president's newly conflicting signals could frustrate Democr

RE: How to find out why UPDATE SQL statement is failing

2010-02-05 Thread Jarvis, Matthew
> -Original Message- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] > On Behalf Of Steve Ellenoff > Sent: Friday, February 05, 2010 12:24 PM > To: profoxt...@leafe.com > Subject: How to find out why UPDATE SQL statement is failing > > I have a biz object that is

RE: Parsing a text field?

2010-02-05 Thread Francis Coppage
Thanks All (Ted, Ricardo, Richard & Stephen) Functions in SQL return unexpected results (sometimes, which is too much), CHRTRAN() would take out ALPHA characters in the part number base (which is essential). RegExp are not supported in SQL (VFP anyway). I have never used wild cards in SQL but tha

Re: Swiss Guy about Guns

2010-02-05 Thread Ed Leafe
On Feb 5, 2010, at 5:01 PM, Gene Wirchenko wrote: > I would like to see a list that is not so dysfunctional. So would everyone else, except for the dysfunctional people. > You call it whining. It is when you expect the world to bend to your whim when a simple solution ha

RE: Swiss Guy about Guns

2010-02-05 Thread Richard Kaye
Hi Gene, This is not a moderated list. You have to make your own decision about whether or not it is worth your time & energy to deal with those people who are either unable or unwilling to abide by the OT conventions. I think for most, filters and the delete key get the job done. Please don't

Re: Parsing a text field?

2010-02-05 Thread Paul Newton
Francis Coppage wrote: > Again, many thanks to all. It never fails that when I run into > a problem THE board pulls me through. I try not to be a pain > but every now and then I need someone to pull my A$$ out of the > wringer!! > > THANKS!!! > The list is not DYSFUNCTIONAL at all then ! But

Re: [OT] No, he can't

2010-02-05 Thread Ricardo Aráoz
Minimus Dickus wrote: > http://bit.ly/bO3NaP > > - - - > WASHINGTON – No, maybe he can't. President Barack Obama, who insisted > he would succeed where other presidents had failed to fix the nation's > health care system, now concedes the effort may die in Congress. > > The president's newly confli

Re: [OT] No, he can't

2010-02-05 Thread Michael Madigan
This retard (borrowing a phrase from Rahm) only had to compromise a little bit on his plan and he would have peeled off 10 Republicans to vote yes, but his narcissism prevented him from doing it. Chump. --- On Fri, 2/5/10, Publius Maximus wrote: > From: Publius Maximus > Subject: [OT] No, he

Re: [OT] No, he can't

2010-02-05 Thread Publius Maximus
On Fri, Feb 5, 2010 at 5:31 PM, Michael Madigan wrote: > This retard (borrowing a phrase from Rahm) only had to compromise a little > bit on > his plan and he would have peeled off 10 Republicans to vote yes, but his > narcissism > prevented him from doing it.  Chump. Actually, the danger has in

Re: Swiss Guy about Guns

2010-02-05 Thread Jeff Johnson
Maybe we should have a list where we compare who we filter out! ;^) The below says it all. I really appreciate this list and it has been invaluable to me for my business. The good thing about unmarked OT coming through is to appreciate why we don't subscribe to the OT. I like the way it is s

Re: [OT] No, he can't

2010-02-05 Thread Publius Maximus
On Fri, Feb 5, 2010 at 5:31 PM, Michael Madigan wrote: > This retard (borrowing a phrase from Rahm) only had to compromise a little > bit on his plan BTW, the dirty little secret laid bare by how this all unfolded was that he never had a *plan* per se... all he had was Chavez-type ambition and a

Re: Swiss Guy about Guns

2010-02-05 Thread Jeff Johnson
It seems to me that there are what you might call "repeat offenders." Filter out those one or two folks and you will be fine. To be honest, I only filter out one person and I am good. Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. 623-582-0323 Fax 623-869-0675 Richard Kaye wrote: > Hi Gene,

Re: Swiss Guy about Guns

2010-02-05 Thread Paul McNett
On 2/5/10 3:11 PM, Jeff Johnson wrote: > Maybe we should have a list where we compare who we filter out! ;^) > The below says it all. I really appreciate this list and it has been > invaluable to me for my business. The good thing about unmarked OT > coming through is to appreciate why we don't

Re: Swiss Guy about Guns

2010-02-05 Thread Paul McNett
On 2/5/10 3:14 PM, Jeff Johnson wrote: > It seems to me that there are what you might call "repeat offenders." > Filter out those one or two folks and you will be fine. To be honest, I > only filter out one person and I am good. But then you risk missing the day when that person actually posts so

Re: [OT] No, he can't

2010-02-05 Thread Michael Madigan
It's time for him to open the concentration camps and round up the small business owners. --- On Fri, 2/5/10, Publius Maximus wrote: > From: Publius Maximus > Subject: Re: [OT] No, he can't > To: "ProFox Email List" > Date: Friday, February 5, 2010, 6:12 PM > On Fri, Feb 5, 2010 at 5:31 PM,

Re: [OT] No, he can't

2010-02-05 Thread Publius Maximus
On Fri, Feb 5, 2010 at 6:39 PM, Michael Madigan wrote: > It's time for him to open the concentration camps and round up the small > business owners. > I don't have any doubt in my mind, nor any contradiction from my spirit, that Obama is Very Bad News for the republic. Indeed, I grieved over it

Re: [OT] No, he can't

2010-02-05 Thread Pete Theisen
Michael Madigan wrote: > It's time for him to open the concentration camps and round up the small > business owners. Hi Michael. Actually, it will be the Old People. Yesterday I read over my new Medicare Drug Plan. Can you say "Death Panel"? All the stuff you hated in the "new" health care pro

Re: Swiss Guy about Guns

2010-02-05 Thread Ed Leafe
On Feb 5, 2010, at 6:18 PM, Paul McNett wrote: >> It seems to me that there are what you might call "repeat offenders." >> Filter out those one or two folks and you will be fine. To be honest, I >> only filter out one person and I am good. > > But then you risk missing the day when that person a

rookie needs help

2010-02-05 Thread Gary Jeurink
In my main form I call up individual forms with buttons like THISFORM.RELEASE DO FORM c:\alldat\forms\songeditor I'm closing each of the multiple forms with THISFORM.RELEASE DO c:/alldat/prog/mainprogram && which calls back the main program form Some forms called up are opening with an em

Re: [OT] No, he can't

2010-02-05 Thread Pete Theisen
Publius Maximus wrote: > this doofus has the gall to > chide "Washington" for too much spending even as he himself proposes a > deficit the size of some black hole Hi Bob, There you go again! How many times do "they" have to tell you that it only used to be "black". Right now it is "African Amer

[NF] Insert an Excel Table into Web Page

2010-02-05 Thread Charles Hart Enzer, M.D., FAACP
I want to insert an Excel Wortsheet onto a web page. I want to maintain the table within Excel. And then the web page would be updated. I would place on my site: * WebPage.html * ExcelWorkSheet.xls What is the code for this insertion? Thank you. -- *Charles *-- Website: *http://home

RE: [OT] No, he can't

2010-02-05 Thread Geoff
Well at least you guys now get to keep you unenviable record as having the worst health system in the civilized world. ENJOY! -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Pete Theisen Sent: Saturday, 6 February 2010 11:08 AM To: ProFox Em

Re: [OT] No, he can't

2010-02-05 Thread Pete Theisen
Geoff wrote: > Well at least you guys now get to keep you unenviable record as having the > worst health system in the civilized world. ENJOY! Hi Geoff, http://en.wikipedia.org/wiki/Health_care_in_Australia Is it working out for sick people in Australia? Is there a Death Panel? Is abortion mand

RE: [OT] No, he can't

2010-02-05 Thread Geoff
We 'solved' it by keeping our eyes open nearly 40 years ago and doing something about national medical care. Many of the seemingly intractable problems you face are because you tolerate it. And when someone stands up to attack the problem all you do is complain about the method or a side issue. The

Re: [OT] No, he can't

2010-02-05 Thread Pete Theisen
Geoff wrote: > We 'solved' it by keeping our eyes open nearly 40 years ago and doing > something about national medical care. Many of the seemingly intractable > problems you face are because you tolerate it. And when someone stands up to > attack the problem all you do is complain about the method

RE: [OT] No, he can't

2010-02-05 Thread Geoff
It is a war and it won't be won in one battle. It will take time and continued tinkering and work to ensure it remains just, universal and affordable. But it takes that first step that you seem unwilling to take. Yes, universal health care looks after those who contribute nothing but sickness. Yes,