RE: [OT] Obama was born in Kenya.

2012-05-18 Thread Adam Buckland
And into international press...

http://blogs.telegraph.co.uk/news/timstanley/100158834/obama-used-to-be-a-kenyan/



-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Michael Madigan
Sent: 17 May 2012 18:57
To: Pro Fox Email List
Subject: [OT] Obama was born in Kenya. 

http://www.breitbart.com/Big-Government/2012/05/17/The-Vetting-Barack-Obama-Literary-Agent-1991-Born-in-Kenya-Raised-Indonesia-Hawaii 

[excessive quoting removed by server]

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/442E79C1A7355C4EA228D320AA59D69CBE8681@SBS2011.eurohill.local
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: [OT] Obama was born in Kenya.

2012-05-18 Thread Michael Madigan
With the revelation that they tried to bribe Reverend Wright with $150,000 to 
stay quiet during the 2008 election,  the 2012 re-election is falling apart.   

Look for Obama to attack Iran in October.   


- Original Message -
From: Adam Buckland adam.buckl...@apac.co.uk
To: ProFox Email List profox@leafe.com
Cc: 
Sent: Friday, May 18, 2012 6:08 AM
Subject: RE: [OT] Obama was born in Kenya. 

And into international press...

http://blogs.telegraph.co.uk/news/timstanley/100158834/obama-used-to-be-a-kenyan/



-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Michael Madigan
Sent: 17 May 2012 18:57
To: Pro Fox Email List
Subject: [OT] Obama was born in Kenya. 

http://www.breitbart.com/Big-Government/2012/05/17/The-Vetting-Barack-Obama-Literary-Agent-1991-Born-in-K[excessive
 quoting removed by server]

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1337336439.61034.yahoomail...@web125604.mail.ne1.yahoo.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Need my Profox Fix.......

2012-05-18 Thread Dave Crozier
Where is everybody, or do we have an outage?

Dave


___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f11e5...@ex-a-fpl.fpl.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Need my Profox Fix.......

2012-05-18 Thread Dave Crozier
Well I can see myself. that's a start!

Dave


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Dave Crozier
Sent: 18 May 2012 16:53
To: ProFox Email List
Subject: Need my Profox Fix...

Where is everybody, or do we have an outage?

Dave


[excessive quoting removed by server]

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f11e5...@ex-a-fpl.fpl.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Need my Profox Fix.......

2012-05-18 Thread Ed Leafe
On May 18, 2012, at 10:53 AM, Dave Crozier wrote:

 Where is everybody, or do we have an outage?

They're all busy buying Facebook stock?


-- Ed Leafe




___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/43507a65-5b75-47e8-b968-ed778cb7f...@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Need my Profox Fix.......

2012-05-18 Thread Kurt Wendt
Really?

But, I TOO was surprised to see ALL of Thur go by - and NO Messages at
all. However, I guess, considering your reply Ed - that there was no
Actual Outtage - just an Extremely quiet day in the Land of ProFox.

-K-

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Ed Leafe
Sent: Friday, May 18, 2012 12:03 PM

On May 18, 2012, at 10:53 AM, Dave Crozier wrote:

 Where is everybody, or do we have an outage?
They're all busy buying Facebook stock?

-- Ed Leafe

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Need my Profox Fix.......

2012-05-18 Thread Kurt Wendt
I just got the news via the ZDNet newsletter about FB stock now up for
sale. So - I guess you were only half joking! So - U run and go buy
some?

I know Pete would NEVER Buy the stuff - he'd rather run in the other
direction as FAST as Possible!!!

:-)
-K-

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Ed Leafe
Sent: Friday, May 18, 2012 12:03 PM

On May 18, 2012, at 10:53 AM, Dave Crozier wrote:

 Where is everybody, or do we have an outage?
They're all busy buying Facebook stock?

-- Ed Leafe

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Need my Profox Fix.......

2012-05-18 Thread Ken Kixmoeller (ProFox)
Another blessed Pete-free day. Praises to the Flying Spaghetti Monster!!!

Ken

On Fri, May 18, 2012 at 11:03 AM, Kurt Wendt kurtwe...@waitex.com wrote:
 Really?

 But, I TOO was surprised to see ALL of Thur go by - and NO Messages at
 all. However, I guess, considering your reply Ed - that there was no
 Actual Outtage - just an Extremely quiet day in the Land of ProFox.

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAFyV=lnxee9ngaoms+cyg5km6rvcc2bn7h5wpxf+8sxs7yj...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Need my Profox Fix.......

2012-05-18 Thread MB Software Solutions, LLC
On 5/18/2012 12:29 PM, Paul McNett wrote:
 On 5/18/12 8:53 AM, Dave Crozier wrote:
 Where is everybody, or do we have an outage?

 It turns out Facebook is run on Visual Foxpro DBC's and they need help with 
 data
 wrangling. We are all in Menlo Park.

 Paul


Bwahahahaahahaha!


-- 
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4fb67aaf.5040...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Need my Profox Fix.......

2012-05-18 Thread Ed Leafe
On May 18, 2012, at 11:03 AM, Kurt Wendt wrote:

 But, I TOO was surprised to see ALL of Thur go by - and NO Messages at
 all. However, I guess, considering your reply Ed - that there was no
 Actual Outtage - just an Extremely quiet day in the Land of ProFox.

I saw no signs of any issues, but absence of evidence is not proof...

Did anyone post anything yesterday that never appeared?


-- Ed Leafe




___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/dee81f82-9424-42c0-9111-2ea892b58...@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Need my Profox Fix.......

2012-05-18 Thread Kurt Wendt
Nope - not me. Seems the Only Hotspot on ProFox yesterday was the Less
Pro stuff of crazy OT Discussions about Jesus  Obama (although - praise
the Lord - NOT in the Same message thread). I just changed my
subscriptions so that I can gander at the Crazy OT discussions, and it
was immediately Obvious that I was getting my money's worth...

...funny thing is - I ended up getting only OT stuff - and NOT any of
the regular stuff - and for a while there - I was worried that I had
somehow messed up my subscription - and that was WHY I was only getting
OT stuff. But, of course - that's just not possible!

-K-

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Ed Leafe
Sent: Friday, May 18, 2012 1:09 PM

On May 18, 2012, at 11:03 AM, Kurt Wendt wrote:

 But, I TOO was surprised to see ALL of Thur go by - and NO Messages at
 all. However, I guess, considering your reply Ed - that there was no
 Actual Outtage - just an Extremely quiet day in the Land of ProFox.

I saw no signs of any issues, but absence of evidence is not
proof...
Did anyone post anything yesterday that never appeared?

-- Ed Leafe

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


[OT] Gorehole schmoozing with new chick on tax dime

2012-05-18 Thread Pete Theisen
Hi Everybody,

http://www.humanevents.com/article.php?id=51592
-- 
Regards,

Pete

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4fb6927f.1090...@verizon.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


[OT] 1st Solar CEO took his $ out while taking good

2012-05-18 Thread Pete Theisen
Hi Everybody,

http://www.humanevents.com/article.php?id=51551
-- 
Regards,

Pete

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4fb696fc.1090...@verizon.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: [OT] Did Jesus reveal the name of the Anti-Christ?

2012-05-18 Thread jerry foote
Interesting.
Jerry


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Pete Theisen
Sent: Thursday, May 17, 2012 10:35 PM
To: ProFox Email List
Subject: [OT] Did Jesus reveal the name of the Anti-Christ?

Hi Everybody,

Not that anyone would be surprised:

http://www.youtube.com/watch?v=PlT9SYR6jq4feature=related
-- 
Regards,

Pete
http://pete-theisen.com/
http://elect-pete-theisen.com/

[excessive quoting removed by server]

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/E5697D8FE0F7479BAD90C2BE59EE1826@jerryfootePC
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Need my Profox Fix.......

2012-05-18 Thread Dan Covill
I wondered about that myself.  I just changed from ProFox to ProFoxTech 
(guess why), and it occurred to me that maybe Pete had sucked up all the 
bandwith in [OT] so that no regular posts got through.  g

Dan


On 05/18/12 10:17, Kurt Wendt wrote:
 Nope - not me. Seems the Only Hotspot on ProFox yesterday was the Less
 Pro stuff of crazy OT Discussions about Jesus  Obama (although - praise
 the Lord - NOT in the Same message thread). I just changed my
 subscriptions so that I can gander at the Crazy OT discussions, and it
 was immediately Obvious that I was getting my money's worth...

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4fb6a6f0.2060...@san.rr.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Need my Profox Fix.......

2012-05-18 Thread Michael Madigan
They're all shorting Facebook stock


- Original Message -
From: Ed Leafe e...@leafe.com
To: ProFox Email List profox@leafe.com
Cc: 
Sent: Friday, May 18, 2012 12:02 PM
Subject: Re: Need my Profox Fix...

On May 18, 2012, at 10:53 AM, Dave Crozier wrote:

 Where is everybody, or do we have an outage?

    They're all busy buying Facebook stock?


-- Ed Leafe




___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/43507a65-5b75-47e8-b968-ed778cb7f...@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1337371089.96004.yahoomail...@web125604.mail.ne1.yahoo.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


[OT] Leaf Blower Photography

2012-05-18 Thread Michael Madigan
http://www.theblaze.com/stories/leaf-blower-photographer-incredible-pictures-youll-want-to-see/ 


___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1337373773.23130.yahoomail...@web125606.mail.ne1.yahoo.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Error 2066 corruption followup

2012-05-18 Thread Fred Taylor
To your # 3, DTOS always return 8 chars (MMDD) no matter what the SET
CENTURY setting is.  Not a likely culprit in different length index
expressions.  More likely #1 or #4 was the cause, though #4 should have
alerted you to an issue, not created one.

Fred


On Fri, May 18, 2012 at 2:07 PM, Michael Madigan mmadi10...@yahoo.comwrote:

 I'm writing this in case someone needs to research this later in the
 archives


 I was getting a lot of 2066 errors which is index corruption when we took
 a legacy FPW 2.5 program and converted it to a VFP 9.0 program.  We have
 the old and the new system sharing the same databases.


 The possible causes and solutions so far, as the number of corruptions
 have gone down dramatically.


 1.  Win 7 machines running SMB2 - I shut off SMB2 on all windows 7
 machines.

 2.  Browse noedit screens browsing the same database open in the main form
 - I replaced the browse database with SQL Selects into a cursor instead.

 3.  Possible index corruption caused by DTOS(DATE)  being part of index
 field.   Troubleshooting a different issue, it turns out perhaps CENTURY
 was being toggled on and off somewhere in the program.   This may cause
 differences in the length of the index statement, which may cause index
 corruption.

 4.  Making sure Tablevalidate is set to 0 everywhere.   It was set to the
 default originally.


 So far no index corruption at all for the last 3 days and other errors
 have dropped too.  I'm keeping my fingers crossed.

[excessive quoting removed by server]

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAJCBkspHcCgSONSa2vGmQAJc=3zsohrvybasaslmlzgxqm8...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Error 2066 corruption followup

2012-05-18 Thread Michael Madigan
I'm still not sure if it's fixed, we'll see.   


- Original Message -
From: Fred Taylor fbtay...@gmail.com
To: ProFox Email List profox@leafe.com
Cc: 
Sent: Friday, May 18, 2012 5:22 PM
Subject: Re: Error 2066 corruption followup

To your # 3, DTOS always return 8 chars (MMDD) no matter what the SET
CENTURY setting is.  Not a likely culprit in different length index
expressions.  More likely #1 or #4 was the cause, though #4 should have
alerted you to an issue, not created one.

Fred


On Fri, May 18, 2012 at 2:07 PM, Michael Madigan mmadi10...@yahoo.comwrote:

 I'm writing this in case someone needs to research this later in the
 archives


 I was getting a lot of 2066 errors which is index corruption when we took
 a legacy FPW 2.5 program and converted it to a VFP 9.0 program.  We have
 the old and the new system sharing the same databases.


 The possible causes and solutions so far, as the number of corruptions
 have gone down dramatically.


 1.  Win 7 machines running SMB2 - I shut off SMB2 on all windows 7
 machines.

 2.  Browse noedit screens browsing the same database open in the main form
 - I replaced the browse database with SQL Selects into a cursor instead.

 3.  Possible index corruption caused by DTOS(DATE)  being part of index
 field.   Troubleshooting a different issue, it turns out perhaps CENTURY
 was being toggled on and off somewhere in the program.   This may cause
 differences in the length of the index statement, which may cause index
 corruption.

 4.  Making sure Tablevalidate is set to 0 everywhere.   It was set to the
 default originally.


 So far no index corruption at all for the last 3 days and other errors
 have dropped too.  I'm ke[excessive quoting removed by server]

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1337386946.67330.yahoomail...@web125606.mail.ne1.yahoo.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: select question

2012-05-18 Thread Ken Dibble

No, the problem is that the syntax is invalid.  From the VFP Help:
SELECT [ALL][DISTINCT][TOP exp] field list ..
I.e., the top 5 has to come before the field list.

Hm.. Well you can do:

SELECT myfield1, myfield2 DISTINCT FROM...

without a problem. So it's something peculiar to TOP.

Ken Dibble
www.stic-cil.org


___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5.2.1.1.1.20120518202832.01f5e...@pop-server.stny.rr.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: select question

2012-05-18 Thread MB Software Solutions, LLC
On 5/18/2012 8:29 PM, Ken Dibble wrote:

 No, the problem is that the syntax is invalid.  From the VFP Help:
 SELECT [ALL][DISTINCT][TOPexp]field list  ..
 I.e., the top 5 has to come before the field list.

 Hm.. Well you can do:

 SELECT myfield1, myfield2 DISTINCT FROM...

 without a problem. So it's something peculiar to TOP.



Yes but you really should put DISTINCT first.  I don't think other 
RDBMSes will let you get away with that like the Fox.


-- 
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4fb6f0df.6010...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: select question

2012-05-18 Thread Dan Covill
On 05/18/12 17:29, Ken Dibble wrote:

 No, the problem is that the syntax is invalid.  From the VFP Help:
 SELECT [ALL][DISTINCT][TOPexp]field list  ..
 I.e., the top 5 has to come before the field list.

 Hm.. Well you can do:

 SELECT myfield1, myfield2 DISTINCT FROM...

 without a problem. So it's something peculiar to TOP.

Not really. There is a bug in the syntax checking for DISTINCT. And the 
error message is rather unhelpful.

Dan Covill
San Diego

___
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
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4fb72732.5080...@san.rr.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.