Re: [NF] What would you miss from VFP, when migrating

[MB Software Solutions, LLC]

Yeah, that'd suck.  I guess you'd have to loop through record sets like ADO

FOR MyLoop = 1 to MyRecordSet.Recordset.Count

ENDFOR

??? "This sucks"

On 6/27/2019 4:45 PM, John Weller wrote:

I think I would miss SCAN/ENDSCAN most.

John

John Weller
01380 723235
07976 393631




[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/99eabb06-705c-cc91-367a-f448cc722...@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] What would you miss from VFP, when migrating

[MB Software Solutions, LLC]

Knew you'd post that.  I win my bets.  lol

Careful consideration is always made so thanks for the humor nonetheless.


On 6/27/2019 4:10 PM, Stephen Russell wrote:

Thanks.

It gives me a chuckle like this:
https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/be49e3a0-7670-4efd-85a7-c4e98cd85...@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] What would you miss from VFP, when migrating

[MB Software Solutions, LLC]

In my largest case, it's usually helping to build SQLs dynamically 
depending on a number of variables.  In other cases, it's for building a 
SET FILTER command which then gets executed.



On 6/27/2019 3:43 PM, Stephen Russell wrote:

Am I missing something about TEXT/ENDTEXT where it just mashes up a string
for you for whatever transpires within the loop?

What do you do with that output or the textmerge when you are done with
it?

On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:


Steve Ellenoff and I were talking the other day about the beauty of
TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or
earlier versions anyway).  I use TEXT/ENDTEXT *HEAVILY* in code often.


On 6/27/2019 8:51 AM, Johan Nel wrote:

Hi VFPers

I have asked this question on foxite too with very little feedback, so
I am asking it here too.

If you have to summarize the 1 or 2 features of VFP that you will feel
is a step backwards when migrating to .NET or any other platform as a
move forwards.

Looking forward to your replies.

Two things that was highlighted on Foxite:

1. Macro-compilation
2. Evaluate(

Re: [NF] What would you miss from VFP, when migrating

[MB Software Solutions, LLC]

Steve Ellenoff and I were talking the other day about the beauty of 
TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or 
earlier versions anyway).  I use TEXT/ENDTEXT *HEAVILY* in code often.



On 6/27/2019 8:51 AM, Johan Nel wrote:

Hi VFPers

I have asked this question on foxite too with very little feedback, so 
I am asking it here too.


If you have to summarize the 1 or 2 features of VFP that you will feel 
is a step backwards when migrating to .NET or any other platform as a 
move forwards.


Looking forward to your replies.

Two things that was highlighted on Foxite:

1. Macro-compilation
2. Evaluate(

Re: VFP 9 SP fix lists

[MB Software Solutions, LLC]

On 6/11/2019 11:52 AM, Tracy Pearson wrote:

Thank you Ted. Still can't find what I'm looking for.

Related to why I'm looking for this information is Error 2103.
It seems this will popup when VFP 9 SP 1 is installed, but not VFP 9 SP 2
Hotfix 3 is installed.
Some code, just different runtimes registered on the PC.



In a Citrix or Terminal Server environment, right?



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/63b3275a-4aa6-6fc3-68eb-78050be9c...@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: Grid and DynamicForeColor

[MB Software Solutions, LLC]

Sorry, I don't have the solution off hand, but I'm thinking it's due to 
the Highlight properties.   ???


On 6/11/2019 6:55 AM, Paul Newton wrote:

Hi all

I have a grid on which I have set DynamicForeColor and all works fine EXCEPT that the 
cell in the grid which has current focus does not respect the DynamicForeColor setting.  
I have SetAll("SelectOnEntry",.F.) but that makes no difference.  Any ideas how 
to fix this?

Many thanks

Paul Newton


[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/97ad80f9-c8a0-93d2-ca7e-e38acc42b...@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: [OT] X# progress report - June 2019

[MB Software Solutions, LLC]

This would be [NF] for Not-FoxPro but still technical.  [OT] is 
off-topic for usually crap like politics.


On 6/6/2019 11:28 AM, Johan Nel wrote:

Hi VFPers,

Just announced on the X# webpage, work on the VFP repos will start in 
earnest once this build is released. WITH, TEXT...ENDTEXT, USING etc. 
already part of the in progress tasks of the next compiler.


ANNOUNCEMENT - Created: 06 June 2019

Just a quick message about our progress in the RDD system and other 
areas of the product.


The DBFCDX RDD is now working, and we have also added a DBFVFP RDD 
that allows you to read and update Visual Foxpro DBF files. DBFVFP is 
not completely ready yet (for example AutoIncrement fields are not 
automatically updated) but complete enough to allow to read VFP 
tables. We support Binary and Nullable fields, and new datatypes such 
as Currency, DateTime, Double and more.


Further we made some changes to the compiler. We have started work on 
the FoxPro dialect and we now suppress including the Vulcan Header 
files if you are having a reference to SDKDEFINES.DLL or the relevant 
X# SDK files. This should make compile speed somewhat faster. Of 
course it is better to remove the #includes when you don't need them 
anymore.


We expect that we can publish a new build (for our FOX subscribers 
only) by the end of next week.


We expect to release the complete runtime early July.

And don't forget the special "Spring" discount of 25% for new FOX 
subscribers.




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/e19bc1e2-008f-fbf1-2f3a-eff3fe4ed...@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.

[NF] Fun with Table of Contents in MS Word 2016 (...NOT FUN)

[MB Software Solutions, LLC]

Inherited somebody's document, needed to make edits, but when I rebuild 
the content, the TOC puts the Section# just ahead of the PageNumber when 
imaging the page# on the far right.  See screenshot: 
https://www.screencast.com/t/46q8EBqzE


Anybody come across and slay this beast in the past??!!??

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/c68e9046-c929-f640-89fb-944bfbf50...@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.

[NF] What do you think of Microsoft?

[MB Software Solutions, LLC]

Got this survey in email today: https://www.screencast.com/t/Ngn4iWC6H

Was going to send it back with a Pro-Fox (get it...hahaha) message.

lol



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/1b293ae5-97f0-fc62-0653-1aa71560f...@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: ? Cross tabulation

[MB Software Solutions, LLC]

Ah the good ol' days.  Still great content.

Too bad M$ didn't keep the Fox going.   What a great toolstill to 
this day.



On 5/21/2019 1:44 PM, Ted Roche wrote:

(Replying to Eric because I never see Paul's original posts)

July 2006 Advisor Answers:
http://www.tomorrowssolutionsllc.com/Articles/Create%20Cross-tabs.PDF

and the FoxWiki Tamar references:

http://fox.wikis.com/wc.dll?Wiki~CrossTab~VB
http://fox.wikis.com/wc.dll?Wiki~MatXTab (with download link)


On Tue, May 21, 2019 at 10:28 AM Eric Selje  wrote:


There's a cross-tab wizard that comes with VFP, but I'd look at this VFPX
project: https://github.com/VFPX/FastXTab

Eric


On Tue, May 21, 2019 at 8:43 AM Paul Newton 
wrote:


Hi all

I have data like this:
Tablename   Auditdate   Auditsize
CTRAN   01/01/2019  25
PTRAN   01/01/2019  30
STRAN   01/01/2019  35
CTRAN   01/02/2019  30
PTRAN   01/02/2019  35
STRAN   01/02/2019  40
CTRAN   01/03/2019  35
PTRAN   01/03/2019  40
STRAN   01/03/2019  45

And I want to process it in such a way that it ends up like this

TableName   01/01/2019  01/02/2019  01/03/2019
CTRAN   25  30  35
PTRAN   30  35  40
STRAN   35  40  45

I realise that the dates would have be converted to valid field names.
Anybody have ideas/suggestions?  Does anybody know of a tool that would
achieve this?

Many thanks

Paul Newton


[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/efb69086-83d4-9b27-46db-84ed4379a...@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] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

[MB Software Solutions, LLC]

Excellent reply!

Reminds me of this: 
https://www.google.com/search?q=No+I+will+not+fix+your+PC&client=avast&source=lnms&tbm=isch&sa=X&ved=0ahUKEwi_7cOMqq3iAhUE16wKHTfPCecQ_AUIDigB&biw=1904&bih=996



On 5/21/2019 3:09 PM, Eric Selje wrote:

And as a programmer, can you fix my iPhone?

On Tue, May 21, 2019 at 12:32 PM Kurt @ Gmail  wrote:


Mike - how DARE you make a comment like that! You're a programmer - and
ALL code should look Easy to you!!! No???

:-)

-K-


On 5/21/2019 8:49 AM, MB Software Solutions, LLC wrote:

Ouch...that gives me a headache just trying to decipher that!


On 5/21/2019 4:36 AM, Johan Nel wrote:

And straight from the .NET runtime, the culprit is  drum
rolling..  BestFitMapping = false :-)

[DllImport("user32.dll", BestFitMapping = false, CharSet =
CharSet.Auto, SetLastError = true)]
[SuppressUnmanagedCodeSecurity]
[SecurityCritical]
public static extern int MessageBox(HandleRef hWnd, string text,
string caption, int type);

On 2019/05/20 23:52, MB Software Solutions, LLC wrote:

GRR! I've got a colossal cleanup to do with bookmark
references and this freaking window refuses to enlarge in any
direction: https://www.screencast.com/t/PTDtv8bVI

C'MON, M$!!!  NOT TODAY!


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/a65197cf-20c6-f54b-4c60-2f11f0df8...@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] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

[MB Software Solutions, LLC]

Ouch...that gives me a headache just trying to decipher that!


On 5/21/2019 4:36 AM, Johan Nel wrote:
And straight from the .NET runtime, the culprit is  drum 
rolling..  BestFitMapping = false :-)


[DllImport("user32.dll", BestFitMapping = false, CharSet = 
CharSet.Auto, SetLastError = true)]

[SuppressUnmanagedCodeSecurity]
[SecurityCritical]
public static extern int MessageBox(HandleRef hWnd, string text, 
string caption, int type);


On 2019/05/20 23:52, MB Software Solutions, LLC wrote:
GRR! I've got a colossal cleanup to do with bookmark 
references and this freaking window refuses to enlarge in any 
direction: https://www.screencast.com/t/PTDtv8bVI


C'MON, M$!!!  NOT TODAY!


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/ae9daa25-4042-1077-5fdf-8df34990f...@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.

[NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016

[MB Software Solutions, LLC]

GRR!  I've got a colossal cleanup to do with bookmark references 
and this freaking window refuses to enlarge in any direction: 
https://www.screencast.com/t/PTDtv8bVI


C'MON, M$!!!  NOT TODAY!


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/3506ed33-88cb-586b-fd7b-d40b388d3...@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: Changing VFP menu (during runtime in app) FONT NAME

[MB Software Solutions, LLC]

Can you post a screenshot of your finished design running, Charlie?  
Just of the pseudo-toolbar, I mean.



On 5/20/2019 9:30 AM, Charlie-gm wrote:


Just as a quick aside - and this does NOT answer the original 
question, but...


When I wanted to spruce up the application menu system, I started 
using the toolbar class. And if you put a container object inside the 
toolbar, and put all your menu "objects" inside that container, you 
can get fine control over placement (give things more or less spacing, 
etc). From there you can do all the usual events and stuff (like 
moving/resizing/changing fonts of objects in the "menu" based on 
events, etc). So you could put text objects (or labels even?) in that 
container, decorate as desired, trap the click event and call your 
pop-up menu where you do have better font control, and so on. The 
toolbar class does NOT have to be used to make "button" type menus.


HTH,
-Charlie


On 5/20/2019 8:36 AM, MB Software Solutions, LLC wrote:
Thanks for the link, Koen.  I'll check that out.  Yeah, I vaguely 
recall learning the main menu font was not able to be changed. This 
is an area where FoxPro obviously shows its age.



On 5/18/2019 4:44 AM, Koen Piller wrote:

Hi,
You cannot change the font in the mainmenu, this object will always 
take
the font you have stipulated in your windows settings. You can 
change the
submenu's font, by changing the .mpr file. Be sure after you have 
done that

not to invoke the default menudesigner anymore as this will reset your
fontsettings.
An other possibility is to study Yousfi's blog on this subject:
http://yousfi.over-blog.com/tag/menu/
Regards,
Koen

Op vr 17 mei 2019 om 06:28 schreef MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com>:


VFP9SP2 on Win7/8/10

I see in VFP Help that if you're stick building your app's top
positioned (not-pop-up) Menu code by hand, it has a FONT clause.
However, I use the good ol' fashioned Menu designer (as clunky as it
is).  I've introduced the ability for the user to pick the Font s/he
wants in my app now and have that working great for the forms 
UI...but I
want to get the top menu using the same Font Name.  I realize 
MESSAGEBOX

fonts are a different beast so that's a different time. Here's a
screenshot: https://www.screencast.com/t/kWLEGwE9G

But the VFP menu:  I adjusted the MyMenu.MPR file like below:
https://www.screencast.com/t/U7ptKp7rrxV

...but that didn't work.  Plus, to make it worse, when I rebuilt all
files in the project, those font command changes went away.

Ideas?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/e6c2b15f-1bdf-aa87-ad35-f71b42e65...@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: Changing VFP menu (during runtime in app) FONT NAME

[MB Software Solutions, LLC]

Yeah I recall dumping the toolbar class honestly probably 15+ years ago 
as it was difficult (I thought) to work with due to something at the time.


On 5/20/2019 9:30 AM, Charlie-gm wrote:


Just as a quick aside - and this does NOT answer the original 
question, but...


When I wanted to spruce up the application menu system, I started 
using the toolbar class. And if you put a container object inside the 
toolbar, and put all your menu "objects" inside that container, you 
can get fine control over placement (give things more or less spacing, 
etc). From there you can do all the usual events and stuff (like 
moving/resizing/changing fonts of objects in the "menu" based on 
events, etc). So you could put text objects (or labels even?) in that 
container, decorate as desired, trap the click event and call your 
pop-up menu where you do have better font control, and so on. The 
toolbar class does NOT have to be used to make "button" type menus.


HTH,
-Charlie


On 5/20/2019 8:36 AM, MB Software Solutions, LLC wrote:
Thanks for the link, Koen.  I'll check that out.  Yeah, I vaguely 
recall learning the main menu font was not able to be changed. This 
is an area where FoxPro obviously shows its age.



On 5/18/2019 4:44 AM, Koen Piller wrote:

Hi,
You cannot change the font in the mainmenu, this object will always 
take
the font you have stipulated in your windows settings. You can 
change the
submenu's font, by changing the .mpr file. Be sure after you have 
done that

not to invoke the default menudesigner anymore as this will reset your
fontsettings.
An other possibility is to study Yousfi's blog on this subject:
http://yousfi.over-blog.com/tag/menu/
Regards,
Koen

Op vr 17 mei 2019 om 06:28 schreef MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com>:


VFP9SP2 on Win7/8/10

I see in VFP Help that if you're stick building your app's top
positioned (not-pop-up) Menu code by hand, it has a FONT clause.
However, I use the good ol' fashioned Menu designer (as clunky as it
is).  I've introduced the ability for the user to pick the Font s/he
wants in my app now and have that working great for the forms 
UI...but I
want to get the top menu using the same Font Name.  I realize 
MESSAGEBOX

fonts are a different beast so that's a different time. Here's a
screenshot: https://www.screencast.com/t/kWLEGwE9G

But the VFP menu:  I adjusted the MyMenu.MPR file like below:
https://www.screencast.com/t/U7ptKp7rrxV

...but that didn't work.  Plus, to make it worse, when I rebuilt all
files in the project, those font command changes went away.

Ideas?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/93b20071-949d-bf55-85f7-44c8790b4...@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: Changing VFP menu (during runtime in app) FONT NAME

[MB Software Solutions, LLC]

Thanks for the link, Koen.  I'll check that out.  Yeah, I vaguely recall 
learning the main menu font was not able to be changed. This is an area 
where FoxPro obviously shows its age.



On 5/18/2019 4:44 AM, Koen Piller wrote:

Hi,
You cannot change the font in the mainmenu, this object will always take
the font you have stipulated in your windows settings. You can change the
submenu's font, by changing the .mpr file. Be sure after you have done that
not to invoke the default menudesigner anymore as this will reset your
fontsettings.
An other possibility is to study Yousfi's blog on this subject:
http://yousfi.over-blog.com/tag/menu/
Regards,
Koen

Op vr 17 mei 2019 om 06:28 schreef MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com>:


VFP9SP2 on Win7/8/10

I see in VFP Help that if you're stick building your app's top
positioned (not-pop-up) Menu code by hand, it has a FONT clause.
However, I use the good ol' fashioned Menu designer (as clunky as it
is).  I've introduced the ability for the user to pick the Font s/he
wants in my app now and have that working great for the forms UI...but I
want to get the top menu using the same Font Name.  I realize MESSAGEBOX
fonts are a different beast so that's a different time.  Here's a
screenshot: https://www.screencast.com/t/kWLEGwE9G

But the VFP menu:  I adjusted the MyMenu.MPR file like below:
https://www.screencast.com/t/U7ptKp7rrxV

...but that didn't work.  Plus, to make it worse, when I rebuilt all
files in the project, those font command changes went away.

Ideas?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/8105f258-5d79-3e4e-1ccd-17e3f832d...@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.

Changing VFP menu (during runtime in app) FONT NAME

[MB Software Solutions, LLC]

VFP9SP2 on Win7/8/10

I see in VFP Help that if you're stick building your app's top 
positioned (not-pop-up) Menu code by hand, it has a FONT clause. 
However, I use the good ol' fashioned Menu designer (as clunky as it 
is).  I've introduced the ability for the user to pick the Font s/he 
wants in my app now and have that working great for the forms UI...but I 
want to get the top menu using the same Font Name.  I realize MESSAGEBOX 
fonts are a different beast so that's a different time.  Here's a 
screenshot: https://www.screencast.com/t/kWLEGwE9G


But the VFP menu:  I adjusted the MyMenu.MPR file like below: 
https://www.screencast.com/t/U7ptKp7rrxV


...but that didn't work.  Plus, to make it worse, when I rebuilt all 
files in the project, those font command changes went away.


Ideas?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/1753fe63-abb2-6c57-1b97-b94c971c2...@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: Filtering Oddity

[MB Software Solutions, LLC]

Hi Koen,

I respectfully disagree.  In my case, I grabbed all of the Server data 
locally into a cursor, and then I use the SET FILTER on that to show the 
respective data when appropriate. This is better than repeat trips to 
the Server via the SQL SELECT.  I'll take that bet every day of the week 
that ends in 'y' .   ;-)



On 5/16/2019 1:26 AM, Koen Piller wrote:

Richard,
what you describe is a matter of personal taste.
There is no overhaed in building a cursor with select * from myData where
unpaid<>0 into cursor curUnpaid  vs set fillter to unpaid <> 0 in myData.
I, personaly, would prefer #1 in the enduser environment environment# 2 in
my development environment - version(2)#0 vs version(2)=0.
There is also no need to call a select() statement an overhead.
Regards,
Koen



Op do 16 mei 2019 om 00:23 schreef Richard Kaye :


And here's a use case where SET FILTER can be quite useful in a production
application. Let's say you have a form that displays account receivable
transactions for a customer (invoices, payments, adjustments, etc.). You
want to be able to display only open (i.e. unpaid) transactions or
transactions related to a specific invoice. The primary query has returned
all the rows I need to display for that customer. SET FILTER handles that
quickly and simply without the overhead of running another query against
the main database.

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Gene
Wirchenko
Sent: Wednesday, May 15, 2019 2:55 PM
To: profoxt...@leafe.com
Subject: RE: Filtering Oddity

At 11:41 2019-05-15, Richard Kaye  wrote:

Gene and Woody's point is that XBASE tools are quite useful for us when
developing/testing, not that they are necessarily preferable for
production code.

   Exactly.

   One advantage that is particularly nice is that they are often
short, simple, and fast.  When I am chasing a bug or working on an idea, I
prefer being able to get done what I want done fast.  The protections that
one might well want for an app are often not relevant.

[snip]

Sincerely,

Gene Wirchenko



[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/f8c0cb63-eadf-9959-2082-0c3da5843...@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: Filtering Oddity

[MB Software Solutions, LLC]

On 5/15/2019 6:23 PM, Richard Kaye wrote:

And here's a use case where SET FILTER can be quite useful in a production 
application. Let's say you have a form that displays account receivable 
transactions for a customer (invoices, payments, adjustments, etc.). You want 
to be able to display only open (i.e. unpaid) transactions or transactions 
related to a specific invoice. The primary query has returned all the rows I 
need to display for that customer. SET FILTER handles that quickly and simply 
without the overhead of running another query against the main database.

--

rk


EXACTLY!!!  That's been (part of) the beauty of FoxPro for years, 
something other programs didn't (and perhaps still don't) have.




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/246d31ad-762d-3b18-c965-5244d1193...@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: How would you generate this report?

[MB Software Solutions, LLC]

How do you dynamically add the rows?  Via Office Automation code?  If 
so, care to share?



On 5/15/2019 4:54 PM, Frank Cazabon wrote:
I do stuff like that using Bookmarks in a Word template and automating 
their replacement.


Frank.

Frank Cazabon

On 15/05/2019 03:05 PM, MB Software Solutions, LLC wrote:
Screenshot of Word document in question (with notations for where 
content is dynamic; some parts blurred just to protect the players): 
https://www.screencast.com/t/vOJd9eBwPaX


Currently, my colleague did so many of these documents MANUALLY in 
Word.  I'd pull my hair out if I had to do that, especially since 
I've got VFP.  The trick here is to dynamically enter the names for 
each letter to an organization.  Each organization can have 1:M names 
in this report.


The quick thought is a VFP FRX Report, using XFRX (or something else) 
to save the output to a Word document.  And given that the text above 
the dynamic organization name and user names/emails part is static, I 
could do it.  But like you've probably encountered before, I don't 
like to force the Line-breaks in the VFP Report Writer if I can avoid 
it (PITA).


So how would you produce these dynamic Word documents easily?

Flattened cursor for this would have this structure:

 * OrgName
 * OrgID (e.g., P0135)
 * Name
 * Email
 * AcctType

That's it.  User would select the Yes/No values and return to us. 
Task here is generated these 100 reports without having to manually 
do it (and obviously avoid the human error factor).


tia,
--Mike




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/c80d9bd1-700f-80a2-b835-6c9bde045...@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: How would you generate this report?

[MB Software Solutions, LLC]

Thanks for the 2 cents, Kevin!

Still wanting to output these to Word documents though for end-user 
familiarity.  We email these documents to 100 organizations currently.  
Better design would be some sort of integration into our website but 
that's Version .Next.



On 5/15/2019 4:46 PM, Kevin Cully wrote:
I've been creating my "reports" in HTML lately as a flexible, wicked 
fast way of producing output.  With CSS you have great control over 
looks and layout.  Images, no problem.  Links, no problem. Content 
wrapping, no problem.  Page breaks, no problem. The only issue is full 
control over headers and footers ... to an extent. It's what I use to 
create invoices with.


$0.02.

-Kevin



On 05/15/2019 03:05 PM, MB Software Solutions, LLC wrote:
Screenshot of Word document in question (with notations for where 
content is dynamic; some parts blurred just to protect the players): 
https://www.screencast.com/t/vOJd9eBwPaX


Currently, my colleague did so many of these documents MANUALLY in 
Word.  I'd pull my hair out if I had to do that, especially since 
I've got VFP.  The trick here is to dynamically enter the names for 
each letter to an organization.  Each organization can have 1:M names 
in this report.


The quick thought is a VFP FRX Report, using XFRX (or something else) 
to save the output to a Word document.  And given that the text above 
the dynamic organization name and user names/emails part is static, I 
could do it.  But like you've probably encountered before, I don't 
like to force the Line-breaks in the VFP Report Writer if I can avoid 
it (PITA).


So how would you produce these dynamic Word documents easily?

Flattened cursor for this would have this structure:

 * OrgName
 * OrgID (e.g., P0135)
 * Name
 * Email
 * AcctType

That's it.  User would select the Yes/No values and return to us. 
Task here is generated these 100 reports without having to manually 
do it (and obviously avoid the human error factor).


tia,
--Mike




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/9330e9cb-05b0-1c09-ff5e-1a1ebdc55...@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.

How would you generate this report?

[MB Software Solutions, LLC]

Screenshot of Word document in question (with notations for where 
content is dynamic; some parts blurred just to protect the players):  
https://www.screencast.com/t/vOJd9eBwPaX


Currently, my colleague did so many of these documents MANUALLY in 
Word.  I'd pull my hair out if I had to do that, especially since I've 
got VFP.  The trick here is to dynamically enter the names for each 
letter to an organization.  Each organization can have 1:M names in this 
report.


The quick thought is a VFP FRX Report, using XFRX (or something else) to 
save the output to a Word document.  And given that the text above the 
dynamic organization name and user names/emails part is static, I could 
do it.  But like you've probably encountered before, I don't like to 
force the Line-breaks in the VFP Report Writer if I can avoid it (PITA).


So how would you produce these dynamic Word documents easily?

Flattened cursor for this would have this structure:

 * OrgName
 * OrgID (e.g., P0135)
 * Name
 * Email
 * AcctType

That's it.  User would select the Yes/No values and return to us.  Task 
here is generated these 100 reports without having to manually do it 
(and obviously avoid the human error factor).


tia,
--Mike




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/5e9413df-b3db-21ed-3392-848e4bf27...@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: Old Andy Kramek trick from WhilFest years ago...I can't recall exactly how he said it

[MB Software Solutions, LLC]

On 5/7/2019 8:13 PM, Gene Wirchenko wrote:
 I set .lockscreen to .t. at the beginning of instantiating a form 
and back to .f. after the setup.  I have not looked at the speed-up 
recently, but in my testing years ago, it made about a 20% difference.


 I do not use it otherwise.



When you say "after the Setup", Gene, what event is that...Show() ?


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/ace1d633-634c-41a8-ed3d-0c401a6d0...@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: Old Andy Kramek trick from WhilFest years ago...I can't recall exactly how he said it

[MB Software Solutions, LLC]

Hi Tracy,

No, that's not it.  I use thisform.lockscreen now.  It was something 
more "nifty" or "crafty" with his approach.


I don't have any issues really; was just trying to remember what was 
"cool" about his trick/tip that was better than Thisform.refresh.  Just 
curiosity.


Thanks,
--Mike


On 5/7/2019 4:20 PM, Tracy Pearson wrote:

Both ThisForm and _Screen have the LockScreen property.
If you are updating a lot of things, you can flip it to .T. then flip it back 
to .F. when done.

Remember, if you _Screen.LockScreen, then the user moves the form, it leaves 
bits of the form outline behind.

I've never changed the visibility of _Screen after I made it visible.

Oh, if there is an ActiveX object on the form, LockScreen does nothing to help 
it. Some of them may expose the right hWnd value to allow you to use the API 
for it.

HTH,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: Tuesday, May 07, 2019 4:04 PM
To: profoxt...@leafe.com
Subject: Old Andy Kramek trick from WhilFest years ago...I can't recall exactly 
how he said it

Years ago (2003?) at WhilFest (Great Lakes Great Databases Workshop),
speaker and Fox great Andy Kramek showed us some cool alternate
refresh/repaint routine, and I think it was where he said LockScreen =
.T. and then set the _screen.visible = .F., but can't recall.

Does anybody remember that?  This is one of those things that has always
bugged me and I wanted to get resolution on it.

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/90136828-4388-f823-8bc6-a5b60641c...@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.

Old Andy Kramek trick from WhilFest years ago...I can't recall exactly how he said it

[MB Software Solutions, LLC]

Years ago (2003?) at WhilFest (Great Lakes Great Databases Workshop), 
speaker and Fox great Andy Kramek showed us some cool alternate 
refresh/repaint routine, and I think it was where he said LockScreen = 
.T. and then set the _screen.visible = .F., but can't recall.


Does anybody remember that?  This is one of those things that has always 
bugged me and I wanted to get resolution on it.


tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/1e79963a-f725-3c6f-968d-f4883a652...@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: Error on Win10 machine invoking IE in code from VFP9SP2 app

[MB Software Solutions, LLC]

On 4/26/2019 11:36 AM, Alan Bourke wrote:

investigate any other instances of IE
besides version 11 on their machine.
  


What I mean is if they open Task Manager (or go out to an administrator prompt 
and do 'tasklist') are there a whole load of IEXPLORE.EXE listed ?



I'll check.  On mine, which runs fine, I did the tasklist and noticed 6 
instances of iexpore.exe listed.  So what?  Not sure how that matters 
since mine works fine and shows multiple instances running.



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/07b6e0f3-85e7-00ea-56f5-61e12e0b1...@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: Error on Win10 machine invoking IE in code from VFP9SP2 app

[MB Software Solutions, LLC]

Hi Alan/Tracy,

I suspect there's some afoul in the registry.  I'm suggesting they run 
CCleaner and have their IT guy investigate any other instances of IE 
besides version 11 on their machine.



On 4/26/2019 11:31 AM, Tracy Pearson wrote:

Have you checked the Registry to verify that entry exists? 
HKEY_CLASSES_ROOT\InternetExplorer.Application

Following the CLSID in the Wow6432Node on my 64-bit Windows 10 system I find the 
HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{0002DF01---C000-0046}\LocalServer32 
points to a very odd util. "%ProgramFiles(x86)%\Internet 
Explorer\ielowutil.exe" -CLSID:{0002DF01---C000-0046}

It's possible the program has been uninstalled, or didn't ship with the PC when 
it was new.

But I've had my computer since it was running Windows 7, so IE is still 
installed.

HTH,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: Friday, April 26, 2019 11:16 AM
To: profoxt...@leafe.com
Subject: Error on Win10 machine invoking IE in code from VFP9SP2 app

VFP9SP2 app running on Win10 Pro, build 1809.

See https://www.screencast.com/t/pFvzYl2H7ZX6. These users are all
running Windows 10, and my app works on all machines but 1.  I tracked
it down (via vRunFox!) to the line that creates an instance of Internet
Explorer:  oIE = createobject("internetexplorer.application")

This code has been running fine for nearly 15 years.  Ideas?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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/cbba079e-fd48-a9bc-8a46-aebaedaf4...@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.

Error on Win10 machine invoking IE in code from VFP9SP2 app

[MB Software Solutions, LLC]

VFP9SP2 app running on Win10 Pro, build 1809.

See https://www.screencast.com/t/pFvzYl2H7ZX6. These users are all 
running Windows 10, and my app works on all machines but 1.  I tracked 
it down (via vRunFox!) to the line that creates an instance of Internet 
Explorer:  oIE = createobject("internetexplorer.application")


This code has been running fine for nearly 15 years.  Ideas?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/51aea5e1-fbbe-5335-76b2-c4e335310...@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: FoxPro Job

[MB Software Solutions, LLC]

There you go, Stephen...back in the car business...and you were a SBT 
guy, weren't you???



On 4/24/2019 4:39 PM, Eric Selje wrote:

Matthew Bergman from ProAmMotors is looking for some help.

matt...@proamotors.com

He says "*We are currently looking for a way to import orders via a CSV
file into SBT.*"

If anyone can help him, shoot him an email.

Eric


--- 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/efef0d11-e317-9cab-2449-5e74c93c3...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

On 4/24/2019 4:45 AM, Alan Bourke wrote:

On Tue, 23 Apr 2019, at 5:04 PM, Fletcher Johnson wrote:


The second is much more critical.  If the price of an item changes,
when an invoice is printed, it needs to show the price in effect when
it was printed.  If I sell something today, the current price is
usually appropriate.  But if I re-print an invoice from last month, I
need to know the price (and quite likely, other values) in effect at
that time.  In other words, time is just one more critical data point
used to identify the correct data.

The downside to the first is that, unless you re-write your code, the
solution requires either triggers or stored procs - both of which
require a DBA (in most work environments.)

The downside to the second is that not only will it require a dba
(structure changes),

In the case of re-printing an invoice, store the price at the time of initial 
creation in your invoice line details table and use that when reprinting. Or 
store a PDF of the emailed\printed invoice, and re-use that.



Yeah, you definitely need to store the price used at the time of 
creation, imo.  That's how I do it in FabMate/FabNet.  I'd never rely on 
the lookup code for pricing in jobs.



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/a73eba56-f182-ce59-aaee-444e28206...@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: [ADMIN] SSL Issues

[MB Software Solutions, LLC]

On 4/23/2019 3:36 PM, Ted Roche wrote:

I've been maintaining a 16-year-old blog and it is AMAZING how few links
are left.
I've got a great plugin that makes expired links pretty easy to manage,
even suggesting a matching archive.org site when available.



I'm sure that at least 23.7% of the links out there on the interweb are 
dead links, for whatever reason.  (Then again, 81.5% of statistics are 
made up on the spot, right?  lol)


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/de1b497b-8783-9e15-7209-e12b5343e...@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.

Fwd: Re: [ADMIN] Replies going right to the user instead of the group

[MB Software Solutions, LLC]

Figured it out.  I was hitting the Reply button instead of Reply List 
button in Thunderbird.  That'll take some getting used to.




 Forwarded Message 
Subject:Re: [ADMIN] Replies going right to the user instead of the group
Date:   Fri, 19 Apr 2019 17:20:52 -0400
From: 	MB Software Solutions, LLC 


To: Ted Roche 



On 4/19/2019 10:49 AM, Ted Roche wrote:
Many mailing lists have this defect, but ProFox does not. You likely 
have a

defective or misconfigured email client, which is replying to the From:
address and not the Reply-To:

Reply-To: profox@leafe.com
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:60.0) Gecko/20100101
Thunderbird/60.6.1



Strange...I'm using the latest Mozilla Thunderbird out of the box 
(nothing special).




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--- 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/23b16676-5b14-26b8-fa28-a6298b146...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

On 4/22/2019 5:06 PM, Eric Selje wrote:

Yes, absolutely appropriate for an ONUPDATE trigger. Insert a new record
into the history table before doing the update.

If you want to do this for every field in every table, FoxAudit is the tool
of choice. (I don't see it on TakeNote.com's website any more but maybe
shoot an email to Jim Duffy)



I recall FoxAudit, but I use MySQL backends for nearly all of my work.  
I avoid DBFs unless I inherit them.


Thanks though!

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/3a657105-07d5-e52c-8ed8-a5f705f45...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

On 4/22/2019 6:13 PM, Frank Cazabon wrote:

Yeah, my succinct point :) was I didn't think it should be a log but a table 
that allows edits. You can then put an audit trail on that if you want or need.



Would it be just another update?  Yeah, kind of a wasted row but still, 
why break process?



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/4976cf33-7c90-a129-4b8b-c49fcd4d8...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

On 4/22/2019 7:19 PM, Johan Nel wrote:
Well I use PostgreSQL and my believe is that updates should be handled 
by the DB itself, e.g. an administrator doing updates directly to the 
DB without using the UI application...  All my tables have 
INSERT/UPDATE columns: usr_ins, usr_upd, dt_ins, dt_upd that are 
trigger populated based on the login details. When rows are 
updated/deleted, the old row is TRIGGER driven to be inserted in a 
_audit with the same columns as the live table plus an 
"audit_no" and  "trg_op"="U|D".


Very easy then to have a view of db changes and even do rollbacks to a 
certain Point in time (which will even be logged in the audit table 
with no software interaction needed).



Hi Johan,

Yeah, I was wondering if I'd do some sort of hardcoded logic in the 
UPDATE/DELETE triggers for this.  I wanted to get the logged-in User's 
ID in the history table so we know who changed it.  Was thinking of 
creating a Session variable upon establishing connection to the MySQL 
(MariaDB) database and then referencing that @Session.MyUserID in the 
UPDATE/DELETE trigger code.  See any problems with that approach?


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/f8f43f46-8e28-f4b9-761b-8ca88d39b...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

Even if somebody's built it for MySQL, I'd still have to code my VFP app 
to query that History table to show the changes made by who and when.



On 4/22/2019 4:05 PM, Paul H. Tarver wrote:

I did a project many moons ago where we used the INSERT, UPDATE and DELETE 
triggers in a Foxpro 6.0 DBC to track field level changes by users by date and 
time. It was fairly successful other than making our data very dependent upon 
maintaining a valid DBC. Later, we extended program by adding a connection to a 
FirebirdSQL database which was then use by a Java-based web front-end. In the 
case of Firebird, I found a tools called IBLogManager which did the same thing 
at a SQL level using the same sorts of triggers.

I wonder if someone hasn't already created a similar tool for MySQL that you 
could take advantage of.

Paul H. Tarver


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: Monday, April 22, 2019 2:34 PM
To: profoxt...@leafe.com
Subject: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR 
A DBA)

VFP9SP2 app, MariaDB 10 (MySQL) backend.

One of my clients asked about a history of price changes.  Easy enough
to implement programmatically for the few price fields, but then I got
to wondering if simply putting code in the ON UPDATE trigger to send the
old record to a "history" table would be a more complete (and long term
EASIER) solution, whereby my app would query the "history" table for
changes.

Your thoughts for tracking price (or other) changes?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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/f699f2ca-8882-f5f3-cec8-3c7255dfa...@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.

How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

VFP9SP2 app, MariaDB 10 (MySQL) backend.

One of my clients asked about a history of price changes.  Easy enough 
to implement programmatically for the few price fields, but then I got 
to wondering if simply putting code in the ON UPDATE trigger to send the 
old record to a "history" table would be a more complete (and long term 
EASIER) solution, whereby my app would query the "history" table for 
changes.


Your thoughts for tracking price (or other) changes?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/44820f32-921d-b662-45cd-151a705bf...@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] Microsoft Dynamics

[MB Software Solutions, LLC]

On 4/19/2019 11:14 AM, Srikanth Bhandari wrote:

https://cdn.technologyadvice.com/wp-content/uploads/2015/03/technologyadvice-salesforce-dynamics-comparison.jpg

Take a look at this link.



Thanks!


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/cc281b40-2e99-806a-b99f-028b8f93d...@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.

[ADMIN] Replies going right to the user instead of the group

[MB Software Solutions, LLC]

Has anyone else noticed that when you hit Reply, it goes to the person 
and not ProFox@leafe.com?



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/ab23a670-9c8a-2bc9-1219-e10569e54...@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] Microsoft Dynamics

[MB Software Solutions, LLC]

What's the advantage then to using the MS-CRM?  Surely you're getting 
something for spending more $.  ???



On 4/19/2019 10:14 AM, Srikanth Bhandari wrote:

Your welcome Stephen.

I was referring to the SalesForce being readily available as a Hosted 
Solution in a Multi-tenanted model which is not the case with MS-CRM.


You have to buy the MS-CRM & have the same hosted on a Private/Public 
Cloud to suit the Organization's requirements. This would move up the 
costs in comparison to SalesForce.


You may host the MS-CRM on any Cloud including the Azure.

Feel free to let me know if you have any further queries.

--
Cheers!!!

*Srikanth Bhandari*
Mobile: +91 99625 42134 / +91 99001 39393
Email: consult...@srikanthbhandari.ind.in 
<mailto:consult...@srikanthbhandari.ind.in> / 
srikanth.bhanda...@gmail.com <mailto:srikanth.bhanda...@gmail.com>

Web: srikanthbhandari.ind.in <http://srikanthbhandari.ind.in/>


On Thu, Apr 18, 2019 at 1:57 PM MB Software Solutions, LLC 
<mailto:mbsoftwaresoluti...@mbsoftwaresolutions.com>> wrote:


Thanks, Srikanth!  I'm wondering if they can use Microsoft Azure for
hosting the data in the MS Cloud to lessen the cost?  When you say
"hosted by the Client Organization", do you mean that Corporate
actually
has a server in-house hosting this data?  I'm sure I'm mistaken
and it's
hosted in some private cloud somewhere.


On 4/18/2019 12:29 PM, Srikanth Bhandari wrote:
> Hi!
>
> I do have consulting experience in MS-CRM & Sales Force based on my
> in-house Experience to the same being implemented at a couple Client
> Organizations.
>
> Dynamics has an exclusive CRM Module as well as an ERP
Integrated once.
>
> MS-CRM is like an ERP in itself & requires to be configured from
scratch
> with capabilities for customization going to the extent of
creating custom
> fields. Has the capability to be set up for Data Exchange (EDI)
with other
> Applications.
>
> Unlike Salesforce offering Cloud capabilities on a multi-tenanted
> environment, bringing down the TCO, MS-CRM has to be hosted by
the Client
> Organization, which does increase the TCO substantially.
>
> SalesForce also has lower initial setup costs in comparison to
MS-CRM.
>
> --
> Cheers!!!
>
> *Srikanth Bhandari*
> Mobile: +91 99625 42134 / +91 99001 39393
> Email: consult...@srikanthbhandari.ind.in
<mailto:consult...@srikanthbhandari.ind.in> /
srikanth.bhanda...@gmail.com <mailto:srikanth.bhanda...@gmail.com>
> Web: srikanthbhandari.ind.in <http://srikanthbhandari.ind.in>
>
>
> On Wed, Apr 17, 2019 at 6:36 PM MB Software Solutions, LLC <
> mbsoftwaresoluti...@mbsoftwaresolutions.com
<mailto:mbsoftwaresoluti...@mbsoftwaresolutions.com>> wrote:
>
>> Any M$ Dymanics devs out there in ProFox land?  I'm wondering
if this is
>> M$'s equivalent to Salesforce?  We use Salesforce at my daytime
>> Corporate gig.  My former employer has implemented Microsoft
Dynamics to
>> replace the legacy VFP app (and it's going BADLY).
>>
>> Just thought I'd ask "the Fox room" for anyone with experience
to weigh
>> in on their thoughts of it.
>>
>> tia,
>> --Mike
>>
>>
>>
>> ---
>> This email has been checked for viruses by Avast antivirus
software.
>> https://www.avast.com/antivirus
>>
>>

[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/7a5a67ec-a594-a5ef-6f89-e1dfa81e6...@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.

[NF] Microsoft Dynamics

[MB Software Solutions, LLC]

Any M$ Dymanics devs out there in ProFox land?  I'm wondering if this is 
M$'s equivalent to Salesforce?  We use Salesforce at my daytime 
Corporate gig.  My former employer has implemented Microsoft Dynamics to 
replace the legacy VFP app (and it's going BADLY).


Just thought I'd ask "the Fox room" for anyone with experience to weigh 
in on their thoughts of it.


tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/0aa2e5f0-d99d-ee0b-18d0-55a1618e8...@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.

2-factor authentication in your apps

[MB Software Solutions, LLC]

I see I asked this 2 years ago but apparently no replies back then:  
https://leafe.com/archives/full_thread/509408


Do any of you use 2-factor authentication in your apps?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/03c7c2b1-8086-77cb-55af-8e0938351...@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.

ReFox branding (encryption)

[MB Software Solutions, LLC]

https://www.refox.net/help/rexbrand.html

Trying to decide which one to use.  I'm looking for comments from those 
who've used it (and hopefully still do) and why you chose what you did.


tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/37f847c0-b850-e64f-229f-4182ec67e...@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.

Your laptop

[MB Software Solutions, LLC]

Been 6 years on my Dell Latitude 5530.  Time to get a new one. What are 
all you cool kids using nowadays?  Do you recommend it?


tia,
--Mike


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/b16efb50-e2bc-5deb-cbcc-85a1c63b9...@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.

[NF] AdBlade popup windows a major annoyance at one of my clients

[MB Software Solutions, LLC]

Anybody seen this crap before?  Random popups on the desktop advertising 
junk:  https://www.screencast.com/t/iT8WbT46Jw


Investigating how to get rid of it.

tia,
--Mike


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/2d4170cf-0389-c2a5-bad8-a85f14902...@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.

[NF] Why don't more folks use RDP?

[MB Software Solutions, LLC]

(I asked this in a different thread but didn't want to hijack that one 
so I'm starting a new thread now.  Also, I searched for RDP in the 
ProFox archives for all time for both word and phrase and it found no 
matches.  Years ago Ed had to adjust the site for 3-letter-word searches 
(JVP anyone?) so I'm wondering if during his last migration this tweak 
got lost?)



Discussing RDP with a couple guys recently, I have to wonder why more 
don't go the RDP route?  Seems like a better setup with that central 
control.  The client I took over from Jeff Johnson (RIP) uses RDP and it 
sounds like a better option--no workstation computers, just thin clients 
so no maintenance time needed on those workstations.


Your thoughts on RDP?

tia,
--Michael


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/45b5f16e-c215-8518-849b-fcf1f3242...@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: FoxBin2Prg Form.Property = "" becomes .F.

[MB Software Solutions, LLC]

Hi Tracy,

Did you write something into a ProjectHook?  Care to share?  I'd like to 
integrate FoxBin2PRG too in my framework.  Just haven't gotten around to it.


tia,
--Mike


On 3/14/2019 10:48 AM, Tracy Pearson wrote:

I have just recently started to use FoxBin2Prg to store my VCX and SCX files
as text versions in Git.
Some of my forms have properties set to a have nothing in it. VFP displays
this as "(none)".

When I use FoxBin2Prg to put this particular form in to the SC2 form, the
back to the SCX form this property becomes a .F.

Just putting this out there for those that might use this tool.

Tracy



[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/662d87a5-0315-053e-eb0e-632857348...@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: VFP9SP2 on Win7 error trying to maximize memory

[MB Software Solutions, LLC]

Oh what's in a number48000 vs 536870912.

LOL

On 11/1/2013 4:28 PM, Richard Kaye wrote:

VFP was designed in an era when the operating system couldn't use more than 2GB 
of RAM. I forget where I saw this (could have been Christof, could have been 
wOOdy) but I long ago switched to this:

SYS(3050,1,48000)
SYS(3050,2,48000)

Keep it simple... :-)

--
rk


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: Friday, November 01, 2013 4:20 PM
To: profoxt...@leafe.com
Subject: VFP9SP2 on Win7 error trying to maximize memory

Had one user's WIn7 Pro machine (8GB RAM) fail on this code:

  SYS(3050,1,MIN(536870912, VAL(SYS(3050,1,0
  SYS(3050,2,MIN(536870912, VAL(SYS(3050,1,0

...because the MIN(..) arg returned -1351876608.

Looks like I should add a ABS(..) around the whole thing to avoid the error.  I 
should update the Fox Wiki too as I got the code from there.

Heads up in case you use the same code...

--
Mike Babcock, MCP



[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/5274119d.5030...@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.

VFP9SP2 on Win7 error trying to maximize memory

[MB Software Solutions, LLC]

Had one user's WIn7 Pro machine (8GB RAM) fail on this code:

SYS(3050,1,MIN(536870912, VAL(SYS(3050,1,0
SYS(3050,2,MIN(536870912, VAL(SYS(3050,1,0

...because the MIN(..) arg returned -1351876608.

Looks like I should add a ABS(..) around the whole thing to avoid the 
error.  I should update the Fox Wiki too as I got the code from there.


Heads up in case you use the same code...

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


---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.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/52740cf1.4000...@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: [OT] Old Spock vs. New Spock Audi commercial

[MB Software Solutions, LLC]

On 11/1/2013 2:55 PM, MB Software Solutions, LLC wrote:

http://www.youtube.com/watch?v=WPkByAkAdZs

This is HILARIOUS!



Notice that the car at the end is a self-driving car!

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

---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.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/5273fabf.2000...@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.

[OT] Old Spock vs. New Spock Audi commercial

[MB Software Solutions, LLC]

http://www.youtube.com/watch?v=WPkByAkAdZs

This is HILARIOUS!

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

---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.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/5273f933.1000...@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: I Need a geek

[MB Software Solutions, LLC]

On 11/1/2013 1:17 PM, Ted Roche wrote:

"It's whatever we're selling this week." -- Sales rep in the 80's asked to
explain what "client-server" was.



And here I thought that was from a M$ rep in the early DotNet days where 
EVERYTHING was DotNet.  lol



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

---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.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/5273f869.2010...@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: Is code self documenting?

[MB Software Solutions, LLC]

On 10/31/2013 11:20 AM, Dave Crozier wrote:

Rule 1 of writing software for nontechnical users is this: if they have to read 
documentation to use it you designed it wrong.


I can get behind this one



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

---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.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/5272783a.1020...@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] Condo association needs private forum

[MB Software Solutions, LLC]

On 10/25/2013 5:34 PM, Kurt @ VR-FX wrote:

Hey Mike - Gotcha. I think what someone else mentioned is that to do the
Google Docs thing - THAT you MAY have to have a GMail account. But, I
can't Confirm Nor Deny that Captain!



Google Docs would only be necessary if multiple folks are collaborating 
on document creation/updating, right?



--
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://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/526bc920.10...@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] Condo association needs private forum

[MB Software Solutions, LLC]

On 10/25/2013 5:20 PM, Kurt @ VR-FX wrote:

Wrong - I'm using GG for Two 3D Printer forums - and, for the 2nd one -
I use a Regular e-mail address - NOT a Gmail - as I mentioned before...



Yeah I saw your email AFTER I sent mine.  Thanks for the confirmation!


--
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://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/526ae0b8.9050...@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] Condo association needs private forum

[MB Software Solutions, LLC]

On 10/25/2013 1:23 PM, Gene Wirchenko wrote:

At 14:31 2013-10-24, "MB Software Solutions,

[snip]

I don't like that idea as I think it exposes too much risk.  What
happens if they share the wrong stuff?  We're talking about some
not-tech-savvy folks who just need a simple common area on the web to
share/reflect/post.


  How well is their non-computerised system working?  By that, I
mean that if someone were to ask for a document that he is entitled to
view, how difficult would it be to get the document?  If there currently
is no or little effective organisation, adding a computer system to the
mess will not work.

  If they are really technologically-declined, they might be better
off with a good manual system.


No, they need stuff online.  This is a resort condo, meaning that it's a 
beach home for folks and they live elsewhere.  They can't drive to the 
beach when they need to review a document.



--
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://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/526adff0.4090...@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] Condo association needs private forum

[MB Software Solutions, LLC]

On 10/25/2013 10:53 AM, Stephen Russell wrote:

On Thu, Oct 24, 2013 at 11:05 PM, AndyHC  wrote:


Tried that but it didn't work even for a small group - everyone has to
have a Google account and at least half the people failed in setting it up.


---

Suffered same downfall myself in attempting to set an officers space for my
KofC council.





So Google Groups only works if everyone is using a gmail address?

--
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://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/526adf8e.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: [NF] Condo association needs private forum

[MB Software Solutions, LLC]

On 10/25/2013 10:09 AM, Dave Thayer wrote:

In additional to Google Groups, Yahoo groups <http://groups.yahoo.com>
also allows private groups. More info at
<http://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15010>
or <http://tinyurl.com/pal7yh7>

If your users don't want to set up Yahoo accounts you can run your
group as a straight mailing list. I believe the same would be true
with Google Groups, but I don't have any experience with that.



hi Dave,

Can't just be a mailing list as they want a page where folks can easily 
download forms/documents/etc.





--
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://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/526a864f.4080...@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] Condo association needs private forum

[MB Software Solutions, LLC]

On Thu, Oct 24, 2013 at 2:22 PM, MB Software Solutions, LLC
 wrote:

Buddy of mine is on his condo board and wants to have a website (he says) to
make it easy for members to grab documents and get information.  Needs to be
private.  I was thinking of the old phpBB forums, but I'm sure there are
better options today.  They don't yet have a domain. What do you think?  I
suggested he get a domain and use that kind of a forum.  I did warn him that
they'll be bombarded by the rest of the internet trying to get access (so
those imposters can post links to porn and malware).  And of course, they
don't have any budget allocated for this, so I told him that getting a
website designed probably wasn't his best choice (but this pre-packaged
forum software was).




Ironically, I get this email just now from the phpBB folks (well, at 
least from phpbb...@gmail.com, which is probably a scammer!!!):

-
Hello,
phpBB 3.0.12 is now available , please
be sure to backup your forum before
staring in the update process .

we are happy to help you in updating
your forum safely, please reply to this
email if you are interested in our paid
sevices .

thank you
-

The fact that it's so plain vanilla AND has grammatical errors makes me 
very leery of it actually being legit.  Oddly, no links or attachments 
in the email.  I always just delete them.


--
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://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/5269923f.3000...@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] Condo association needs private forum

[MB Software Solutions, LLC]

On 10/24/2013 5:25 PM, M Jarvis wrote:

On Thu, Oct 24, 2013 at 2:22 PM, MB Software Solutions, LLC
 wrote:

Buddy of mine is on his condo board and wants to have a website (he says) to
make it easy for members to grab documents and get information.  Needs to be
private.  I was thinking of the old phpBB forums, but I'm sure there are
better options today.  They don't yet have a domain. What do you think?  I
suggested he get a domain and use that kind of a forum.  I did warn him that
they'll be bombarded by the rest of the internet trying to get access (so
those imposters can post links to porn and malware).  And of course, they
don't have any budget allocated for this, so I told him that getting a
website designed probably wasn't his best choice (but this pre-packaged
forum software was).

Your ideas/thoughts/comments?

tia,
--Mike



Dropbox?



I don't like that idea as I think it exposes too much risk.  What 
happens if they share the wrong stuff?  We're talking about some 
not-tech-savvy folks who just need a simple common area on the web to 
share/reflect/post.


--
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://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/526991aa.8060...@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.

[NF] Condo association needs private forum

[MB Software Solutions, LLC]

Buddy of mine is on his condo board and wants to have a website (he 
says) to make it easy for members to grab documents and get information. 
 Needs to be private.  I was thinking of the old phpBB forums, but I'm 
sure there are better options today.  They don't yet have a domain. 
What do you think?  I suggested he get a domain and use that kind of a 
forum.  I did warn him that they'll be bombarded by the rest of the 
internet trying to get access (so those imposters can post links to porn 
and malware).  And of course, they don't have any budget allocated for 
this, so I told him that getting a website designed probably wasn't his 
best choice (but this pre-packaged forum software was).


Your ideas/thoughts/comments?

tia,
--Mike

--
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://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/52698f7a.9070...@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: mysql workbench

[MB Software Solutions, LLC]

On 10/24/2013 3:32 PM, Stephen Russell wrote:

On Thu, Oct 24, 2013 at 2:24 PM, MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:


On 10/24/2013 2:46 PM, Stephen Russell wrote:


There is no bit or binary data type?






Yes there is.  MySQL has a bit type.
---




Why not use the proper data version.





Hence why I asked how "Y" or "N" was better.

--
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://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/52697681.8050...@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: mysql workbench

[MB Software Solutions, LLC]

On 10/24/2013 2:46 PM, Stephen Russell wrote:

There is no bit or binary data type?



Yes there is.  MySQL has a bit type.


--
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://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/52697404.2010...@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: mysql workbench

[MB Software Solutions, LLC]

On 10/24/2013 8:01 AM, Man-wai Chang wrote:

I rather use a char(1) field with values ("Y"."N")  for logical value.
That would make update errors visible and data recovery easier.

On 10/23/13, Gary Jeurink  wrote:

to mysql data transfers.  I still have to change all the .t. and .f. to 1
and 0 along with reformatting the dates using word macro's but over all I'm
really happy with it.





How would that be easier?


--
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://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/5269670b.6030...@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: SWFox Conf. Keynote is LIVE Now!

[MB Software Solutions, LLC]

Congratulations, Ted!  I was pitching for you in past years!  You 
deserve it, buddy.



On 10/17/2013 10:36 PM, Bill Anderson wrote:

Ted Roche, Lifetime Achievement Award!!

Congratulations Ted!

Bill Anderson

On Thursday, October 17, 2013, Kurt @ VR-FX wrote:


And - yup - I've been watching it - started at 10pm EST - and still going.
Here's the link:
http://www.ustream.tv/channel/**swfoxtv?utm_source=event-**
reminder&utm_medium=visit-**channel&utm_campaign=**notifications

-K-

__**_
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/52609BB3.7070400@**
optonline.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.




--- 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/52679cfd.6040...@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: win 8.1

[MB Software Solutions, LLC]

On 10/16/2013 9:52 AM, Ken Dibble wrote:

This will eventually be true for XP. Long before people stop using it,
people will stop writing malware for it. Sometime after that, malware
designed for it will cease to circulate. At that point, it will be safe.


I don't know, but the M$ haters out there (who write virus/malware 
software exploits) probably still see XP as a huge target for which they 
can hurt M$'s credibility.



--
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://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/525e9e1e.1010...@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: win 8.1

[MB Software Solutions, LLC]

On 10/15/2013 8:37 PM, Ken Dibble wrote:

The older an OS is, the less likely it is to be attacked. Malware
producers are like everybody else in the computer industry; they target
the latest-and-greatest. Eventually, the stuff aimed at older OSes drops
out of circulation, Meanwhile the new ones keep getting hit harder and
harder.



Yes, but virus writers who hate M$ know that there will be a huge number 
of XP installations vulnerable, and that's the reason they'll still love 
to exploit XP users.





My problem with XP seems to be cruft. People who constantly update the
OS don't notice this perhaps. But go 6 months between applications of
critical updates to XP and you will immediately notice the loss of
performance. I have XP running on machines with 2.6 GHz processors and 2
GB of RAM, and are only 3 years old, and they are so slow they are
approaching unusable. (And yes, they are clean; have passed Spybot,
MalwareBytes, and Avast! full scans with flying colors, and have been
defragged.)

I don't notice Win 7 slowing down nearly as much after updates. The one
thing I'm seeing a lot of with updated Win 7 is delays when switching
between users. These days the screen has time to go dark and display the
"no input" message during the switch. That never used to happen.



Yeah but your Win 7 machine---is it 64-bit?  Your XP is 32-bit.  64-bit 
should be faster, right?




--
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://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/525e0561.8090...@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: win 8.1

[MB Software Solutions, LLC]

On 10/15/2013 8:26 PM, Mike Copeland wrote:

I remember him laughing at the end of the
call saying that when his calls were reviewed, he would be reprimanded
for spending so much time on one call...but he was looking for a job
when he got that one.



LOL!


--
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://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/525e0417.40...@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: win 8.1

[MB Software Solutions, LLC]

On 10/15/2013 4:17 PM, Dan Covill wrote:

Worst thing I've hit so far:  under Privacy, went to turn off the
targeted advertising.  There's a video to play on how advertising is so
good for you.  But it's a Flash video (I thought MS didn't like Flash!),
and it wanted to update my Flash Player.  I said OK, and then noticed
that the update included McAfee "Security Scan Plus".
I un-checked it ok, but you should NOT be getting drive-by downloads
from a Microsoft program!!



It was APPLE who hated Flash.


--
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://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/525da376.1080...@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: win 8.1

[MB Software Solutions, LLC]

On 10/15/2013 9:59 AM, Allen wrote:

  After all who needs
M$ support. Most of us do well without it.
Al



I'd bet 99% of all Windows users NEVER call Microsoft for supportEVER.



--
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://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/525d8e35.8050...@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: win 8.1

[MB Software Solutions, LLC]

On 10/14/2013 5:23 PM, Mike Copeland wrote:

The pre-release 8.1 worked fine...even better than Win7Pro.
Don't know about the release candidate.



How so better?  I'm guessing you're referring to the funkiness of menus? 
 or something else?



--
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://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/525d8d1e.7000...@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] Programmers Needed???

[MB Software Solutions, LLC]

On 10/11/2013 8:34 AM, Jeff Johnson wrote:

They tell you when you're leaving the IRS and tell you when
you are returning.




Huh?  I don't understand that.

--
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://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/52583024.6030...@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] CPU usage remains high, despite hardly anything running....why?

[MB Software Solutions, LLC]

On 10/4/2013 11:26 AM, Mike Copeland wrote:

You can't kill the LMIGuardianSvc.exe (LogMeIn) remotely, obviously
(using LogMeIn). And you'll have to jump through a few hoops to kill it
regardless. It is a protected service that exists only to make sure LMI
doesn't get hijacked.

I use LogMeIn on hundreds of computers and never have any problem
regardless of the OS (including Android, Linux, Win 2000, Win XP, Win 7,
and Win 8).



Yeah when I went home for lunch, I End Tasked the LMI stuff and no change.

How would I be able to detect if someone has put some sort of 
keystroking and/or screen-picture-taking software on like Spectre Pro on 
my computer?  http://www.spectorsoft.com/



--
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://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/524f1cfd.4030...@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.

VFP job in Reading, PA

[MB Software Solutions, LLC]

For those who want to Keep America Working...here ya go!!

http://lnkd.in/b-6MBBb

Could get up to $50/hr (not 1099 though).  I used to live 30 minutes 
from Reading, PA.  Not somewhere I'd like to live, but hey, it's a job.


--
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://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/524dd4d2.8010...@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.

[OT] Very cheap phone contract?!?

[MB Software Solutions, LLC]

Saw this link on Spiceworks recently:

http://www.pcmag.com/article2/0,2817,2425079,00.asp

I always hated paying AT&T over $2000/year for phone service.  Might 
just try this.  What's the worst that could happen?


On a side note...I haven't seen a classic ASP page for ages.  Surprised 
to see that on PCMag.


--
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://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/524d8e2d.5090...@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: VFP9 install on 64-bit new laptop?

[MB Software Solutions, LLC]

On 10/3/2013 3:29 AM, Allen wrote:

I'm not surprised. Most of their stuff is something doable in VFP anyway
hence overpriced. And the offers of 2 for 1, what is the use of 2 of the
same for a single programmer? That annoyed me and the fact that even a half
price was overpriced.
Al


Exactly.  I'm just a single programmer as well.  I don't need 2.  It's 
not a sale for me.



--
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://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/524d7919.6080...@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.

DBI (was Re: VFP9 install on 64-bit new laptop?)

[MB Software Solutions, LLC]

On 10/3/2013 3:21 AM, Mike Copeland wrote:

What really irked me was that it is obviously a bug and I was actually
trying to inform them of the problem, not get it fixed. I mean, sure, if
they knew of a solution that would be fine, but my assumption was that
one of the supporting Windows DLL files in Win 7 Home was different (or
missing) when compared to Win 7 Pro.

I think they were in a hurt for money.



Where are they located?  I got the impression it wasn't the USA.


--
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://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/524d7799.1060...@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: VFP9 install on 64-bit new laptop?

[MB Software Solutions, LLC]

On 10/2/2013 10:40 PM, Mike Copeland wrote:

I have VFP9 running on over 75 Win 7 SP1 Pro 64-bit systems, no problem.
I develop on a Win 7 SP1 Pro 64-bit system, no problem.
I've installed and used my main application on both Win 8 Pro and Win
8.1 Pro (beta pre-release), no problem, and this application uses ODBC
to connect to a MariaDB backend server, pluse quite a few OCX controls.
No problems and no special requirements needed.

What does NOT work, for my application, for some unknown reason, is Win
7 Home (32 or 64 bit). But the problem isn't VFP 9, it's an OCX control
from DBI. And to be fair, it does work, but it is exceptionally slow (a
process that takes less than one second on Win 7 Pro takes nearly 5
minutes using Win 7 Home.)

Hope this helps.

Mike Copeland



Thanks, Mike.  Which DBI control was it?


--
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://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/524d7729.1010...@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.

VFP9 install on 64-bit new laptop?

[MB Software Solutions, LLC]

VFP9 will install on a 64-bit laptop, right?  I'm looking at getting a 
new laptop soon.  Saw no reason to get the Windows 7 32-bit or even 
64-bit with XP Compatibility if I don't need it for VFP9.


tia,
--Mike

--
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://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/524c9883.5070...@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} Windows

[MB Software Solutions, LLC]

On 10/2/2013 6:04 AM, Michael Madigan wrote:

reinstalling is always the last resort



Yeah that's a nuke option.  Your customers won't really appreciate that 
path.



--
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://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/524c2653.10...@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] CPU usage remains high, despite hardly anything running....why?

[MB Software Solutions, LLC]

On 10/2/2013 9:28 AM, Alan Bourke wrote:

Download Process Monitor from SysInternals.com, set it to always on top
and auto-scroll, and just see what seems to be hitting the filesystem
for a while. After it gets some data, you can then group it by process.



Definitely worth checking out.  Good tip.  Thanks Alan!



--
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://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/524c2619.8010...@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] CPU usage remains high, despite hardly anything running....why?

[MB Software Solutions, LLC]

On 10/2/2013 9:07 AM, Dave Crozier wrote:

Windows indexing service in progress?

I always disable it.

Dave


Hi Dave,

I'll bet that was it.  I noticed it was checked in the Properties of the 
C: drive.  The Service was stopped, though.  I've unchecked it and will 
re-evaluate once that's done.


Not sure when/how I turned that back on.  I always ran with that turned 
off.  Never liked that.


Thanks!
--Mike



--
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://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/524c25fb.7030...@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.

[NF] CPU usage remains high, despite hardly anything running....why?

[MB Software Solutions, LLC]

The facts:
- old Inspiron 1520, new in 2008, 250GB HD (not SSD)
- tons of free HD space
- uses Avast a/v free for a/v software
- ran MalwareBytes and removed 2 things
- ran CCleaner full options, including turning off useless crap in Startup
- no streaming media playing, just VFP open (with no programs running) 
and Thunderbird

- wired internet connection
- no Windows updates pending/downloading


Any ideas why the machine seems so busy when it shouldn't be?

--
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://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/524c15f3.7040...@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: Broken Connection and Remote Views

[MB Software Solutions, LLC]

On 9/25/2013 3:48 PM, Mike Copeland wrote:

Actually @@identity does have other uses, and depending on your backend
server you may not want to use it (Microsoft SQL Server comes to mind)
but I only work with MariaDB (MySQL) so it provides all I need.

Google "select @@identity" and see if there are any issues using it with
your backend server.



I use "select @@version" myself.


--
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://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/5244964e.4050...@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: Broken Connection and Remote Views

[MB Software Solutions, LLC]

On 9/25/2013 3:19 PM, Mike Copeland wrote:

There are probably better ways to do it, but I use

 nResult=SQLEXEC(datahandle,'SELECT @@identity')

If nResult is 0 then I just assume that there is a problem and proceed
to disconnect, throw away the old handle, and then reconnect. If that
fails, then bail out.  "Select @@identity" has a very low footprint,
returning nothing and only useful to see if the communication link is
still valid (as far as I know.)

Some Fox error codes to look for would be 1526, 1466, and 2006.

I've never used views, but in my opinion using views with SQL is not
recommended. I just fetch whatever data I need from the server and the
connection is only needed for that data transmission. After that brief
communication, nothing is assumed and the next communication has to
stand on its own. I run the above "Select @@identity" before each
request for data. Yeah, additional overhead, but it's quick and ensures
that the connection is still valid.



This is what I do too, but I don't use Views for the same reason.  I use 
SPT cursors and when it's time to update, I test the current connection 
in a similar way to what Mike said and if invalid I reconnect.  Works 
great since 2004!



--
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://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/52449623.9070...@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.

[NF] Still hate Gartner every time I see their name

[MB Software Solutions, LLC]

http://app.response.quest.com/e/es.aspx?s=2149&e=197789&elq=0afa72f07aed42d5861ed3bc84a365c0

I must say I always am leery about whatever Gartner says.  Old scars, 
you know.


--
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://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/5241b8c4.5050...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: select top 12 order ascending

[MB Software Solutions, LLC]

select b1.* from (select top 12 val(hip_no) as MyValue, hip_no as MyKey 
from stnhorse where Amount > 0 order by 1 desc) a1

inner join stnhorse b1 on a1.MyKey = b1.hip_no
order by a1.MyValue ASC
into cursor MyResult


Just a WAG, but basically I'm having the subselect do the criteria 
selecting, and the outer select do the ordering.


hth,
--Mike


On 9/23/2013 11:16 AM, James Harvey wrote:

Here is how I get the last 12 horses sold to appear in a grid in order by
hip number ascending.

"Hip_no" is a character field, but they want it to show as a "number", with
no leading zeros.  The "amount" field gets an amount posted as each horse is
sold at the auction.

Is it possible to get the return set in one select statement?

Example:
Hip#
2300
2301
2302
2303
2304
Etc., etc.




***returns the last 12 horse sold but in hip number descending order.

Select ;
Top 12 ;
hip_no as hip, ;
Val(hip_no) As hip_no, ;
Name, ;
Alltrim(Alltrim(sbfname) + " " + Alltrim(sblname)) As signby, ;
amount ;
From ;
stnhorse ;
Where ;
amount > 0 ;
Order By ;
hip_no Desc ;
Into Cursor (Thisform.r_temp)




***reverses hip number order of last 12 horse returned in above select
statement.

Select ;
hip, ;
hip_no, ;
Name, ;
signby, ;
amount ;
From ;
(Thisform.r_temp) ;
Order By ;
hip  ;
Into Cursor (Thisform.r_lcfile)







James E Harvey
M.I.S.
Hanover Shoe Farms, Inc.
www.hanoverpa.com
office: 717-637-8931
cell: 717-887-2565
fax: 717-637-6766




[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/52405e53.5010...@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: SET FILTER TO

[MB Software Solutions, LLC]

On 9/21/2013 3:14 PM, Dan Covill wrote:

Instead of the above:
 select * into cursor lcTemp ;
 where invoice = 'the one I want to print'
 select lcTemp
 lcfrs2any = 'FRX2Any'
 ...
 select 

SET FILTER has a whole bunch of problems when other users are in the
same file.

Dan



+1 to what Dan said.  I always like to work with local flat cursors for 
reporting rather than the network files.



--
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://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/52404db2.6050...@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 9 SP2 and Windows Servers

[MB Software Solutions, LLC]

On 9/20/2013 1:15 PM, Man-wai Chang wrote:

I would turn off all forms of write-caching in the network shares! :)


Definitely to prevent corruption due to power loss/fluctuation or 
network connectivity issues.



--
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://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/523c8dbb.8070...@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: Getting Data from Another form

[MB Software Solutions, LLC]

On 9/20/2013 2:18 PM, Jack Skelley wrote:

In all my applications this statement is included somewhere in the code...when 
the NJ Devils scouting system was officially 1 year late I mentioned it to the 
powers that be and they didn't think it funny...
Thanks again for all the help!
Best regards,

Jack

Jack Skelley
Senior Director, Programming/Computer Operations
New Jersey Devils
(973)757-6164
jskel...@newjerseydevils.com



You'd better get it right so the Devils can be contenders and make it to 
the Big Game once again!  :-)



--
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://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/523c9318.6070...@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 9 SP2 and Windows Servers

[MB Software Solutions, LLC]

On 9/20/2013 11:54 AM, Richard Kaye wrote:

http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html



Thanks, Richard.  From the article: "The best data integrity, security 
and performance is available by using a client/server database, such as 
IBM DB2, Microsoft SQL Server or Pervasive.SQL with your Visual DataFlex 
and DataFlex applications."



--
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://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/523c74e1.7070...@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 9 SP2 and Windows Servers

[MB Software Solutions, LLC]

On 9/20/2013 10:19 AM, Alan Bourke wrote:

In theory, yes it can. Where you *may* find issues is in the area of
file locking and performance, due to the SMB2 protocol that Windows
Vista, 7 or 8 clients will use to talk to it not being particularly
designed with things like VFP in mind.



These SMB concerns only come into play when you're accessible VFP on the 
backend (DBFs), right?  If you're using MySQL, SQL Server, Oracle, or 
other RDBMS, you don't have that concern, do you?


tia,
--Mike



--
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://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/523c6e50.4090...@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: Getting Data from Another form

[MB Software Solutions, LLC]

On 9/19/2013 6:25 PM, Jack Skelley wrote:


Good Evening Mike:
Thanks for the help but when I run this:
for each oForm in _vfp.forms
IF LOWER(oForm.Name) = "frmcoach" then
  frmCoach.top = 5
  EXIT
ENDIF
endfor
When the frmCoach.top was evaluated it returned frmCoach is not an object but 
when I changed it to oForms.top = 5 it did execute and move the form.
In my other systems I say
Public frmCoach
then issue frmCoach.top = 5 from another form with no issues. I can't figure 
what is wrong or what could be different.
Best regards,

Jack



Hi Jack,

You'd have to use the oForm reference variable, not frmCoach.

hth,
--Mike



--
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://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/523c6a56.80...@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] Does Windows Surface have a chance?

[MB Software Solutions, LLC]

On 9/20/2013 10:57 AM, Dave Crozier wrote:

Mike,
I progressed a little from the initial concept but it is still a work in 
progress as I decided to concentrate the system on Android development for the 
application in question. However I have had a request for a system on Win 8.1 
which I have hust installed on a VM (uuugh ... not much better than 8 methinks) 
so I'll be revisiting it next week and kicking it back into action.

Dave



Was it simply a matter of designing large buttons?


--
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://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/523c6854.8090...@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: Getting Data from Another form

[MB Software Solutions, LLC]

On 9/20/2013 9:57 AM, Richard Kaye wrote:

HI Jack,

If it wasn't 100% clear from some of the earlier posts, you need to refer to 
the memvar created by the FOR...ENDFOR loop whilst inside the loop and not the 
explicit reference to the one form you want to manipulate. For example, let's 
say you wanted to retrieve the values of certain textbox controls in a single 
form you could do something like this:

myvar=[]
for each oControl in myform.controls
  if INLIST(LOWER(oControl.Name),[txtFirstname],[txtLastname])
   myvar=myvar+[,]+oTextbox.value
  endif
endfor



Just keep in mind that because of the LOWER() function, you'd need to 
check against txtfirstname and txtlastname (no capital letters).  Also, 
you'd want to reference oControl instead of oTextbox.  :-)



--
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://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/523c6bcf.4090...@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: Getting Data from Another form

[MB Software Solutions, LLC]

On 9/19/2013 5:08 PM, Jack Skelley wrote:

Good Afternoon All
I have done this before and can't get it to work now.
I have a modeless form as a top level form and run the next form. Now I want to 
get data from the top level form on the now modal form and it tells me that the 
modeless form name is not an object.
On the modal form:
lnForm_top = frmModeless.top
and it says that frmModeless is not an object.
But wexist('frmModeless') returns true...
What am I doing wrong? I have checked other instances of this in other systems 
and it works perfectly. I just can't see any differences...
Thnaks!
Jack


Just a quick work-around:

for each oForm in _vfp.forms
  if oForm.Name = "TheOneIWant" then && there you go
MyValue = oForm.WhateverPropertyYouWant
exit && assuming you got the form you wanted and don't care about 
the rest

  endif
endfor



--
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://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/523b6bad.2020...@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] Does Windows Surface have a chance?

[MB Software Solutions, LLC]

On 9/19/2013 10:18 AM, Peter Cushing wrote:

Alan Bourke wrote:

and there won't be anything we can do about it.


Apart from putting the data on a low-cost Linux-based NAS device that
runs Samba, somewhere on the network, that is.


As long as there's an RDP client you can still run your VFP app from
anything.  You do have to design the screen for touchpad use rather than
mouse though.

Peter



Dave Crozier -- weren't you doing this awhile back with the large 
buttons in your apps?  How'd that turn out?



--
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://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/523b232b.4070...@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] Does Windows Surface have a chance?

[MB Software Solutions, LLC]

On 9/18/2013 12:18 PM, Stephen Russell wrote:


Apple had a heads up on the isses that iPhone apps didn't work as well on
iPads and they were able to control what would be allowed and what needed
to be tweaked by the software vendor.  M$ doesn't have that radical
control.



It amazes me that Apple has that much control, and they always made M$ 
out to be the big bad guy.  Pot...meet Kettle.


--
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://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/5239d690.6040...@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] Does Windows Surface have a chance?

[MB Software Solutions, LLC]

On 9/18/2013 6:08 AM, Alan Bourke wrote:

They were late to the tablet game - the RT is sort of pointless and the
full Windows 8 tabs that should make a killing in the corporate world
are too expensive.



If M$ had priced them 1/2 of what they are, do you think the end-result 
would have been significantly different?



--
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://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/5239cddf.3020...@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: Client--Server via Internet

[MB Software Solutions, LLC]

I would agree with you, Bob, but to facilitate further discussion to 
make it more clear, why would you say so?  What makes your solution secure?


Thanks,
--Mike


On 9/15/2013 3:31 PM, Bob Lee wrote:

I am using amazon hosted mysql. Called rds. , quite secure
Just my 2c

Bob Lee
1amsoftware.com

On Jun 5, 2013, at 1:07 AM, Alan Bourke  wrote:




On Tue, Jun 4, 2013, at 11:00 PM, Mike Copeland wrote:



Thanks for any wisdom or opinions.



My €0.02 is that exposing any database server to the public internet is
a bad idea, and web services are the way to go.


[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/52370286.9000...@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.