date:20150527

Its not about being shy. Fact is, I won't actually GO To the websites if I find 
the questionable! That is what they warn people at this job. Why do I find the 
sites questionable?? They are giving away a font for Free - which other sites 
Charge for. That's why I consider it questionable. 

In the end - it's a moot point - since, in my last response - I mentioned that 
I actually found the font already installed on my work PC!

So - its all good now...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai 
Chang
Sent: Wednesday, May 27, 2015 4:22 AM
To: profoxt...@leafe.com
Subject: Re: [NF] About a Font...

Don't be shy but just ask the corresponding websites about the license?

On Wed, May 27, 2015 at 2:04 AM, Kurt Wendt kurt_we...@globetax.com wrote:
 I also found Other links - of sites to download the Font for free. But, I'm 
 not sure how Legit they are - and I am VERY Wary of going to questionable 
 websites here at work. So - was wondering what people here might think. A 
 couple of the websites coming up in the Bing search showing Free downloadable 
 fonts for this are: Font-Zone.com, Fonts101.com, Free-fonts.com, 
 Fontpalace.com and Urbanfonts.com.

--
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ 
http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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: A Quirk w/the PUTFILE Function?

I Did post the line of Code where the issue occurs - which had the PUTFILE 
function. And, no - Set Default is NOT in the system prior to the line with the 
problem. I just showed that - since it puts me in the proper folder and I also 
displayed it in case there were any quirks with the Path that someone may 
notice. 

FYI - I signed confidentiality forms here at my day job - so, I can't be just 
posting a Lot of code - for obvious reasons. 

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai 
Chang
Sent: Wednesday, May 27, 2015 4:21 AM
To: profoxt...@leafe.com
Subject: Re: A Quirk w/the PUTFILE Function?

Post the actual lines of codes in your system!

Did you try using CD instead of SET DEFAULT?

On Wed, May 27, 2015 at 1:57 AM, Kurt Wendt kurt_we...@globetax.com wrote:
 If I run the following 2 command by hand in the Command window in VFP (v9.0 
 release) - it functions as expected:
 SET DEFAULT TO I:\COMMON\OPER\TEST\PNC_Elections\PNCBK\PayMapToday
 gcPayTestFile = PUTFILE('Items May Require PayMap Today:', 
 PayMapToday , 'XLS')

 The problem is -to the left of the Save button - where you see the selected 
 file name - it Properly defaults that name and displays it when I run the 
 command by hand. However, when the system is running the command - even 
 though the file name is Passed - it appears as Blank initially!

--
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ 
http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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: WANTED: VFP Club Membership System

2015-05-27 Thread Adam Buckland

Can I join the love in... Born in Pembury and just moved from Tunbridge Wells 
to Hawkhurst.. Offices in Tonbridge...

Small world...

From: ProFox [profox-boun...@leafe.com] on behalf of Allen 
[pro...@gatwicksoftware.com]
Sent: 25 May 2015 10:29
To: profox@leafe.com
Subject: RE: WANTED: VFP Club Membership System

Good grief, we were nearly neighbours. I used to live near Henfield in
Sussex.
Al

-Original Message-

I have written such a system for Tunbridge Wells Constitutional Club of
which I am a member. Happy to discuss requirements and spec.

Laurie.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/442E79C1A7355C4EA228D320AA59D69C07751A9B@SBS2011.eurohill.local
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: A Quirk w/the PUTFILE Function?

SP2, yes, hotfixes, no, apparently.

I see the KB articles for the issues resolved by the hotfixes and none
of them are applicable in my current app, fortunately. The KB points
to an MSDN location that reports the Archive has been retired. which
is, after all, the point of an archive. Is there a place where the VFP
community has these stored? I don't need them, but wonder.

On Wed, May 27, 2015 at 1:19 PM, Richard Kaye rk...@invaluable.com wrote:
You're not on SP2, Ted? (Apologies to Kurt for stealing his thread...)

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Wednesday, May 27, 2015 1:15 PM
To: profoxt...@leafe.com
Subject: Re: A Quirk w/the PUTFILE Function?

On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com wrote:

Regarding your other suggestions like Concatenating and such - I have not
tried them yet. I will try them shortly to see if that has any impact on the
problem. At the moment I am working on another issue - so I will have to
come back to This problem as soon as I can and try your suggestions.

It seems to me that if you're asking PUTFILE() to put up a dialog showing
only files of extensions XLS but you give it a default name that doesn't
have the XLS, well, I can understand why it might be confused. Windows does
such a poor job of optionally showing file extensions.

What version of Windows are you running? Does the Window explorer usually
show extensions?

when I issue:

? PUTFILE(Custom text,text with spaces in the filename,XLS)

it displays and returns text with spaces in the filename.XLS

if I CD to a network drive and repeat the test, I see the same result.

I'm running VFP 9.0, version(4) says 09.00..5815

Perhaps you've already addressed this in the message thread, but I didn't see
it: there's a colon in the original file name. That won't work for me, or
likely on Windows, I get an Invalid path or filename
error.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CACW6n4sywsKiq4N+4ctV+NYPsvmKq9tT-mm2TnX03A3OtC=t...@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: A Quirk w/the PUTFILE Function?

It's on VFPX now.

http://vfpx.codeplex.com/wikipage?title=VFP%209%20SP2%20Hotfix%203%20Download%20%28latest%20one%29

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Wednesday, May 27, 2015 2:25 PM
To: profoxt...@leafe.com
Subject: Re: A Quirk w/the PUTFILE Function?

SP2, yes, hotfixes, no, apparently.

I see the KB articles for the issues resolved by the hotfixes and none of them 
are applicable in my current app, fortunately. The KB points to an MSDN 
location that reports the Archive has been retired. which is, after all, the 
point of an archive. Is there a place where the VFP community has these stored? 
I don't need them, but wonder.


On Wed, May 27, 2015 at 1:19 PM, Richard Kaye rk...@invaluable.com wrote:
 You're not on SP2, Ted? (Apologies to Kurt for stealing his thread...)

 --

 rk
 -Original Message-
 From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
 Ted Roche
 Sent: Wednesday, May 27, 2015 1:15 PM
 To: profoxt...@leafe.com
 Subject: Re: A Quirk w/the PUTFILE Function?

 On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com wrote:

 Regarding your other suggestions like Concatenating and such - I have not 
 tried them yet. I will try them shortly to see if that has any impact on the 
 problem. At the moment I am working on another issue - so I will have to 
 come back to This problem as soon as I can and try your suggestions.

 It seems to me that if you're asking PUTFILE() to put up a dialog showing 
 only files of extensions XLS but you give it a default name that doesn't 
 have the XLS, well, I can understand why it might be confused. Windows does 
 such a poor job of optionally showing file extensions.

 What version of Windows are you running? Does the Window explorer usually 
 show extensions?

 when I issue:

 ? PUTFILE(Custom text,text with spaces in the filename,XLS)

 it displays and returns text with spaces in the filename.XLS

 if I CD to a network drive and repeat the test, I see the same result.

 I'm running VFP 9.0, version(4) says 09.00..5815

 Perhaps you've already addressed this in the message thread, but I didn't see 
 it: there's a colon in the original file name. That won't work for me, or 
 likely on Windows, I get an Invalid path or filename
 error.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb04511800453d4f6215bea3b8d2...@blupr10mb0451.namprd10.prod.outlook.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: A Quirk w/the PUTFILE Function?

good to know. Thanks.

On Wed, May 27, 2015 at 2:31 PM, Richard Kaye rk...@invaluable.com wrote:
 It's on VFPX now.

 http://vfpx.codeplex.com/wikipage?title=VFP%209%20SP2%20Hotfix%203%20Download%20%28latest%20one%29

 --

 rk
 -Original Message-
 From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
 Sent: Wednesday, May 27, 2015 2:25 PM
 To: profoxt...@leafe.com
 Subject: Re: A Quirk w/the PUTFILE Function?

 SP2, yes, hotfixes, no, apparently.

 I see the KB articles for the issues resolved by the hotfixes and none of 
 them are applicable in my current app, fortunately. The KB points to an MSDN 
 location that reports the Archive has been retired. which is, after all, 
 the point of an archive. Is there a place where the VFP community has these 
 stored? I don't need them, but wonder.


 On Wed, May 27, 2015 at 1:19 PM, Richard Kaye rk...@invaluable.com wrote:
 You're not on SP2, Ted? (Apologies to Kurt for stealing his thread...)

 --

 rk
 -Original Message-
 From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
 Ted Roche
 Sent: Wednesday, May 27, 2015 1:15 PM
 To: profoxt...@leafe.com
 Subject: Re: A Quirk w/the PUTFILE Function?

 On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com wrote:

 Regarding your other suggestions like Concatenating and such - I have not 
 tried them yet. I will try them shortly to see if that has any impact on 
 the problem. At the moment I am working on another issue - so I will have 
 to come back to This problem as soon as I can and try your suggestions.

 It seems to me that if you're asking PUTFILE() to put up a dialog showing 
 only files of extensions XLS but you give it a default name that doesn't 
 have the XLS, well, I can understand why it might be confused. Windows does 
 such a poor job of optionally showing file extensions.

 What version of Windows are you running? Does the Window explorer usually 
 show extensions?

 when I issue:

 ? PUTFILE(Custom text,text with spaces in the filename,XLS)

 it displays and returns text with spaces in the filename.XLS

 if I CD to a network drive and repeat the test, I see the same result.

 I'm running VFP 9.0, version(4) says 09.00..5815

 Perhaps you've already addressed this in the message thread, but I didn't 
 see it: there's a colon in the original file name. That won't work for me, 
 or likely on Windows, I get an Invalid path or filename
 error.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cacw6n4s7u56tp+fr1qinxkqheyyz-xkat7wt3gqgdxp_eh8...@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: A Quirk w/the PUTFILE Function?

2015-05-27 Thread Fernando D. Bozzo

Here VFP9-SP2 / VFP8-SP1 / VFP7-SP1 / VFP6-SP5:
https://vfpx.codeplex.com/releases/view/194354

And here VFP9-SP2 HotFix3:
https://vfpx.codeplex.com/wikipage?title=VFP%209%20SP2%20Hotfix%203%20Download%20%28latest%20one%29referringTitle=Home

Regards.-

2015-05-27 20:25 GMT+02:00 Ted Roche tedro...@gmail.com:

SP2, yes, hotfixes, no, apparently.

On Wed, May 27, 2015 at 1:19 PM, Richard Kaye rk...@invaluable.com
wrote:
You're not on SP2, Ted? (Apologies to Kurt for stealing his thread...)

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Wednesday, May 27, 2015 1:15 PM
To: profoxt...@leafe.com
Subject: Re: A Quirk w/the PUTFILE Function?

On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com
wrote:

Regarding your other suggestions like Concatenating and such - I have
not tried them yet. I will try them shortly to see if that has any impact
on the problem. At the moment I am working on another issue - so I will
have to come back to This problem as soon as I can and try your suggestions.

It seems to me that if you're asking PUTFILE() to put up a dialog
showing only files of extensions XLS but you give it a default name that
doesn't have the XLS, well, I can understand why it might be confused.
Windows does such a poor job of optionally showing file extensions.

What version of Windows are you running? Does the Window explorer
usually show extensions?

when I issue:

? PUTFILE(Custom text,text with spaces in the filename,XLS)

it displays and returns text with spaces in the filename.XLS

if I CD to a network drive and repeat the test, I see the same result.

I'm running VFP 9.0, version(4) says 09.00..5815

Perhaps you've already addressed this in the message thread, but I
didn't see it: there's a colon in the original file name. That won't work
for me, or likely on Windows, I get an Invalid path or filename
error.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAGQ_JumOu0GJqN9=PdEVujeTvNXekyWoyPt_-3Fy+nu5=cx...@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: [NF] Interesting post about foreign keys in SQL

I like taking full advantage of the database server and it's enforcement 
to keep out bad data, but I also can appreciate the perspective of 
having the RI logic in the data tier and just treating the backend as 
big dumb storage so as to make your app much more portable and not 
tied to any particular backend database.


Like so many situations, I guess it all depends on your need.

--Mike


On 2015-05-26 12:13, Richard Kaye wrote:

For those of you who are not familiar with this site, there's a ton of
excellent SQL Server info here. They also post about Oracle on
occasion but as I have no experience with Oracle I don't know how
useful those might be.

http://www.brentozar.com/archive/2015/05/do-foreign-keys-matter-for-insert-speed/

--

rk



--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1a68bb1595a9d37619ba11b7b58f5...@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: Excel 2013 slow automation

Dave -- are you suggesting he take the VFP cursor and do a CursorToXML() 
call on it to produce the XML file in a folder, then have Excel open 
that XML file?  Just wanting to make sure I'm clear on your suggestion.


Thanks,
--Mike


On 2015-05-26 06:39, Dave Crozier wrote:

Peter,
Why not export the report as XML and then set Office to read in the
XML data. This makes it so simple and you don't lose memo data.

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Peter 
Cushing

Sent: 26 May 2015 11:37
To: profox@leafe.com
Subject: Re: Excel 2013 slow automation



On 24/05/2015 07:26, Darren wrote:

As for excel export I wrote an export back in 2002 that has had
minimal changes over the years. Still works well and fast. Idea is
simply to use the snip Happy to send you the code if you want.



Any chance you could send me the code or maybe put it on the download
page?  Sounds useful.

Thanks,

Peter





This communication is intended for the person or organisation to whom
it is addressed. The contents are confidential and may be protected in
law. Unauthorised use, copying or disclosure of any of it may be
unlawful. If you have received this message in error, please notify us
immediately by telephone or email.

www.whisperingsmith.com

Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 
1RR.

Tel:0161 831 3700
Fax:0161 831 3715

London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/8bfaabb078ddd6dedc315515bbdbc...@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: Drew Speedie at CPVFUG, 12 years ago yesterday

Yep.  Took he, his wife, and son out to dinner.  I think Jonathan Finch 
(our Treasurer) went with me.  What an amazing man.  I guess no one will 
ever know what drove him to that end.


On 2015-05-23 08:14, James Harvey wrote:
I remember that meeting, he was incredible. The news of his passing 
saddened

me, and was shocking.

James E Harvey
Spring Grove, PA
717-887-2565

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, May 22, 2015 2:31 PM
To: profox@leafe.com
Subject: Drew Speedie at CPVFUG, 12 years ago yesterday

http://mbsoftwaresolutions.com/images/DrewSpeedieAtCPVFUG.jpg

RIP, Drew.  Truly a wonderful pillar in the VFP community.


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/b822dd3088cbf34ec3921ce4fa94c...@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: [NF] Recomendations for a developer laptop

2015-05-27 Thread Michael Oke, II

Dvorak perhaps.  That seems to be the most common non-QWERTY option.



On Wed, May 27, 2015 at 8:55 AM, 
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

 Paul -- way back when, weren't you trying to non-conventional keyboard
 layout???  Not the QWERTY but something else?



 On 2015-05-18 07:46, Paul McNett wrote:

 Hey Ted, I read your whole thing but am only going to say a couple
 specific things:

 1) The System76 gazelle is an awesome machine except for one huge
 thing and one thing to be aware of.

 The huge thing:the keyboard is garbage. My K key only hits half the
 time, the keys are spaced weird including a right-shift key that's
 hard to hit, the keys don't travel far enough for my liking, etc.



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACBEV=wo5lru7cbw-uqtnhkg8p8aet+7j6ju1_ogbvr1iwh...@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: A Quirk w/the PUTFILE Function?

Hello Richard,

Thanks again for your feedback with my issue. 

So - as for the actual issue. When the Putfile function invokes the Save As 
dialog box - the spot in the dialog box where the actual File Name appears - it 
instead shows up as Blank - even though an actual filename is passed in. And, a 
guy in QA who was testing for another development issue - he came across this 
Bug. He found it peculiar and reported it as a Bug - even though others who 
have been using the system for a long time probably saw the problem happen - 
then just ignored the issue. And, even though the filename is blank - if you 
simply select a file from the main file selection area of the Dialog - then the 
filename does indeed get displayed as the currently selected file. 

As such, in the end - it's a quirk of how the PUTFILE Function is working. It 
throws No Error - and there is NO actual Value to test for When the quirk 
happens - and that's why I was saying that the usage of ASSERT or the TRY...  
commands could not really be used. FYI - regarding the directory where I am 
expecting to be sitting when the program runs - it IS in that folder. I simply 
used the SET DEFAULT command for testing at the Command prompt. 

Regarding your other suggestions like Concatenating and such - I have not tried 
them yet. I will try them shortly to see if that has any impact on the problem. 
At the moment I am working on another issue - so I will have to come back to 
This problem as soon as I can and try your suggestions.

Thanks again for your input. 

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 11:43 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

To be honest I never had a 100% clear picture in my head of what your oddity 
is. :-)

If you can reproduce this issue in the dev environment and can test a logical 
condition then ASSERTS are way better than SET STEP ON, imo. For example, let's 
say you are expecting to be in a certain location before your PUTFILE runs. You 
can do something like this:

untested pseudo-code
ASSERT CURDIR()=[my expected location] MESSAGE [You're not where you think you 
are! Debug now?]
PUTFILE(...)

This will give you the option to invoke the debugger and then evaluate the 
environment as it is at that point in time. 

Have you tried concatenating the full path with the file name as the 2nd 
PUTFILE param instead of just the file name? Added the extension to the name? 
Use a memvar for the output file name instead of a literal string?

Have you investigated using Windows APIs instead of PUTFILE?

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 27, 2015 11:25 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

I never used an ASSERT before. So - I looked at the online help - and I don't 
think it will help in this situation. Also - I don't think the TRY would work 
either - since the TRY is used to handle trapping of an error. And, although a 
strange behavior occurs with regards to my issue - it doesn't actually throw an 
error of any kind...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 11:15 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

ASSERTs and TRY..CATCH may help you hunt this down. 

--

rk 


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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: Excel 2013 slow automation

2015-05-27 Thread Dave Crozier

Mike,
Yes... Excel reads in XML files no problem however large the data set and does 
all of the data conversion for you, but you need the document compatibility 
software update from Microsoft first.

Dave


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: 27 May 2015 16:49
To: ProFox Email List
Subject: RE: Excel 2013 slow automation

Dave -- are you suggesting he take the VFP cursor and do a CursorToXML() call 
on it to produce the XML file in a folder, then have Excel open that XML file?  
Just wanting to make sure I'm clear on your suggestion.

Thanks,
--Mike


On 2015-05-26 06:39, Dave Crozier wrote:
 Peter,
 Why not export the report as XML and then set Office to read in the 
 XML data. This makes it so simple and you don't lose memo data.
 
 Dave
 
 -Original Message-
 From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Peter 
 Cushing
 Sent: 26 May 2015 11:37
 To: profox@leafe.com
 Subject: Re: Excel 2013 slow automation
 
 
 
 On 24/05/2015 07:26, Darren wrote:
 As for excel export I wrote an export back in 2002 that has had 
 minimal changes over the years. Still works well and fast. Idea is 
 simply to use the snip Happy to send you the code if you want.
 
 
 Any chance you could send me the code or maybe put it on the download 
 page?  Sounds useful.
 
 Thanks,
 
 Peter
 
 
 
 
 
 This communication is intended for the person or organisation to whom 
 it is addressed. The contents are confidential and may be protected in 
 law. Unauthorised use, copying or disclosure of any of it may be 
 unlawful. If you have received this message in error, please notify us 
 immediately by telephone or email.
 
 www.whisperingsmith.com
 
 Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 
 1RR.
 Tel:0161 831 3700
 Fax:0161 831 3715
 
 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
 
 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab25973c...@ex2010-a-fpl.fpl.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SMB2 Workstation Cache Configuration

I've had one of the 3 entries in my SMB/OpLocks workarounds for years.

DirectoryCacheLifetime

But not the other two.

FileInfoCacheLifetime
FileNotFoundCacheLifetime

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: Wednesday, May 27, 2015 11:34 AM
To: profoxt...@leafe.com
Subject: Re: SMB2 Workstation Cache Configuration

Useful to have in the armoury however (a) That's XBase++ and may or may not 
apply to VFP and (b) I've never had to do what it mentions, in other words the 
implication from them is that you MUST do it, and maybe you do with XBase++, 
but you don't necessarily with VFP.

--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb0451f44aa8d1517f29ee233dd2...@blupr10mb0451.namprd10.prod.outlook.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: SMB2 Workstation Cache Configuration

2015-05-27 Thread Alan Bourke

Useful to have in the armoury however (a) That's XBase++ and may or may
not apply to VFP and (b) I've never had to do what it mentions, in other
words the implication from them is that you MUST do it, and maybe you do
with XBase++, but you don't necessarily with VFP.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1432740811.4170232.279488729.02b35...@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] Recomendations for a developer laptop

Paul -- way back when, weren't you trying to non-conventional keyboard 
layout???  Not the QWERTY but something else?




On 2015-05-18 07:46, Paul McNett wrote:

Hey Ted, I read your whole thing but am only going to say a couple
specific things:

1) The System76 gazelle is an awesome machine except for one huge
thing and one thing to be aware of.

The huge thing:the keyboard is garbage. My K key only hits half the
time, the keys are spaced weird including a right-shift key that's
hard to hit, the keys don't travel far enough for my liking, etc.



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/c9cff7d735e6fa2328f8e316bc6ec...@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: A Quirk w/the PUTFILE Function?

To be honest I never had a 100% clear picture in my head of what your oddity 
is. :-)

If you can reproduce this issue in the dev environment and can test a logical 
condition then ASSERTS are way better than SET STEP ON, imo. For example, let's 
say you are expecting to be in a certain location before your PUTFILE runs. You 
can do something like this:

untested pseudo-code
ASSERT CURDIR()=[my expected location] MESSAGE [You're not where you think you 
are! Debug now?]
PUTFILE(...)

This will give you the option to invoke the debugger and then evaluate the 
environment as it is at that point in time. 

Have you tried concatenating the full path with the file name as the 2nd 
PUTFILE param instead of just the file name? Added the extension to the name? 
Use a memvar for the output file name instead of a literal string?

Have you investigated using Windows APIs instead of PUTFILE?

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 27, 2015 11:25 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

I never used an ASSERT before. So - I looked at the online help - and I don't 
think it will help in this situation. Also - I don't think the TRY would work 
either - since the TRY is used to handle trapping of an error. And, although a 
strange behavior occurs with regards to my issue - it doesn't actually throw an 
error of any kind...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 11:15 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

ASSERTs and TRY..CATCH may help you hunt this down. 

--

rk 


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb04515897063bdf4f9804b0d9d2...@blupr10mb0451.namprd10.prod.outlook.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] Recomendations for a developer laptop

Well that's cool, but I thought it was more than just a separation for
fighting carpel tunnel syndrome (CTS) but a different ORDER of keys,
something that was more natural if I recall his words from gazillion
years ago. I do recall he dropped it eventually.

http://www.colamco.com/product/kinesis/computer-accessories/keyboards-keypads/kinesis-advantage-keyboard-698894?source=bing

I use the Microsoft natural ergonomic keyboard 4000 model, personally.

On 2015-05-27 11:53, Michael Oke, II wrote:

Dvorak perhaps. That seems to be the most common non-QWERTY option.

On Wed, May 27, 2015 at 8:55 AM,
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

Paul -- way back when, weren't you trying to non-conventional keyboard
layout??? Not the QWERTY but something else?

On 2015-05-18 07:46, Paul McNett wrote:

Hey Ted, I read your whole thing but am only going to say a couple
specific things:

1) The System76 gazelle is an awesome machine except for one huge
thing and one thing to be aware of.

The huge thing:the keyboard is garbage. My K key only hits half the
time, the keys are spaced weird including a right-shift key that's
hard to hit, the keys don't travel far enough for my liking, etc.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/202bec235da351e856f0ba65a66b3...@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.

SMB2 Workstation Cache Configuration

Big props to Rick Schummer for passing on this link to a utility from
Alaska software that addresses the problems that VFP and other
applications run into when:

-- workstation is Vista or Win7 or later (note, I didn't say better :)
-- data is stored on a Server 2008 or later file server
-- application is checking file size, last update date or file existence.

The small installation file is located here:

http://www.alaska-software.com/community/smb2.cxp

I have read of other solutions to force SMB2 to behave in a compatible
manner. I'd be interested to hear if this helps folks running into
problems.



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACW6n4tkzjDppVRA07DcXK1RVt=ci4dTh3PKgcvCj03sat=j...@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: A Quirk w/the PUTFILE Function?

I never used an ASSERT before. So - I looked at the online help - and I don't 
think it will help in this situation. Also - I don't think the TRY would work 
either - since the TRY is used to handle trapping of an error. And, although a 
strange behavior occurs with regards to my issue - it doesn't actually throw an 
error of any kind...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 11:15 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

ASSERTs and TRY..CATCH may help you hunt this down. 

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 27, 2015 11:09 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

Hey Tracy,

Thanks for your input. We compile EXE's strictly - for our users. And, I also 
test with an EXE.

Like yourself - the problem is strange. Since - when I run code to test for the 
problem - via the Command window - the problem does Not happen. 

It is a rather peculiar problem...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy 
Pearson
Sent: Wednesday, May 27, 2015 11:04 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

Kurt Wendt wrote on 2015-05-27: 
  I Did post the line of Code where the issue occurs - which had the
PUTFILE function. And, no - Set Default is NOT in the system prior to the line 
with the problem. I just showed that - since it puts me in the proper folder 
and I also displayed it in case there were any quirks with the Path that 
someone may notice.
  
  FYI - I signed confidentiality forms here at my day job - so, I can't 
 be
just posting a Lot of code - for obvious reasons.
  
  -K-
  

Kurt,

I am unable to reproduce the behavior you described.
Curious about the structure. I'm testing in a compiled EXE.
Is this distributed as an FXP, Forms, Class Library external of an EXE, is in 
an APP that is launched by an EXE?

At one time, I had launched a APP file compiled by VFP 8 from a VFP 6 compiled 
EXE. That caused some odd behaviors.


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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: A Quirk w/the PUTFILE Function?

2015-05-27 Thread Tracy Pearson

Kurt Wendt wrote on 2015-05-27: 
  I Did post the line of Code where the issue occurs - which had the
PUTFILE function. And, no - Set Default is NOT in the system prior to the
line with the problem. I just showed that - since it puts me in the proper
folder and I also displayed it in case there were any quirks with the Path
that someone may notice.
  
  FYI - I signed confidentiality forms here at my day job - so, I can't be
just posting a Lot of code - for obvious reasons.
  
  -K-
  

Kurt,

I am unable to reproduce the behavior you described.
Curious about the structure. I'm testing in a compiled EXE.
Is this distributed as an FXP, Forms, Class Library external of an EXE, is
in an APP that is launched by an EXE?

At one time, I had launched a APP file compiled by VFP 8 from a VFP 6
compiled EXE. That caused some odd behaviors.

Tracy Pearson
PowerChurch Software


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/000b01d0988e$5ffae300$1ff0a900$@powerchurch.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: A Quirk w/the PUTFILE Function?

Hey Tracy,

Thanks for your input. We compile EXE's strictly - for our users. And, I also 
test with an EXE.

Like yourself - the problem is strange. Since - when I run code to test for the 
problem - via the Command window - the problem does Not happen. 

It is a rather peculiar problem...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy 
Pearson
Sent: Wednesday, May 27, 2015 11:04 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

Kurt Wendt wrote on 2015-05-27: 
  I Did post the line of Code where the issue occurs - which had the
PUTFILE function. And, no - Set Default is NOT in the system prior to the line 
with the problem. I just showed that - since it puts me in the proper folder 
and I also displayed it in case there were any quirks with the Path that 
someone may notice.
  
  FYI - I signed confidentiality forms here at my day job - so, I can't 
 be
just posting a Lot of code - for obvious reasons.
  
  -K-
  

Kurt,

I am unable to reproduce the behavior you described.
Curious about the structure. I'm testing in a compiled EXE.
Is this distributed as an FXP, Forms, Class Library external of an EXE, is in 
an APP that is launched by an EXE?

At one time, I had launched a APP file compiled by VFP 8 from a VFP 6 compiled 
EXE. That caused some odd behaviors.

Tracy Pearson
PowerChurch Software


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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: A Quirk w/the PUTFILE Function?

ASSERTs and TRY..CATCH may help you hunt this down. 

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 27, 2015 11:09 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

Hey Tracy,

Thanks for your input. We compile EXE's strictly - for our users. And, I also 
test with an EXE.

Like yourself - the problem is strange. Since - when I run code to test for the 
problem - via the Command window - the problem does Not happen. 

It is a rather peculiar problem...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy 
Pearson
Sent: Wednesday, May 27, 2015 11:04 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

Kurt Wendt wrote on 2015-05-27: 
  I Did post the line of Code where the issue occurs - which had the
PUTFILE function. And, no - Set Default is NOT in the system prior to the line 
with the problem. I just showed that - since it puts me in the proper folder 
and I also displayed it in case there were any quirks with the Path that 
someone may notice.

  FYI - I signed confidentiality forms here at my day job - so, I can't 
 be
just posting a Lot of code - for obvious reasons.

  -K-

Kurt,

I am unable to reproduce the behavior you described.
Curious about the structure. I'm testing in a compiled EXE.
Is this distributed as an FXP, Forms, Class Library external of an EXE, is in 
an APP that is launched by an EXE?

At one time, I had launched a APP file compiled by VFP 8 from a VFP 6 compiled 
EXE. That caused some odd behaviors.

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb0451b47ea6057e0c2f0f39eed2...@blupr10mb0451.namprd10.prod.outlook.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.

Tom Rettig's TRUE utility, specifically PRG2VCX

I need to convert a PRG class to VCX.  Google searching shows Tom 
Rettig's PRG2VCX would do the job, yet the links I find for it are no 
longer valid, the FTP on prolib.de requires credentials (that I don't 
know), and I'm not a UniversalThread member since the 90s.  Anybody got 
a copy and can shoot it to me?


Thanks,
--Mike


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5379ae71f8365460d59a2c917e185...@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: A Quirk w/the PUTFILE Function?

Richard - it looks to me as Ted IS on VFP9 SP2 - as I am - and mine also shows 
the exact same version#.

And, gosh - it sure didn't Look like you were stealing my thread! Otherwise I 
would have sent the Thread Police after you - Right Pete??   

:-)
-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 1:20 PM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

You're not on SP2, Ted? (Apologies to Kurt for stealing his thread...)

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Wednesday, May 27, 2015 1:15 PM
To: profoxt...@leafe.com
Subject: Re: A Quirk w/the PUTFILE Function?

On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com wrote:

 Regarding your other suggestions like Concatenating and such - I have not 
 tried them yet. I will try them shortly to see if that has any impact on the 
 problem. At the moment I am working on another issue - so I will have to come 
 back to This problem as soon as I can and try your suggestions.

It seems to me that if you're asking PUTFILE() to put up a dialog showing only 
files of extensions XLS but you give it a default name that doesn't have the 
XLS, well, I can understand why it might be confused. Windows does such a poor 
job of optionally showing file extensions.

What version of Windows are you running? Does the Window explorer usually show 
extensions?

when I issue:

? PUTFILE(Custom text,text with spaces in the filename,XLS)

it displays and returns text with spaces in the filename.XLS

if I CD to a network drive and repeat the test, I see the same result.

I'm running VFP 9.0, version(4) says 09.00..5815

Perhaps you've already addressed this in the message thread, but I didn't see 
it: there's a colon in the original file name. That won't work for me, or 
likely on Windows, I get an Invalid path or filename
error.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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] Interesting post about foreign keys in SQL

Stephen - if your Database is Talking to you - maybe its truly time for You to 
talk to a Shrink!!!

:-)

All kidding aside. I know there is this whole argument about keep business 
rules away from the Database - even though, in many cases - people implement 
them within Stored Procedures. Which means the rules get tied to the data. But, 
I know this is a Very Intense argument that a lot of folks argue over. So - 
sorry if I am just adding to the flame war about Data vs. Program code...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen 
Russell
Sent: Wednesday, May 27, 2015 1:00 PM
To: profoxt...@leafe.com
Subject: Re: [NF] Interesting post about foreign keys in SQL

On Wed, May 27, 2015 at 10:33 AM, 
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

 I like taking full advantage of the database server and it's 
 enforcement to keep out bad data, but I also can appreciate the 
 perspective of having the RI logic in the data tier and just treating 
 the backend as big dumb storage so as to make your app much more 
 portable and not tied to any particular backend database.

 Like so many situations, I guess it all depends on your need.

 ---


You make my db cry when you call it dumb storage.  It says it is so much more 
with analytics involved that makes cubes for end user reporting real easy.  Or 
dashboards for a variety of data needs across all aspects of our business.

It also mentions the ability to cross reference data from other systems we have 
in house who all have different instances on the same DB server.

My databse also said that living in a third normal form environment is faster 
than you think.


--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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: A Quirk w/the PUTFILE Function?

On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com wrote:

Regarding your other suggestions like Concatenating and such - I have not
tried them yet. I will try them shortly to see if that has any impact on the
problem. At the moment I am working on another issue - so I will have to come
back to This problem as soon as I can and try your suggestions.

It seems to me that if you're asking PUTFILE() to put up a dialog
showing only files of extensions XLS but you give it a default name
that doesn't have the XLS, well, I can understand why it might be
confused. Windows does such a poor job of optionally showing file
extensions.

What version of Windows are you running? Does the Window explorer
usually show extensions?

when I issue:

? PUTFILE(Custom text,text with spaces in the filename,XLS)

it displays and returns text with spaces in the filename.XLS

if I CD to a network drive and repeat the test, I see the same result.

I'm running VFP 9.0, version(4) says 09.00..5815

Perhaps you've already addressed this in the message thread, but I
didn't see it: there's a colon in the original file name. That won't
work for me, or likely on Windows, I get an Invalid path or filename
error.

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CACW6n4t+2=mqScsH996=mczw_qxqxobeuxxpdkkppp-ywmg...@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: [NF] Recomendations for a developer laptop

On Wed, May 27, 2015 at 12:48 PM, Kurt Wendt kurt_we...@globetax.com wrote:

 Talking about a different kind of Keyboard layout - and needing to re-learn 
 how to type with it. A number of years ago there was a special device that 
 was supposed to be used with things like VR applications. It was a kind of 
 keyboard - it was one handed. So - it had 5 keys that you pressed.

Just like hitting multiple keys on a musical instrument to produce a
different sound: it's called a chorded' keyboard, and an internet
search should find you many. Also good for people with motion injuries
or restrictions.

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACW6n4snVk6B_pJRDSdqQfYjmAQ2ZEXKy1j=2rowkszsuws...@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: A Quirk w/the PUTFILE Function?

http://fox.wikis.com/wc.dll?Wiki~CurrentVersion~WIN_COM_API

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 27, 2015 1:28 PM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

Richard - it looks to me as Ted IS on VFP9 SP2 - as I am - and mine also shows 
the exact same version#.

And, gosh - it sure didn't Look like you were stealing my thread! Otherwise I 
would have sent the Thread Police after you - Right Pete??   

:-)
-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 1:20 PM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

You're not on SP2, Ted? (Apologies to Kurt for stealing his thread...)

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Wednesday, May 27, 2015 1:15 PM
To: profoxt...@leafe.com
Subject: Re: A Quirk w/the PUTFILE Function?

On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com wrote:

 Regarding your other suggestions like Concatenating and such - I have not 
 tried them yet. I will try them shortly to see if that has any impact on the 
 problem. At the moment I am working on another issue - so I will have to come 
 back to This problem as soon as I can and try your suggestions.

It seems to me that if you're asking PUTFILE() to put up a dialog showing only 
files of extensions XLS but you give it a default name that doesn't have the 
XLS, well, I can understand why it might be confused. Windows does such a poor 
job of optionally showing file extensions.

What version of Windows are you running? Does the Window explorer usually show 
extensions?

when I issue:

? PUTFILE(Custom text,text with spaces in the filename,XLS)

it displays and returns text with spaces in the filename.XLS

if I CD to a network drive and repeat the test, I see the same result.

I'm running VFP 9.0, version(4) says 09.00..5815

Perhaps you've already addressed this in the message thread, but I didn't see 
it: there's a colon in the original file name. That won't work for me, or 
likely on Windows, I get an Invalid path or filename
error.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb045168c12261ea0f4eba533ad2...@blupr10mb0451.namprd10.prod.outlook.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] Interesting post about foreign keys in SQL

2015-05-27 Thread Stephen Russell

On Wed, May 27, 2015 at 10:33 AM, 
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

 I like taking full advantage of the database server and it's enforcement
 to keep out bad data, but I also can appreciate the perspective of having
 the RI logic in the data tier and just treating the backend as big dumb
 storage so as to make your app much more portable and not tied to any
 particular backend database.

 Like so many situations, I guess it all depends on your need.

 ---


You make my db cry when you call it dumb storage.  It says it is so much
more with analytics involved that makes cubes for end user reporting real
easy.  Or dashboards for a variety of data needs across all aspects of our
business.

It also mentions the ability to cross reference data from other systems we
have in house who all have different instances on the same DB server.

My databse also said that living in a third normal form environment is
faster than you think.


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAJidMYL2VLoxt=oNLF3mQL4rMe0JSiX-aas2OEnj=+xh5gz...@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: A Quirk w/the PUTFILE Function?

Hey there Ted!

I'm using Win7 Pro SP1. And, yes, same Version of VFP w/.5815 at the end. And, 
nope - file name didn't have the colon - it's the CustomText field that has the 
colon. And, correct - if I just do PUTFILE by hand in the command window - it 
Always works right. The strange issue only happens when the system is running. 
And, yes, in my case - Windows Explorer does indeed show the extensions. 

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Wednesday, May 27, 2015 1:15 PM
To: profoxt...@leafe.com
Subject: Re: A Quirk w/the PUTFILE Function?

On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com wrote:

 Regarding your other suggestions like Concatenating and such - I have not 
 tried them yet. I will try them shortly to see if that has any impact on the 
 problem. At the moment I am working on another issue - so I will have to come 
 back to This problem as soon as I can and try your suggestions.

It seems to me that if you're asking PUTFILE() to put up a dialog showing only 
files of extensions XLS but you give it a default name that doesn't have the 
XLS, well, I can understand why it might be confused. Windows does such a poor 
job of optionally showing file extensions.

What version of Windows are you running? Does the Window explorer usually show 
extensions?

when I issue:

? PUTFILE(Custom text,text with spaces in the filename,XLS)

it displays and returns text with spaces in the filename.XLS

if I CD to a network drive and repeat the test, I see the same result.

I'm running VFP 9.0, version(4) says 09.00..5815

Perhaps you've already addressed this in the message thread, but I didn't see 
it: there's a colon in the original file name. That won't work for me, or 
likely on Windows, I get an Invalid path or filename
error.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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: A Quirk w/the PUTFILE Function?

A slight misstatement on my part. 5815 was the original SP2 release, iirc. 
There was an SP2 rollup/hotfix and that version number is 7423.

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 27, 2015 1:28 PM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

Richard - it looks to me as Ted IS on VFP9 SP2 - as I am - and mine also shows 
the exact same version#.

And, gosh - it sure didn't Look like you were stealing my thread! Otherwise I 
would have sent the Thread Police after you - Right Pete??   

:-)
-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 1:20 PM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

You're not on SP2, Ted? (Apologies to Kurt for stealing his thread...)

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Wednesday, May 27, 2015 1:15 PM
To: profoxt...@leafe.com
Subject: Re: A Quirk w/the PUTFILE Function?

On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com wrote:

 Regarding your other suggestions like Concatenating and such - I have not 
 tried them yet. I will try them shortly to see if that has any impact on the 
 problem. At the moment I am working on another issue - so I will have to come 
 back to This problem as soon as I can and try your suggestions.

It seems to me that if you're asking PUTFILE() to put up a dialog showing only 
files of extensions XLS but you give it a default name that doesn't have the 
XLS, well, I can understand why it might be confused. Windows does such a poor 
job of optionally showing file extensions.

What version of Windows are you running? Does the Window explorer usually show 
extensions?

when I issue:

? PUTFILE(Custom text,text with spaces in the filename,XLS)

it displays and returns text with spaces in the filename.XLS

if I CD to a network drive and repeat the test, I see the same result.

I'm running VFP 9.0, version(4) says 09.00..5815

Perhaps you've already addressed this in the message thread, but I didn't see 
it: there's a colon in the original file name. That won't work for me, or 
likely on Windows, I get an Invalid path or filename
error.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb0451a118466af8baee0cf395d2...@blupr10mb0451.namprd10.prod.outlook.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: SMB2 Workstation Cache Configuration

2015-05-27 Thread Tracy Pearson

Alan Bourke wrote on 2015-05-27: 
  Useful to have in the armoury however (a) That's XBase++ and may or may
  not apply to VFP and (b) I've never had to do what it mentions, in other
  words the implication from them is that you MUST do it, and maybe you do
  with XBase++, but you don't necessarily with VFP.

Alan,

After reading a response I got from Christof some months ago, I really think
these SMB caching issues are related to how the files are opened and used on
workstations.  http://leafe.com/archives/msg/497230 

I believe the XBase++ files are still Indexed Sequential Access Method
(ISAM), or separate files for each table. 
See
http://www.techrepublic.com/article/explore-the-differences-between-isam-and
-relational-databases/ for more details on ISAM.

When the program is written to work in a disconnected flow, the problems are
less likely to occur. My programs were designed and implemented in a
connected manner. Our customers see issues from SMB caching and locking, as
well as our online hosting of customers data get this behavior.

Tracy Pearson
PowerChurch Software


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/001001d098a3$75f69590$61e3c0b0$@powerchurch.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: A Quirk w/the PUTFILE Function?

You're not on SP2, Ted? (Apologies to Kurt for stealing his thread...)

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Wednesday, May 27, 2015 1:15 PM
To: profoxt...@leafe.com
Subject: Re: A Quirk w/the PUTFILE Function?

On Wed, May 27, 2015 at 11:59 AM, Kurt Wendt kurt_we...@globetax.com wrote:

 Regarding your other suggestions like Concatenating and such - I have not 
 tried them yet. I will try them shortly to see if that has any impact on the 
 problem. At the moment I am working on another issue - so I will have to come 
 back to This problem as soon as I can and try your suggestions.

It seems to me that if you're asking PUTFILE() to put up a dialog showing only 
files of extensions XLS but you give it a default name that doesn't have the 
XLS, well, I can understand why it might be confused. Windows does such a poor 
job of optionally showing file extensions.

What version of Windows are you running? Does the Window explorer usually show 
extensions?

when I issue:

? PUTFILE(Custom text,text with spaces in the filename,XLS)

it displays and returns text with spaces in the filename.XLS

if I CD to a network drive and repeat the test, I see the same result.

I'm running VFP 9.0, version(4) says 09.00..5815

Perhaps you've already addressed this in the message thread, but I didn't see 
it: there's a colon in the original file name. That won't work for me, or 
likely on Windows, I get an Invalid path or filename
error.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb0451a62996bcfd7919fda338d2...@blupr10mb0451.namprd10.prod.outlook.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] Recomendations for a developer laptop

2015-05-27 Thread Michael Oke, II

DVORAK is a different layout that is supposed to be easier/faster when
typing, provided that you can unlearn QWERTY and relearn the new.

On Wed, May 27, 2015 at 9:06 AM,
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

http://www.colamco.com/product/kinesis/computer-accessories/keyboards-keypads/kinesis-advantage-keyboard-698894?source=bing

I use the Microsoft natural ergonomic keyboard 4000 model, personally.

On 2015-05-27 11:53, Michael Oke, II wrote:

Dvorak perhaps. That seems to be the most common non-QWERTY option.

On Wed, May 27, 2015 at 8:55 AM,
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

Paul -- way back when, weren't you trying to non-conventional keyboard
layout??? Not the QWERTY but something else?

On 2015-05-18 07:46, Paul McNett wrote:

Hey Ted, I read your whole thing but am only going to say a couple
specific things:

1) The System76 gazelle is an awesome machine except for one huge
thing and one thing to be aware of.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CACBEV=XEEVNQzP5izyreBtaq+b0B=qk5xogme0xy6az3j42...@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: [NF] Recomendations for a developer laptop

AFAIK - those are the only 2 types of standard keyboard layouts. But, obviously 
- Dvorak never really caught on. Kinda like the old days of VHS vs. BETA - and 
VHS became the standard - even though BETA was better and more sophisticated. 
So - even though BETA didn't become the standard, so you never saw it in Home 
VCR's - it Was used in the Video Production world. 

Talking about a different kind of Keyboard layout - and needing to re-learn how 
to type with it. A number of years ago there was a special device that was 
supposed to be used with things like VR applications. It was a kind of keyboard 
- it was one handed. So - it had 5 keys that you pressed. And, theoretically 
you could type almost Anything with it - once you trained yourself. I thought 
it would be pretty cool to use with a laptop for typing - when you have limited 
elbow room - like on an airplane or train!

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael 
Oke, II
Sent: Wednesday, May 27, 2015 12:42 PM
To: profoxt...@leafe.com
Subject: Re: [NF] Recomendations for a developer laptop

DVORAK is a different layout that is supposed to be easier/faster when typing, 
provided that you can unlearn QWERTY and relearn the new.



On Wed, May 27, 2015 at 9:06 AM, 
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

 Well that's cool, but I thought it was more than just a separation for 
 fighting carpel tunnel syndrome (CTS) but a different ORDER of keys, 
 something that was more natural if I recall his words from gazillion 
 years ago.  I do recall he dropped it eventually.


 http://www.colamco.com/product/kinesis/computer-accessories/keyboards-
 keypads/kinesis-advantage-keyboard-698894?source=bing

 I use the Microsoft natural ergonomic keyboard 4000 model, personally.



 On 2015-05-27 11:53, Michael Oke, II wrote:

 Dvorak perhaps.  That seems to be the most common non-QWERTY option.



 On Wed, May 27, 2015 at 8:55 AM, 
 mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

  Paul -- way back when, weren't you trying to non-conventional 
 keyboard
 layout???  Not the QWERTY but something else?



 On 2015-05-18 07:46, Paul McNett wrote:

  Hey Ted, I read your whole thing but am only going to say a couple
 specific things:

 1) The System76 gazelle is an awesome machine except for one huge 
 thing and one thing to be aware of.

 The huge thing:the keyboard is garbage. My K key only hits half the 
 time, the keys are spaced weird including a right-shift key that's 
 hard to hit, the keys don't travel far enough for my liking, etc.



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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] Interesting post about foreign keys in SQL

2015-05-27 Thread Stephen Russell

On Wed, May 27, 2015 at 12:03 PM, Kurt Wendt kurt_we...@globetax.com
wrote:

 Stephen - if your Database is Talking to you - maybe its truly time for
 You to talk to a Shrink!!!

 :-)

 All kidding aside. I know there is this whole argument about keep business
 rules away from the Database - even though, in many cases - people
 implement them within Stored Procedures. Which means the rules get tied to
 the data. But, I know this is a Very Intense argument that a lot of folks
 argue over. So - sorry if I am just adding to the flame war about Data vs.
 Program code...
 --


I have a shrink right here!  :)

DBCC SHRINKFILE (N'TheInvoices_log' , 0, TRUNCATEONLY)
GO

Running all CRUD operations through stored procedures protects you compared
to having unsanitized input put into a dynamic script that is executed.
But then it is your data and you can do what you want.


http://www.esecurityplanet.com/hackers/how-to-prevent-sql-injection-attacks.html


Having someone sneak this line into a mySQL sytem really sucks.

 -BNe show tables | awk '{print set foreign_key_checks=0; drop table `
$1 `;}'


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cajidmykbdqtyqxf9p07vmpbhvu-jdqk-tybgl+j5vc54gbu...@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: A Quirk w/the PUTFILE Function?

Richard - I followed this suggestion of your's:
   'Added the extension to the name?'

And, it seems it DID fix the problem. What I noticed - was that the system was 
trying to generate that Excel file in a Folder called PayMapToday - while the 
file it was trying to generate was also called PayMapToday.

I think a User made a mistake - and created that folder inadvertently. Then, 
the Putfile function gets 'confused' between the XLS file name and the Folder 
name. So, by using the Extension - it stopped the confusion - and now properly 
displays the File name in the Save As!

So - all is well that Ends well. 
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 11:43 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

To be honest I never had a 100% clear picture in my head of what your oddity 
is. :-)

If you can reproduce this issue in the dev environment and can test a logical 
condition then ASSERTS are way better than SET STEP ON, imo. For example, let's 
say you are expecting to be in a certain location before your PUTFILE runs. You 
can do something like this:

untested pseudo-code
ASSERT CURDIR()=[my expected location] MESSAGE [You're not where you think you 
are! Debug now?]
PUTFILE(...)

This will give you the option to invoke the debugger and then evaluate the 
environment as it is at that point in time. 

Have you tried concatenating the full path with the file name as the 2nd 
PUTFILE param instead of just the file name? Added the extension to the name? 
Use a memvar for the output file name instead of a literal string?

Have you investigated using Windows APIs instead of PUTFILE?

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 27, 2015 11:25 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

I never used an ASSERT before. So - I looked at the online help - and I don't 
think it will help in this situation. Also - I don't think the TRY would work 
either - since the TRY is used to handle trapping of an error. And, although a 
strange behavior occurs with regards to my issue - it doesn't actually throw an 
error of any kind...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 11:15 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

ASSERTs and TRY..CATCH may help you hunt this down. 

--

rk 


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.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: A Quirk w/the PUTFILE Function?

Yep, silly end user tricks can bit you like that.

I took a stroll through my code (Thank you, GoFish!) and I seem to have a 
delightful blend of calling putfile with and without paths and extensions. I 
think I've gotten the most consistent behavior when I include the extension 
with the provisional file name.

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 27, 2015 4:34 PM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

Richard - I followed this suggestion of your's:
   'Added the extension to the name?'

And, it seems it DID fix the problem. What I noticed - was that the system was 
trying to generate that Excel file in a Folder called PayMapToday - while the 
file it was trying to generate was also called PayMapToday.

I think a User made a mistake - and created that folder inadvertently. Then, 
the Putfile function gets 'confused' between the XLS file name and the Folder 
name. So, by using the Extension - it stopped the confusion - and now properly 
displays the File name in the Save As!

So - all is well that Ends well. 
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 11:43 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

To be honest I never had a 100% clear picture in my head of what your oddity 
is. :-)

If you can reproduce this issue in the dev environment and can test a logical 
condition then ASSERTS are way better than SET STEP ON, imo. For example, let's 
say you are expecting to be in a certain location before your PUTFILE runs. You 
can do something like this:

untested pseudo-code
ASSERT CURDIR()=[my expected location] MESSAGE [You're not where you think you 
are! Debug now?]
PUTFILE(...)

This will give you the option to invoke the debugger and then evaluate the 
environment as it is at that point in time. 

Have you tried concatenating the full path with the file name as the 2nd 
PUTFILE param instead of just the file name? Added the extension to the name? 
Use a memvar for the output file name instead of a literal string?

Have you investigated using Windows APIs instead of PUTFILE?

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: Wednesday, May 27, 2015 11:25 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

I never used an ASSERT before. So - I looked at the online help - and I don't 
think it will help in this situation. Also - I don't think the TRY would work 
either - since the TRY is used to handle trapping of an error. And, although a 
strange behavior occurs with regards to my issue - it doesn't actually throw an 
error of any kind...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, May 27, 2015 11:15 AM
To: profoxt...@leafe.com
Subject: RE: A Quirk w/the PUTFILE Function?

ASSERTs and TRY..CATCH may help you hunt this down. 

--

rk 


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/blupr10mb0451f735500e99e26d0712efd2...@blupr10mb0451.namprd10.prod.outlook.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: Tom Rettig's TRUE utility, specifically PRG2VCX


On 2015-05-27 19:42, Ted Roche wrote:

And the original's in your copy of the Hacker's Guide to Visual FoxPro
3. Inside the back cover. On a floppy disk.




I think I only have my e-copy yet.

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1e3734a0b74c59990ec6d34a6595b...@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: Tom Rettig's TRUE utility, specifically PRG2VCX


On 2015-05-27 18:38, Michael Glassman wrote:

According to the Visual FoxPro Wiki
(http://fox.wikis.com/wc.dll?Wiki~PrgToVcx), the enhanced version of
Prg2Vcx is PrgToVcx, which is available here on Leafe
(http://leafe.com/download/PrgToVcx.zip).

Mike



H.I swear I looked at the Downloads page todaydarn eyes.

Thanks!
--Mike


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/e746383f2276d33d51efb26cfa8a2...@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: [NF] Interesting post about foreign keys in SQL


On 2015-05-27 13:03, Kurt Wendt wrote:

Stephen - if your Database is Talking to you - maybe its truly time
for You to talk to a Shrink!!!

:-)

All kidding aside. I know there is this whole argument about keep
business rules away from the Database - even though, in many cases -
people implement them within Stored Procedures. Which means the rules
get tied to the data. But, I know this is a Very Intense argument that
a lot of folks argue over. So - sorry if I am just adding to the flame
war about Data vs. Program code...




Just depends how much you want to tether yourself to the backend 
database too.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/8d891d337205c5352d569c38a74ef...@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: Tom Rettig's TRUE utility, specifically PRG2VCX

And the original's in your copy of the Hacker's Guide to Visual FoxPro
3. Inside the back cover. On a floppy disk.

On Wed, May 27, 2015 at 11:09 AM,
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
 I need to convert a PRG class to VCX.  Google searching shows Tom Rettig's
 PRG2VCX would do the job, yet the links I find for it are no longer valid,
 the FTP on prolib.de requires credentials (that I don't know), and I'm not a
 UniversalThread member since the 90s.  Anybody got a copy and can shoot it
 to me?

 Thanks,
 --Mike


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cacw6n4tjknqfg9w2bzwkbwjiz3nwjn94gwrhj+9nu4jm8of...@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: Excel 2013 slow automation


On 2015-05-27 12:01, Dave Crozier wrote:
but you need the document compatibility software update from Microsoft 
first.



...for your Excel installation?


tia, Dave!
--Mike

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/d22c3732e51f50e9f16d7f5d65e4a...@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: [NF] Interesting post about foreign keys in SQL