Hi Guys,
It's a Monday morning and my brain isn't working properly (surprise,
surprise!)
Anyway, I have 3 tables that I want to join together.
Table 1 has 1 record =
Table1 My data
Table 2 has 1 record =
Table2 My data
Table 3 has 2 records =
Table3 My data record 1
As long as you know that table one has all the records you need then two
and thress should be left outer joins.
--
Regards
Michael.
[EMAIL PROTECTED]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Bill Arnold said:
David, I think circumstances at some point in time, say even 10 or 15
years from now, will force MS to do *something* with the source code,
either sell it or put it on the public domain.
A triggering event might be the 1st time a VFP application stops working
after a MS OS
Michael Hawksworth wrote:
As long as you know that table one has all the records you need then
two and thress should be left outer joins.
What?
Select Customers.Name, Invoices.InvNo, Invoices.OrderDate, Invoices.
From Customers
Left join Invoices on Customers.CustNo = Invoices.CustNo
Tristan Leask wrote:
Hi Guys,
It's a Monday morning and my brain isn't working properly (surprise,
surprise!)
Anyway, I have 3 tables that I want to join together.
Table 1 has 1 record =
Table1 My data
Table 2 has 1 record =
Table2 My data
Table 3 has 2 records
Given the example Tristan gave then you could have tables two and/or
three with more records than table one and so laft outers wont work.
With no context given I added the restriction.
--
Regards
Michael.
[EMAIL PROTECTED]
___
Post Messages to:
Hi Nick,
Multi-threading in VFP is only possible using the MTDLL runtime. This means
you need at least one COM server that acts as the main program for the new
thread. To launch an MTDLL in a different thread, you need a little bit of
C/C++ code which you can download from
There are two other frameworks you can try.
StrataFrame at http://www.strataframe.net/default.aspx. You can download a
trial version.
eXpressApp Framework at http://www.devexpress.com/. You can download the
beta version.
I almost through evaluating StrataFrame and seems to be a very decent
On 3/24/07, Ed Leafe [EMAIL PROTECTED] wrote:
http://www.gotapi.com/
Anyone want to create a VFP entry?
http://www.gotapi.com/contribute/index.html
I'll bet the naming convention on the MS help site is consistent enough so
that someone could automate most of it with
Thanks Roderick!
___
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
** All postings, unless explicitly stated otherwise,
Clever parody:
http://blog.wired.com/cultofmac/2007/03/novell_launches.html
--
Ted Roche
Ted Roche Associates, LLC
http://www.tedroche.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
Will it ever end?
Waits for the I'm a playstation video. roll eyes
Tristan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Ted Roche
Posted At: 26 March 2007 14:00
Posted To: Profox Archive
Conversation: [NF] Hi, I'm PC and I'm a Mac... and I'm Linux
A study showed that people who bought wine at a grocery store also bought
things like tofu and low fat yogurt and lettuce leaves, said Bamforth.
delPeople/del Programmers who bought beer bought things like burgers,
minced beef and cigarettes. Now just imagine how unhealthy they would be if
they
On Mar 26, 2007, at 9:05 AM, Tristan Leask wrote:
Waits for the I'm a playstation video. roll eyes
Too late: http://leafe.com/archives/showMsg/345323
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
___
Post Messages to:
LOL! Good god!
Tristan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Ed Leafe
Posted At: 26 March 2007 14:16
Posted To: Profox Archive
Conversation: [NF] Hi, I'm PC and I'm a Mac... and I'm Linux
Subject: Re: [NF] Hi, I'm PC and I'm a Mac... and I'm
On 3/26/07, Tristan Leask [EMAIL PROTECTED] wrote:
LOL! Good god!
Grape minds think in a bunch.
--
Ted Roche
Ted Roche Associates, LLC
http://www.tedroche.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
On Mar 25, 2007, at 7:48 PM, john harvey wrote:
After 28 years of living with a woman, you
just get beat down!s Haha
28 years? Ha! 28 days, more likely!
On retirement, I have a hard time imagining not doing this. Absent
the pressure to make money, though, I'd like to pursue other (non-
I want a Wii, take my Xbox360 away!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tristan Leask
Sent: 26 March 2007 14:20
To: profox@leafe.com
Subject: RE: [NF] Hi, I'm PC and I'm a Mac... and I'm Linux
LOL! Good god!
Tristan
-Original
Ted Roche wrote:
Clever parody:
http://blog.wired.com/cultofmac/2007/03/novell_launches.html
She's kinda cute!
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!
Adam Buckland wrote:
I want a Wii, take my Xbox360 away!
Is that how much she weighs? Bad Mike!
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!
New Rule: Traitors don't get to question my patriotism.
http://www.youtube.com/watch?v=yWhy-hhoBkA
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
We're waiting for the Wii to get back in stock to get one for the kiddles.
Is the PS3 implosion going to go down in history and become the new
betamax? Sony seems to have a knack at putting their foot in their
mouth lately.
-Kevin
CULLY Technologies, LLC
Sponsor of FoxForward 2007
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Whil Hentzen (Pro*)
Sent: Sunday, March 25, 2007 11:20 AM
To: [EMAIL PROTECTED]
Subject: [NF] What's this nonsense about retiring from IT?
Regarding the recent life after VFP thread... folks
Is the PS3 implosion going to go down in history and become the new
betamax? Sony seems to have a knack at putting their foot in their
mouth lately.
Well, they're certainly doing their level best to ruin the huge
potential of the PSP. And we in Europe get to pay *more* for an inferior
Maybe my view is skewed, given my status as self-employed since the
early 80s. But I don't ever plan on 'retiring'. I love what I do, and
plan on doing it until I keel over on top of my keyboard. Why 'retire'?
I think that's key. I don't know many people who work for someone else and
have to
David, I think circumstances at some point in time, say even 10 or
15
years from now, will force MS to do *something* with the source
code,
either sell it or put it on the public domain.
A triggering event might be the 1st time a VFP application stops
working after a MS OS change.
... for an 18th birthday present for my godson what is going to
Staffordshire University to study Computer Games Design.
Would like something different that may help with his course and career
choice..
Or has anyone worked in the industry and can offer suggestions?
::a
Adam
12 Months subscription to either Penthouse or CAMRA! BG
Dave Crozier
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Adam Buckland
Sent: 26 March 2007 16:16
To: ProFox Email List
Subject: [NF] What do you buy...
... for an 18th birthday present
The only suggestion so far from another group was and I quote:
A gallon of ale and a night with a top-notch hooker.
Cheers,
Rich.
... for an 18th birthday present for my godson what is going to
Staffordshire University to study Computer Games Design.
-Original Message-
From:
The operative points here, I think, are that VFP is very, very good at
what it does; that .NET is not a suitable replacement; that the
royalty-free standard for this type of language/product is a stake in
the ground that MS will never remove, and that not only is there a
market for VFP, but a
For anyone wanting a good reference site for Objects and Components, take a
look at
http://www.cetus-links.org/
Some very interesting links under Python, Business Objects and even Visual
Foxpro.
Dave Crozier
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version:
Well, I'd get him the MAME arcade emulator and almost every coin-op
arcade game ever written up until about 2001:
http://www.romburner.co.uk/about_rom_burner.htm
Then I'd direct him here and ask him to familiarise himself with this:
http://www.bmigaming.com/top100arcade.htm
Or alternatively,
On Monday, March 26, 2007 11:45 AM Dave Crozier wrote:
For anyone wanting a good reference site for Objects and Components,
take a look at
http://www.cetus-links.org/
Some very interesting links under Python, Business Objects and even
Visual Foxpro.
The VFP page needs to updated as it talks
I like Alan's suggestions - to which I'd add - buy him a cheap return
flight to Bombay (asap 'cos it's too hot / wet by early May) - if he's
smart he'll be able to get a few days in Goa topping up his tan/ beer and
then buy all the books he needs in Bombay on the way back (just about every
Tracy,
Better safe than sorry to report these to the Fox Team. According to Milind's
February 2007 letter,
send all reports through the Connect site. Details can be found here:
http://msdn2.microsoft.com/en-us/vfoxpro/bb308951.aspx
Rick
White Light Computing, Inc.
www.whitelightcomputing.com
Wow, didn't know there was another MAME fan on the list. Good to know!
Regards,
Andrew Baker
e-mail: [EMAIL PROTECTED]
Alan Bourke [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/26/2007 12:00 PM
Please respond to profox
To: [EMAIL PROTECTED]
cc:
Subject:
An old laptop with Pacman, asteroids, Repton, Space Invaders, Tetris, etc?
They were *real* games!
John Weller
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Adam Buckland
Sent: 26 March 2007 16:16
To: [EMAIL PROTECTED]
Subject: [NF] What do you buy...
How many people remember the first time they saw Pong?
I was a kid eating with my family at a pizza joint when I was some commotion
over in the corner. People were lining up to stand in front of this TV
thing, I had to get a better look. They didn't really get to me until
Asteroids came out. Then,
Critics complain that there is no roadmap for Web 2.0, unlike
Microsoft Cairo, er, Chicago, no, Mephis. Well, here it is:
http://radar.oreilly.com/archives/2007/03/the_future_of_w_1.html
--
Ted Roche
Ted Roche Associates, LLC
http://www.tedroche.com
Funny you should mention it. We were at a family gathering last night and
my sister in law was saying how people for Arthur Anderson and
her work very
hard. I mentioned that I have been self employed for sixteen years which
can only be considered hard work. She said I didn't have a clue.
I was going through the list and somehow remembering where all of my money
went back in those days:
Space Invaders: the first one I remember spending quite a few quarters on.
Asteroids: Tons of time on, my fingers are getting twitchy just thinking
about it!
Asteroids Deluxe: They just added color
An old laptop with Pacman, asteroids, Repton, Space Invaders, Tetris,
etc?
Dig-Dug - took all my quarters for years...
John
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version
What goes around, comes around! You generally get the sort of friends that
you are.
I've only worked for about 3 months in my life since I left school 46 years
ago if you define work as doing something that you don't *want* to do but
are doing it because you need the money. I was RAF aircrew
Yeah Gil!! I agree with you. I plan to do the same. Heck with other people
who say anything about my 25 plus years of independence as a self employed
consultant.
snip
Yep, me, I did not live up to my potential. Hmmm... When I was 17 I made
a
conscious decision to get to the point in life
The operative points here, I think, are that VFP is very, very good
at
what it does; that .NET is not a suitable replacement; that the
royalty-free standard for this type of language/product is a stake
in
the ground that MS will never remove, and that not only is there a
market
[EMAIL PROTECTED] wrote:
Wow, didn't know there was another MAME fan on the list. Good to know!
Make that at least two. I never thought I'd get to play Mappy or R-Type
again.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
What goes around, comes around! You generally get the sort of
friends that
you are.
That is what I have seen over the past 52 years of life. No guarantee I
won't get my teeth kicked out of my head once in a while, but at least I
wake up with a clear conscience, broken out teeth or not.
Three.
-Original Message-
From: Vince Teachout [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 11:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [NF] What do you buy...
[EMAIL PROTECTED] wrote:
Wow, didn't know there was another MAME fan on the list. Good to know!
Make that at
Bill,
YAG has been quite clear on the fact VFP will never be sold because of the
Intellectual Property
(IP) in VFP that is now in other MS products.
He also mentioned that Microsoft will look at any severe problem in VFP
discovered after VFP 9 SP2
is released and address it on a case-by-case
Pablo,
Just so you are clear, SP2 is pre-beta and will overwrite your VFP 9 runtimes
and merge modules if
you install it. These runtimes are not necessarily ready for prime-time and you
could accidentally
release them to your clients if you are not careful when installing the SP2
patch file.
Rick, thanks for the Heads Up re SP2 and the lite load for Sedna needed as
opposed to the Full Load.
Gil
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Rick Schummer
Sent: Monday, March 26, 2007 1:59 PM
To: [EMAIL PROTECTED]
Subject: RE: Foxpro going
Critics complain that there is no roadmap for Web 2.0, unlike
Microsoft Cairo, er, Chicago, no, Mephis. Well, here it is:
http://radar.oreilly.com/archives/2007/03/the_future_of_w_1.html
2011 is the year of the Linux desktop, headlines will pronounce...
Sounds about right.
--
Derek
Rick,
YAG has been quite clear on the fact VFP will never be sold
because of the Intellectual Property
(IP) in VFP that is now in other MS products.
He also mentioned that Microsoft will look at any severe
problem in VFP discovered after VFP 9 SP2 is released and
address it on a
- RDBMS. When the day comes that RDBMS's are passé, replaced with
something so good that relational doesn't make sense anymore, then I
would be inclined to agree the genre is dead.
VFP doesn't even compare with other RDBMS's in common use today. Yes,
sometimes the speed is comparible, but the
On 3/26/07, Derek Kalweit [EMAIL PROTECTED] wrote:
2011 is the year of the Linux desktop, headlines will pronounce...
Sounds about right.
And Whil Ed and Paul and I will have the 5 years of experience all
the job postings will be asking for.
--
Ted (written from my Linux desktop) Roche
Ted
He also mentioned that Microsoft will look at any severe
problem in VFP discovered after VFP 9 SP2 is released and
address it on a case-by-case basis. While I cannot speak for
MS, I would think something breaking because of a future OS
release might trigger such consideration.
BTW,
2011 is the year of the Linux desktop, headlines will pronounce...
Sounds about right.
And Whil Ed and Paul and I will have the 5 years of experience all
the job postings will be asking for.
Well, I certainly hope that the 4 of you won't be so hard up for a job
that you'd take a desktop
Aaarrrggh!.
Thank you Rick for this clarification, timely and will prevent some
headaches here!
Back to reinstall VFP9.
PabloSr
===
Original Message:
-
From: Rick Schummer [EMAIL PROTECTED]
Date: Mon, 26 Mar 2007
Derek -
Your arguments here all seem to be directed
towards VFP's own internal DBF support rather
than evaluating the entire product as a whole. If
one were to remove .DBF support from VFP, the
product would STILL be superior to every other
RAD tool out there that handles data in my
On 3/23/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Red Hat has responded to claims that it is acting like Microsoft
Speaking of Microsoft,
We had to get an RMA for a defective hard drive to Seagate the other
day, wrote a reader at a small computer shop. I went online to their
web site
Kevin Cully wrote:
We're waiting for the Wii to get back in stock to get one for the kiddles.
Is the PS3 implosion going to go down in history and become the new
betamax? Sony seems to have a knack at putting their foot in their
mouth lately.
I wasn't aware that it was an implosion?
As a former/retired mamedev member, I guess I probably count too.. :)
I loved those old video games, and it's really great to be able to
enjoy them all over again, any time I want.
If you like pinball, check out the sister mame project - pinmame,
which I was head of for many years until
- RDBMS. When the day comes that RDBMS's are passé, replaced with
something so good that relational doesn't make sense
anymore, then I
would be inclined to agree the genre is dead.
VFP doesn't even compare with other RDBMS's in common use
today. Yes, sometimes the speed is
Rick,
Thank you, Before searching, I submitted bug #265335
I see there are at least 4 others already posted, none have a comment from
Microsoft acknowledging they will look at it. (264298, 257771, 248856,
232667) Anybody care to vote on one or more of these?
The first one I mentioned earlier, I
I'm not a game player, but my kids sure are. We've got the Nintendo
GameCube based on the reputation that we could get more kid friendly
games compared to the other platforms. So, I've been watching with some
interest as the next generation machines were coming out. Well, from my
armchair, it
Makes me glad my kids are still too young to want any of that stuff.
When the time comes, I think their 'allowance' will have to cover
those kinds of purchases. It's insane the $ you have to spend to keep
up these days, as my friends tell me.
At 02:59 PM 3/26/2007, you wrote:
I'm not a game
It's the grandparents that front most of the bill. g I'm not sure if
we've ever paid full price for a GameCube game. Rhino (now GameStop) is
our $ saving stop. They buy and sell used games.
When our GameCube stopped playing the mini-DVD disks, after much cursing
to myself, I found a website on
VFP doesn't even compare with other RDBMS's in common use
today. Yes, sometimes the speed is comparible, but the
featureset lags far behind Oracle, MSSQL, and MySQL(free
versions exist of MySQL and MSSQL; possibly Oracle, but I'm
not as familiar).
VFP was never designed to function as
someone at the store to hide one for you. The PS3 sits in stacks.
Evidently it has to do with the high price and the lack of playable
titles for the PS3.
Possibly it's because Nintendo took a gamble and stepped outside the
box with the nunchuck controller? PS3 and even xbox 360 still has the
Tracy,
none have a comment from Microsoft acknowledging they will look at it
Microsoft is looking at every VFP submission on Connect. I know that for a fact
because the team
told us while at the MVP Summit and I believe them. Do not take the status of
any VFP report on
Connect to mean
Alan Bourke wrote:
Thanks Roderick!
MM.NET has extended the infragistic controls http://www.infragistics.com/ to
be databound for use with his framework.
Not sure about the other frameworks they may or may not.
Stephen Russell
DBA / .Net Developer
Memphis TN 38115
901.246-0159
A good
I just had a Maalox Moment(tm). g
I'm working on this project that I'm supposed to demo tomorrow and all
of a sudden I'm getting Member object removed -- cannot complete the
save operation. Nothing is working. If I try to rebuild the project,
it pegs the CPU to 100% and never returns.
I went
I think I've figured out what is going on. I'm using BMPs with the same
name, but different sizes and in different directories.
f:\vfp\application\bmp\32x32\actions\add.bmp
f:\vfp\application\bmp\16x16\actions\add.bmp
Even though the command buttons have the full path in the property, the
73 matches
Mail list logo