Re: Splitting PDF Files with Ghostscript

[Christof Wollenhaupt]

Hi,

If you plan to redistribute PDFtk along with a commercial application you now 
need a Redistribution License. It’s free to distribute with GPL licensed 
software.

—
Christof



> On 28. Mar 2024, at 10:24, Graham Brown  wrote:
> 
> Hi 
> 
> Alternative approach is to use the free PDFTK utility. This is command line
> and from memory you give it a command line argument  of "CAT".
> 
> Regards]
> Graham
> 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/af2c97cd-0ed3-4849-b764-0d87e413b...@wollenhaupt.org
** 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] Queries re: Python & Such...

[Christof Wollenhaupt]

> You don't have to be in Widows Land for Visual Studio Code.  I also run it in 
> Linux - 3 different distros, and they also have it for Mac:
> https://code.visualstudio.com/download

Indeed... Lots of folks at Microsoft aren't in Windows Land anymore. I'm 
running MS SQL server and Visual Studio on my Mac and Ubuntu on my Windows 
machine. Microsoft is a happy camper as long as we and our customers continue 
to pay for O365 and Azure. 

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/6584814d-43c9-49fb-a3f0-6f1034d81...@wollenhaupt.org
** 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: Equation solving from VFP

[Christof Wollenhaupt]

> Thinking aloud, if you could guarantee 32-bit Excel was available you could 
> probably use Excel automation to do it, i.e.


Actually, for Office automation it doesn't matter whether it's 32-bit or 
64-bit, as long as it is installed on the machine. 32-bit is only relevant for 
DLLs or drivers.

-- 
Christof


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/31889d12-9d66-4bec-b478-e97e6e7e4...@wollenhaupt.org
** 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] Those were the days ... ISP charges

[Christof Wollenhaupt]

>> Was that REALLY the cost for CompuServe? Yikes!
> 
> This is from my bank account statement February 1997. That's the fee for 
> January 1997 just for CompuServe. I also paid Deutsche Telekom by the minute 
> in phone charges on top of that.


Image didn't make it:

991951 11.02 11.02 COMPUSERVE INC. 78,85-
970241007701601
EZV9001569191

--
Christof




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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/b059fe7f-3ed7-43b7-b42d-6acf89989...@wollenhaupt.org
** 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] Those were the days ... ISP charges

[Christof Wollenhaupt]

> Was that REALLY the cost for CompuServe? Yikes!

This is from my bank account statement February 1997. That's the fee for 
January 1997 just for CompuServe. I also paid Deutsche Telekom by the minute in 
phone charges on top of that.



-- 
Christof



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/3156465b-d69a-4ad8-88ed-b836ced65...@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [SPAM] RE: Problem moving controls on a form at runtime

[Christof Wollenhaupt]

Have you tried making the control invisible then reposition it and then make it 
visible again?

Sent from my iPhone

> On 27. Feb 2022, at 00:35, paul.newton.h...@gmail.com wrote:
> 
> Tracy
> 
> Anchor is set to 0 - but thanks anyway
> 
> Paul
> -Original Message-
> From: ProfoxTech  On Behalf Of Tracy Pearson
> Sent: 26 February 2022 23:33
> To: profoxt...@leafe.com
> Subject: Re: Problem moving controls on a form at runtime
> 
> This happens to me when the anchor is set on the control.
> 
> Tracy
> 
>> On February 26, 2022 6:08:22 PM EST, paul.newton.h...@gmail.com wrote:
>> Hi all
>> 
>> 
>> 
>> I am trying to reposition controls on a form at runtime and all is 
>> working well, except for one control (Microsoft Web Browser 
>> olecontrol).  I can adjust its width and height, but whatever I have 
>> tried fails to move the control to a new Top and Left position on the form.
>> 
>> 
>> 
>> I have tried setting Top and Left on the control and its object (i.e. 
>> on MyOLEControl and on MyOLEControl.Object.  I have tried in the form 
>> Init, in the form Activate and from a command button Click event after 
>> the form has displayed.  All to no avail.
>> 
>> 
>> 
>> Am I missing something here?  I can probably resolve the problem by 
>> putting the oleControl inside a container and then moving the 
>> container, but I would rather not have to do that.
>> 
>> 
>> 
>> Many thanks
>> 
>> 
>> 
>> Paul Newton
>> 
>> 
>> 
>> 
>> 
>> --- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/aa2bc4de-8b47-496c-905b-d02c6f796...@wollenhaupt.org
** 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: Copy contents of code/editor window with formatting

[Christof Wollenhaupt]

> BTW - ISX - Is that InstallShield Express?

No, that's my original IntelliSense alternative for VFP 6 written at a time 
when we called everything soandsoX. 

https://bitbucket.org/cwollenhaupt/foxpert.tools.isx/src/master/ 


There's am enhanced version called IntelliSenseX that is part of Thor:

https://github.com/VFPX/IntelliSenseX 

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/6455b219-12a3-4860-a40d-cb977118b...@wollenhaupt.org
** 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: Copy contents of code/editor window with formatting

[Christof Wollenhaupt]

Hi Paul,

> 1.I want it to work with the current/open editing window

in ISX I use the following code:

*-
* Get the current window and verify that it is a valid window.
*-
Local lnWHandle
lnWHandle = GetCurrentWindow()
If lnWHandle == 0
If not Empty(m.tcInvocation)
Clear TypeAhead
Keyboard "{Mouse}{Mouse}"+m.tcInvocation Plain
Endif
Return
Endif

*-
* Verify that the current window is indeed an edit window.
*-
Local lnEditSource 
lnEditSource = GetEditSource(m.lnWHandle)
If not InList( m.lnEditSource, 1, 8, 10, 12 )
If not Empty(m.tcInvocation)
Clear TypeAhead
Keyboard "{Mouse}{Mouse}"+m.tcInvocation Plain
Endif
Return
EndIf

*
* Determines the source of the window identified by the passed 
* WHandle. It returns the following values:
*
* -1 The window is not an edit window
*  0 Command Window
*  1 MODIFY COMMAND window
*  2 MODIFY FILE window
*  8 Menu Designer code window
* 10 Method Edit Window in Class or Form Designer
* 12 MODIFY PROCEDURE window
*
* This procedure uses _EdGetEnv() from the FoxTools.Fll to determine
* the edit source. Passing an invalid handle causes an exception in
* VFP 5 and VFP 3. In VFP 6 this raises an error 2028 (API function
* caused an exception). Therefore we return -1 in this case, too.
*
Procedure GetEditSource
LParameter tnWHandle

Local laEnv[25], lnSource, lnOK, lcError
lcError = On( "Error" )
On Error lnOK = 0
lnOK = _EdGetEnv( m.tnWHandle, @laEnv )
On Error 
If m.lnOK == 0
lnSource = -1
Else
lnSource = laEnv[25]
Endif

Return m.lnSource


*
* Returns the WHandle of the current edit window or 0, if no edit
* window is available.
*
Procedure GetCurrentWindow

Local lnWindowOnTop
lnWindowOnTop = _WOnTop()
If m.lnWindowOnTop <= 0
Return 0
Endif
If GetEditSource( m.lnWindowOnTop ) == -1
lnWindowOnTop = 0
Endif

Return m.lnWindowOnTop


-- 
Christof



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/edcf902b-5506-4043-a70b-6ef032e3d...@wollenhaupt.org
** 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: Slow performance after moving to VM

[Christof Wollenhaupt]

Hi Chris,

> Thanks Christof, assuming at the moment this was the issue did you manage to 
> speed it up?  Was there a configuration on the client which determined how 
> many packets could be exchanged?

No, in this case it was handed over to the IT people. Setting up an extensive 
virtual network with various Windows servers was on my todo list for a long 
time, but I never found the time to actually install and configure all these 
machines.

There are just too many variables that could have an impact. Like there is SMB 
signing where packets are signed and validated. With signing the certificate 
infrastructure might have an impact. There are various ways to configure 
network throughput on the servers as well as on any router and switch in 
between. There's also a growing number of "smart" solutions that tries to 
optimize network throughput, but makes it really hard to get repeatable 
results. On top of that there might be extra services on the server from 
obvious ones like virus scanners, to less obvious ones such as filter drivers 
for distributed file systems. 

Then there's the whole thing of OpLocks and client side caching that impacts 
performance and stability depending on whether a file is used, has recently 
been used, or is not used by more than one client machine in the network.

Plus SMB 2.x/3.x is a protocol that dynamically adjusts its behavior based on 
network performance and quality. 

Whatever the reason is, the fewer read/write requests you make, the better your 
application will perform, if that is the cause of your problem, even when you 
can't fix the network.

Other reasons might include a larger number of users adding records, modifying 
memo fields or updating index fields. All of these are operations that require 
exclusive access in FoxPro and therefore can only be performed by one client at 
a time. These operations lock the table, index and memo field header, 
respectively. That would be an entirely different problem that in ProcMon you 
would notice with locker than usual times between the LockFile and the 
Read/WriteFile lines as well as the total number of LockFile requests for each 
period of using the application when monitored on the server.

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/3c13c343-c104-4893-b16b-dd25a7d91...@wollenhaupt.org
** 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: Slow performance after moving to VM

[Christof Wollenhaupt]

Hi Chris,

> Most of the 20 clients are still running fine, but a handful (3 identified) 
> at the moment are running really slow, they are only running slow in the VFP 
> application any other use of the server like copying files runs fine.  They 
> also seem to be the better spec'd machines out of the 20.  Nothing has 
> changed on the client pc's other than the unc path where the application is 
> looking for the data.

I had issues with systems were the number of TCP/IP packets that could be 
exchanged between client and server depended on the version of Windows on the 
server. So the same client would exchange 250 packets per second with a Windows 
2012 R2 but 1250 with Windows 2008 R2. Because VFP requests records one at a 
time and only reads the next one when the first has been processed, we ended up 
reading a maximum of one record every 4ms or every 0.8 ms. Both were slow, but 
the new Windows server considerably slower.

My first step would be to run Process Monitor on the client once for the faster 
machines and then once for the slower system. Then look at the timing between 
ReadFile requests in some table. Preferably one where multiple records are read 
in a row, such as a SCAN loop, SELECT statement or a grid control. Look if 
there's a significant difference in the duration between two records and if 
this number is somewhat constant.

If this doesn't help, then WireShark is a great tool, but does require some 
digging into SMB protocols.

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/9c05ec56-938d-4b6d-afc7-8441812a2...@wollenhaupt.org
** 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: Combining PDFs for printing multiple images on a sheet

[Christof Wollenhaupt]

Hi Joe,

> I have G-code that produces PDF images of labeled charts one chart per
> day.  I want to combine seven daily charts into a weekly sheet that will be
> printed from Acrobat Reader.

We used different solutions for different projects... 

One project uses pdfTK (https://www.pdflabs.com/tools/pdftk-server/ 
) which is a free tool to merge 
multiple PDF documents into one. If you merge seven single page PDF files you 
would end up with a single PDF file that has seven pages. It does not merge 
content of multiple documents into a single page, if that is what you need.

In another project our source files were images. We converted them to a single 
HTML file by embedding the images as Data Urls 
(https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/Data_URIs 
). 
This approach does allow arranging images on a page, but you have to do this in 
HTML. As this is an HTML document, you would either use the browser to print 
them, or open the file in Word.

A third approach, again based on images, was creating Word documents with an 
image on each side and then saving it as a PDF document. We used 
GemBox.Document for this (https://www.gemboxsoftware.com/document 
) but it would work with a not too old 
version of WinWord or many of the other libraries. Because this is a .NET 
library, I used wwDotNetBridge to call it.

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/05cbd8e1-d31e-4e85-a28b-2e575cafd...@wollenhaupt.org
** 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: Matt Slay

[Christof Wollenhaupt]

That's truly sad news and what a great loss that is. I was looking forward to 
meeting him at Virtual Fox Fest. Rest in peace.

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/2856619c-309f-467d-b742-f00afb988...@wollenhaupt.org
** 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] - Is Bigger Always Better When It Comes To Your Monitors? :)

[Christof Wollenhaupt]

> So, my question is this: What size monitors are you using for development
> and how many? 

27" 5K Apple Display (made by LG)... If I need a second monitor I open my 
macbook. I've never been a fan of multiple monitors, though. To me it's so much 
easier to have virtual desktops and just swipe to the one I need in fractions 
of a second without the need to refocus my eyes or look for my mouse pointer. 

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/81a3d5f5-a2d0-41ec-8fee-94ae87f79...@wollenhaupt.org
** 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] Winforms

[Christof Wollenhaupt]

> I'd definitely consider Windows Presentation Foundation over Winforms if this 
> inheritance thing is a problem for you, because WPF *does* support that sort 
> of visual inheritance, and i will set you up for WinUI going forward.

Coincidentally, there is also a session about using WPF in Visual FoxPro at 
Virtual FoxFest that covers some of the fundamentals of WPF and how it's 
different from VFP and HTML.

https://virtualfoxfest.com/Sessions.aspx#WPF_Modern_UIs_in_VFP_Applications 
 

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/522a9636-83c2-445e-88ff-d1f8d5bda...@wollenhaupt.org
** 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 2.6 for Windows App

[Christof Wollenhaupt]

Hi Philip,

> Does FoxPro 2.6 have to have a 32 bit hardware (machine) as well as Windows 
> 32 bit OS ?

You need any CPU compatible with Intel x86 or x64 (ARM won't work) and a 32-bit 
OS. That makes Windows 10 the last version to support 16-bit Windows or DOS 
programs. 

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/e8165084-5cbb-459d-adbe-08d981cff...@wollenhaupt.org
** 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: File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1

[Christof Wollenhaupt]

> My guess is he meant this:
> 
> HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRXSmb\Parameters

Correct! Thanks.

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/c87043b1-d367-49be-a57d-c4fb065dc...@wollenhaupt.org
** 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: File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1

[Christof Wollenhaupt]

> 
> Even when the issues that occurred in 2018 Windows 10 1809 (IIRC)  aren't a 
> problem any more (in my experience at least) ? 

My experience differs from yours. We have more issues with SMB every year 
unless oplock and caching is disabled. And even then we sometimes run into 
corruption issues that look like SMB problems.

UseWriteThrough doesn't solve this issue, because corruption happens due to 
client side caching caused by oplocks.

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/33beac05-20af-4bb7-ac8c-92aa6dbb6...@wollenhaupt.org
** 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: File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1

[Christof Wollenhaupt]

Hi Alan,

> If you make these changes you are removing all the performance benefits of 
> SMB3 for *all* applications on workstations and server, including file 
> copying etc.

Yes, that's true. It's a matter of priorities, I'd say: You can have correct 
data, or you can get data fast. 

We recommend terminal services with data stored locally on the terminal server 
or remotely on an iSCSI storage. For extra redundancy we recommend using 
terminal server in a virtual environment with redundant servers and redundant 
storage. But usually that advice is being ignored. 

-- 
Christof 
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/58fb0d64-7b37-4dc1-bfe1-f3d8b8583...@wollenhaupt.org
** 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: File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1

[Christof Wollenhaupt]

Hi Phillip,


> What do any experts on SMB protocol say/recommend for this situation?

As strange as this might sound The most reliable results we recently had 
with Ubuntu as the server instead of Windows. With Ubuntu you can entirely 
disable all caching and all oplocks which both are the reasons for the problems 
we have in VFP. Windows doesn't disable all of them, even if you ask nicely.

For Windows here's my current set of registry settings that must be applied to 
the server and the client and requires a reboot of both when making any 
changes. 

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\LanmanServer\Parameters
DisableLeasing DWORD 1
EnableOplocks DWORD 0

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\LanmanWorkstation\Parameters
CacheFileTimeout DWORD 0
DirectoryCacheLifetime DWORD 0
DormantDirectoryTimeout DWORD 1
DormantFileLimit DWORD 0
FileInfoCacheLifetime DWORD 0
FileNotFoundCacheLifetime DWORD 0

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\\Parameters
OplocksDisabled DWORD 1

-- 
Christof 

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/b1de0400-a461-4a0d-97b7-a242a280f...@wollenhaupt.org
** 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] Macbook Upgrade

[Christof Wollenhaupt]

> Is that in your new MBP? If so, no reason that it wouldn't fit in older,
> like the 2016? I have gotten so insecure about this stuff, not paying much
> attention the last few years.

It's the external one. My internal SSD drive is whatever Apple put in there. I 
don't think you can change the SSD in a MacBook anymore.

CompuServe: I had two numbers. The one I used last was 100770,1601.

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/85d8af4b-07df-471b-9160-484e6dd1d...@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [SPAM] [NF] Macbook Upgrade

[Christof Wollenhaupt]

Hi Eric,

> Why do you need 4TB of local storage? I'm doing as much as I can to go the
> other way now - keeping as much as possible on my Synology NAS so I can
> access it from any device. That may be your constraint.

We have like a half a dozen Synologies in various offices in different sizes. 
None of them would meet Ken's "must be portable" requirement.  The other 
issue with Synologies is that in terms of data transfer it's hard to exceed 100 
MB/second and the network adds extra latency, as does the SMB protocol. My 
external SSD connected to USB-C maintains 240 MB/sec and the internal one is a 
lot faster than that. 

We tried TimeMachine backups on the Synology and storing our VMs there, but it 
was just too slow and buggy. We now use SSDs for TimeMachine and a lot of 
problems have disappeared.

I've 2 TB of storage, but constantly get error messages because I run out of 
disk space. I've moved rarely used VMs to an external disk, even though I don't 
like that. I guess videos need a similar amount of storage.

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/23b4da66-3b74-4a6b-8011-338d41654...@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [SPAM] [NF] Macbook Upgrade

[Christof Wollenhaupt]

Hi Ken,

The M1 chip is a big change as far as compatibility goes. If you want to be 
guaranteed to run Windows software then you need to get an Intel Mac, and soon 
the only way to get one will be a used one.

On the M1 chip you currently can use wine or CrossOver to run Windows 
applications. But that depends on Rosetta 2 which will only remain available 
for a few more years max. There's an M1 version of Parallels, but it only runs 
the ARM editions of Windows and Linux, not the x86 editions.

For most things a 2016 MacBook Pro would actually be a decent choice. It has 
the MagSafe adapter and the real keyboard. I've used it for a few weeks while 
my newer MBP was being repaired. With an external 4 TB SSD connected to USB-3 
that was plenty fast even for my regular work. Only Windows VMs were a bit 
slow. My SSD drive is the Samsung 860 EVO 4 TB SSD.

If you don't want an external drive, then you should get the current 16" 
MacBook Pro model as long as it is still Intel. The keyboard is better than the 
2017-2019 models and the ESC key is back. But it's still not the same keyboard 
that the older MacBook Pro generation had. Performance-wise most other MacBooks 
would work, but large screen and huge storage is only the 16" MacBook Pro.

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/6e82d6cf-438c-419d-a930-15eca173a...@wollenhaupt.org
** 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: SourceSafe from within Foxpro

[Christof Wollenhaupt]

Hi Martin,

> This works fine on a PC at the location of a client who I support, which
> runs XP.  Also, on my own Windows 10 PC, VSS works perfectly from the VSS
> application, but when I try to access it from VFP I get "database XXX does
> not exist". 

Sometimes Microsoft's VirtualStore makes it look like a file is in a location, 
but when you access the same location with a different user or with an elevated 
application, then suddenly it's not there. The easiest way to check is using 
MODIFY FILE from VFP to see if VFP has actually the same content that you see 
from VSS. VirtualStore is located at %LOCALAPPDATA%\VirtualStore.

If it turns out that everything is still OK, I would use Process Monitor as my 
next step to find out which file location VFP is looking at to find the VSS 
database and what error message Windows reports back. You can download Process 
Monitor from https://docs.microsoft.com/en-us/sysinternals/downloads/procmon 
.

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/ebe0a0e2-c586-488f-bf16-6707d5eb1...@wollenhaupt.org
** 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: Opinions on Servers

[Christof Wollenhaupt]

> Yes sorry I didn't make it clear, this is an RDS server so the .exe and DBFs 
> will be on the same machine.  So it sounds like the main consideration to 
> make the application work as quickly as possible is the disk.  
> 
> Typically in the past we would have had 4 15k rpm HDD's running in a Raid 10 
> configuration.  We are thinking maybe SSD or NVMe will make a massive 
> difference but not sure how much of a difference taking into account the cost.

VFP is IOPS intensive, so anything you can do to increase that number will 
directly benefit VFP applications. An array of 4 SSDs equals to an array of 150 
15K SAS disks in terms of IOPS. If SSD is an option when considering that 
server grade SSDs are more expensive, I'd definitely go with SSD. I don't think 
NVMe would make a big difference here over 6 Gb/s SSDs. Depending on how many 
different channels you have to access SSDs, they already deliver 15-60 MB/s per 
user minimum. Plus a TS with local DBF files can actually cache data that is 
most used unlike TS that access a NAS or SAN.

The other issue is memory. Without reconfiguring Window a VFP application can 
make use of up to 2 GB of memory. For 30 users working mainly with this 
application you probably peak out at 96 GB RAM. It's a little more if you run 
browsers and Office in addition to the VFP application. On the other side of 
the spectrum I wouldn't run on anything less than 32 GB these days. 

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/5fdd5328-ffc1-4051-b100-db10b31dc...@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [SPAM] Free Visual Foxpro

[Christof Wollenhaupt]

> The next question is just as interesting though:  where to get it  I'm 
> guessing you could still get it from a MSDN subscription of some kind.  Years 
> ago they have the very cheap ISV program, iirc.

Yes, VFP is still available with the "Visual Studio Professional with MSDN" 
subscription. The license is perpetual, so you only need to subscribe for the 
shortest time possible. Be aware, though, there is also a subscription that you 
pay by the month which is NOT perpetual.

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/ad186931-510f-4be5-85be-1487b7166...@wollenhaupt.org
** 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: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?

[Christof Wollenhaupt]

Thanks, it makes sense not to reveal true identities. gl is "general ledger"? 

> On 24. Oct 2020, at 18:04, Stephen Russell  wrote:
> 
> glTable600 was replacing the true table name because we don't state true
> identities.  It is our gl transaction table and it is a beast in size.



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/0b9e032a-a3be-4ffd-8e0a-39f907083...@wollenhaupt.org
** 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: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?

[Christof Wollenhaupt]

SQL server works completely differently from FoxPro. For Sql Server the 
performance even on the same system would heavily depend on the isolation level 
you use, concurrent access and memory usage. I've consulted on SQL server 
databases projects in the close to a TB database size range where developers 
were thinking that performance optimization means creating the right indexes, 
but totally ignored how SQL server locking works, how transactions work, how 
memory can be utilized, etc. 

It does make a big difference, if the database engine knows which parts of a 
file have changed (SQL Server) vs. it can only tell if a file has changed, if 
at all (VFP).

BTW, what exactly is "glTable600"? 

-- 
Christof

> On 24. Oct 2020, at 17:25, Stephen Russell  wrote:
> 
> I just did a count(*) from one of our biggest tables.  It took 2 min to
> load it into memory the first time.
> SELECT count(*) cnt
>  FROM [erplndb].[dbo].[glTable600]
> 
> cnt
> 138,371,855
> 
> The second time I run this it only takes .03 seconds.   The size of the
> table and index is a mere 364 gigs today.
> 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/daf37e96-609c-4e59-a4bd-63ab36064...@wollenhaupt.org
** 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: Task: Process thousands of records through a regular process -- multiple EXE runs to cut down processing time??

[Christof Wollenhaupt]

> I'm not sure I trust RLock(). I'd probably use a "Status" field that
> indicates the record is unprocessed, in process, or processed. This might
> be a good use case for Christof's DMult multi-threading utility

You still have to use either RLOCK() or a SET REFRESH value of -1 to read the 
status field, because otherwise VFP will lie to you about the current value of 
that field. Unless you move away from a record, you get the same value for 
hours in VFP. Even if you move away, the cache is considered to be the truth 
for up to how many seconds SET REFRESH indicates.

Christof


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/8bc9aee1-ed4a-43b2-b3db-6bf3c5b91...@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [SPAM] Unit tests (was Re: [NF] I will .....)

[Christof Wollenhaupt]

> I still have trouble conceptualizing how to write unit tests for data
> access.

I have a function that reads a table and recreates the same structure as an 
empty cursor with all indexes, and such. Optionally, it appends the existing 
content of the table. In my unit test I can then make changes to the cursor.

This covers about 80-90% of the need if you have a common way of opening tables 
that you can plug into. For test cases, where a cursor is too different from 
the table for a useful test, I do have test data in a subfolder that I copy 
into a temporary folder and then use for the test. 

For projects that use a more object oriented approach I use foxmock to simulate 
data. Most times what I really need isn't the actual data access, because I 
know that these classes work, rather I have to test the code that accesses 
data. foxmock has a method that returns a scatter object based on a record.

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/ece0761d-3fe8-4fa8-8c21-066753ace...@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [SPAM] [SPAM] Unit tests (was Re: [NF] I will .....)

[Christof Wollenhaupt]

> Having said that, TDD does work "best" for new development, and many VFP
> devs are not doing a ton of apps from scratch which is why it may not have
> caught on. It also works best with logic that's not buried in the UI, and
> unfortunately a lot of us buried it there (forgive me father). 

We have used FoxUnit for our FoxPro DOS based application. That program was 
certainly not written with unit tests or even classes in mind. But even a 
procedure with private variables can be a testable unit if you design the 
interface carefully.

It doesn't make sense to retrospectively create unit test for an existing 
application, I agree. However, when you modify existing code it's often 
possible to move the parts that you need to change out of the SCX Click or 
whatever method into a separate class. There is no need to do this all at once, 
just when you need to make changes to code anyway.

When code uses functions like MESSAGEBOX(), etc. you can replace those with a 
simple messagebox or dialog class (such as the one in INTL) and then in your 
test mock this class. Various tests can then cover multiple paths through the 
code depending on a simulated choice a user made. You can also assert that 
certain messages are shown to the user by making a call an expectation in 
foxmock and then verify those afterwards.

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/3c5b4138-b249-4929-a5f3-13088009c...@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [SPAM] Unit tests (was Re: [NF] I will .....)

[Christof Wollenhaupt]

> 
> To make an unit test in VFP is as easy as anything:
> just write your code, highlight it, activate the shortcut (right mouse
> click), select the option 'Execute the selection'.  A very neat and quick
> solution.

It's even quicker if you use FoxUnit and foxmock. Both are free on VFPX. I've 
hundreds of unit tests that I can run with a single key stroke that test many 
different modules of our applications. Writing testable code also tends to lead 
to a cleaner class design that is more reusable.

-- 
Christof



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/74ad2596-4d52-4be8-a9e6-17c705446...@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [SPAM] Memo bloat

[Christof Wollenhaupt]

Hi Alan,

> If the changed data in bytes > blocksize then it will add a new block. If you 
> keep the changes < blocksize then it will re-use the same space. The trouble 
> is with a blocksize of 64, it's very likely that it will almost always be 
> adding blocks.

That would be very thoughtful of VFP, indeed, but it's unfortunately not what 
is happening:

Set Blocksize To 64
Create Table memotest (memofield M) 
Use memotest shared
Insert into memotest values ("1234567890")
Use
Dir like memotest.fpt
?
Use memotest shared
Replace memofield with "54321"
Use
Dir like memotest.fpt
?
Use memotest shared
Replace memofield with "1234567890"
Use
Dir like memotest.fpt

The code replaces the same field with a shorter string, then with a longer 
string. All strings are way below the blocksize. Yet, each time the FPT file 
grows by 64 bytes.

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/8d18d8a2-e3b2-498e-806a-62d763270...@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [SPAM] Memo bloat

[Christof Wollenhaupt]

Hi Paul,

> I have a table with a memo field.  It contains ca. 970 records and the size 
> of the FPT is ca 230KB.  I added 161 records to the table, populating the 
> memo field with several lines of text (the total size of all the text added 
> was ca 700KB).  In each case the memo field was a single replace (no memo = 
> memo + ..., no replace memo with  Additive).  The FPT ended up as 234MB 
> but a PACK MEMO reduced this to ca 935KB.

This doesn't sound like the memo file is actually written at once and only 
once. When you change a memo field in a table that is not exclusively open, 
then VFP always appends the new text to the file. With just one write 
operation, you should end up with padded versions of the content appended only 
once.

Could it be that you have code that replaces the memo field with itself or does 
SCATTER MEMO / GATHER MEMO. VFP isn't smart enough to detect if you put the 
same content into a memo field again and just appends it. That might happen on 
other records than the newly added one.

I would test this with just one record instead of 161. Make a copy of the FPT 
file, run the code to append the record, then make another copy of the FPT file 
and look at what is different. If the file is OK, try the same with three 
records which should reveal patterns, if you process the same record more than 
once.

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/7b169611-aba8-495d-971d-bccea7665...@wollenhaupt.org
** 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: The Y2K Bug Returns: Revenge of the Kludge

[Christof Wollenhaupt]

> 
> https://www.zdnet.com/article/the-y2k-bug-is-back-causing-headaches-for-developers-again/

Nice, they even mention our local subway system in Hamburg which failed a 
couple of days ago due to a software update. 

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/02a988de-6c97-4579-9c80-99d7e0923...@wollenhaupt.org
** 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] TeamViewer alternatives

[Christof Wollenhaupt]

> Actually, the company buying LassPass, Francisco Partners, is an investor in
> or owner of the following companies: Bomgar, Legal Zoom, Comodo, LogMeIn,
> SonicWall, WatchGuard and many more.

Francisco Partners is buying LogMeIn. LastPass already had been sold to LogMeIn 
four years ago. 

-- 
Christof

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/16095c97-0d92-4c0f-bc5a-02c24fd41...@wollenhaupt.org
** 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: Calling code in parent's parent class

[Christof Wollenhaupt]

> Let's say that I have the following situation:
> 
> GreatGrandParent -> GrandParent -> Parent -> Class
> 
> In Class I want to bypass the code in Parent but call the code in either 
> GrandParent OR GreatGrandParent.

GrandParent::Method ()

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/f76db487-bdea-4050-9dd6-e15103875...@wollenhaupt.org
** 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: We''re getting old ;)

[Christof Wollenhaupt]

>  And, I was surprised to see you - Christof - doing a session on AI - a 
> session I would have loved to have seen!

That was a fun session to do. It was a lot of work to prepare, but also a great 
learning opportunity for myself.

-- 
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/9507b6ed-f6a8-4407-9522-7a84f56e5...@wollenhaupt.org
** 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 file types in explorer

[Christof Wollenhaupt]

File extensions can be registered in the HKEY_LOCAL_MACHINE and 
HKEY_CURRENT_USER hive. Maybe there's something in your own settings that is 
causing the problem. All of the suggested fixes register extensions system wide.

What do you see if you create a new local Windows user and log on as that user?

-- 
Christof
___
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/850a79db-5518--ab81-a8387a7ff...@wollenhaupt.org
** 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: ON KEY usage in your apps

[Christof Wollenhaupt]

> Except for that Microsoft's version has selected parameter evaluation and 
> mine has all parameters evaluated -- not something programmers can control in 
> the VFP language -- our icase()s work the same.

Technically speaking, you would be able to achieve this by rewriting the FXP 
file which must not be encrypted. There's a token for SkipOnTrue and 
SkipOnFalse that VFP inserts into expressions that are not fully evaluated, 
such as AND or OR. Whether this is really worth the effort is an entirely 
different question, though.

-- 
Christof
___
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/404cdc5d-46b5-4a33-a4e9-71e185388...@wollenhaupt.org
** 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: Example of T-SQL exception handling within a transaction?

[Christof Wollenhaupt]

> 
> Anyone have an example of how to trap and exception within a T-SQL
> transaction and save diagnostic details on why the transaction failed to
> an error log? If you insert the exception data to an error table this
> information gets lost when you rollback the transaction. I'm sure I'm
> missing something obvious :)

Yes, you log into a variable, roll back the transaction in the CATCH block and 
then insert the variable into the error log table.

-- 
Christof


___
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/f9812b11-b091-48a2-a805-1b79b876e...@wollenhaupt.org
** 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: WestWind Web ClrHost and wwDotNetBridge error on Win2K3 Server

[Christof Wollenhaupt]

Looks like the .NET Framework isn't installed.

--
Christof

On Thu 9. Nov 2017 at 05:49 <mbsoftwaresoluti...@mbsoftwaresolutions.com>
wrote:

> Tried moving a simple VFP9SP2 EXE that works fine on my machine to a
> different machine (remote from me) where I already had a working VFP9SP2
> EXE complete with the runtime files.  I moved my EXE, its INI, and the
> ClrHost.dll, wwDotNetBridge.xml, wwDotNetBridge.dll, and a C# file name
> Onboarding.dll that's used as a go-between for a webservice call.  I get
> this error though when trying to run it:
> https://www.screencast.com/t/yRQ04qhs4C
>
-- 
Mit freundlichen Grüßen,
Christof Wollenhaupt

-- 
foxpert Softwareentwicklung und Beratung
Christof Wollenhaupt
Ulzburger Straße 352
22846 Norderstedt

Tel  : (040) 605 3373-70
Fax  : (040) 605 3373-75
Mobil: (0171) 496 8216
EMail: christof.wollenha...@foxpert.com

http://www.foxpert.com - http://www.afpages.de - http://www.guineu.net


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

Re: Multiuser VFP9 application served on Win Pro share?

[Christof Wollenhaupt]

>
> I have a client that is wondering if he can serve up a lightly used VFP
> application for 20 users on a Windows 10 Pro machine share.


20 users is cutting it close. The Windows license allows a combined total
of 20 different devices to access file, print and web services. Most of our
small users have what used to be called a peer-to-peer network with one
workstation acting as the "server".

-- 
Christof


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

Re: Look at this, How about a VFP Extension....

[Christof Wollenhaupt]

>
> I only wish they would have a change in the mindset about doing the same
> with VFP (no chance I guess) but the signs are encouraging nevertheless.
> Just noticed that Christof has posted in another thread. I wonder what his
> take is on this.
>

I do have as much insight into Microsoft these days as everyone else.
Unless FoxPro / xBase suddenly becomes a hip choice among twenty-year olds
I don't see anything happen at all.

With regards to other's doing something there's been a constant stream of
small and larger projects that want to provide a way forward for VFP
developers. None of those has yet emerged as the generally accepted
solution.

-- 
Christof


--- 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/CAL4QJhjd9O=WxzBOkh3T15PZFh+fuxoC9htDuu_EiZJCbLy=z...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Performance SQL Server Tuning

[Christof Wollenhaupt]

 Good ideas on how to look at performance and what to consider.


 https://www.mssqltips.com/sqlservertip/2453/sql-server-performance-tuning-for-each-layer-of-an-application/


Sorry, have to disagree here... That article merely lists some random
performance counters that cover only a tiny fraction of performance related
issues and do not help solving the issue. A few examples:

- Weekly rebuilds of the index will kill your transaction log if you do not
have a backup plan

- Whenever tables have mixed read/write access locking becomes a lot more
important.

- SQL server can only handle a limited amount of transactions per second,
because every COMMIT causes physical disk activity. That counter is
completely missing.

-- 
Christof


--- 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/cal4qjhgg-ko7aukdaju4rlkmd59ue-9lpkwnn+rjjl2npp_...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: VFP on a tablet

[Christof Wollenhaupt]

There's an SWFox session on this topic this year:

http://swfox.net/sessionsswfox.aspx#Computer_Sensors_in_Business_Applications

;-)

-- 
Christof


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

Re: [NF] Recomendations for a developer laptop

[Christof Wollenhaupt]

 As for general performance, an i5 with my 1Tb HD are more than what I need
 for everyday work. I don't edit video, and unless you are recommending a
 SSD drive for playing I don't think it's money well spent.


If you carry your laptop around an SSD is a more reliable data storage than
an old-fashioned HDD. If you don't carry around the laptop, your money
would be better spent on a desktop computer.

I switched to SSDs six years ago when my HDD broke right after security at
the airport on the beginning of a 24 hour trip home. Never had a laptop
with a spinning disk ever since (and my six year old SSD is still working
just fine, in case you wonder about durability).

-- 
Christof


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

Re: [NF] Recomendations for a developer laptop

[Christof Wollenhaupt]

 Is there an alternative to Parallels?  - Besides a dual boot.


VMWare Fusion 7 (http://www.vmware.com/products/fusion/features.html)

-- 
Christof


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

Re: Performance measure

[Christof Wollenhaupt]

 Tracy, I can only log into the *server*


You can run Microsoft's Process Monitor on the server to see what is
transferred to the client.

-- 
Christof


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

Re: SYS(2015)

[Christof Wollenhaupt]

 Anyone know how to reverse engineer this function so that you get a
 datetime value?


Here's the C# version that generates a SYS(2015) value. It's three
characters for the year/day and six for the milliseconds within the day:

https://bitbucket.org/cwollenhaupt/guineu/src/6daa05f4c05df6663b53145c841ab916357b412a/Source/Guineu.Runtime.Desktop/Functions/SYS2015.cs?at=master


-- 
Christof


--- 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/CAL4QJhiDkn+HxarjhuojybnXAPKi55zkiKqosXh-nbT0=mx...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Wanting to compare before and after records

[Christof Wollenhaupt]

LOCAL loRec as Object
this.obiz.GetCompanyRecord(@loRec)
this.oStartingRecord = loRec

*this.obiz.GetCompanyRecord(@loRec)*this.oRecord = loRec

Assuming that GetCompanyRecord contains a SCATTER you need to repeat the
call to get two different objects.

-- 
Christof


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

Re: [NF] How cheap is it to get SQL Server Developer? VERY

[Christof Wollenhaupt]

  Temp data is written into the database?  I think you mean Transactions

are written to the .log of the database unless you override that.


What I mean is data temporarily being loaded into the database. I've often
seen import processes implemented by loading data into a processing table
in the main database, then have some process go through this data to
integrate this into the actual tables.

The proper way to handle this would be to load that raw input data into a
separate database that uses simple recovery. Then process the table and
only update those records in the main database that need to be updated.

The biggest problem of MS SQL server is that it's so easy to use, but so
hard to use correctly. MS made SQL server so accessible to developers and
users that hardly anyone operating an MS SQL server has any clue what they
are doing.

-- 
Christof


--- 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/CAL4QJhgJ=T0jm-82BWRX_5Pb_3w20g+sRvYSzFR=ke755cj...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] How cheap is it to get SQL Server Developer? VERY

[Christof Wollenhaupt]

On Wed, Mar 11, 2015 at 8:15 PM, Stephen Russell srussell...@gmail.com
wrote:

 10 gigs just gets you more time till you
 start to run out of space so learn how to shrink logs.


There should never be the need to shrink logs. Growing logs are a sign of a
misconfigured or misused system:

- The recovery model isn't set according to the database's role
- No backup strategy exists
- Temporary data is written into the production database
- DML commands are used thoughtlessly like updating the same values or
using DELETE/INSERT instead of UPDATE.

-- 
Christof


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

Re: [NF] Experience with Evernote or its competitors?

[Christof Wollenhaupt]

 Anyone successfully using Evernote? I'm considering using it, but
 nervous because of the very mixed reviews. Some people seem to love this
 product ... and it seems there is a lot of 3rd party love for this
 product as well. However, reading posts on Evernote forums and blogs
 reveals a lot of users extremely frustrated with this product's buggy
 behavior and cumbersome design.


I do have about 15,000 notes in Evernote. Evernote is a mixed experience,
that's true. The Windows client is far worse than the Mac client. The iOS
client is pretty slow. Usable on my iPad air, unusable slow on the iPhone
4s. Unfortunately, Evernote keeps adding features which clutter the UI if
you don't need that feature, such as the latest one: Work Chat, or before
that Presentation Mode.

Evernote is great at unstructured personal documents. If your documents are
all structured, OneNote might be a better choice (or DEVONthink for the
Mac). It does kind of work as a group collaboration tool, but you can tell
that this is not its primary purpose.

They also tend to rewrite the client from scratch. The Windows client is
the third complete rewritten one. Mac has been rewritten twice. iOS either
twice or three times. Right now they have a UI that is somewhat hard on the
elderly because the UI element frames are difficult to distinguish (light
gray on white).

With Google Keep I wouldn't trust it to stay around long enough.

-- 
Christof


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

Re: Network Slow Query

[Christof Wollenhaupt]

 The tables are open with multilock and opportunistic table locking.


You mean optimistic table locking, right? Because opportunistic locking is
what likely makes the first query fast. But that is an SMB thing, not a VFP
feature.

Network access speed is largely driven by two factors: What data do I need
to read at all, and how fast can I get data across the network. For the
network speed the bandwidth is the least important attribute. More
important are latency and package throughput.

When only one client opens a remote file, the server and the client
negotiate who is allowed to maintain the read and write caches. In most
cases this will be the client. Effectively this means that the file only
needs to be transferred once and it can be done very efficiently in large
blocks, since all the repeated small block access happens on the client.

When a second client joins the party, the first client is being told to
send back the write cache and discard all client side caches. All further
caching is done on the server. This results in the second opening of a file
to be even slower than further requests, because the server has to wait for
the client to respond. It can also result in data loss, if the first client
fails to respond.

The second part is package throughput. VFP will basically read every record
individually. There are optimization when repeatedly continuous records are
requested, but in many cases it's down to one record per read request. The
number of packets varies wildly between the systems. On the same network
I've seen 250 packets/sec form a Windows 7 client onto a Windows 2008 R2
server and 1250 packets/sec from a Windows 8.1 client onto a Windows 2012
server. But that number is still very slow compared to the roughly 30,000
records/sec that a local drive provided.

Process Monitor from Sysinternals is a good way to see this type of
effects. When you filter on your application, you should see a huge list of
read requests each the size of a record. There's a time column on the left.
In my cases the times where 4 ms for Windows 7 and 0.8 ms for Windows 8.1

-- 
Christof


--- 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/CAL4QJhiiX-tswRSc5-MBNB6vUQ2UoJr2GZmSP9=gdg272ac...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Cloud Servers

[Christof Wollenhaupt]

I'm using ovh.com. They offer a broad range of services, from an
inexpensive virtual server for a few dollars to a redundant private cloud
based on ESXi. Support requests are usually answered within an hour to a
day depending on severity of the issue. You can renew on a monthly basis
which for me meant that I would simply move my server to another machine if
I encountered problems instead of wasting my time fixing the issue. Their
North American location is at the US/Canadian border.

-- 
Christof


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

Re: [NF] Supporting remote clients

[Christof Wollenhaupt]

 TeamViewer is a one-time fee, right, Matt?


Kind of... You pay once and can use it as long as you want.

However, each client can only talk to clients of the same version or lower.
They prominently feature the latest client on their website. If your users
happen to download those, or some other company installed a newer version,
it's a real hassle to get a user to quit the newer one, download the older
one and execute the correct version.

The iPad version keeps supporting the latest version and is even less
expensive than the desktop version. Which is helpful in these cases.

-- 
Christof


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

Re: Containers was Watson interface

[Christof Wollenhaupt]

 http://azure.microsoft.com/blog/2014/10/15/new-windows-server-containers-and

 http://azure.microsoft.com/blog/2014/10/15/new-windows-server-containers-and-azure-support-for-docker/
 -azure-support-for-docker/

 http://azure.microsoft.com/blog/2014/10/15/new-windows-server-containers-and-azure-support-for-docker/


It seems this should have some bearing on Mike's interest.


I'm not sure... This article talks about running Windows Server
applications as a container. It'll help to deploy server based Windows
applications on Windows Server 2014 R2/2016 and onward. There is no mention
that you can run existing Linux containers on Windows Server or vice versa.
It doesn't help a typical VFP desktop application, either.

To the contrary, actually. Windows virtualization is largely driven by the
need to run separate OS server systems for a variety of server applications
for compatibility and security reasons. This led to Windows DataCenter
virtualization with unlimited licensed instances per licensed Server. Most
companies that want to centralize VFP desktop applications rely on these
licenses with terminal server farms or remote desktops.

When the need to run many virtualized servers fades away, there is little
incentive for Microsoft to keep this license model. Instead they are free
to push their own Desktop As a Service approach that is  more expensive
(Windows DataCenter is less than $150/month).

For a modern server based application, I can see that this is a sweet
development. As a classic desktop developer I just see one required more
piece going away.

-- 
Christof


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

Re: [NF] Reformat a MAC

[Christof Wollenhaupt]

 My wife wants to reformat as the performance has degraded severely. She
 had done all upgrades since she's had it.  She believes reformatting will
 improve performance.


The new MacOSes have higher performance requirement that older ones. If
that's something like a 2009 MacBook and you install Yosemite, it's going
to be slower than running Snow Leopard. We found that the best way to
improve performance is replacing the hard disk with an SSD drive and adding
more memory.

Since we just stumbled across this a few days ago: If you have enabled
FileVault, you need the recovery password in order to format the hard disk,
or decrypt the drive before formatting.

Christof


--- 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/CAL4QJhhwuCMNnfw+rCT4c_Daad+xDNsWq4sQ-9=oufqhamg...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Extreme Case of PRG File Corruption?

[Christof Wollenhaupt]

 Anyway...all this is not my real problem. My real problem is, how can
 moving a completely unrelated class definition from one .prg file to
 another trigger this insane error?


The behavior you see would make sense if the MainForm object where the
Resize method is triggered is based on the MyForm class that you move
around or contains an object that is based on this class.

-- 
Christof


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

Re: Very Frustrated !!

[Christof Wollenhaupt]

 How can this happen and more important how can I avoid this in the future ?

 Is this a Foxpro problem ? a Windows 8 problem or a Dell laptop problem ?


It's a known bug in VFP. When VFP saves a form it saves using a temporary
name, deletes the old version and renames the temporary copy. Windows can
delete a file that is still open, say in a virus scanner. The file will
then not be removed and has the state DELETE_PENDING.

VFP can't deal with this. It get's the OK back from the delete call and
assumes that the form is gone. But it's still there and will automatically
be deleted when the lock on the file is released. Because the file is
there, the temporary copy cannot be renamed, but VFP ignores that.

For SCX files you might have luck finding two TMP files in the same folder
as your form which contain the SCX/SCT files. The names usually only differ
by one ending letter. The smaller name (eg. 1ABC123K.TMP is the SCX
file, the larger name (eg. 1ABC123L.TMP) is the SCT file.

-- 
Christof


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

Re: [NF] Virtual Machine Need for Antivirus?

[Christof Wollenhaupt]

 I called Avast and they told me that not to load into the VM.


That certainly is a weird response...

Maybe they meant to say that your license covers only a single machine and
you are not allowed to install one more in the VM?

Or, the asked for the specs of the hardware and meant that it would be too
slow when two instances of Avast are scanning at the same time.

A google search on virtual xp mode avast indicates a number of issues
with Avast. If that was the reason for Avast to tell you not to install a
virus scanner, you should certainly check out another one that is working.

As others have said, a virtual machine connected to any virtual or physical
hardware is just as vulnerable as a physical machine and can just as easy
infect any other machine on your network.

-- 
Christof


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

Re: [NF] Virtual Machine Need for Antivirus?

[Christof Wollenhaupt]

 I'll do a Google search on VMware and on Avast.


I don't know if VMWare and Avast have the same issues. The operating system
combinations you gave looked like you might have been talking about the
Virtual XP mode in Windows 7 and later which is a virtualized copy of
Windows XP using Microsoft's Hyper-V technology. That was speculation on my
part and does not apply, when you are actually using VMWare Player.


 What are your thoughts on using Avast on the host  AVG on the guest
 (vmware player)?


I can't really comment in Avast or AVG. I use ESET for my systems. I do
think, though, that any virus scanner on both machines is better than no
virus scanner.

-- 
Christof


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

Re: Prague Meet up.

[Christof Wollenhaupt]

If anyone wants to combine this with a visit to Germany... German DevCon is
from Nov 13th to 15th. One, two and three day tickets should be available.
There's is at least one track of English sessions.

-- 
Christof


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

Re: [NF] Small and Light Replacement for Laptop

[Christof Wollenhaupt]

 Is there an alternative to M$ Office for the Mac?


Depends on what features you use... 90% of my office stuff is Google Docs.
I do have Mac Office on my main machine for the remaining 10%.


 Is there a similar product to M$ Outlook for the Mac - my life revolves
 around Outlook?


There's Outlook for Mac. The Mac version comes with Office 365 which is
available for $69.99/year and does include the full versions for the iPad,
too.


 Can I run VFP under Win 7 on Virtual Box?  I need to be able to maintain my
 few remaining VFP apps.


I used VMWare and Parallels. VFP works great in both. Can't comment on
Virtual Box.

-- 
Christof


--- 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/CAL4QJhgTZcfxKNZc3v=c-oJPHKiunFHurGV3u=t4v3b0wdq...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: use dropbox,cubby,one drive,google drive as cloud server

[Christof Wollenhaupt]

 use \\dropbox\???..\mytable.dbf

 Is this possible?


No. With dropbox you can open the local copy, but you will at some times
end up with conflicting copies.

-- 
Christof


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

Re: Still have a need to run FoxPro for DOS or other DOS software?

[Christof Wollenhaupt]

The issue with DOSBox is that it's extremely slow in running FoxPro DOS.
It's like a dBase converter. g

-- 
Christof


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

Re: File exists function in win api

[Christof Wollenhaupt]

You could also use SYS(2000) which is just a wrapper around the FindFirst,
FindNext API, or ADIR() which does not exhibit the same strange behavior as
FILE() does.

-- 
Christig


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

Re: VFPEncryption71.fll hanging up Inno Setup compile

[Christof Wollenhaupt]

 Every time I try to compile my setup.exe with the vfpencryption71.fll
 included, Inno hangs and says the file is in use.


I had the same issue with FinalBuilder and a different file. Turned out
that ESET AntiVirus was scanning the file at this time. While the virus
scanner is analyzing a file it's locked for other processes for write
access.

You can use Sysinternals' Process Monitor to see whether the virus scanner
is the culprit.

-- 
Christof


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

Re: Running a Batch File from VFP

[Christof Wollenhaupt]

You can use CreateProcess to execute the batch file. One of the parameters
in the structure passed to CreateProcess is a pointer to a new environment
block.

Or you can use the SetEnvironmentVariable API function to set the variables
for the current VFP application which then would be inherited by any child
process you launch.

You should also run the test again with disabled virus scanner and malware
protection. Using a batch file to send e-mails is pretty much what spammers
would do on a computer. All current scanners monitor behavior of processes,
let them do their stuff and terminate the process or handles once activity
is suspicious. That's the same reason why we get sudden error reading
file messages in VFP applications.

-- 
Christof


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

Re: [NF] Windows permissions

[Christof Wollenhaupt]

Al,

If you need to store files that only the current user needs to access, then
they go into the user's home directory. Application Data is the perfect
place for this.

If you have data that is shared among users then this data either goes onto
a share on a server, or in a directory that your setup program creates in a
place of your (or your user's choice) along with the correct permissions.
The setup needs to be executed by an administrator. Look at c:\inetpub as
an example.

If you don't want a setup program and don't want to deal with permissions,
your program goes onto a second partition or drive (eg. D:\). Any partition
other than the system partition is set up for read/write access by default.

-- 
Christof


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

Re: [NF] Can a Mac Join a SAMBA NT Domain or Access a Windows RDP Server?

[Christof Wollenhaupt]

Hi Ken,

Default account? I am not familiar with Macs, but the user is not logging
 into his local machine with the domain user account I am referring to. He
 has his own local account for the Mac. I don't see how the Mac would
 automatically know his domain user account credentials in order to connect
 to a network share.


When a Mac connects to an SMB share it attempts to log into using the local
credentials, and if that fails, as a guest. Each share can only be
connected once. So if the share is connected, he needs to disconnect first.
The way to do this on the Mac is

In Filer press Shift+Cmd+G to open the Go to Folder dialog.
Enter /Volumes
The Public share should be listed. Right-click (Ctrl+Click by default) and
select Eject Public

A Mac can join a domain. Here's a description of all required steps:

http://www.techrepublic.com/blog/apple-in-the-enterprise/integrate-macs-into-a-windows-active-directory-domain/

If SMB2 is the problem (it is for older clients with Mavericks) then you
can disable it:

http://www.zdnet.com/mavericks-smb2-problem-and-fixes-722519/

Eventually, you can activate the AFP protocol on the CentOS machine. That's
the Apple File Protocol. Often it's disguised as Time Machine access in
NAS systems.

-- 
Christof


--- 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/CAL4QJhhPW=rZx9eSTyfspUC1S-jd2ZjG1=u_y6fbb622fqb...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Comparing security settings of two folders

[Christof Wollenhaupt]

 Do you have a good tool that does that? What is it?

 I just found some interesting problem in my Win 8.1 installation.
 Changing the owner of my user folder could prevent all Metro apps from
 working. Restoring the owner to its previous value did NOT reset the
 problem. :)


I would use CACLS.EXE recursively to list security information into a text
file and then use BeyondCompare (or something similar) to compare these
files.

-- 
Christof


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

Re: Encryption

[Christof Wollenhaupt]

  # use a truecrypt volume


That's a good suggestion. BitLocker would be another option. To protect
against theft, it's a lot more secure to completely encrypt the drive
instead of individual files and make unencrypted copies of them.

To control access it's easier and safer to simply use Windows permissions.
Let the charity create a user group for those that are allowed to process
sensitive data. Give this group access to your member table and do not
allow anyone else to access the file. Make sure your application handles
the Access denied error message that you will get without permission.

The charity needs to do some work, as well, like documenting processes and
establishing a regular audit.

-- 
Christof


--- 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/CAL4QJhh3oVWSm+49p+9yBQFWtKcDhvX3qxgJg4GHBGZ4=sl...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Encryption

[Christof Wollenhaupt]

Hi John,

a) Please start reading about the data protection act before you do
anything. This is a good introduction:
http://ico.org.uk/Global/~/media/documents/library/Data_Protection/Practical_application/THE_GUIDE_TO_DATA_PROTECTION.ashx

b) Your approach would not help you in any way to comply with the data
protection act. Compliance is not a matter of technically encrypting data,
it's a whole system that starts with the process, not a technical
implementation detail. You first need to be clear about who is processing
and storing which data for which purpose.

-- 
Christof


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

Re: [NF] Can a Mac Join a SAMBA NT Domain or Access a Windows RDP Server?

[Christof Wollenhaupt]

A gray share means that the user is already connected, most likely with his 
default account.

-- 
Christof
___
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/8ab50868-3546-44da-9d87-ba6c4d6e5...@foxpert.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 Indexes...

[Christof Wollenhaupt]

 Apart from the obvious decrease in performance, does anyone know how to
 find out how fragmented/overflowed VFP indexes are in a similar way to how
 you can find out the fragmentation of SQL indexes?


We keep track of the file sizes after the last reindex. Then you can
estimate fragmentation with:

( ((newCdxSize/newDbfSize) / (oldCdxSize/oldDbfSize)) -1 ) * 100

If this is 50, then index grew 50% more than the DBF file. It's only an
estimate, since indexes a compressed, so the actual space needed depends on
the data in the table. But it's good enough to trigger a reindex, when
combined with the growth in file size for either CDX or DBF file.

To calculate the precise amount of empty space vs. used space in the index,
you need to scan the CDX file which is a low level operation.

-- 
Christof


--- 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/CAL4QJhjTtYtkrkn1+k5uBuVg=fcug60qifuppxoa0mugrs1...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Apple The Evil Empire? was [NF] Should I use Window 7 or Windows 8?

[Christof Wollenhaupt]

  I don't think Apple are much different from Microsoft in their attitude
  to users. Look what they did to iWork for example.


 I'm not a daily OS X user. What's the iWork story?


So Microsoft keeps adding features to Office and gets blamed for that.
Apple takes features away and causes an outcry. Google hasn't changed
Google Docs at all, and that's not good either... g

Neither Apple, nor Microsoft behave inconsistently, though.

With Apple you just know that they don't care about older products, they
never have. Not a single Mac application that was on the market when
Windows XP was released does run on the latest Mac. Not a single one. If
you look at support expiration most Apple products are measured in a years,
two maybe three, not a decade like Microsoft. Even features that would
possibly run, they don't allow. They sell hardware: New means sales, old,
who cares?

Microsoft sells software licenses. Have an older machine? Guess what, one
of the features touted for Windows 8 was that it runs on less powerful
machines than Windows 7. Any hardware is good, as long as you keep buying
new products. Licenses are important, so don't expect unlimited users or a
free OS upgrade like Apple is providing them.

At the end of the day, these corporations sell the exact same stuff to
billions of people. How personal can this experience possibly be?

The OS has become a commodity, anyway. Computer power has become a
commodity (our main machines are in a data center). Most people seem to pay
more attention to whether something is new, rather what the exact technical
specification is. Developers are a rare exception. Years ago when somebody
posted that they bought a new laptop, Toni Feltman used to joke and ask
which color?. I admit that these days I do pay more attention to the
color of my computer than the type of RAM or CPU model. Apple makes that
easy. They are like Starbucks: MacBook Tall, MacBook Grande, MacBook
Venti... and you can pick a flavor.

-- 
Christof


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

Re: Invalid seek offset

[Christof Wollenhaupt]

 Has anyone come across a definitive reason for this error?


You get this error when the network connection dropped even for a split
second and the file handle became invalid.

-- 
Christof


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

Re: google maps

[Christof Wollenhaupt]

 I downloaded your Googlefy-your-App zip file and it contains some terrific
 stuff. However, an include file (acodey.h) references iAcodey.h which
 doesn't exist in the download (as far as I can see). I've commented out the
 reference to acodey.h in chttpclient.prg and everything works OK, at least
 in maps.scx


Good point, should have mentioned this in the docs.

iAcodey.h is the place where settings from Acodey.h are overidden. It's
part of the framework to allow updates to the main include file. Just
create an empty iAcodey.h file and everything should work fine.

acodey.h contains some of the constants of foxpro.h, specifically the T_
type constants (T_CHARACTER) which I use for VARTYPE() checks.

-- 
Christof


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

Re: [NF] Advice on selecting cloud storage and backup services?

[Christof Wollenhaupt]

 I'm overwhelmed with the options for cloud storage and backup. Anyone
 have a favorite service they would like to recommend or a service to
 definitely avoid? My use cases are cloud accessible storage for roaming
 Windows/Mac laptops daily workstation/server(?) backups, and limited
 secure file sharing between a limited number of parties.


What would be the locations of the computers that you mostly want to keep
in sync? If they are all in the office, maybe a storage device (like a
Synology) would be easier. They often have a cloud sync client, too.

What's your storage size requirement? Beyond 100 GB things become quickly
more expensive. On the other hand, renting a computer in a data center can
be inexpensive. OVH offers a server with two physical drives for around $39
per month in the US. It's down to around $10 if you can live with a
computer in Europe.

I do have a Google Apps for Business account and use Google Drive for a lot
of things. It works well enough for regular documents. Not as seamless as
Dropbox, but still well enough to be worth the price difference.

One thing you need to be aware of is that most sync services have a file
size limit. It's 10 GB for Google Drive, Dropbox (when using the web
client) and Synology CloudStation. 2 GB for SkyDrive.

-- 
Christof


--- 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/cal4qjhin+hthybr41wgurd2pgr1b+ppcn8xmu+a-mkeyq2q...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Moving from Windows to MacBook/OS X - advice on apps/accessories to consider?

[Christof Wollenhaupt]

 Any other gotta have apps, utilities, or hardware accessories you
 would recommend?


BeyondCompare... They have a Mac version now (
http://www.scootersoftware.com/beta.php).

What kind of files are you editing? For source code, you could use XCode
(free) or one of the JetBrain IDE's (WebStorm, PhpStorm, etc.).

Multiple monitor support does not work as well on the Mac as it does on
Windows. I've read about some issues even in Maverick and - as it seems -
4K monitors are not supported at all. One of my guys has used a macMini
with two monitors, and that worked fine. But now that I gave him an iMac
he's gone to one monitor only.

-- 
Christof


--- 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/CAL4QJhiqF8H_TJKVmu-bhWGHHDd_u6EC9eq5oRUPOiJV=ybQ=g...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: google maps

[Christof Wollenhaupt]

 I just got a request to show a google map on a form, when an address is
 given. IOW, the user opens a customer screen and it would contain, among
 other things, the full address.


If your application needs to print a map, too, you can use the Maps sample
from my Googlefy your App session. It displays the map in an image control
instead of a browser. Anything that does not open a full browser window
needs to be licensed, though.

http://foxpert.com/docs/googlefy-your-app.en.html

-- 
Christof


--- 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/CAL4QJhiGXUFycVCxFvgPMvONi9U=1mGkDzcH8=bnpqplmfa...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: virtualised servers

[Christof Wollenhaupt]

A virtualized server is a server that runs on a system like VMWare, Hype-V
or Xen. These systems enable the installation on multiple computers on a
single physical machine. Such a server looks exactly like a physical server
to your application.

If your application does not access any special hardware (USB devices,
serial port, extension cards) then it will run on a virtual server just
like on a physical server. I've been running virtual machines and servers
for many, many years now.

You might want to check, though, if your client has got their terminology
right. They may refer to a Terminal Service like Windows TS or Citrix.
That's a whole different thing and there are indeed some issues in VFP apps
that you might need to test.

-- 
Christof


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

Re: Guineu, FP runtine,. WHAT DOES IT DO.

[Christof Wollenhaupt]

 WHAT DOES THE GUINEU FP RUNTIME ALLOW ONE TO DO. (VFP 5.0 PART OF VIS
 STUDIO PROFESSIONAL)


It's a runtime that executes compiled FoxPro programs without the need for
Visual FoxPro. Guineu supports only a subset of the features found in VFP
plus some additional ones like native .NET objects, http and mail access,
and mobile support.

Most of the production apps are running on Windows Mobile devices usually
scanners or PDAs for mobile data entry.

-- 
Christof


--- 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/CAL4QJhgWwgQbtXwLsC1sjFaURcX_yE+hDaX9FN=ra8h5ooy...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Considering a MacBook Air or Pro - looking for advice

[Christof Wollenhaupt]

Hi Malcolm,

1. Memory: 8 or 16 Gb of RAM? I think the latter forces my hand on the
 MacBook Pro vs. Air? I'm thinking 8 Gb min in order to run the
 occasional VM.


8 GB is fine if your VM doesn't have more than 2 GB of RAM configured. RAM
is a lot impacted by how many web sites you have open. Chrome and Safari
eat RAM like candy. Right now I've one tab open in Chrome with the GMail
interface and Activity Monitor reports roughly 500 MB just for Chrome.


 3. VM software: Parallels, VMware, other? Ideally I would like to
 virtualize my existing Win 7 environment and have it available on a
 limited use basis.


Try both. Both have a 30 day money back guarantee and you can convert
machines either way. I like Parallels more, but have switched to VMWare,
because it's easier to move around virtual machines. If you store your
virtual machines on an external drive that is formatted in HFSP, you would
need something like MacDrive to mount them in Windows. Note sure if there's
a Linux driver for HFSP.


 6. Anything else?


Most people don't like the idea, but I do most of my development via RDP.
The actual development machines are hosted on an ESXi server and my Mac is
often only a terminal to the development machine. It puts less load onto
the client so that batteries last longer. The server is real server
hardware which is a lot faster than a laptop. It's easy to switch from
client to client when batteries are empty or a larger screen is needed
without terminating the current development session.

-- 
Christof


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

Re: SWFox Conf. Keynote is LIVE Now!

[Christof Wollenhaupt]

 There's a bottle of 18 year old Macallan in the liquor cabinet that's been
 waiting on an occasion. A toast tonight, with a nod towards Marina Del Ray.


Cheers!

Congratulations, Ted!

-- 
Christof
___
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/CAL4QJhiobihLbVsg4-NS1hz=ixbvw2zt7ssajawcfmfraqf...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [sortaNF] What's the deal with FoxRockX???

[Christof Wollenhaupt]

You should have access to all issues using the credentials you got:

http://portaladmin.dfpug.de/dFPUG/Dokumente/FoxRockX/PDFIssues/

The latest issue is the July issue (
http://portaladmin.dfpug.de/dFPUG/Dokumente/FoxRockX/PDFIssues/FoxRockX_201307.pdf
).

Christof


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

Re: Malware eating PRGs and SPRs

[Christof Wollenhaupt]

Hi Gérard,

VFP first temporarly renames the .bak (if it exists)
 Then, it copies the original on a 'new' .bak
 And then it creates the new .prg.


Actually, it depends...

If you configure the VFP editor to create a BAK file when saving a PRG
file, then you are correct. VFP renames the existing file to BAK. Any read
lock remains on the backup file.

If you, however, configure the editor to not create BAK files, you will see
the behavior that I described.

Christof


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

Re: Malware eating PRGs and SPRs

[Christof Wollenhaupt]

 I was at my customer's site from 8/20-8/31/13.  On 8/21, we discovered
 that all of the PRGs in \SBT7\AP\ were empty.  Date and time stamps were
 untouched.  We are converting an old VisionPoint, SBT7 program to Visual
 FoxPro.


I've seen similar behavior with virus scanners. The suddenly block access
to a file so initially you can open or read, but suddenly there's an error.
If that happens during a read, the file might appear empty even if it is
not. If it happens during a write, the file will be empty.

PRG and SPR have one other problem in VFP. When VFP saves a file, it
renames the original, saves the new one, deletes the copy and then renames
the new one. When the PRG/SPR files is opened with a read lock by another
program (usually a virus scanner or a text viewer), the delete operation
succeeds, but does not actually delete the file. Rather it's marked as
DELETE_PENDING, which means the file will be deleted once the reading
program closes the file. Since the file still exist, the final rename
fails. As a result you end up with no PRG file, at all.

In your case, I'd demand that they keep running ProcMon with a capture
filter on PRG files. If there's an access problem you would note it there.

-- 
Christof


--- 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/CAL4QJhh=rtdMSZ7b=YDFODL=7HF7__XWk=voeqp1wcgt77x...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Text 'jumping' in grid

[Christof Wollenhaupt]

That is controlled by the Margin property. The column control displays text 
without a margin. The Textbox control that is displayed when the column 
receives focus has a default margin of 2. 

Christof
___
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/a3a5e08d-064d-445b-9a7b-258d93ad7...@foxpert.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: Mergingall VCX files.

[Christof Wollenhaupt]

 I have a load of disparate VCX files that I want to merge into one for
 deployment.


To add a class to a VCX file you would use the ADD CLASS command:

ADD CLASS myClass OF oldLib TO newLib

To get a list of all classes in a VCX file, you use the AVCXCLASSES
function. The problem with the native commands and your manual approach is
that the location of parent classes is not updated. That is one feature
that the class browser does. If you move all classes into a single library
it would be a matter of replacing the CLASSLOC field with the new VCX name.

-- 
Christof


--- 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/CAL4QJhjGyK-OtdR8EfbN54okPLo=i+e3ojbjwnvlw4bubtj...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [FPD] Abnormal program termination

[Christof Wollenhaupt]

Hi Kevin,

Sudden program terminations have for us all been data or hardware
related... It's usually a corrupt index or memo file. On the hardware side
it's mostly a thermal issue.

I've last tried DOSbox a few months ago. We have a performance test in our
application that does a number of typical FoxPro operations, mainly a
combination of performing calculations and SEEK operations. DOSbox was over
100 times slower than a Windows XP machine both running on the same host
computer.

-- 
Christof


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

Re: [NF] Intel i5 vs. Xeon CPU for a data server

[Christof Wollenhaupt]

 Does the availability of SSDs affect the desirability of quantity of disks
 vs. size, Christof?


SSD is still expensive, and yes, you would still want multiple, because
rebuilding a smaller disk takes less time than rebuilding a larger disk and
thus leaves your RAID vulnerable for a shorter period. It's less important
than with spindles, though, since SSD have IOPS a hundred times higher.

The biggest issue with SSD in servers is that server SSD are very different
from desktop SSD. SSD don't work like memory where you can simply change a
byte. They operate on pages just like a disk. Unlike a disk, however, you
can't just overwrite an existing page, the page has to be all zero before
you can set bits.

Therefore replacing an existing record requires the disk to first blank the
page, then write new content. Since that operation costs time, the SSD
usually moves sectors around. If you change a sector, the SSD is looking
for an empty page and puts the new sector in that page. Then it marks the
existing page pending and puts it into a queue. When the disk is idle, the
drive purges old pages.

Because of this an SSD drive gets exponentially slower the fuller it gets.
All SSD drives have more memory than they report as disk space. A desktop
SSD has only a bit more, a server SSD usually has twice or three times the
memory, so it always finds a blank page even with heavy load.

Thats where TRIM support is important, on the SSD side and the software
side (ESXi, for instance, does not support TRIM). TRIM means that the
operating system reports to the disk that a sector may contain data, but
that the file system considers this block to be empty and will overwrite it
when demand is there. That happens, for instance, when you delete a file.
The content is still there, the file is only removed from the index. With
TRIM all sectors are additionally reported as empty. This gives the drive
the opportunity to blank those pages when its idle and increasing the
number of empty blocks.

SSD often work on 4K pages. You need to know this, because otherwise you
might just change 1024 bytes (two sectors) that are in different pages,
causing 8 KB to be read, purged and written.

-- 
Christof


--- 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/CAL4QJhjKF=tr4z1ho_eoaizwmetcsg2b+bofvgbkixqbdcu...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Intel i5 vs. Xeon CPU for a data server

[Christof Wollenhaupt]

CPU usage isn't a valid measurement to compare desktop and server CPUs. The
same application might use 5% on a Core i5, but only 2% on a Xeon E7 due to
triple the cache, better conflict management, better predictive queues,
etc. A Xeon would still be twice as fast in this case. A core isn't a
separate CPU. A number of parts of the CPU do not exist once per core and
are shared among cores. Most importantly, the cache and the bus are shared.

Before you do any guessing, you could rent a server in a data center for a
month and do some load testing yourself. Amazon rents Xeon machines by the
hour for a few cents per hour. In a data center you get a i5 for less than
$100 a month and Xeon for less than $200.

With a database server I'd pay probably pay more attention to storage,
memory and connectivity.

Instead of local storage, I'd probably get a SAN connected via multipath GB
network. There're inexpensive SANs available from Qnap, Synology, and the
like. Most of them offer replication between two instances. If the database
server performs replication, that's extra load and bandwidth taken from
read-only, in memory queries that the server could do instead.

If your database application has lots of writes you have to pay attention
to IOPS on the storage system. 200 clients on a single mirrored disk system
with 150 IOPS means that a write operation will take about a second.
Replace it with a RAID that has many spindles, you increase IOPS linearly.
IOPS are the reason that most server disks are still small (600 GB, 1.2
TB), because in a server you want more disks, nor larger disks.

Closely related is the topic of alignment. In a database server the
database block size MUST align with the cluster block size and location of
file systems and disk. Otherwise you might end up with a system that has to
read/write multiple clusters for every database block. That's especially
important as some file systems use significantly larger cluster sizes of up
to 2 MB or with virtualized drives.

When you test network performance keep in mind that bandwidth is only part
of the equations. The other important measure is packets per second (PPS).
Every switch/router/hub has a limit of how many IP packets it can manage
per second. Higher PPS values are often the reason that a business switch
is so much more expensive than a consumer device even if both have GB ports.

--
Christof


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

Re: JPG file in a VCX

[Christof Wollenhaupt]

Is this for an image control? If so, you can write a small program that
takes the file and converts it to a series of CHR(xx)+... code lines. Then
assign the resulting string to the PictureVal property.

This won't work if you need the image as an icon for the class in the
project manager.

-- 
Christof


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

Re: Design Question: Abstract Classes, Yes or No?

[Christof Wollenhaupt]

Hi Ken,

Are there any real benefits to using abstract classes between one's
 immediate subclasses of all VFP controls, and one's first layer of concrete
 classes, in VFP? If so, what are they?


No, usually not. In most cases it's another case of adopting a practice
that is valid for other languages even when it's not appropriate in Visual
FoxPro.

Empty classes in VFP make sense when you are providing code to third
parties as a framework vendor or tools provider. In these cases they
provide developers with a place to put customizations of the framework
without resorting to complex strategies. They are also useful if your users
create a lot of specialized subclasses and you want to ensure that certain
methods are always callable or properties are guaranteed to be there.

In most other cases I've come across they are merely there just in case
or because it's good OOP practice.

Can't comment on Python or Dabo.

-- 
Christof


--- 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/CAL4QJhhrzHD0F6mNo5tXq-KSvwyiVDdZT9fVXJU=ypnpq+4...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Google Calendar API

[Christof Wollenhaupt]

Hi Sytze,

If this relates to a VFP APP, I sure would like to hear more.
 I really want to integrate with Google Calendar and I have been stuck for a
 long time


My fault. I remember I have dropped off a conversation. Where are you stuck
now?

-- 
Christof


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

Re: Pack memo doesn't pack deleted records, does it?

[Christof Wollenhaupt]

 Yeah, that's what I have.  What do you do instead of that?


Instead of directly adding to the memo field it would be better to append
to a variable and then store the result into the memo field.

I forgot to mention that the replace line should have no effect on a
buffered table. So that might be another option.

-- 
Christof


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

Re: Pack memo doesn't pack deleted records, does it?

[Christof Wollenhaupt]

 And boy do I have bloat.

Check if you have code along the lines of

REPLACE memo WITH memo + string

This line always appends the whole memo field to the end of the file, even
if there would be free space in the current block. Updates within a block
only occur if the table is opened exclusively.

-- 
Christof


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

Re: SPACED OUT CAN MAKE LIFE A MISERY, WHY DOES IT HAPPEN

[Christof Wollenhaupt]

The corruption is definitely caused by something else. VFP never executes
the source code directly, but compiled (tokenized) code. The tokenized
versions of both lines are identical and can therefore not produce
different behavior.

What kind of corruption are you experiencing? If the DBF file is on a
network share, consider checking the network connection first. You might
also run into a heat problem, especially when the computer is already old.

-- 
Christof


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