date:20100609

AT&T's fuggup from what I can see.
-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) 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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1276152858.4791.1379395...@webmail.messagingengine.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.

LA Fox 20th Anniversary Celebration!

2010-06-09 Thread Bill Anderson

On Tuesday June 15 LA Fox celebrates 20 years of existence!

Come on by to celebrate our 20 years of existence! We'll have food, fun, and
good times as we recap a rich history of our user group. Add your memories
or simply help us celebrate -- we look forward to your participation!

Location:

Bill Rosendahl's Westchester office
7166 W. Manchester Ave.
Westchester, CA 90045

Please see http://www.lafox.org for further details or contact me via email.

Bill Anderson


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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/aanlktilinjdb5xlysxgjgoluhuflspkcpgkjggxoo...@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.

DAFUG - June 2010

2010-06-09 Thread Rick Schummer

Thursday, June 10, 2010
Detroit Area Fox User Group (DAFUG) presents:
"Introduction to Regular Expressions", by Dave Hanna
 
This presentation provides an introduction to a powerful tool called
"regular expressions". Regular expressions are available in many types of
applications (e.g., editors, word processors and system tools), but their
power is most fully exposed when used via a programming language.
 
In this session Dave will:
 
- Introduce the concept of regular expressions.
- Expand upon the concept with some basic examples.
- Explore a variety of regular expression pattern matching techniques.
- Demonstrate a real-world example that is used to clean up names in a
customer table.

Holiday Inn Express - Southfield
25100 Northwestern HWY
Southfield, MI 48075

Small Meeting Room on 1st Floor

Hope to see you there.
More DAFUG details at http://www.dafug.org

Agenda:
6:00 - 8:00 Presentation
8:00 - ? Food
Meetings are typically followed by food, FoxPro, and developer discussion at
a local restaurant.

Future Planned DAFUG Meetings and Speakers:
July 2010 - No Meeting (maybe a baseball game??)
August 12, 2010 - Southwest Fox Rehearsal
September 16, 2010 - Southwest Fox Rehearsal
October 7, 2010 - Southwest Fox Rehearsal
November 18, 2010 - TBD
December 9, 2010 - TBD

DAFUG meets on the second or third Thursday of the month (except for July).

Admission to DAFUG meetings will be granted free to anyone for 1 (one)
meeting. After that you must either join the group (at the low cost of $30 a
year, $15 for a half year) or you will be asked to pay $5 per meeting you
attend. The $5 will grant you admission but no other rights or privileges of
membership.

Rick
White Light Computing, Inc.

www.whitelightcomputing.com
www.swfox.net
www.rickschummer.com
586.254.2530 - office




___
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/013501cb084b$e88f35a0$b9ada0...@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: [spam] RE: VFP OLEDRAGDROP not working in dev mode

If it means anything, I disabled the UAC in W7, a very annoying feature. 
Maybe that is why it works in my computer.

Just a thought

Rafael


El 09/06/2010 13:39, Dave Crozier escribió:
> Thanks Rafael,
> Don't know if that helps or not. I can't get it to work...DOH!!!
>
> Back to the drawing board!
>
>
> Dave C
>
> -Original Message-
> From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
> Of Rafael Copquin
> Sent: 09 June 2010 17:33
> To: ProFox Email List
> Subject: Re: VFP OLEDRAGDROP not working in dev mode
>
> I use Windows 7 home premium. I ran your prg in development mode and it
> worked very well.
>
> I dropped both text files and bitmaps.
>
> Rafael Copquin
>
>
>
> El 09/06/2010 11:05, Dave Crozier escribió:
>
>> Guys,
>> I have just spent over an hour trying to sort out a weird problem relating
>> to OLEDRAGDROP with VFP and I am getting nowhere. The reason seems to be
>> that in development mode (VFP IDE) the OLEDRAGDROP doesn't work when
>> dragging from outside the VFP application. In the compiled application
>> everything seems to be OK.
>>
>> Could someone verify that I am right in saying that using OLEDRAGDROP in
>> windows 7 with VFP doesn't work in VFP Development mode even though it
>>  
> does
>
>> in runtime mode.
>>
>> Some example coding just to quickly use in a test is at:
>>
>> http://www.news2news.com/vfp/?example=323&function=953
>>
>> I haven't access to an XP development box but would be really grateful of
>> someone could also confirm that the same program DOES works on XP in
>> development mode with VFP SP1 or SP2. When I developed all the DRAGDROP it
>> was on XP and I can't remember having a problem during development.
>>
>> Either that, or I'm going nuts here and my Windows 7 installation or VFP
>>  
> is
>
>> hosed in some way. OR, there is s setting somewhere in the IDE that I
>> haven't found as of yet.
>>
>> Thanks
>> Dave C
>>
>>
>>
>>  
[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/4c10287b.8090...@ciudad.com.ar
** 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: [spam] Re: ADO and VFP

Nope

El 09/06/2010 13:51, Stephen Russell escribió:
> On Wed, Jun 9, 2010 at 11:41 AM, Rafael Copquin  
> wrote:
>
>> Would clients off campus need 24x7 access or every once in a while?
>>
>> Only during store hours, 9:00 AM to 7:00 PM Mondays thru Fridays
>>  
> ---
>
> Does IT have a VPN already setup?
>
>

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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/4c1027f9.1080...@ciudad.com.ar
** 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.

[NF] Apples worst security breach to date

2010-06-09 Thread Michael Madigan

http://gawker.com/5559346/apples-worst-security-breach-114000-ipad-owners-exposed

___
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/693934.4072...@web31404.mail.mud.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: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Ed Leafe

On Jun 9, 2010, at 6:49 PM, Dave Crozier wrote:

> I have two accounts set up on Profox, the work (Flexipol) one and the home
> (Replacement-Software). Both are on the full list.

That shouldn't matter as far as whether a message gets set to the 
tech-only list. Besides, I just checked the server logs and all 4 of your 
messages were correctly forward to ProFoxTech.

-- 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/daf18930-86ac-4f49-bbff-ddb63c1f4...@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: VFP OLEDRAGDROP not working in dev mode

I have two accounts set up on Profox, the work (Flexipol) one and the home
(Replacement-Software). Both are on the full list.

Dave

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Tracy Pearson
Sent: 09 June 2010 20:12
To: profox@leafe.com
Subject: RE: VFP OLEDRAGDROP not working in dev mode

Ed Leafe wrote on 2010-06-09: 
> On Jun 9, 2010, at 1:47 PM, Tracy Pearson wrote:
> 
>> Looks likes his emails are going to the full list, not the Tech ONLY
> list.
> 
>   They are not two separate lists. All mail goes through ProFox. If a
> message is not OT, it is then forwarded to the ProFoxTech subscribers.
> 
> 
> -- Ed Leafe
> 

Ed,

I know that you have pointed that out before, the original from email
address is not on the list then perhaps. So those are caught in an approve
place or something. The last email he sent was from a different address and
it came through to the tech list.

Tracy Pearson
PowerChurch Software

[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/001301cb0826$0e40d360$2ac27a...@co.uk
** 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.

[NF] Apples worst security breach to date

2010-06-09 Thread Michael Madigan

http://gawker.com/5559346/apples-worst-security-breach-114000-ipad-owners-exposed

___
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/817357.9984...@web31403.mail.mud.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: [ADMIN]Re: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Grigore Dolghin

I didn't get those mails either.

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On 
Behalf Of Andrew Stirling
Sent: Thursday, June 10, 2010 12:36 AM
To: profoxt...@leafe.com
Subject: [ADMIN]Re: VFP OLEDRAGDROP not working in dev mode

Ed
Dave's first 2 emails were from Flexipol.co.uk, which I, and others, did not 
get, but Rafael received them.
His last 2 were from replacement-software.co.uk which I, & others, did get.

Thanks

Andrew Stirling
01250 874580
http://www.calcpay.co.uk
HMRC Accredited UK payroll program

On 09/06/2010 20:11, Tracy Pearson wrote:
> Ed Leafe wrote on 2010-06-09:
>> On Jun 9, 2010, at 1:47 PM, Tracy Pearson wrote:
>>
>>> Looks likes his emails are going to the full list, not the Tech ONLY
>> list.
>>
>>  They are not two separate lists. All mail goes through ProFox. If a 
>> message is not OT, it is then forwarded to the ProFoxTech subscribers.
>>
>>
>> -- Ed Leafe
>>
>
> Ed,
>
> I know that you have pointed that out before, the original from email 
> address is not on the list then perhaps. So those are caught in an 
> approve place or something. The last email he sent was from a 
> different address and it came through to the tech list.
>
> Tracy Pearson
> PowerChurch Software
>
>
>
>
[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/01cb0820$c4ead0d0$4ec072...@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: [ADMIN]Re: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Allen

I never got them and I checked spam as well
Al

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Ed Leafe
Sent: 09 June 2010 23:38
To: profoxt...@leafe.com
Subject: Re: [ADMIN]Re: VFP OLEDRAGDROP not working in dev mode

On Jun 9, 2010, at 5:35 PM, Andrew Stirling wrote:

> Dave's first 2 emails were from Flexipol.co.uk, which I, and others, did 
> not get, but Rafael received them.
> His last 2 were from replacement-software.co.uk which I, & others, did
get.

Odd; all 4 came through the server just fine, and are in the
archives.

-- 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/004b01cb081e$6a158f30$3e40ad...@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: [ADMIN]Re: VFP OLEDRAGDROP not working in dev mode

Ed Leafe wrote on 2010-06-09: 
> On Jun 9, 2010, at 5:35 PM, Andrew Stirling wrote:
> 
>> Dave's first 2 emails were from Flexipol.co.uk, which I, and others,
>> did not get, but Rafael received them.
>> His last 2 were from replacement-software.co.uk which I, & others,
> did get.
> 
>   Odd; all 4 came through the server just fine, and are in the
archives.
> 
> 
> -- Ed Leafe

Ed,

The First 2 did not make it to the Tech list. I do not have them in my tech
list inbox, but do have them in my inbox that is the full list. Somehow it
dropped from being sent to the tech list. My filter is on the from address
to sort them.

Tracy Pearson
PowerChurch Software

___
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/000801cb081d$b3b18320$1b1489...@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: Creating a list of stress tests for unit tests involving files

On Wed, Jun 9, 2010 at 4:35 PM, Malcolm Greene  wrote:
> I'm working on a set of unit tests designed to stress test some
> file handling capabilities of our application.
>
> Listed below are some file names designed to cause failures when
> used with file open, copy, delete, and rename activites.
>
> Can anyone think of additional scenarios (path names
> or unusual file access) that we could test against? My tests will
> initially be for the Windows platform (2000-Windows 7), but I
> would welcome Linux and/or Mac specific failure conditions as
> well.
>
> UNITTEST_DRIVE_NOT_READY = 'a:'
> UNITTEST_DRIVE_READ_ONLY = 'g:'  # CD drive with CD
> UNITTEST_UNC_NOT_EXIST   = '\\unc_not_exist'
> UNITTEST_FILE_BAD_CHARS  = 'path_bad_chars_*<>|'
> UNITTEST_FILE_NO_WRITE   = 'c:\program files'
> UNITTEST_FILE_NOT_EXIST  = '\path_not_exist'
> UNITTEST_FILE_LOCKED     = 'file_locked.tmp' # will be open
> unittest_file_locked     = fopen( UNITTEST_FILE_LOCKED, 1 )
> UNITTEST_UNICODE_PATH    = 'unicode_chars_here'
>
--

I just had to look this up earlier today so back at you.

-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
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/aanlktiktmck0noypcp6ufpggkvvdfibn1c9bfbken...@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: Creating a list of stress tests for unit tests involving files

Malcolm Greene wrote on 2010-06-09: 
> I'm working on a set of unit tests designed to stress test some file
> handling capabilities of our application.
> 
> Listed below are some file names designed to cause failures when used
> with file open, copy, delete, and rename activites.
> 
> Can anyone think of additional scenarios (path names or unusual file
> access) that we could test against? My tests will initially be for the
> Windows platform (2000-Windows 7), but I would welcome Linux and/or
> Mac specific failure conditions as well.
> 
> UNITTEST_DRIVE_NOT_READY = 'a:'
> UNITTEST_DRIVE_READ_ONLY = 'g:'  # CD drive with CD
> UNITTEST_UNC_NOT_EXIST   = '\\unc_not_exist'
> UNITTEST_FILE_BAD_CHARS  = 'path_bad_chars_*<>|'
> UNITTEST_FILE_NO_WRITE   = 'c:\program files'
> UNITTEST_FILE_NOT_EXIST  = '\path_not_exist'
> UNITTEST_FILE_LOCKED = 'file_locked.tmp' # will be open
> unittest_file_locked = fopen( UNITTEST_FILE_LOCKED, 1 )
> UNITTEST_UNICODE_PATH= 'unicode_chars_here'
> 
> Thank you,
> Malcolm
> 

Malcolm,

When the parent directory does not have read access.

\\network\noread\readwrite

I had a customer setup the users "Documents" folder to the network using
this scenario. The readwrite is the user directory, the noread folder did
not have rights to view the names of any files/folders with in it.

Tracy Pearson
PowerChurch Software




___
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/000701cb081d$0e930120$2bb903...@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: [ADMIN]Re: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Ed Leafe

On Jun 9, 2010, at 5:35 PM, Andrew Stirling wrote:

> Dave's first 2 emails were from Flexipol.co.uk, which I, and others, did 
> not get, but Rafael received them.
> His last 2 were from replacement-software.co.uk which I, & others, did get.

Odd; all 4 came through the server just fine, and are in the archives.

-- 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/d7661b8a-bb77-4606-ae7f-29faec36b...@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.

Creating a list of stress tests for unit tests involving files

2010-06-09 Thread Malcolm Greene

I'm working on a set of unit tests designed to stress test some
file handling capabilities of our application.

Listed below are some file names designed to cause failures when
used with file open, copy, delete, and rename activites.

Can anyone think of additional scenarios (path names
or unusual file access) that we could test against? My tests will
initially be for the Windows platform (2000-Windows 7), but I
would welcome Linux and/or Mac specific failure conditions as
well.

UNITTEST_DRIVE_NOT_READY = 'a:'
UNITTEST_DRIVE_READ_ONLY = 'g:'  # CD drive with CD
UNITTEST_UNC_NOT_EXIST   = '\\unc_not_exist'
UNITTEST_FILE_BAD_CHARS  = 'path_bad_chars_*<>|'
UNITTEST_FILE_NO_WRITE   = 'c:\program files'
UNITTEST_FILE_NOT_EXIST  = '\path_not_exist'
UNITTEST_FILE_LOCKED = 'file_locked.tmp' # will be open
unittest_file_locked = fopen( UNITTEST_FILE_LOCKED, 1 )
UNITTEST_UNICODE_PATH= 'unicode_chars_here'

Thank you,
Malcolm

___
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/1276119335.24548.1379336...@webmail.messagingengine.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.

[ADMIN]Re: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Andrew Stirling

Ed
Dave's first 2 emails were from Flexipol.co.uk, which I, and others, did 
not get, but Rafael received them.
His last 2 were from replacement-software.co.uk which I, & others, did get.

Thanks

Andrew Stirling
01250 874580
http://www.calcpay.co.uk
HMRC Accredited UK payroll program

On 09/06/2010 20:11, Tracy Pearson wrote:
> Ed Leafe wrote on 2010-06-09:
>> On Jun 9, 2010, at 1:47 PM, Tracy Pearson wrote:
>>
>>> Looks likes his emails are going to the full list, not the Tech ONLY
>> list.
>>
>>  They are not two separate lists. All mail goes through ProFox. If a
>> message is not OT, it is then forwarded to the ProFoxTech subscribers.
>>
>>
>> -- Ed Leafe
>>
>
> Ed,
>
> I know that you have pointed that out before, the original from email
> address is not on the list then perhaps. So those are caught in an approve
> place or something. The last email he sent was from a different address and
> it came through to the tech list.
>
> Tracy Pearson
> PowerChurch Software
>
>
>
>
[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/4c100922.6050...@calcpay.co.uk
** 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.

[NF] What would you recommend for a 15-user Web Filtering solution?

2010-06-09 Thread Michael Madigan

What would you recommend for a 15-user Web Filtering solution?  We're trying to 
prevent employees from surfing dangerous sites to prevent malware from being 
picked up.

___
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/699206.38698...@web31403.mail.mud.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: Word Automation in Windows 7 as Restricted User

On Wed, Jun 9, 2010 at 2:53 PM, Tracy Pearson  wrote:

> Running as a Domain Administrator removes UAC on Vista, I believe it is the
> same on Windows 7. Even Internet Explorer will run in the administrative
> privilege with this user.
>
> You found the Word.Application in the HKCR/Classes, it has a CLSID entry. Go
> to this in HKCR/Classes/CLSID. I believe this is where you need to add that
> Elevation key.
>
> HKCR = HKEY_CLASSES_ROOT
-

Do you also remove the guard on your circular saw because it gets in the way?

Is your Indian name Runs with Scissors?

-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
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/aanlktimzeghb8-l7c3kroz-fe5hwkdzsogvvtmyef...@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: Word Automation in Windows 7 as Restricted User

Ken Dibble wrote on 2010-06-09: 
> This is a continuation of my "Word Automation: OLE exception error
> 5981 in Windows 7" thread.

> 
> However, even with the "User Account Control: Behavior of the
> elevation prompt for standard users" item set to "Prompt for
> credentials", when the Word 97 automation code is encountered, there is no
prompt.
> Instead, the object reference to the "Word.Application" object is
> successfully created, and then I get "could not open macro storage" on
> .documents.Add. What is notable about this was, before I disabled
> prompts and confirmations for administrators, I would get a different
> error, "operation requires elevation",  on the
> CREATEOBJECT("Word.Application") call when running in my Domain
> Administrator account.
> 
> Some digging in Microsoft publications on UAC brought up an article
> that suggested that if I could find a Class folder for the Word
> automation object in the registry, I could give it a new key called
> "Elevation" with a DWORD variable called "Enabled" set to 1. However,
> I couldn't find any appropriate Class in the registry for Word.
> 
> So. Does anyone have any suggestions on how I can force Windows 7 to
> let a restricted user a VFP 9 SP 1 .exe that contains Word 97
> automation code?
> 
> Thanks very much.
> 
> Ken Dibble
> www.stic-cil.org
> 
> 

Ken,

Running as a Domain Administrator removes UAC on Vista, I believe it is the
same on Windows 7. Even Internet Explorer will run in the administrative
privilege with this user.

You found the Word.Application in the HKCR/Classes, it has a CLSID entry. Go
to this in HKCR/Classes/CLSID. I believe this is where you need to add that
Elevation key.

HKCR = HKEY_CLASSES_ROOT

Tracy Pearson
PowerChurch Software




___
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/000601cb080d$6da81480$48f83d...@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.

Word Automation in Windows 7 as Restricted User

2010-06-09 Thread Ken Dibble

This is a continuation of my "Word Automation: OLE exception error 5981 in
Windows 7" thread.

Thanks to some great help from many of you, so far I have accomplished the
following:

1. I established that my Word 97 automation system works fine in Windows XP
once I make sure a required .bmp file is present in the path.

2. With most of the Windows 7 UAC security policies disabled or set to the
loosest possible values, my Word 97 automation code now runs correctly, as
originally written, in Windows 7, when using a Domain Administrator
account. The program runs correctly in the IDE or as a compiled .exe file.

3. After learning that after setting the Word 97 "mode" back to Win 98, I
could not longer do things like "Save As...", I reset it to run in Windows
7 mode. That doesn't affect my automation code at all in my Domain
Administrator account.

4. After changing the UAC policies I also find that I don't need to have
Word set to "run as administrator" in order for the automation to work in
my Domain Administrator account.

5. I do not need to run my application "as administrator" either in order
for it to work when using my Domain Administrator account.

Now the problem is to get this program to work for a restricted user on
Windows 7.

A Windows 7 restricted user cannot open the Visual Basic editor in Word 97
no matter what combination of "compatibility modes" are in effect, not even
if Word is set to "run as administrator".

If I run my .exe in the restricted Domain User account in Windows 7, I get
the "Could not open macro storage" error on .documents.Add, again, no
matter what combination of "compatibility modes" are in effect, and
regardless of whether the .exe is run "as administrator".

Making the user a "Power User" has no effect on this issue.

There is no local security policy setting that lets me say "restricted
users can have programs 'elevated' automatically without prompting", the
way I can for adminstrators.

However, even with the "User Account Control: Behavior of the elevation
prompt for standard users" item set to "Prompt for credentials", when the
Word 97 automation code is encountered, there is no prompt. Instead, the
object reference to the "Word.Application" object is successfully created,
and then I get "could not open macro storage" on .documents.Add. What is
notable about this was, before I disabled prompts and confirmations for
administrators, I would get a different error, "operation requires
elevation", on the CREATEOBJECT("Word.Application") call when running in
my Domain Administrator account.

Some digging in Microsoft publications on UAC brought up an article that
suggested that if I could find a Class folder for the Word automation
object in the registry, I could give it a new key called "Elevation" with a
DWORD variable called "Enabled" set to 1. However, I couldn't find any
appropriate Class in the registry for Word.

So. Does anyone have any suggestions on how I can force Windows 7 to let a
restricted user a VFP 9 SP 1 .exe that contains Word 97 automation code?

Thanks very much.

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.20100609123340.01bf3...@pop3.frontiernet.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: VFP OLEDRAGDROP not working in dev mode

Ed Leafe wrote on 2010-06-09: 
> On Jun 9, 2010, at 1:47 PM, Tracy Pearson wrote:
> 
>> Looks likes his emails are going to the full list, not the Tech ONLY
> list.
> 
>   They are not two separate lists. All mail goes through ProFox. If a
> message is not OT, it is then forwarded to the ProFoxTech subscribers.
> 
> 
> -- Ed Leafe
> 

Ed,

I know that you have pointed that out before, the original from email
address is not on the list then perhaps. So those are caught in an approve
place or something. The last email he sent was from a different address and
it came through to the tech list.

Tracy Pearson
PowerChurch Software

___
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/000201cb0807$a01c17a0$e05446...@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] Street paintings by Mueller



-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
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/aanlktikqoigbkk9iaixumqqlyos9ppvfbcnqhbt3n...@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: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Ed Leafe

On Jun 9, 2010, at 1:47 PM, Tracy Pearson wrote:

> Looks likes his emails are going to the full list, not the Tech ONLY list.

They are not two separate lists. All mail goes through ProFox. If a 
message is not OT, it is then forwarded to the ProFoxTech subscribers.


-- 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/7a614ac4-83e8-4372-b9e3-395799e58...@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: VFP OLEDRAGDROP not working in dev mode

Tracy,
That was it. I had set up my shortcut to run VFP with admin privileges. As
soon as I removed them and ran as a normal user it burst into life. 

Thanks
Dave C


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Tracy Pearson
Sent: 09 June 2010 19:13
To: 'ProFox Email List'
Subject: RE: VFP OLEDRAGDROP not working in dev mode

Dave Crozier wrote on 2010-06-09: 
> Guys,
> I have just spent over an hour trying to sort out a weird problem
> relating to OLEDRAGDROP with VFP and I am getting nowhere. The reason
> seems to be that in development mode (VFP IDE) the OLEDRAGDROP doesn't
> work when dragging from outside the VFP application. In the compiled
> application everything seems to be OK.
> 
> Could someone verify that I am right in saying that using OLEDRAGDROP
> in windows 7 with VFP doesn't work in VFP Development mode even though
> it does in runtime mode.
> 
> Some example coding just to quickly use in a test is at:
> 
> http://www.news2news.com/vfp/?example=323&function=953
> 
> I haven't access to an XP development box but would be really grateful
> of someone could also confirm that the same program DOES works on XP
> in development mode with VFP SP1 or SP2. When I developed all the
> DRAGDROP it was on XP and I can't remember having a problem during
development.
> 
> Either that, or I'm going nuts here and my Windows 7 installation or
> VFP is hosed in some way. OR, there is s setting somewhere in the IDE
> that I haven't found as of yet.
> 
> Thanks
> Dave C
> 

Dave,

If you are running VFP in administrator privileges, and dragging for
Explorer, which doesn't, it could be a privilege problem.

Tracy Pearson
PowerChurch Software




[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/01cb0801$c58a0f20$509e2d...@co.uk
** 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: VFP OLEDRAGDROP not working in dev mode

Dave Crozier wrote on 2010-06-09: 
> Guys,
> I have just spent over an hour trying to sort out a weird problem
> relating to OLEDRAGDROP with VFP and I am getting nowhere. The reason
> seems to be that in development mode (VFP IDE) the OLEDRAGDROP doesn't
> work when dragging from outside the VFP application. In the compiled
> application everything seems to be OK.
> 
> Could someone verify that I am right in saying that using OLEDRAGDROP
> in windows 7 with VFP doesn't work in VFP Development mode even though
> it does in runtime mode.
> 
> Some example coding just to quickly use in a test is at:
> 
> http://www.news2news.com/vfp/?example=323&function=953
> 
> I haven't access to an XP development box but would be really grateful
> of someone could also confirm that the same program DOES works on XP
> in development mode with VFP SP1 or SP2. When I developed all the
> DRAGDROP it was on XP and I can't remember having a problem during
development.
> 
> Either that, or I'm going nuts here and my Windows 7 installation or
> VFP is hosed in some way. OR, there is s setting somewhere in the IDE
> that I haven't found as of yet.
> 
> Thanks
> Dave C
> 

Dave,

If you are running VFP in administrator privileges, and dragging for
Explorer, which doesn't, it could be a privilege problem.

Tracy Pearson
PowerChurch Software




___
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/000101cb07ff$5dd50e90$197f2b...@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: VFP OLEDRAGDROP not working in dev mode

Damn it, I've tried on my laptop at home and STIL it won't work with a clean
installation of Win7  and clean VFP, but it works on my VMware XP Virtual
disk... this is weird!

Dave C

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Richard Kaye
Sent: 09 June 2010 17:57
To: profox@leafe.com
Subject: RE: VFP OLEDRAGDROP not working in dev mode

Ditto.

rk

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Allen
Sent: Wednesday, June 09, 2010 12:56 PM
To: profoxt...@leafe.com
Subject: RE: VFP OLEDRAGDROP not working in dev mode

Very odd, I didn't get the original of this.
Al

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Rafael Copquin
Sent: 09 June 2010 18:33
To: profoxt...@leafe.com
Subject: Re: VFP OLEDRAGDROP not working in dev mode

I use Windows 7 home premium. I ran your prg in development mode and it 
worked very well.

I dropped both text files and bitmaps.

Rafael Copquin


[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/005801cb07fd$ba83ef00$2f8bcd...@co.uk
** 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: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Fred Taylor

Maybe you're ISP is filtering Dave's address?  I saw his original.

Fred

On Wed, Jun 9, 2010 at 10:31 AM, Rick Schummer <
pro...@whitelightcomputing.com> wrote:

> >> I have not seen an original Dave email for ages, only get to see them
> when it is included in some else's replay.<<
>
> I thought this was just me!!! Been looking at rules and junk-mail list
> until
> blue in the face and has been driving me nuts. Thanks for piping in with
> this.
>
> Rick
> White Light Computing, Inc.
>
> www.whitelightcomputing.com
> www.swfox.net
> www.rickschummer.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/aanlktike8ltbwhpcj77v7tptfwidsutrwu7gd0lhn...@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: VFP OLEDRAGDROP not working in dev mode

Looks likes his emails are going to the full list, not the Tech ONLY list.

> -Original Message-
> From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
> Behalf Of Dave Crozier
> Sent: Wednesday, June 09, 2010 10:05 AM
> To: 'ProFox Email List'
> Subject: VFP OLEDRAGDROP not working in dev mode
> 
> Guys,
> I have just spent over an hour trying to sort out a weird problem
> relating to OLEDRAGDROP with VFP and I am getting nowhere. The reason
> seems to be that in development mode (VFP IDE) the OLEDRAGDROP doesn't
> work when dragging from outside the VFP application. In the compiled
> application everything seems to be OK.
> 
> Could someone verify that I am right in saying that using OLEDRAGDROP
> in windows 7 with VFP doesn't work in VFP Development mode even though
> it does in runtime mode.
> 
> Some example coding just to quickly use in a test is at:
> 
> http://www.news2news.com/vfp/?example=323&function=953
> 
> I haven't access to an XP development box but would be really grateful
> of someone could also confirm that the same program DOES works on XP in
> development mode with VFP SP1 or SP2. When I developed all the DRAGDROP
> it was on XP and I can't remember having a problem during development.
> 
> Either that, or I'm going nuts here and my Windows 7 installation or
> VFP is hosed in some way. OR, there is s setting somewhere in the IDE
> that I haven't found as of yet.
> 
> Thanks
> Dave C
> 


___
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/01cb07fb$d2d289b0$78779d...@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: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Rick Schummer

>> I have not seen an original Dave email for ages, only get to see them 
when it is included in some else's replay.<<

I thought this was just me!!! Been looking at rules and junk-mail list until
blue in the face and has been driving me nuts. Thanks for piping in with
this.

Rick
White Light Computing, Inc.

www.whitelightcomputing.com
www.swfox.net
www.rickschummer.com



___
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/00c101cb07f9$a35c08c0$ea141a...@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: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Andrew Stirling

I have not seen an original Dave email for ages, only get to see them 
when it is included in some else's replay.

Andrew Stirling
01250 874580
http://www.calcpay.co.uk
HMRC Accredited UK payroll program

On 09/06/2010 17:56, Richard Kaye wrote:
> Ditto.
>
> rk
>
> -Original Message-
> From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On 
> Behalf Of Allen
> Sent: Wednesday, June 09, 2010 12:56 PM
> To: profoxt...@leafe.com
> Subject: RE: VFP OLEDRAGDROP not working in dev mode
>
> Very odd, I didn't get the original of this.
> Al
>

___
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/4c0fcb97.7070...@calcpay.co.uk
** 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: [spam] Re: ADO and VFP

On Wed, Jun 9, 2010 at 11:41 AM, Rafael Copquin  wrote:
> Would clients off campus need 24x7 access or every once in a while?
>
> Only during store hours, 9:00 AM to 7:00 PM Mondays thru Fridays
---

Does IT have a VPN already setup?

-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
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/aanlktikiyzpm078kvaztagj5bszlgdlzonpbkiq3f...@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.

VFP app on VPN created by Hamachi (was Re: ADO and VFP)

MB Software Solutions, LLC wrote:
> Rafael Copquin wrote:
>> OK,OK I hear you all guys. Stop thrashing me,please(:->)
>>
>> Seriously now
>>
>> No opening of the router port. No violation of the firewall. Use a VPN. 
>> I got that.
>>
>> How about Hamachi, from LogMeIn?
> 
> 
> Great question!  I'd like to hear about Hamachi, too.  I've heard good 
> things about its simple networking.  Some day-gig franchisees have setup 
> VPNs for their multiple learning centers with Hamachi.  And at only 
> $199/yr, that sounds decent, and even AWESOME if it allows me to create 
> a VFP/MySQL solution that addresses the security concerns of accessing 
> the MySQL database over the web.
> 

If this makes creating a VPN super easy, what's to say this can't be 
created/used for your VFP apps to allow for easier/safer connections? 
If the backend of the database was MySQL (not VFP), it'd already be in a 
disconnected fashion like a traditional RDBMS, so I wouldn't expect the 
performance to be horrible, but rather at an acceptable level.

Your thoughts?

-- 
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/4c0fc7e2.3090...@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: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Richard Kaye

Ditto.

rk

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On 
Behalf Of Allen
Sent: Wednesday, June 09, 2010 12:56 PM
To: profoxt...@leafe.com
Subject: RE: VFP OLEDRAGDROP not working in dev mode

Very odd, I didn't get the original of this.
Al

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Rafael Copquin
Sent: 09 June 2010 18:33
To: profoxt...@leafe.com
Subject: Re: VFP OLEDRAGDROP not working in dev mode

I use Windows 7 home premium. I ran your prg in development mode and it 
worked very well.

I dropped both text files and bitmaps.

Rafael Copquin

___
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/df1eef11e586a64fb54a97f22a8bd04406842f1...@ackbwddqh1.artfact.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: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Allen

Very odd, I didn't get the original of this.
Al

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Rafael Copquin
Sent: 09 June 2010 18:33
To: profoxt...@leafe.com
Subject: Re: VFP OLEDRAGDROP not working in dev mode

I use Windows 7 home premium. I ran your prg in development mode and it 
worked very well.

I dropped both text files and bitmaps.

Rafael Copquin

___
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/003801cb07f4$a80e5f80$f82b1e...@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: ADO and VFP

Rafael Copquin wrote:
> OK,OK I hear you all guys. Stop thrashing me,please(:->)
> 
> Seriously now
> 
> No opening of the router port. No violation of the firewall. Use a VPN. 
> I got that.
> 
> How about Hamachi, from LogMeIn?

Great question!  I'd like to hear about Hamachi, too.  I've heard good 
things about its simple networking.  Some day-gig franchisees have setup 
VPNs for their multiple learning centers with Hamachi.  And at only 
$199/yr, that sounds decent, and even AWESOME if it allows me to create 
a VFP/MySQL solution that addresses the security concerns of accessing 
the MySQL database over the web.

-- 
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/4c0fc6ed.1090...@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: [spam] Re: ADO and VFP

Would clients off campus need 24x7 access or every once in a while?

Only during store hours, 9:00 AM to 7:00 PM Mondays thru Fridays

Rafael Copquin

El 09/06/2010 13:27, Stephen Russell escribió:
> On Wed, Jun 9, 2010 at 11:19 AM, Rafael Copquin  
> wrote:
>
>> OK,OK I hear you all guys. Stop thrashing me,please(:->)
>>
>> Seriously now
>>
>> No opening of the router port. No violation of the firewall. Use a VPN.
>> I got that.
>>
>> How about Hamachi, from LogMeIn?
>>
>>  
> --
>
> The 5.0.0.0/8 network is used to avoid collisions with private IP
> networks that might already be in use on the client side. Specifically
> - 10.0.0.0/8, 172.16.0.0/12 and 192.168.0.0/16. The 5.0.0.0/8 address
> block is unallocated by IANA[1] and is not currently in use in the
> Internet routing domain, but this is not guaranteed to continue. For
> example in January 2010 the address range 1.0.0.0/8 "used" by AnoNet
> became allocated. The IANA free pool is expected to be exhausted by
> February 2011.[2] If this range is allocated, Hamachi users will not
> be able to connect to any Internet IP addresses within the range as
> long as the Hamachi client is running.
>
> I would not use Hamachi because of this point.
>
> Would clients off campus need 24x7 access or every once in a while?
>
>
>
>
>
>
>
>

___
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/4c0fc437.7000...@ciudad.com.ar
** 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: VFP OLEDRAGDROP not working in dev mode

Thanks Rafael,
Don't know if that helps or not. I can't get it to work...DOH!!!

Back to the drawing board!


Dave C

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Rafael Copquin
Sent: 09 June 2010 17:33
To: ProFox Email List
Subject: Re: VFP OLEDRAGDROP not working in dev mode

I use Windows 7 home premium. I ran your prg in development mode and it 
worked very well.

I dropped both text files and bitmaps.

Rafael Copquin



El 09/06/2010 11:05, Dave Crozier escribió:
> Guys,
> I have just spent over an hour trying to sort out a weird problem relating
> to OLEDRAGDROP with VFP and I am getting nowhere. The reason seems to be
> that in development mode (VFP IDE) the OLEDRAGDROP doesn't work when
> dragging from outside the VFP application. In the compiled application
> everything seems to be OK.
>
> Could someone verify that I am right in saying that using OLEDRAGDROP in
> windows 7 with VFP doesn't work in VFP Development mode even though it
does
> in runtime mode.
>
> Some example coding just to quickly use in a test is at:
>
> http://www.news2news.com/vfp/?example=323&function=953
>
> I haven't access to an XP development box but would be really grateful of
> someone could also confirm that the same program DOES works on XP in
> development mode with VFP SP1 or SP2. When I developed all the DRAGDROP it
> was on XP and I can't remember having a problem during development.
>
> Either that, or I'm going nuts here and my Windows 7 installation or VFP
is
> hosed in some way. OR, there is s setting somewhere in the IDE that I
> haven't found as of yet.
>
> Thanks
> Dave C
>
>
>
[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/002f01cb07f2$4a2acc70$de8065...@co.uk
** 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: VFP OLEDRAGDROP not working in dev mode

I use Windows 7 home premium. I ran your prg in development mode and it 
worked very well.

I dropped both text files and bitmaps.

Rafael Copquin



El 09/06/2010 11:05, Dave Crozier escribió:
> Guys,
> I have just spent over an hour trying to sort out a weird problem relating
> to OLEDRAGDROP with VFP and I am getting nowhere. The reason seems to be
> that in development mode (VFP IDE) the OLEDRAGDROP doesn't work when
> dragging from outside the VFP application. In the compiled application
> everything seems to be OK.
>
> Could someone verify that I am right in saying that using OLEDRAGDROP in
> windows 7 with VFP doesn't work in VFP Development mode even though it does
> in runtime mode.
>
> Some example coding just to quickly use in a test is at:
>
> http://www.news2news.com/vfp/?example=323&function=953
>
> I haven't access to an XP development box but would be really grateful of
> someone could also confirm that the same program DOES works on XP in
> development mode with VFP SP1 or SP2. When I developed all the DRAGDROP it
> was on XP and I can't remember having a problem during development.
>
> Either that, or I'm going nuts here and my Windows 7 installation or VFP is
> hosed in some way. OR, there is s setting somewhere in the IDE that I
> haven't found as of yet.
>
> Thanks
> Dave C
>
>
>
[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/4c0fc22e.3070...@ciudad.com.ar
** 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: Word Automation: OLE exception error 5981 in Windows 7

2010-06-09 Thread Ken Dibble

 >Also, just running my compiled .exe, without accessing the Word automation
 > feature--just starting it and shutting it down--as a standard user,
 > produces VFP error 57 "not enough disk space" on the line:
 >
 > SET RESOURCE TO
 >
 > in my environment object.
 >
 > I thought this was because the foxuser files were in my administrative
 > account's profile, so I tried copying them to the same location in the
 > standard user's account--no dice; same error.
 >
 > Is there something I can put in config.fpw to tell it where the foxuser
 > files are?

Fred wrote:

 >resource="x:\folder\name_of _foxuser_table"

Yeah, unfortunately in config.fpw, resource= can either be "on","off" or a 
file location. I already have the line

resource="off" in there.

The reason why my shutdown code has a SET RESOURCE TO line is because I use 
the old separate printing resource file dodge to force a print preview 
toolbar without a print button on it. If the print feature is used, we 
would go from SET RESOURCE OFF to having a resource file that would then 
need to be cleaned up on shutdown.

However, since restoring the SET RESOURCE value is only applicable when 
shutting down my app in the IDE, I just did this:

IF (NOT "6" $ OS()) OR _VFP.StartMode = 0
  IF FILE( (PreviouslyStoredPath\FileLocationForResourceTable))
   SET RESOURCE TO (TheOldResourceTo)
  ENDIF
ENDIF

That fixed the problem.

So thanks Fred.

I still have the issue of not being able to make my automation code work in 
Windows 7 when running as a restricted Domain User. I think I'll start a 
new thread on that and summarize everything so far.

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.20100609122156.01be5...@pop3.frontiernet.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: ADO and VFP

On Wed, Jun 9, 2010 at 11:19 AM, Rafael Copquin  wrote:
> OK,OK I hear you all guys. Stop thrashing me,please(:->)
>
> Seriously now
>
> No opening of the router port. No violation of the firewall. Use a VPN.
> I got that.
>
> How about Hamachi, from LogMeIn?
>
--

The 5.0.0.0/8 network is used to avoid collisions with private IP
networks that might already be in use on the client side. Specifically
- 10.0.0.0/8, 172.16.0.0/12 and 192.168.0.0/16. The 5.0.0.0/8 address
block is unallocated by IANA[1] and is not currently in use in the
Internet routing domain, but this is not guaranteed to continue. For
example in January 2010 the address range 1.0.0.0/8 "used" by AnoNet
became allocated. The IANA free pool is expected to be exhausted by
February 2011.[2] If this range is allocated, Hamachi users will not
be able to connect to any Internet IP addresses within the range as
long as the Hamachi client is running.

I would not use Hamachi because of this point.

Would clients off campus need 24x7 access or every once in a while?

-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
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/aanlktilpzfl4zlbk2sfholn5mffsuepnzvjtw8i7h...@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: ADO and VFP

OK,OK I hear you all guys. Stop thrashing me,please(:->)

Seriously now

No opening of the router port. No violation of the firewall. Use a VPN. 
I got that.

How about Hamachi, from LogMeIn?

Rafael Copquin


El 09/06/2010 9:35, Rafael Copquin escribió:
> As always, very informative and to the point. Thank you.
>
> Now, I guess my next question (should it be labeled [NF]?) is the following:
>
> Suppose you have to link two stores, one with the SQL Server installed
> and the other one, just a branch, with a local LAN.
>
> The idea is that the branch can access the SQL database on line in real
> time, to retrieve or update information in the database.
>
> Now, according to SQL Server help, I should open ports 1433 and 1434 in
> the head office router to enable the branch to access the database.
>
> But what would be the connection string at the branch?
>
> Locally, the connection string looks like this:
>
>
> cConnString=[DRIVER=SQL Server Native Client
> 10.0;SERVER=RAFANUEVA\SQLEXPRESS;UID=;Trusted_Connection=Yes;APP=Microsoft
> Visual FoxPro;WSID=RAFANUEVA;DATABASE=mytestdb;LANGUAGE=Español;]
>
> and the command to obtain the handle is:
>
> nHandle=sqlstringconnect(cConnString)
>
> The question is:
>
> How should I modify the above commands at the branch, to obtain a remote
> connection handle?
> Should I do anything else?
>
>
> Rafael Copquin
>
>
>
>
> El 08/06/2010 20:45, Rick Schummer escribió:
>
>> Rafael,
>>
>>
>>  
 I am beginning to use VFP9 as a front end and SQL server as a backend. I

  
>> wonder if any of you can help with examples of code to use ADO with VFP.<<
>>
>> During my remote data session (presented at Southwest Fox 2009 and German
>> Devcon 2009) I tested the performance of each of the VFP data access
>> techniques and technologies. For the most part remote views, SQL
>> Passthrough, and CursorAdapters using ODBC were about on equal footing
>> performance wise. These tests were done from my desktop to a MySQL database
>> on a server somewhere in Arizona. The tests were run over and over and while
>> each of the technologies took their share of wins, the differences were not
>> all that significant. One thing was for sure though, ADO access was normally
>> between 25 and 100 percent slower than the native technologies.
>>
>> Please note that the performance will depend on several factors though
>> including but not limited to the backend server, the server itself, the
>> wires in between, and the way the queries are programmed. My recommendation
>> is to balance the performance with the ease of use and maintainability, and
>> how the access fits the existing applications if appropriate. Try and test
>> to find the balance.
>>
>> One of the easiest ways to learn how to use ADO and CursorAdapters though is
>> through the VFP 9 (or Sedna) Data Explorer. Create an ADO connection to the
>> data. Drill down to a table, and drag it to a PRG. It will create the code
>> to open a cursor in VFP that you can use all the native XBase commands to
>> manipulate the data, and a simple TABLEUPDATE() to post it back to the
>> backend. It is simply magic.
>>
>> Rick
>> White Light Computing, Inc.
>>
>> www.whitelightcomputing.com
>> www.swfox.net
>> www.rickschummer.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/4c0fbf16.70...@ciudad.com.ar
** 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: ADO and VFP

On Wed, 09 Jun 2010 10:21 -0400, "MB Software Solutions,LLC"
 wrote:

> What feature?  The ability to be secure by means of the SSL certificate?
> 

Apologies I think I may have misunderstood this:
http://msdn.microsoft.com/en-us/library/ms186362.aspx
-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) 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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1276094411.4278.1379266...@webmail.messagingengine.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: ADO and VFP

Alan Bourke wrote:
> 
> On Wed, 09 Jun 2010 09:45 -0400, "MB Software Solutions,LLC"
>  wrote:
> 
>> As long as they get a secure certificate on the site, I thought that 
>> remedies this?  Of course, you need to make sure of login credentials.
> 
> If you mean an SSL certificate, you could well be right, although this
> feature is being removed in some as yet unknown post-2008 R2 version,
> apparently.

What feature?  The ability to be secure by means of the SSL certificate?

-- 
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/4c0fa375.5000...@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: Printer output settings

2010-06-09 Thread Kent Belan

the way we do it is to create separate printers in the control panel for
each tray.

then in your program you can SET PRINTER TO the correct printer and it will
print from the tray selected in the printer properties.
  
HTH,
Kent

> -Original Message-
> From: profox-boun...@leafe.com 
> [mailto:profox-boun...@leafe.com] On Behalf Of Mark Dimmock
> Sent: Wednesday, June 09, 2010 9:51 AM
> To: profox@leafe.com
> Subject: Printer output settings
> 
> Anyone know an easy way of sending reports to specific 
> printer trays using code? Also need to be able to specify 
> number of copies.
> For example,  we need to produce delivery notes from tray 2 
> and invoices from tray 3 from same workstation & printer.
> I know I could use the EXPR field in report.frx, but 
> sometimes if the report is reprinted it may need to go to 
> different printer & tray or only 1 copy.
> 
> Mark Dimmock
> Acton Gate Systems Limited
> Automotive Components Park
> Hallens Drive,
> Wednesbury  WS10 7DD
> T: 0121 505 6533
> F: 0121 505 6943
> M: 07977 431106
> *: ma...@actongate.co.uk
> Web: 
> www.actongate.com
> 
> 
> 
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
> 
[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/718271615e294bb4b7669f236de9d...@kentlaptop
** 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.

VFP OLEDRAGDROP not working in dev mode

Guys,
I have just spent over an hour trying to sort out a weird problem relating
to OLEDRAGDROP with VFP and I am getting nowhere. The reason seems to be
that in development mode (VFP IDE) the OLEDRAGDROP doesn't work when
dragging from outside the VFP application. In the compiled application
everything seems to be OK.
 
Could someone verify that I am right in saying that using OLEDRAGDROP in
windows 7 with VFP doesn't work in VFP Development mode even though it does
in runtime mode.

Some example coding just to quickly use in a test is at:

http://www.news2news.com/vfp/?example=323&function=953

I haven't access to an XP development box but would be really grateful of
someone could also confirm that the same program DOES works on XP in
development mode with VFP SP1 or SP2. When I developed all the DRAGDROP it
was on XP and I can't remember having a problem during development.

Either that, or I'm going nuts here and my Windows 7 installation or VFP is
hosed in some way. OR, there is s setting somewhere in the IDE that I
haven't found as of yet.

Thanks
Dave C



___
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/002901cb07dc$c12a3740$437ea5...@co.uk
** 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: ADO and VFP

On Wed, Jun 9, 2010 at 8:45 AM, MB Software Solutions, LLC
 wrote:
> Alan Bourke wrote:
>>
>> On Wed, 09 Jun 2010 09:35 -0300, "Rafael Copquin"
>>  wrote:
>>> As always, very informative and to the point. Thank you.
>>
>>> The idea is that the branch can access the SQL database on line in real
>>> time, to retrieve or update information in the database.
>>>
>>
>> Major security and speed alarm bells are ringing for me here. It's
>> probably generally accepted that exposing an SQL Server to the internet
>> directly is a bad idea. At the very least make users establish a VPN
>> connection first. A better way would be to use a web service and have
>> the client application go through that.
>
>
> As long as they get a secure certificate on the site, I thought that
> remedies this?  Of course, you need to make sure of login credentials.
-

Not even close to a remedy.  All that does is attempt to hide the data
passed, not stopping access to the port.

As Ted stated never expose a DATA Server to the DMZ, this being SQL is
not diff then say MySQL, Oracle, 

VPN between client site off campus and corporate campus network is necessary.

-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
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/aanlktim0nqhuacudi6nv8mh-kdjpibzk71ny5_uwk...@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: ADO and VFP

On Wed, 09 Jun 2010 09:45 -0400, "MB Software Solutions,LLC"
 wrote:

> As long as they get a secure certificate on the site, I thought that 
> remedies this?  Of course, you need to make sure of login credentials.

If you mean an SSL certificate, you could well be right, although this
feature is being removed in some as yet unknown post-2008 R2 version,
apparently.
-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) 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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1276091555.27006.1379258...@webmail.messagingengine.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.

Printer output settings

2010-06-09 Thread Mark Dimmock

Anyone know an easy way of sending reports to specific printer trays using 
code? Also need to be able to specify number of copies.
For example,  we need to produce delivery notes from tray 2 and invoices from 
tray 3 from same workstation & printer.
I know I could use the EXPR field in report.frx, but sometimes if the report is 
reprinted it may need to go to different printer & tray or only 1 copy.

Mark Dimmock
Acton Gate Systems Limited
Automotive Components Park
Hallens Drive,
Wednesbury  WS10 7DD
T: 0121 505 6533
F: 0121 505 6943
M: 07977 431106
*: ma...@actongate.co.uk
Web: 
www.actongate.com



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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/e72d4f968df0d14fae642ec21a286c29d163391...@exccr01store.sl.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: ADO and VFP

Alan Bourke wrote:
> 
> On Wed, 09 Jun 2010 09:35 -0300, "Rafael Copquin"
>  wrote:
>> As always, very informative and to the point. Thank you.
> 
>> The idea is that the branch can access the SQL database on line in real 
>> time, to retrieve or update information in the database.
>>
> 
> Major security and speed alarm bells are ringing for me here. It's
> probably generally accepted that exposing an SQL Server to the internet
> directly is a bad idea. At the very least make users establish a VPN
> connection first. A better way would be to use a web service and have
> the client application go through that.

As long as they get a secure certificate on the site, I thought that 
remedies this?  Of course, you need to make sure of login credentials.

-- 
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/4c0f9ae9.3040...@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: ADO and VFP

2010-06-09 Thread Ted Roche

On Wed, Jun 9, 2010 at 8:35 AM, Rafael Copquin  wrote:
>
> Now, according to SQL Server help, I should open ports 1433 and 1434 in
> the head office router to enable the branch to access the database.
>

UNDER NO CIRCUMSTANCES do you want to open the ports firewalling your
database from the Internet. (Forgive the shouting, but this is
important.) SQL Server is a database engine, not an Internet
appliance, and evildoers will exploit the direct connection to your
machine to cause a denial of service, theft of data, or other
exploits. It's been done before, and it will happen again. Please
consider establishing a virtual private network between your head
office and branch and then you can open ports, because you are sharing
within an encrypted tunnel.

-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
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/aanlktintylg3bdhptvj8lhh9fldjwfppk4o0wkxng...@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: ADO and VFP

On Wed, 09 Jun 2010 09:35 -0300, "Rafael Copquin"
 wrote:
> As always, very informative and to the point. Thank you.

> The idea is that the branch can access the SQL database on line in real 
> time, to retrieve or update information in the database.
> 

Major security and speed alarm bells are ringing for me here. It's
probably generally accepted that exposing an SQL Server to the internet
directly is a bad idea. At the very least make users establish a VPN
connection first. A better way would be to use a web service and have
the client application go through that.
-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) 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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1276090874.23684.1379255...@webmail.messagingengine.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: [NF] Excel Question

2010-06-09 Thread Bryant Minard

How about using the right function, such as: =RIGHT(E18,3) + 2

Bryant Minard
Medford Software House
25 Ark Rd
Medford, NJ 08055

Tel. (609) 654-5443Fax. (609) 654-5686
sa...@medfordsh.com

> 
> 
> 
> 
> 
> 
> Paul Hill wrote:
> 
> 
> 
> On Tue, Jun 8, 2010 at 7:47 PM, Jeff Johnson  wrote:
> 
> 
> I have a spreadsheet that has numbers entered in cells as '325.  I want
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -- 
> 
> 
> 
> 
> 
> j...@san-dc.com
> 
> 
> www.san-dc.com
> 
> 
> 
> 
> --- StripMime Report -- processed MIME parts ---
> text/html (html body -- converted)
> ---
> 
[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/911acd39-1064-4b42-a4dd-da3b3895f...@me.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: ADO and VFP

On Wed, Jun 9, 2010 at 7:35 AM, Rafael Copquin  wrote:
> As always, very informative and to the point. Thank you.
>
> Now, I guess my next question (should it be labeled [NF]?) is the following:
>
> Suppose you have to link two stores, one with the SQL Server installed
> and the other one, just a branch, with a local LAN.
>
> The idea is that the branch can access the SQL database on line in real
> time, to retrieve or update information in the database.
>
> Now, according to SQL Server help, I should open ports 1433 and 1434 in
> the head office router to enable the branch to access the database.
>
> But what would be the connection string at the branch?
>
> Locally, the connection string looks like this:
>
>
> cConnString=[DRIVER=SQL Server Native Client
> 10.0;SERVER=RAFANUEVA\SQLEXPRESS;UID=;Trusted_Connection=Yes;APP=Microsoft
> Visual FoxPro;WSID=RAFANUEVA;DATABASE=mytestdb;LANGUAGE=Español;]
>
> and the command to obtain the handle is:
>
> nHandle=sqlstringconnect(cConnString)
>
> The question is:
>
> How should I modify the above commands at the branch, to obtain a remote
> connection handle?
> Should I do anything else?
-

You have to define the SERVER properly.

SERVER=RAFANUEVA\SQLEXPRESS  will fail if connecting through the
internet.  You will need to have the server in the DMZ, a dangerous
place for it, or behind the firewall where outside users will need a
VPN to gain access to that network.

Your client may have their network set up that everyone sees properly
through the network an AAA.BBB.CCC.123 can be pinged.

As a heads up I would change the PORT number for SQL Server
communications as well.

-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
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/aanlktilr_gb-uzwbdhizju8dagfl3ynss-rxhpikg...@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: ADO and VFP

As always, very informative and to the point. Thank you.

Now, I guess my next question (should it be labeled [NF]?) is the following:

Suppose you have to link two stores, one with the SQL Server installed 
and the other one, just a branch, with a local LAN.

The idea is that the branch can access the SQL database on line in real 
time, to retrieve or update information in the database.

Now, according to SQL Server help, I should open ports 1433 and 1434 in 
the head office router to enable the branch to access the database.

But what would be the connection string at the branch?

Locally, the connection string looks like this:


cConnString=[DRIVER=SQL Server Native Client 
10.0;SERVER=RAFANUEVA\SQLEXPRESS;UID=;Trusted_Connection=Yes;APP=Microsoft 
Visual FoxPro;WSID=RAFANUEVA;DATABASE=mytestdb;LANGUAGE=Español;]

and the command to obtain the handle is:

nHandle=sqlstringconnect(cConnString)

The question is:

How should I modify the above commands at the branch, to obtain a remote 
connection handle?
Should I do anything else?


Rafael Copquin




El 08/06/2010 20:45, Rick Schummer escribió:
> Rafael,
>
>
>>> I am beginning to use VFP9 as a front end and SQL server as a backend. I
>>>
> wonder if any of you can help with examples of code to use ADO with VFP.<<
>
> During my remote data session (presented at Southwest Fox 2009 and German
> Devcon 2009) I tested the performance of each of the VFP data access
> techniques and technologies. For the most part remote views, SQL
> Passthrough, and CursorAdapters using ODBC were about on equal footing
> performance wise. These tests were done from my desktop to a MySQL database
> on a server somewhere in Arizona. The tests were run over and over and while
> each of the technologies took their share of wins, the differences were not
> all that significant. One thing was for sure though, ADO access was normally
> between 25 and 100 percent slower than the native technologies.
>
> Please note that the performance will depend on several factors though
> including but not limited to the backend server, the server itself, the
> wires in between, and the way the queries are programmed. My recommendation
> is to balance the performance with the ease of use and maintainability, and
> how the access fits the existing applications if appropriate. Try and test
> to find the balance.
>
> One of the easiest ways to learn how to use ADO and CursorAdapters though is
> through the VFP 9 (or Sedna) Data Explorer. Create an ADO connection to the
> data. Drill down to a table, and drag it to a PRG. It will create the code
> to open a cursor in VFP that you can use all the native XBase commands to
> manipulate the data, and a simple TABLEUPDATE() to post it back to the
> backend. It is simply magic.
>
> Rick
> White Light Computing, Inc.
>
> www.whitelightcomputing.com
> www.swfox.net
> www.rickschummer.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/4c0f8a89.3090...@ciudad.com.ar
** 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: [NF] Excel Question

2010-06-09 Thread Jim Felton

try =VALUE(Cell with '325). IE Cell A1 = '325, Cell A2 =VALUE(A1), THE
RESULT A number 325 is in cell A2
Jim

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Jeff Johnson
Sent: Tuesday, June 08, 2010 5:12 PM
To: profox@leafe.com
Subject: Re: [NF] Excel Question

Jeff Johnson wrote:
> http://www.ambience.sk/old/open-office-text-number-format-conversion
>
> It uses search and replace with regular expressions .* and &.
>
> Not bad.
>
>   
Yikes! I can do this in Open Office but not in Excel. I am giving 
instructions to a client. They don't have Open Office.

-- 
Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.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/01cb07ca$6931a300$3b94e9...@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] Nutcase Lib impatient with the colored guy

2010-06-09 Thread Pete Theisen

Hi Everybody,

http://www.heraldtribune.com/article/20100609/COLUMNIST/6091018/-1/todayspaper?Title=Lead-now-on-fossil-fuels
-- 
Regards,

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

___
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/4c0f6205.6030...@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] Parsimonious Euros stick defense tab to US

2010-06-09 Thread Pete Theisen

Hi Everybody,

http://www.heraldtribune.com/article/20100609/ARTICLE/6091029/-1/todayspaper?Title=Gates-urges-Europeans-to-hold-line-on-defense

or

http://tinyurl.com/29qbnr2

Send the bill to Greece?
-- 
Regards,

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

___
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/4c0f5aca.8060...@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: [NF] OS choice if you were in charge?

On Tue, 08 Jun 2010 20:08 -0300, "Ricardo Aráoz" 
wrote:
> On 08/06/10 17:07, Alan Bourke wrote:

> Really?
> Have you ever heard about Open ERP?

And that's one application. There are probably 4 or 5 in the Linux
world, OpenBravo and so on. There are hundreds for Windows, covering
everything from off-the-shelf products for single users all the way up
up to SAP and the like.
-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) 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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1276071115.24607.1379210...@webmail.messagingengine.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: [NF] OS choice if you were in charge?