? STR( 845092370570, 14, 0)
--
Jean MAURICE
Grenoble - France - Europe
www.atoutfox.org
www.aedtf.org
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list:
? str(myLongNumber, 20,0)
Note the final parameter for decimal places is optional.
Dave Crozier
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Sytze de Boer
Sent: 2009-02-09 05:37
To: profox@leafe.com
Subject: VFP9 - truncating numbers
Oh, I also forgot that if you don't want to specify a length for the field
or in fact don't know the length then you can also use:
? Transform(myLongNumber)
Dave Crozier
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Sytze de Boer
On Fri, 06 Feb 2009 18:20:26 -, Mark Stanton
m...@vowleyfarm.co.uk said:
Agent Ransack is just a search tool that you fire up when needed.
That just covers a lot of ground. Agent finds stuff for me in a
fraction of the
time that WDS does, if WDS ever does which it frequently
Hey, handy to have. Thx!
--
Alan Bourke
alanpbou...@fastmail.fm
___
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
http://tinyurl.com/dmo27g
- - -
The $9.7 trillion in pledges would be enough to send a $1,430 check to every
man, woman and child alive in the world. It's 13 times what the U.S. has
spent so far on wars in Iraq and Afghanistan, according to Congressional
Budget Office data, and is almost enough
How do I get a record for each Id even when there is no record in B for Typ2?
TIA - Joe Yoder
* Define and load demo cursors
CREATE CURSOR A (Id I)
CREATE CURSOR B (Parent I, Type C(1))
INSERT INTO A (Id) VALUES (1)
INSERT INTO A (Id) VALUES (2)
INSERT INTO B (Parent, Type) VALUES
Someone else might have a different suggestion. In your limited data set
this works:
SELECT a.id, b1.type as typ1, b2.type as typ2;
FROM b as b1 RIGHT JOIN a ;
ON a.id == b1.parent AND b1.type = 'a' ;
LEFT JOIN b as b2 ;
ON a.id == b2.parent AND b2.type = 'b'
Tracy
If you are working with VFP9 try a 'left outer join' like in this template
SELECT A.Id, B1.Type as Typ1, NVL(B2.Type, ) as Typ2;
FROM A INNER JOIN B b1 ON a.id = b1.parent AND b1.type =a ;
LEFT OUTER JOIN B b2 ON a.id = b2.parent AND b2.type = b
here above you will have a line if
Bob Calco wrote:
Hi Bob!
Yes, the end of the world is almost here, always has been, always will
be. However, we ALL have to stay alive until it comes.
I have a little blue book that contains the Declaration of Independence.
The language of that document is, uh, revolutionary.
Something hard
On Mon, Feb 9, 2009 at 3:13 AM, Alan Bourke alanpbou...@fastmail.fm wrote:
On Fri, 06 Feb 2009 18:20:26 -, Mark Stanton
m...@vowleyfarm.co.uk said:
Agent Ransack is just a search tool that you fire up when needed.
That just covers a lot of ground. Agent finds stuff for me in a
Thanks Jean and Tracy! Your help gets me going and I am filing your
solutions for future study - Joe
On Monday, February 09, 2009 9:52 AM, Jean MAURICE wrote:
Date: Mon, 09 Feb 2009 15:52:17 +0100
From: Jean MAURICE
To: profoxt...@leafe.com
cc:
Subject: Re: SQL help
If you are working with
Stephen,
I liked and used Xobni until just before Xmas and that update started
causing multiple instances of Outlook to be loaded if you inadvertently
re-opened outlook. These phantoms took up huge amounts of memory and
effectively meant that I potentially had a multi-user postbox with all the
Another thing to test is varied data.
* Only Type B
INSERT INTO curA (Id) Values (3)
INSERT INTO curb (Parent, Type) VALUES (3, 'b')
* No Child Records
INSERT INTO curA (Id) Values (4)
-Original Message-
From: Dave Crozier
Sent: Monday, February 09, 2009 10:22 AM
*
* Define and load demo cursors
CREATE CURSOR curA (Id I)
CREATE CURSOR curB (Parent I, Type C(1))
INSERT INTO curA (Id) VALUES (1)
INSERT INTO curA (Id) VALUES (2)
INSERT INTO curB (Parent, Type) VALUES (1, 'a')
INSERT INTO curB (Parent, Type) VALUES (1, 'b')
INSERT INTO curB (Parent, Type)
Thanks Dave,
Yet another approach added to my VFP Q A folder for a day when I can
afford to study all options. I know about the pitfalls of single letter
aliases and wondered whether I would get bitten in this code. I tried it
this way to keep it as small as possible and to see if I could
On Mon, Feb 9, 2009 at 9:26 AM, Dave Crozier da...@flexipol.co.uk wrote:
Stephen,
I liked and used Xobni until just before Xmas and that update started
causing multiple instances of Outlook to be loaded if you inadvertently
re-opened outlook. These phantoms took up huge amounts of memory and
At 06:37 PM 2/9/2009 +1300, Sytze de Boer wrote:
How do I stop a number such as 845092370570 turning into 8.450E+11 when I
say str(mylongnumber)
I think you need to specify the number of digits (2nd parm in STR()
function). If you don't, it defaults to 10 - which would then force the
At 09:22 PM 2/6/2009 -0600, Ed Leafe wrote:
Then you might like this: http://twurl.nl/6ce324
-- Ed Leafe
clap
clap
clap
clap
clap
clap
clap
Hi Joe
Single letter aliases are bad especially in VFP. The best thing is not
even to use CurA, CurB, but to use aliases that have meaning. Saving a
few keystrokes of typing really does not help in the long run. Cut and
paste is your friend. Any saving in time typing is far outweighed by
having
Stephen,
Looks like they have solved the problem then. I'll revisit it, thanks for
checking.
Dave Crozier
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Stephen Russell
Sent: 2009-02-09 16:13
To: ProFox Email List
Subject: Re: anyone
http://tinyurl.com/d7xjpk
- - -
Amid the furor over controversies regarding Cabinet-nominee tax problems and
the seismic battle over a nearly trillion-dollar economic rescue bill,
President Obama made a little-noticed appointment that is now generating
intrigue.
Shauna Daly, a 29-year-old
tinyurl.com/accq5j
--
Stephen Russell
Sr. Production Systems Programmer
First Horizon Bank
Memphis TN
901.246-0159
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this
Stephen Russell wrote:
tinyurl.com/accq5j
Hi Stephen!
I didn't know you were a D. Never entered my mind.
--
Regards,
Pete
http://pete-theisen.com/
http://elect-pete-theisen.com/
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
On Mon, Feb 9, 2009 at 1:03 PM, Pete Theisen petethei...@verizon.net wrote:
Stephen Russell wrote:
tinyurl.com/accq5j
Hi Stephen!
I didn't know you were a D. Never entered my mind.
--
100% not a D or an R.
Both view points led us to our current situation.
I thought that McCain was a
Gil -- any reason you're cutting/pasting but not getting rid of the
original emails? What gives, man?
Gil Hale wrote:
I mean, if they would have been carrying malaria that incident would have
been almost as bad as... hmm... MS releasing Vista.
Very good, Charlie! That brought a big assed
Alan Bourke wrote:
Hey, handy to have. Thx!
Yeah, I'd had the need for some time and so I finally took the time to
throw them together. Hope it helps someone else too!
Cheers,
--Mike
___
Post Messages to: ProFox@leafe.com
Subscription
Paul Hill wrote:
Unfortunately the only effective treatments both have strong side
effects: Linux (beard growth) and MacOS (homosexual urges).
LOL!!
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
MB Software Solutions, LLC wrote:
Paul Hill wrote:
Unfortunately the only effective treatments both have strong side
effects: Linux (beard growth) and MacOS (homosexual urges).
LOL!!
Hi Michael and Paul!
Now that you mention it, since I have been all Linux my beard is getting
fierce.
Stephen Russell wrote:
On Mon, Feb 9, 2009 at 1:03 PM, Pete Theisen petethei...@verizon.net wrote:
Stephen Russell wrote:
tinyurl.com/accq5j
I didn't know you were a D. Never entered my mind.
100% not a D or an R.
Both view points led us to our current situation.
I thought that
We've got RESOURCE = OFF (2nd line, just after TITLE) in our config.fpw
yet the foxuser.* files are still being created. We do not have any
code in the app that says SET RESOURCE ON either. What gives?
tia!
--Michael
___
Post Messages to:
Check the following:
Do you have the config.fpw set to be included?
On the users workstation, is the PATH environment variable invalid?
(i.e. c:\windows\c:\windows\system32 is missing a semi-colon.)
HTH,
Tracy
-Original Message-
From: MB Software Solutions, LLC
Sent:
Tracy Pearson wrote:
Check the following:
Do you have the config.fpw set to be included?
Yes, it's in the project.
On the users workstation, is the PATH environment variable invalid?
(i.e. c:\windows\c:\windows\system32 is missing a semi-colon.)
Hmmm...our QC (quality
Old habits...
-Original Message-
From: profoxtech-boun...@leafe.com
[mailto:profoxtech-boun...@leafe.com]on Behalf Of MB Software
Solutions,LLC
Sent: Monday, February 09, 2009 2:35 PM
To: profoxt...@leafe.com
Subject: Re: [NF] Microsoft Bugs?
Gil -- any reason you're
Gil Hale wrote:
Old habits...
You're one or two keystrokes away from greatness! ;-)
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list:
On Mon, Feb 9, 2009 at 4:22 PM, Mike yearwood mike.yearw...@gmail.com wrote:
Hi Joe
Single letter aliases are bad especially in VFP.
You gotta love backwards compatibility right? Maybe some folks here
are not aware that 'SELECT c' is the same as 'SELECT 3'.
Another one: '123' is the same as
Gil's the only normal Mac user I know.
*
--- On Mon, 2/9/09, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
From: MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com
Subject: Re: [NF]
Are you sure that he is normal? Thats not exaxtly what I would call it! GDR
Mike
Sent from my Verizon Wireless BlackBerry
-Original Message-
From: Michael Madigan mmadi10...@yahoo.com
Date: Mon, 9 Feb 2009 12:24:46
To: profoxt...@leafe.com
Subject: Re: [NF] Microsoft Bugs?
Gil's the
Michael Madigan wrote:
Gil's the only normal Mac user I know.
Hi Michael!
I know a girl who is. However, a former boyfriend gave her the mac, she
didn't buy it herself.
http://viewmorepics.myspace.com/index.cfm?fuseaction=viewImagefriendID=182768841albumID=1251880imageID=29993390
or
I attribute the relative normalcy to having deep roots in DOS from as far
back as 1984, some periphery exposure to UNIX in 1987 - 1991 (including SCO
UNIX286), plenty of Windows exposure, fairly early GUI Linux
(Lindows/Linspire) and a touch of RHL (via Ed), and a full blown
indoctrination (trial
The idea he merely inherited the mess is a lie which only a total
ignoramus could believe. Maybe
THAT STATEMENT alone renders the value of the rest of your post zero. Only
an ignoramus could claim that Obama didn't inherit the mess. It is one thing
to be partisan in politics; it is another thing
Yes, it's in the project.
If included in the EXE then are also leaving open the external FPW
(ALLOWEXTERNAL ON) in the
internal Config.FPW?
Rick
White Light Computing, Inc.
www.whitelightcomputing.com
www.swfox.net
www.rickschummer.com
___
Post
Can you truly inherit something that you yourself helped to create?
::michael
Geoff Flight wrote:
The idea he merely inherited the mess is a lie which only a total
ignoramus could believe. Maybe
THAT STATEMENT alone renders the value of the rest of your post zero. Only
an ignoramus could
Rick Schummer wrote:
Yes, it's in the project.
If included in the EXE then are also leaving open the external FPW
(ALLOWEXTERNAL ON) in the
internal Config.FPW?
No, ALLOWEXTERNAL ON is not there. I should add it for a future
release, though.
Are you sure your application is creating the foxuser.* files. Loader app,
vrunfox or something else might be creating the files.
Tracy
-Original Message-
From: MB Software Solutions, LLC
Sent: Monday, February 09, 2009 5:56 PM
Rick Schummer wrote:
Yes, it's in the project.
If
Tracy Pearson wrote:
Are you sure your application is creating the foxuser.* files. Loader app,
vrunfox or something else might be creating the files.
To find out who is creating them, log on as administrator and create file
foxuser.dbf
in the suspect location. Then set permissions on that
I take a different approach to testing apps on a new(ish) OS, that , when
done, leaves a total blueprint of that OS's internal calls with any app
that I'm testing.
I switched over to this technique late in 1999, and never looked back.
I can understand the gripe and moan philosophy, but if I
Tracy Pearson wrote:
Are you sure your application is creating the foxuser.* files. Loader app,
vrunfox or something else might be creating the files.
Tracy
There's no loaderit's all deployed via Installshield Pro 2009. I'll
have to check the scripts to ensure that the foxuser.* isn't
Good Point. Instead of calling Gil normal, I should more precisely say he's
a non-douchebag. Normal is subjective, but everyone knows what a douchebag is.
*
1/20/2013 Eviction Notice
http://www.cafepress.com/rightwingmike/6169336
--- On Mon,
What a joke this administration has already become. To take questions from a
liberal sewer like the Huffington Post.
*
1/20/2013 Eviction Notice
http://www.cafepress.com/rightwingmike/6169336
___
I dont have the foxuser problem and I dont have this in either
Allen
- Original Message -
From: MB Software Solutions,LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com
No, ALLOWEXTERNAL ON is not there. I should add it for a future
release, though.
I dont. But Im from across the pond.
Al
- Original Message -
From: Michael Madigan mmadi10...@yahoo.com
To: profoxt...@leafe.com
Sent: Tuesday, February 10, 2009 2:11 AM
Subject: Re: [NF] Microsoft Bugs?
Good Point. Instead of calling Gil normal, I should more precisely say
he's a
Allen Pollard wrote:
I dont. But Im from across the pond.
Good Point. Instead of calling Gil normal, I should more precisely say
he's a non-douchebag. Normal is subjective, but everyone knows what a
douchebag is.
Hi Allen!
http://en.wikipedia.org/wiki/Douche
Slang uses
Douche bag, or
Thanks Pete. I had heard the word but never bothered to explore it. Its not
a common word in the uk as far as I know but there are many words or
ridicule that although used, the actual meaning is nothing. Like baby talk
or made up words.
Al
- Original Message -
From: Pete Theisen
54 matches
Mail list logo