AW: VFPA

[juergen]

Hi Chris,

the password for the download of the free version at
http://www.baiyujia.com/f_downloadproc_vfpa32.asp

is a simple "ok" 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Chris Davis
Gesendet: Dienstag, 30. April 2024 12:16
An: ProFox Email List 
Betreff: VFPA

Noticed the download of this is now password protected, has it's
availability changed?


[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/003301da9af0$55389110$ffa9b330$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: VFPA Shortcut Keys

[juergen]

Hi Eric,

Me thinks that those new shortcuts are not really into Internationalization. 
For that "[" we here in German must press Alt+Ctrl+8. Now mix that with another 
Ctrl-Press for getting somen indention? 
Or it works by the physical key-position, then it would be Ctrl+ö or Ctrl+ä, 
which would be also very hard to memorize.

But of course, I'm happy with any improvements for our beloved overaged baby. 

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Eric Selje
Gesendet: Freitag, 1. März 2024 17:57
An: ProFox Email List 
Betreff: VFPA Shortcut Keys

I just got the latest VFPA updates email, and was struck by how awesome the
new keyboard shortcuts are:


___
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/014901da6c10$bfc70a20$3f551e60$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Run under WIN 11

[juergen]

Hi Charles,

VFP3 would run, but only if you have less than 728 Mb of RAM. On today's usual 
boxes with at least 2Gb it errors out with "Insufficient Memory".
Everything else from VFP5 upwards is still working ok. I tested all versions. 

But why would anyone use something even older than VFP9, which is now already 
20 years old? (First release was on 2004-12-13)


wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Charles Hart Enzer, M.D.
Gesendet: Sonntag, 28. Januar 2024 09:09
An: Profox 
Betreff: Run under WIN 11

What is the oldest version that can run under WIN 11

Thank you
-- 


___
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/01a401da52bd$d99f4000$8cddc000$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Printer Dialogue

[juergen]

BTW: To get the oldfashioned printer dialogue for that SYS(1500) stuff,
you need to do this once for every user:

RUN "REG add HKCU\Software\Microsoft\Print\UnifiedPrintDialog /v
PreferLegacyPrintDialog /t REG_DWORD /f /d 1"

Change that trailing "1" to "0" for restoring the new print dialogue

Instead of that onpopping dos-window, real PROs of course would use that
nifty registry class of VFP :=)  
But that one can't read/write values other than strings, and we need
numeric.

Therefore this one would be more modern than a CMD window flashing by:

oWSH = CreateObject("WScript.Shell")
oWsh.RegWrite("HKCU\Software\Microsoft\Print\UnifiedPrintDialog\PreferLegacy
PrintDialog", 1, "REG_DWORD")

to check for that Value use
nResult =
oWSH.RegRead("HKCU\Software\Microsoft\Print\UnifiedPrintDialog\PreferLegacyP
rintDialog)


wOOdy



___
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/004001da342a$d934d500$8b9e7f00$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Printer Dialogue

[juergen]

It's the SYS(1037) dialogue.

AFAIK, the VFPA version has that bug (and many others) fixed.
http://www.baiyujia.com/vfpadvanced/f_vfpa_about.asp

If that's not an option for you, you could write your own function:

FUNCTION Sys1037
SYS(1500,'_mfi_sysprint','_mfile')
RETURN

You now only need to find a way to hook into the toolbarbutton of that
REPORT toolbar. That should be possible with the sourcecode provided at
VFPX.
https://github.com/VFPX/ReportingApps

BTW: have you checked if maybe Doug Hennig has already fixed that there?

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Donnerstag, 21. Dezember 2023 15:14
An: profoxt...@leafe.com
Betreff: Re: Printer Dialogue 

Not following Chris - do you mean GetPrinter() ?

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

[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/001d01da341e$db0b3920$9121ab60$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: ChdkDsk from VFP

[juergen]

Hi Alan,
Thanks for this much needed hint on the obvious way to go.  Moreover, I had
even given several DevCon talks about controlling the PC with the shell
object etc, but that was many years ago. But I might have known :(
Seems I'm getting really old :(

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Montag, 4. Dezember 2023 10:10
An: profoxt...@leafe.com
Betreff: Re: ChdkDsk from VFP

You could skin it a different way and use WMI:

strComputer = "."
objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" +
strComputer +"\root\cimv2") 
objDisk = objWMIService.Get("Win32_LogicalDisk.DeviceID='D:'")
errReturn = objDisk.ChkDsk(.f.)  && or .t. to fix errors
? errReturn

I believe the return codes etc are as described here:
https://learn.microsoft.com/en-us/previous-versions/windows/desktop/vdswmi/c
hkdsk-method-in-class-win32-volume



___
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/005301da29d5$a4636080$ed2a2180$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

ChdkDsk from VFP

[juergen]

Hi guys,

this time I need some help.  I have the need to do a "CHKDSK D: /F" from
within VFP on some USB-Sticks. 
Yes I could do a RUN, but that thingy still needs no, one ore more keypress
sometimes. 

The next best thing would be a shell.run() and a shell.sendkeys() to that
window, with hopefully enufs "N" to respond to all questions.  Still not
quite satisfying...

Thus I thought that there may be some API call or tool available to do this
in a more controllable way.
Any ideas welcome :=) 

 
wOOdy



___
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/006101da2396$56d7a2d0$0486e870$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: ZPL

[juergen]

Hi Chris,

I suspect that you have a "misbehaving char" in your hex data, something like 
Ctrl-Z, which terminates the standard DOS copy process. 

If you need to transfer binary data to your printer, you could use this routine 
here:

??? ChrTran(File2Str("yourPicture.jpg"), "{", "{{}")

wOOdy



-Original Message-
From: ProFox  On Behalf Of Chris Davis
Sent: Monday, November 13, 2023 3:13 PM
To: profox@leafe.com
Subject: RE: ZPL

Done a bit more testing and capture the print job it looks like it only sends 
upto 16535 kB to the printer before it's then captured as a job? Make any sense?



___
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/03d801da16d4$6eb11db0$4c135910$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: ZPL

[juergen]

Hi Chris,

You connect to the printer with a regular 
cPrinterName = GETPRINTER()
SET PRINTER TO NAME (cPrinterName)

Then you open the printer 
SET PRINTER ON

And all commandlines starting with ??? get sent directly, without conversion of 
the Windows drivers.
thus:

#DEFINE CR CHR(13)+CHR(10)

??? "^XA" + CR
??? "^CF0,60" + CR
??? "^FO50,50^GB100,100,100^FS" + CR

SET PRINTER OFF
SET PRINTER TO


One caveat: The ??? command also translates embedded strings between curly 
braces:

??? "This is a printer control string: {27}Q{100} to set the right margin"

If you need to print that left curly bracket in real, then you need to do a 
"{{}"

wOOdy





-Original Message-
From: ProFox  On Behalf Of Chris Davis
Sent: Monday, November 13, 2023 12:27 PM
To: ProFox Email List 
Subject: ZPL

Hi All

Would anyone have any suggestions of how best to approach sending ZPL commands 
to a compatible printer?

If the printer is on the network I can get this to work using ChilKat such as 
https://www.example-code.com/foxpro/socket_connect.asp

But I have also found that you can get ZPL to a printer that is connected via 
USB or network using the Generic / Text Only Driver ... this works with a 
simple example from

https://labelary.com/viewer.html

but if the commands become more extensive (maybe because an image has been 
included) then this method goes wrong I think because the driver is doing 
something relating to page size? But not sure.

If possible I would like a native VFP method of connecting to either a USB or 
Network connected ZPL printer and be able to send whatever I like ... thoughts?

TIA


Chris Davis




--- 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/023901da1628$b8478a10$28d69e30$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Programatically placing text boxes on a form - continued

[juergen]

This one even provides a working version :=)

***
nStartRow = 10
nStartCol = 10

For nCol = 1 To 4
  For nRow = 1 To 10
cTextBoxName = "TextBox" + Trans(nCol) + Trans(nRow)
Thisform.AddObject( cTextBoxName, "textbox")

With Thisform.
  .Left= nStartCol + ((nCol-1) * 110)
  .Top = nStartRow + ((nRow-1) *  24)
  .Width   = 100
  .Value   = "Cell " + Trans(nCol) + ", " + Transform(nRow)
  .Visible = .T.
Endwith
  Endfor
Endfor
***





___
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/000d01da0b74$16bc1df0$443459d0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Logging

[juergen]

... logging to Windows Eventlog. As well as reading that from VFP



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Eric Selje
Gesendet: Dienstag, 1. August 2023 15:13
An: ProFox Email List 
Betreff: Logging

I'm doing a session on logging at SW Fox.

Just based on that information, what would you hope to see the session
cover?

Thanks,

Eric


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/008101d9c4aa$b2e3fab0$18abf010$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Fox.wikis.com

[juergen]

This properly can't work, because the Wayback machine can only follow hardcoded 
links, but not dynamically generated content, coming from a database.



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Jeff Roberts
Gesendet: Donnerstag, 20. Juli 2023 17:02
An: ProFox Email List 
Betreff: Re: Fox.wikis.com

Can't you get the entire thing read only like this:
https://web.archive.org/web/20220129162420/http://fox.wikis.com/wc.dll?wiki~VisualFoxProWiki


[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/02e501d9bb1f$f5ea3ed0$e1bebc70$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: XLSX-Workbook-Class

[juergen]

It would help if you would specify, which xlsx class you're referring to.
Link?

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Chris Davis
Gesendet: Donnerstag, 26. November 2020 16:53
An: profox@leafe.com
Betreff: XLSX-Workbook-Class

Can anyone help with this ???


___
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/02fe01d6c411$8faf5950$af0e0bf0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not 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 and VSS Database does not exist

[juergen]

Hi Martin,

wow. Somebody stil uses the real VSS? Dude...  Why not at least use VAULT
from SourceGear.com? It's free for SingleUsers, and replaces VSS perfectly.
It also integrates the very same in VFP.
They even had some conversion / import tools for VSS, if I remember
correctly.

wOOdy


___
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/002701d6c1a5$210468b0$630d3a10$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Greg Reichert / GLRsoftware.com

[juergen]

SXQgd2FzIHN0aWwgYWN0aXZlIGluIDIwMTgsIHNpbmNlIGF0IHRoYXQgdGltZSBJIGRvd25sb2Fk
ZWQgc29tZSBvZiBoaXMgc3R1ZmYuSGUgYWxzbyB3YXMgbGFzdCBzZWVuIGF0IFVuaXZlcnNhbFRo
cmVhZCBpbiAyMDE5SG1tbS5Wb24gbWVpbmVtIFNhbXN1bmcgR2FsYXh5IFNtYXJ0cGhvbmUgZ2Vz
ZW5kZXQuCi0tLS0tLS0tIFVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodCAtLS0tLS0tLVZvbjogVGVk
IFJvY2hlIDx0ZWRyb2NoZUBnbWFpbC5jb20+IERhdHVtOiAyNC4wNi4yMCAgMTI6MjYgIChHTVQr
MDE6MDApIEFuOiBwcm9mb3hAbGVhZmUuY29tIEJldHJlZmY6IFJlOiBHcmVnIFJlaWNoZXJ0IC8g
R0xSc29mdHdhcmUuY29tIExvb2tzIGxpa2UgaXQgaGFzIGJlZW4gZ29uZSBmb3IgYSB3aGlsZTpo
dHRwczovL3dlYi5hcmNoaXZlLm9yZy93ZWIvMjAwODEwMTUxMjAzMTMvaHR0cDovL3d3dy5nbHJz
b2Z0d2FyZS5jb20vZG93bmxvYWQuYXNwT24gV2VkLCBKdW4gMjQsIDIwMjAgYXQgNToyNCBBTSBK
w7xyZ2VuIFdvbmR6aW5za2kgPGp1ZXJnZW5Ad29uZHppbnNraS5kZT53cm90ZTo+IEFueWJvZHkg
a25vd3Mgd2hhdCBoYXBwZW5lZCB3aXRoIEdyZWcgUmVpY2hlcnQgYW5kIGhpcyBkb21haW4+IGds
cnNvZnR3YXJlLmNvbT8+IEhlIGhhZCBzb21lIHZlcnkgbmlmdHkgVkZQIGNvZGUgcGFydHMgdGhl
cmUuIEknbSBsb29raW5nIGZvciBoaXMgU3lzT2JqPiBjbGFzczsgYmVjYXVzZSBJIGhhdmUgb25s
eSBhIGRhbWFnZWQgemlwIGZyb20gdGhhdCDimLk+PiB3T09keT4+W2V4Y2Vzc2l2ZSBxdW90aW5n
IHJlbW92ZWQgYnkgc2VydmVyXV9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fUG9zdCBNZXNzYWdlcyB0bzogUHJvRm94QGxlYWZlLmNvbVN1YnNjcmlwdGlvbiBN
YWludGVuYW5jZTogaHR0cHM6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3Byb2Zv
eE9ULWZyZWUgdmVyc2lvbiBvZiB0aGlzIGxpc3Q6IGh0dHBzOi8vbWFpbC5sZWFmZS5jb20vbWFp
bG1hbi9saXN0aW5mby9wcm9mb3h0ZWNoU2VhcmNoYWJsZSBBcmNoaXZlOiBodHRwczovL2xlYWZl
LmNvbS9hcmNoaXZlc1RoaXMgbWVzc2FnZTogaHR0cHM6Ly9sZWFmZS5jb20vYXJjaGl2ZXMvYnlN
SUQvQ0FDVzZuNHMtMWlrVFZlVFJhNi1kVkRrRTlnMHhKTy1EdV9jMmRfejZ4LWNhTWU0bmd3QG1h
aWwuZ21haWwuY29tKiogQWxsIHBvc3RpbmdzLCB1bmxlc3MgZXhwbGljaXRseSBzdGF0ZWQgb3Ro
ZXJ3aXNlLCBhcmUgdGhlIG9waW5pb25zIG9mIHRoZSBhdXRob3IsIGFuZCBkbyBub3QgY29uc3Rp
dHV0ZSBsZWdhbCBvciBtZWRpY2FsIGFkdmljZS4gVGhpcyBzdGF0ZW1lbnQgaXMgYWRkZWQgdG8g
dGhlIG1lc3NhZ2VzIGZvciB0aG9zZSBsYXd5ZXJzIHdobyBhcmUgdG9vIHN0dXBpZCB0byBzZWUg
dGhlIG9idmlvdXMu


--- 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/1m4je5-1jnngg1t0j-000...@mrelayeu.kundenserver.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not 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 ;)

[juergen]

Thanks for those pictures! Seeing all of that faces really gets you to
realize how times are flying by. And you realize, that yourself must be also
getting older...  Besides of Cathy of course, she always looks just
stunning...

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Jean Laeremans
Gesendet: Donnerstag, 7. November 2019 11:54
An: ProFox Email List 
Betreff: We''re getting old ;)

https://photos.google.com/share/AF1QipMPKYanhXpYX9QgsBQdRmEipX1A9a48iuzZbDxu
ccdyZWCRNTug-PWhKFZGS0BD2A?key=NThNYmdXVkhOYWtNTnNNTXFrUklqeVlMUWVRMkJn



[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/00c101d59570$33bfeef0$9b3fccd0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: [NF] Asian folder name found in my registry

[juergen]

It's just a Unicode Entry in a different language. 
Any information at the subfolders? 
You could always use the SysInternals tool to watch for that key, and see which 
program is using it.

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Montag, 4. November 2019 21:43
An: profox@leafe.com
Betreff: [NF] Asian folder name found in my registry

Added the [NF]...

While troubleshooting a Camtasia issue, I found this in my registry: 
https://www.screencast.com/t/JkFblYcJ6


What the heck is that?!?!?  Is Beijing spying on me?



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


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/038001d59351$ddaf39a0$990dace0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Exporting Tables

[juergen]

In case you don't know who or what "Vilhelm" is, you'll find him here: 
http://praisachion.blogspot.com/

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Koen Piller
Gesendet: Donnerstag, 31. Oktober 2019 16:24
An: ProFox Email List 
Betreff: Re: Exporting Tables

Gene,

Vilhelm made fabulous classes to export DBF tables with memofields in
MSExcel, MSWord, MSAcces have you tried any of them already?

Koen


___
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/087701d59006$3226e130$9674a390$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Will Visual FoxPro run on Windows 10's successor?

[juergen]

Hi Wes,
just by coincidence I stumbled across that discussion on Quora, which perfectly 
fits to debunk your miserable lies (as in "all support for Win10 will end" etc)

https://www.quora.com/When-will-Windows-11-come-out

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von wes.wil...@yahoo.com
Gesendet: Sonntag, 20. Oktober 2019 13:11
An: profox@leafe.com
Betreff: Will Visual FoxPro run on Windows 10's successor?

>From the internet:
Microsoft is planning to release a new operating system called Windows 12 in 
early 2019. Indeed, there will be no Windows 11, as the company decided to jump 
straight to Windows 12. The reason behind this name is rather a symbolic one. 
Windows 12 is the bridge between the classic Windows OS and the new innovative 
OS.May 2, 2019

Will Visual FoxPro run on Windows 12?

All support for Windows 10 will end in 2025.   For small companies who do not 
have the resources to convert to .NET, this could be a major financial blow. 
What might be the danger of running Windows 10 beyond 2015?
Any thoughts on how long VFP is likely to work?

Thanks,Wes
Wes Wilson, President
  ERW Custom Programming, Inc. Crescent Lake Plaza
5459  Elizabeth Lake Rd.
Waterford, MI 48327
(248) 683-4182
LinkedIn Profile

 "Companies pay too much attention to the cost of doing something. They should 
worry more about the cost of not doing it"  Philip Kotler www.erw.com 
w...@erw.com  

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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/006a01d58927$294efd30$7becf790$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Will Visual FoxPro run on Windows 10's successor?

[juergen]

Hi Wes,

Yes I see your motivation behind posting such stuff :)  
Unfortunately, your information is just FUD, as we see in that tiny little 
tidbid here: "a new operating system called Windows 12 in early 2019".

"Early 2019" is already gone, isn't it? And do we have any info on a Win12? 
Nope.
Should make you get thinking where you get your information from. 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von wes.wil...@yahoo.com
Gesendet: Sonntag, 20. Oktober 2019 13:11
An: profox@leafe.com
Betreff: Will Visual FoxPro run on Windows 10's successor?

>From the internet:
Microsoft is planning to release a new operating system called Windows 12 in 
early 2019. Indeed, there will be no Windows 11, as the company decided to jump 
straight to Windows 12. The reason behind this name is rather a symbolic one. 
Windows 12 is the bridge between the classic Windows OS and the new innovative 
OS.May 2, 2019

Will Visual FoxPro run on Windows 12?

All support for Windows 10 will end in 2025.   For small companies who do not 
have the resources to convert to .NET, this could be a major financial blow. 
What might be the danger of running Windows 10 beyond 2015?
Any thoughts on how long VFP is likely to work?

Thanks,Wes
Wes Wilson, President
  ERW Custom Programming, Inc. Crescent Lake Plaza
5459  Elizabeth Lake Rd.
Waterford, MI 48327
(248) 683-4182
LinkedIn Profile

 "Companies pay too much attention to the cost of doing something. They should 
worry more about the cost of not doing it"  Philip Kotler www.erw.com 
w...@erw.com  

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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/00cb01d58760$c6f542b0$54dfc810$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: VFP App Startup Program

[juergen]

Hi Gene,

normally your Starter programm just runs the main program, after checking
for updates, and then quits itself. The starter cannot update himself, thus
another program / task has to do this.  The easiest way would be to first
install a new main program, which checks the starter for version, and
optionally does the update for the starter program.  Thus the two can update
each other :)

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Gene Wirchenko
Gesendet: Samstag, 5. Oktober 2019 01:03
An: ProFox Email List 
Betreff: VFP App Startup Program

Hello:

  I have seen discussions about this at various times, but I have not
ever seen details.

  You have an app which might be updated and want to have that happen
automatically.

  In my case, it is a VFP .exe, and I wrote a program to handle that
years ago.

  What about if the startup program needs to be updated?  Since there is
a change (the first since) in that, I wanted to write a version that would
update the update program, too.  Somehow, it did not work.  And since there
is less debugging information available when debugging a .exe, I ended up
giving up on it after some trouble.

  My thought was to have two programs:

cbs2run.exe would check cbs2run2.exe if it needed updating (and maybe
update), check cbs2.exe (the app) if it needed updating (and maybe update),
then run cbs2run2.exe.

cbs2run2.exe would check cbs2run.exe if it needed updating (and maybe
update), then run cbs2.exe.

  The reason that I had two programs is so that cbs2run.exe would quit
running and be overwritable.  Even inserting a 5-second pause before trying
to overwrite cbs2run.exe in cbs2run2.exe did not work.  I got some very
inconsistent and confusing results.

  Was I overlooking something?  If so, what?

Sincerely,

Gene Wirchenko


[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/002701d57ce2$72d236d0$5876a470$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: VFP9SP2 DBC -- update trigger

[juergen]

Another option for generating a robust trigger code Including an optional
AuditTrail) would be AMRI, which is a replacement for VFP's original RI
builder.  This was Freeware from Markus Auer (hence the "A M" in the name).
If you can't find it at the usual tools libraries, send me a PM.
 
wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Eric Selje
Gesendet: Donnerstag, 3. Oktober 2019 22:46
An: ProFox Email List 
Betreff: Re: VFP9SP2 DBC -- update trigger

I'd get FoxAudit (if you can find it) for this. Well worth the price and
takes minutes to set up to get very very robust change management.

Eric

On Wed, Oct 2, 2019 at 6:33 AM Charlie Coleman  wrote:

> Yes, with VFP it is that simple.
>
> I would suggest adding a timestamp to your logging table. Technically, 
> since your just doing inserts you could assume sequence - but seeing 
> the time of day of events might help track this down. That means your 
> log table structure would be slightly different of course (the extra 
> field). And if you're adding an extra field, you may as well add one 
> more that will show which trigger fired (add, update, or delete).
>
> Also, the way I've done this is create a stored procedure (aka 
> function) in the database itself. E.g. Modify Database, right-click, 
> choose Edit Stored Procedures. So, for example your procedure above 
> might be created like
> --
> PROCEDURE logmydata(trigg_type)
>
>LOCAL oRec as Object
>SCATTER MEMO NAME oRec
>. (etc, your code above - maybe adding a datetime data value as
> well)
>
> END PROC
> ---
>
> Then in the table properties, you set the triggers
> - Add Trigger: logmydata('a')
> - Update Trigger: logmydata('u')
> - Delete Trigger: logmydata(d')
>
> Or something like that.
>
> Here is one stored procedure I used that could handle logging data 
> across any table. In my case, I made the design such that 'log tables' 
> would start with "z0_" and then the table name (this was nice for 
> sorting purposes reporting on the database schema). And I had extra 
> fields: zlog_user, zlog_type, zlog_time in my log tables. I could have 
> added more 'error checking' but this worked fantastic in production 
> with never a problem. You will also see references to some 'global' 
> variables - aka oApp is the application object where I set user login 
> info, and I had a global 'lLogSuspend' to turn off logging if I wanted 
> to (I always thought I'd take that out of production, but it never 
> turned out to be an issue). I think this was back to VFP 6 or maybe 
> even earlier. I don't think the INSERT FROM NAME was available 
> yet. But you can see how it would be simple to modify - and I would
definitely use objects (FROM NAME) if I rewrote it.
>
> --
> PROCEDURE fn_LOGCHANGE(_pType, cTbl)
>LOCAL cLogTbl, tCurrTime, zlog_modtype, zlog_time, zlog_user, 
> table_ref, alt_id, lContinue
>m.lContinue = .F.
>IF TYPE("m.lLogSuspend") <> "U"
>  IF m.lLogSuspend == .F.
>m.lContinue = .T.
>  ENDIF
>   ENDIF
>
>IF m.lContinue == .T.
>  m.cLogTbl = 'z0_' + m.cTbl
>  *-- using memvars so that it's easier to GATHER below - setting 
> the m. junk
>  SCATTER MEMO MEMVAR
>  IF TYPE("oApp.cUserID") = 'C'
>*-- add the entries for the log_mod_type, log_time, log_user
>m.zlog_modtype = m._pType
>m.zlog_time = DATETIME()
>m.zlog_user = oApp.cUserID
>INSERT INTO (m.cLogTbl) FROM MEMVAR
>  ENDIF
>ENDIF
> ENDPROC
> --
>
> Then in any table trigger, I could do:
>   fn_logchange('a', 'account_master')
>   fn_logchange('u', 'account_master')
>   fn_logchange('a', 'user_data')
>   fn_logchange('d', 'activity_daily')
>   fn_logchange('a', 'office_location')
>
> and so on...
>
>
> HTH,
> -Charlie
>
> On Wed, Oct 2, 2019 at 12:29 AM MB Software Solutions, LLC < 
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
> > I've got a client with a wonky situation where the data (for some 
> > unknown reason) gets "blanked out" (not deleted, mind you...just 
> > some fields set to blanks).  I wanted to add an UPDATE trigger so 
> > that I could get some sort of historical update accounting to help 
> > me hone in on where the problem might be.
> >
> > If I've used triggers in VFP then I've totally forgotten how to use 
> > them.  (Keep in mind that I haven't used VFP DBFs since 2004! This 
> > is an app I took over for one of our former buddies, Jeff Johnson, 
> > after he passed away.)
> >
> > I use triggers in MySQL/MariaDB all the time.  There, I've got the
> > record object in the OLD and NEW object keywords.   Looking at the
> > CREATE TRIGGER Command in VFP help makes me think that the table is 
> > the currently selected work area, and as such, I could just do a 
> > SCATTER MEMO NAME oRec and then use that oRec variable to insert 
> > values into a separate table.
> >
> > Wanted to bounce this off the community prior to my testing 

AW: APPEND BLANK with immediate field values set right after

[juergen]

Sorry but SQL INSERT always does position on the new record. This is
documented even in the helpfile:


-
If the table you specify is open, SQL INSERT appends the new record to the
table. If the table is open in a work area other than the current work area,
it is not selected after the record is appended; the current work area
remains selected.

If the table you specify is not open, Visual FoxPro opens it in a new work
area, and the new record is appended to the table. The new work area is not
selected; the current work area remains selected.

While the SQL INSERT command is executing, the current work area becomes the
area into which the new record is inserted. In other words, when the SQL
INSERT command is executed, it is in the context of the table being inserted
into regardless of the current work area before the command was issued.

>  After executing the INSERT command, Visual FoxPro positions the
record pointer on the new record. <

Visual FoxPro updates the _TALLY system variable with the number of rows
inserted if you include a SQL SELECT statement. For more information, see
_TALLY System Variable.

-

wOOdy


[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/01aa01d579f9$321767f0$964637d0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Another refactoring question regarding unused columns in a DBF table

[juergen]

Hi Mike,
243 - 139 makes 104 useless fields. Plus their indices. Good catch! Question 
remains: why are there 104 seemingly useless fields?  Are those fields 
completely blank / empty? Maybe they have been added for some planned but never 
finished additional module. Maybe they are a leftover from some import / update 
mode.  Maybe they are used from a different application, which you haven't seen 
yet...

I once had a similar scenario, where those fields had names with an 
incrementing number like "field_c_1", "field_c_2", "field_d_1", "field_d_2" etc 
for several fieldtypes.  It was their way to get customizable fields into a 
vertical market application.  For each customer installation they could use 
those dummy fields for different customer demands. The bad thing with that code 
was that a simple "code reference" search for the exact fieldnames didn't got 
any results, since they built the resulting fieldnames in a loop like "field_" 
+ cType + "_" + str(i,1,0)  and stored them then in an array   Yea, it was 
damn flexible, but definitely not for easy understanding!  :)

As to "what to do": go with option 2 and let them run their app again. If it 
bombs on some fields you'll then know fore sure that your search wasn't perfect 
:) Just rename them back, without any hassle to merge old saved data with the 
current tables.
 
wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Mittwoch, 2. Oktober 2019 21:45
An: profox@leafe.com
Betreff: Another refactoring question regarding unused columns in a DBF table

The main table in your inherited legacy application has 243 fields. Through 
looking at the database columns individually, you have determined that only 139 
of those are used.  (really!) They're of mixed types (characters, numbers, 
logicals, date/time, etc.).  Getting rid of them takes you from a record size 
of 3093 down to 1982.  In one instance, testing showed it reduced the size of 
the DBF by 1/3!  Some of those unused fields have indexes on them.  Let's 
assume I dropped the indexes on those fields.

Do you:

 1. do nothing...leave them as-is.
 2. rename them to "X" so that you can basically mark them
useless (to be later dropped) but have the ability to rename back to
original if the app hits a snag showing a dependence on that useless
field.
 3. do something else I haven't considered?  (Dropping them immediately
is not an option as it's too radical/nuclear and offers no failsafe
at time of change)

tia,
--Mike




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


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/005701d579ca$b57a8d40$206fa7c0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Question regarding updates to backend DBF table

[juergen]

You are touching an indexed field. VFP doesn't care what you are writing to 
that field, it just updates the table and subsequentally the index.

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Mittwoch, 2. Oktober 2019 20:10
An: profox@leafe.com
Betreff: Question regarding updates to backend DBF table

Scenario: VFP9SP2 on modern Windows operating system using DBFs. Let's assume 
NO BUFFERING for this scenario, but there IS an index (1 or more) using the 
MyField field in the .CDX file.

If the MyTable.MyField current value is "MyValue", will this code cause any 
network traffic with the backend table even though the value is the same?

   REPLACE MyField WITH "MyValue" IN MyTable

Or is VFP smart enough to say "yeah, I'm not updating it with the same value.  
Next."

???


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


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/005101d579c7$f35a1e80$da0e5b80$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: APPEND BLANK with immediate field values set right after

[juergen]

Hi Mike,
I have seen this coding style sometimes.
Yes, you can change the APPEND BLANK / REPLACE combos with an INSERT INTO 
without any negative siedeeffects.

The part with that GO BOTTOM / SEEK() was normally done for repositioning other 
tables, which are linked with a SET RELATION.  You could substitute four lines 
(together with that "lnNotes" stuff) with a simple GO RECNO(), which does a 
reposition to the current recno together with a buffer refresh.

Interestingly in the SEEK, they use a TAGname "notes_id", but later on do a SET 
ORDER TO "id" , not "notes_id". Was this a failure on your "copy code" job, or 
do they really have two tags?
 
For your third question: Index files are only updated, if indexed fields (or 
expressions) are touched (means: they get updated in any way).  Writing to 
non-indexed fields does not trigger index files updates.

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Mittwoch, 2. Oktober 2019 19:42
An: profox@leafe.com
Betreff: APPEND BLANK with immediate field values set right after

In trying to find the "demons" in this legacy VFP app (shared/used by both 
desktop and internet/website users), I find there's a lot of APPEND BLANKS 
everywhere followed by an immediate REPLACE (and sometimes more than 1).  
Here's a sample of my findings:

  SELECT notes
  APPEND BLANK
  REPLACE notes.id WITH order.invoice
  REPLACE notes.dtg WITH DATETIME()
  LOCAL lnnotes_id
  lnnotes_id = notes.notes_id
  = TABLEUPDATE(.T.)
  GOTO BOTTOM
  = SEEK(lnnotes_id, 'notes', 'notes_id')
  SET ORDER TO ID
  thisform.pgf1.page5.grdnotes.coldetail.setfocus()

Now, 1st, I'd say "switch this over to explicit INSERT INTO MyTable (ID,
Dtg) VALUES (order.invoice,datetime())"   Also, not sure why they're go to the 
bottom and then reposition the record pointer immediately afterwards.  That's 
wasted moves/cycles, imo, although perhaps minuscule.

If the user did NOT have table buffering in place, I can see a bigger knock 
against this approach because with every update, the table's CDX indexes would 
all have to be updated (if those fields were involved). The backend table's CDX 
file isn't updated on changes to the buffered cursor.

Question:  if you update fields that are indexed, I know the index file has to 
update to reflect those changes.  If you update fields that are NOT IN ANY 
INDEXES, there's no update needed for the CDX then...right?

Any other tips?


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


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/004f01d579c7$afc40690$0f4c13b0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Bad style, but any chance it would ever fail to update properly?

[juergen]

Hi Mike,
Imagine this scenario:

USE AA IN 0
USE BB IN 0
USE CC IN 0
Select AA
&& do something unsuccessful in that table:
LOCATE FOR AA.Field1 = "Nonsense"
&& Now your replace:
REPLACE BB.Field1 WITH CC.Field2

This Replace will not happen, since the working alias of the Replace is AA 
(which is on EOF), regardless which fields (or field aliases) are used in the 
fields list.  Additionally the FOR and WHILE conditions are by default equated 
against the current alias. 
Therefor it's considered good practice to always add the IN clause if in doubt, 
so that the working alias is temporarily set to the desired alias.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Mittwoch, 2. Oktober 2019 20:14
An: profox@leafe.com
Betreff: Bad style, but any chance it would ever fail to update properly?

We've seen this before (and I did it 2 decades ago):  REPLACE MyTable.MyField 
with SomeOtherTable.SomeField

The implication is that "replace the MyField value in the MyTable table."  But 
if one doesn't use the IN clause, will there ever be any chance that the update 
to MyTable.MyField would fail?

tia,
--Mike



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


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/004a01d579c5$eedbad30$cc930790$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: VFP9 App: Running on Windows 7 and Windows 10

[juergen]

Hi Alan,

do you have a link to some Knowledgebase entry to your advise? 

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Donnerstag, 19. September 2019 10:05
An: profox@leafe.com; profoxt...@leafe.com
Betreff: Re: VFP9 App: Running on Windows 7 and Windows 10

> Make sure that on those Win10-boxes the SMB-Caching is switched off. 
> If not, that would lead to index corruption, which in turn crashes the
application.
> 

Don't do this unless absolutely necessary or it will destroy performance on
multiuser applications. The problem that this solves has been solved by
Microsoft in Windows 10 1809.

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

[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/032f01d56ec5$60bc1810$22344830$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: VFP9 App: Running on Windows 7 and Windows 10

[juergen]

Hi Desmond,
Make sure that on those Win10-boxes the SMB-Caching is switched off. If not,
that would lead to index corruption, which in turn crashes the application.

The easiest way to set those settings is by running this MSI package, which
just sets three RegistryKeys:
https://www.dropbox.com/s/aa9vwwup1u8h2zy/OPLock_Set_SMB2-infocache.msi?dl=0
The benefit of that MSI is, that you can deploy it as a GPO (GroupPolicy),
targeted for any Domain-Computer.

If you want to set those keys directly, then on every Client-PC (not
Servers!) at
HKEY_LOCAL_MACHINE\system\CurrentControlSet\Services\LanmanWorkstation\Param
eters

Set this keys to a value of 0 
FileInfoCacheLifetime
FileNotFoundCacheLifetime
DirectoryCacheLifetime


In your App you could query those RegKeys and show a warning if not zero.
(You normally can't change them from your app, since they are at
machine-level and therefor need Admin-rights to modify)


With kind regards from Bavaria

Jürgen Wondzinski 
Visual FoxPro Evangelist
Microsoft "Most Valuable Professional" from 1996 to 2009, "Servoy Valued
Professional“ 2011


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Desmond Lloyd
Gesendet: Donnerstag, 19. September 2019 00:52
An: ProFox Email List 
Betreff: VFP9 App: Running on Windows 7 and Windows 10

Have an issue with an application.   They are reporting that when running
under Windows 10 (Pro) the app is intermittently crashing,  while the
Windows 7 machines are running just fine.

Am supporting another app using both OS's and works fine.

Not even sure at what I should look at.   Am reviewing the tables for any
oddities,

Any suggestions/thoughts?
TIA,
Desmond


--- 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/01e701d56e85$9cfdeb90$d6f9c2b0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: SET DEFAULT or ?

[juergen]

Normally a SET PATH TO would be sufficient.  If you're using a DBC, then
just explicitly open that DBC with the provided path is all you need.

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Gene Wirchenko
Gesendet: Mittwoch, 14. August 2019 05:58
An: ProFox Email List 
Betreff: SET DEFAULT or ?

Hello:

  I have an app that has for years been executed out of the default
directory with the data there, too.

  Now, I have to give at least the data an arbitrary location.  Can I
use SET DEFAULT for this and save having to rewrite hundreds of table
referring statements?  Or are there nasty things to worry about?

  I am thinking of having a config table in the startup default
directory that specifies the data directory and then SET DEFAULT to that
directory.  When executing a .exe version of the app, I think this will not
cause trouble, but for a debug version with separate 
.fxp, I think I also need to SET PATH for the code to be found.   I 
join all my code together with SET PROCEDURE TO ... ADDITIVE  in the startup
.fxp if that makes a difference.  Are the gotchas going to get me?

Sincerely,

Gene Wirchenko


[excessive quoting removed by server]

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

AW: Get file path and name from file handle

[juergen]

Hio Paul,

Add a collection (or Array) to _screen, with two columns. One for the
filehandle, one for the filename. 
That way you can search for handle or name.

Or, more sophisticated: Create an helperobject for the various F* functions
to work directly with that collection, which would then be part of that
object. That way you could add a GetFileNameFromHandle method and many more.
Added benefit would be an automatic FClose if that object goes south. :)





-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Montag, 5. August 2019 09:48
An: profox@leafe.com
Betreff: RE: Get file path and name from file handle

Hi Juergen

The FCREATE/FOPEN is used in several places throughout the code and I would
need to somehow store and preserve  the open file details.  Being able to
find the file from the file handle would be much more convenient

Paul Newton



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

AW: Get file path and name from file handle

[juergen]

Or asked differently: Why do you have a FileHandle, but not the FileName?
Sounds like a strange way of encapsulation :)

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von juer...@wondzinski.de
Gesendet: Freitag, 2. August 2019 17:26
An: 'ProFox Email List' 
Betreff: RE: Get file path and name from file handle

Just curious: 
Normally YOU would create the filename, and then FCREATE() does its job. 
Why don't you know the filename you put into the function?



[excessive quoting removed by server]

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

RE: Get file path and name from file handle

[juergen]

Just curious: 
Normally YOU would create the filename, and then FCREATE() does its job. 
Why don't you know the filename you put into the function?



[excessive quoting removed by server]

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

AW: vfp9 exe

[juergen]

Hi Koen,

now that's a very old coding style. Probably from the time before TRY/CATCH
was invented.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Koen Piller
Gesendet: Dienstag, 23. Juli 2019 20:32
An: ProFox Email List 
Betreff: Re: vfp9 exe

Hi,
you can make use of Craig Boyd's procedure, you shall have to parse your DBC
for every file to find if anything in use and than you can make a message to
the other users to please quit the application.
But, but, but.  Why do you need to reindex? That should be a flaw in your
design. Please study again the nessessity and try to redesign. If in any
doubt of why/how, advise you to post a new topic.
Meanwhile, Craoig's coding:

**Procedure by Craig Boyd
**See also Tektips: https://www.tek-tips.com/viewthread.cfm?qid=925399
?IsTableInUse("C:\mytable.dbf")

FUNCTION IsTableInUse(tcTableName)
SET ASSERTS ON
ASSERT PCOUNT() > 0 MESSAGE "Developer Error: Table name parameter is
required!"
ASSERT TYPE("tcTableName") = "C" MESSAGE "Developer Error: Table name
parameter must be a character!"
ASSERT !EMPTY(tcTableName) MESSAGE "Developer Error: Table name
parameter is empty!"
ASSERT FILE(tcTableName) MESSAGE "Developer Error: Table does not
exist!"

LOCAL lcErrorHandlerWas, llReturn
lcErrorHandlerWas = ON("ERROR")
ON ERROR llReturn = .T. && Could call proc that checks for ERROR() = 3
"File is in use"
USE (tcTableName) IN 0 EXCLUSIVE
USE IN SELECT(JUSTSTEM(tcTableName))
ON ERROR 
RETURN llReturn
ENDFUNC

Regards,

Koen

Op di 23 jul. 2019 om 12:58 schreef Kurt @ Gmail :

> Why not create a single file - with a single record, a File Lock Flag.
> So - when a user goes to reindex files - they MUST Lock that one 
> record 1st. Then, at the startup of your system - for regular users - 
> the system must check that flag & record to see if someone locked it 
> and is indexing files.
>
> It's a thought...
>
> -K-
>
> On 7/23/2019 10:36 AM, Ken McGinnis wrote:
> > We have a vfp9 SP2 program that has been running nearly bug free for 
> > over 10 years. Only now we have a need to find out if anyone else is 
> > using the exe in a specific folder. We allow many users to have 
> > their own unique folder with their patient data files.
> >
> > So we log into folder 1 and another user is in folder 2. No problem.
> >
> > If we log into folder 1 and another user is in that same folder, 
> > again no problem. Our software is multi-user down to the individual 
> > record level. The problem is when the 2nd user comes in and needs to 
> > lock many or all files to reindex or other procedures. How can the 
> > 2nd user know that another user is there? Again it is not a problem 
> > until that 1st user starts to do something, almost anything that 
> > requires accessing files. All files are locked by the 2nd user so 
> > the 1st user starts getting errors.
> >
> > We could try to lock the exe and that would fail so we would know 
> > someone else is using the software. However, if that other user is 
> > working with data in a different folder, we don't care so we do not 
> > want to lock the exe.
> >
> > Hope that is clear
> >
> >
> >
> >>
> >>
> >>
[excessive quoting removed by server]

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

AW: [NF] How to Get Black Bars on Monitor

[juergen]

You need to change the settings on the monitor itself. It normally rescales
automatically if you send him non-native resolutions, thus you need to set
the monitor to "Do not scale".




[excessive quoting removed by server]

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

AW: Super bizarre page.init bug on form.pageframe -- it never runs! (VFP9SP2)

[juergen]

As long as you have no MemberClass from a MemberClassLibrary defined in your 
pageframe, new pages are always plain stock standard pages from VFP's internal 
baseclass.
I have a simple PRG for those nonvisual Memberclasses, which is basically  just 
a 

DEFINE MyPage AS PAGE
ENDDEFINE

Save that as MyGrdPages.prg.

Assign that to your MyPageFrame class as
MemberClass = "MyPage"
MemberClassLibrary = "MyGrdPages.prg"

VFP then will warn you that any code assigned to your existing pages will get 
lost, thus you better copy that to a temporary file and add it back afterwards.

Some things you may want to add to your MyPage class:

PROCEDURE ACTIVATE
This.FontBold = .T.
ENDPROC

PROCEDURE DEACTIVATE
This.FontBold = .F.
ENDPROC

Makes a more visual effect to the current page-Caption. You could also change 
the FontColor.  

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Mittwoch, 3. Juli 2019 22:03
An: profox@leafe.com
Betreff: Super bizarre page.init bug on form.pageframe -- it never runs! 
(VFP9SP2)

I added 2 pages to my existing pageframe so that I could add more functionality 
to this form.  There are pages that I conditionally instantiate based on user 
settings.  But for these 2 new pages (automatically added via the IDE after I 
set the pageframe.PageCount from 11 to 13), their Init events never run. I'm 
baffled.

See soundless Camtasia demo I put together to show this: 
https://www.screencast.com/t/eZ1EyfDewnw

I'm hoping somebody can see something obvious that is eluding me!

tia,
--Mike



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


[excessive quoting removed by server]

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

AW: Funny bug

[juergen]

Cool thing! But:

STORE .F. TO Next(1)

&& no kaboom :)


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Bill Anderson
Gesendet: Donnerstag, 6. Juni 2019 01:59
An: ProFox Email List 
Betreff: Funny bug

DECLARE Next(1, 1)
Next(1) = .F. && Boom!

Bill Anderson


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

[excessive quoting removed by server]

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

[NF] Lianja and Python

[juergen]

For those dabbling around with Python, this maybe is interesting:

 

Lianja (aka VFP11) has now upgraded their builtin Python engine from 2.7 to
3.7.
You have the full Lianja Framework to use with Python just as you do with
Lianja/VFP, JavaScript and PHP.

 

 

wOOdy

 

 



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

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

AW: Filtering Oddity

[juergen]

We don't talk about endusers, we are the experts. Experts are using data 
directly and edit directly in a browse. PAH!!

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Koen Piller
Gesendet: Mittwoch, 15. Mai 2019 20:37
An: ProFox Email List 
Betreff: Re: Filtering Oddity

Woody
And where is set filter in this respect?
Browse is not for end users, with a grid you are better of.
Koen



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

AW: Filtering Oddity

[juergen]

I totally agree with Gene.  xBase was originally developed for interactive
use, and those commands are just perfect for hacking around in real live
data. No clumpsy and verbose SQL statements, just USE your data and massage
it as you want.  

I often also do some ON KEY LABEL xx REPLACE / STUFF / STRTRAN  and visually
skip through a BROWSE and if I find a culprit I then just press my F-Key for
some magic... 

Believe me, xBase commands are even better than sliced bread!  

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Koen Piller
Gesendet: Mittwoch, 15. Mai 2019 20:02
An: ProFox Email List 
Betreff: Re: Filtering Oddity

Gene
I would like to see an actual situation where set filter is preferable over
select() according to you.
Regards
Koen


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

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

[juergen]

Hi Gene,

yepp, either be very serious about the counterparts, or just issue a 
thisform.lockscreen = 0  and don't give a shit about that counterparts; just 
flip it to OFF in any situation.

wOOdy


-Ursprüngliche Nachricht-
Von: MB Software Solutions, LLC  
Gesendet: Mittwoch, 8. Mai 2019 00:15
An: juer...@wondzinski.de
Betreff: Re: AW: Old Andy Kramek trick from WhilFest years ago...I can't recall 
exactly how he said it

Oh, so the Lockscreen = .T. commands along a process path would accumulate and 
thus you'd need an equal number of offsetting Lockscreen = .F. commands to make 
things right?  That might explain some weirdness I've seen over the years when 
I had set Lockscreen=.T. in Routine_A but then it called Routine_B which called 
Routine_C etc and some of those may have also have Lockscreen = .T. commands.  
I suppose the takeaway there is make sure you have the Lockscreen = .F. in the 
same routine as its counterpart?


On 5/7/2019 6:05 PM, juer...@wondzinski.de wrote:
> Maybe it was, that Lockscreen also accepts a numeric 0 instead of .F.
> Every lockscreen = .t. increments an internal counter, and every lockscreen = 
> .F. decrements it.  Thus you really need to watch out to always have a 
> balanced on/off couple count. You can override that with just setting that 
> counter to 0, and don't care about "have I thought about every exit path in 
> that module?"
> That undocumented(?) feature is helpful if you're doing a lot of 
> subroutines but don't know if everyone is behaving correctly 
>
> wOOdy
>
>
>
> -Ursprüngliche Nachricht-
> Von: ProFox  Im Auftrag von MB Software 
> Solutions, LLC
> Gesendet: Dienstag, 7. Mai 2019 23:33
> An: profox@leafe.com
> Betreff: Re: Old Andy Kramek trick from WhilFest years ago...I can't 
> recall exactly how he said it
>
> Hi Tracy,
>
> No, that's not it.  I use thisform.lockscreen now.  It was something more 
> "nifty" or "crafty" with his approach.
>
> I don't have any issues really; was just trying to remember what was "cool" 
> about his trick/tip that was better than Thisform.refresh.  Just curiosity.
>
> Thanks,
> --Mike
>
>
>
> ___
> Post Messages to: ProFox@leafe.com
> Subscription Maintenance: 
> http://mail.leafe.com/mailman/listinfo/profox
> OT-free version of this list: 
> http://mail.leafe.com/mailman/listinfo/profoxtech
> Searchable Archive: https://leafe.com/archives This message: 
> https://leafe.com/archives/byMID/007901d50520$ec780a80$c5681f80$@wondz
> inski.de
> ** All postings, unless explicitly stated otherwise, are the opinions of the 
> author, and do not constitute legal or medical advice. This statement is 
> added to the messages for those lawyers who are too stupid to see the obvious.

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



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

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

[juergen]

Maybe it was, that Lockscreen also accepts a numeric 0 instead of .F.
Every lockscreen = .t. increments an internal counter, and every lockscreen = 
.F. decrements it.  Thus you really need to watch out to always have a balanced 
on/off couple count. You can override that with just setting that counter to 0, 
and don't care about "have I thought about every exit path in that module?" 
That undocumented(?) feature is helpful if you're doing a lot of subroutines 
but don't know if everyone is behaving correctly 

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Dienstag, 7. Mai 2019 23:33
An: profox@leafe.com
Betreff: Re: Old Andy Kramek trick from WhilFest years ago...I can't recall 
exactly how he said it

Hi Tracy,

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

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

Thanks,
--Mike



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/007901d50520$ec780a80$c5681f80$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not 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] StackOverflow Developer Survey Results

[juergen]

Even that I know of StackOverflow as a website, I haven't visited them since
a decade or so. Does this make me a bad programmer?  I even didn't know of
that survey. Maybe that's the reason of those results? 

Maybe those at StackOverflow are just those who need to copy'n'paste some
codefragments without understanding what they are doing (aka Youngsters with
10 or more programming languages on their skillset), thus a lot of
specialized languages and their programmers don't show up at that site /
survey.  Why should I ask a VFP or Lianja or Servoy questions on
StackOverflow, if there are targeted forums available with way better
answers?

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ted Roche
Gesendet: Donnerstag, 11. April 2019 00:52
An: profox@leafe.com
Betreff: Re: [NF] StackOverflow Developer Survey Results

On Wed, Apr 10, 2019 at 4:05 PM Ed Leafe  wrote:

> I felt that I had to put [NF] in the subject line, because (spoiler
> alert!) there is no mention of Fox in these results. Nor any xbase 
> language. Nor Xojo. Nor Servoy. Nor any of the other technologies 
> trying to lure Fox developers out of their shells.
>
> https://insights.stackoverflow.com/survey/2019


... but Python did quite well!

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


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://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/004101d4f035$1b586da0$520948e0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Your laptop

[juergen]

I was a long time Dell Latitude fan, but the current series is nowhere as 
useful as the 55 / 65 series.

Nowadays I'm quite happy with my Microsoft Surface Book. You can tear it apart 
to be only a Tablet, or use it as a regular Laptop. Not exactly on the cheaper 
side of products, but very handy. Very good Graphicscard (internal resolution 
is 3000x2000), and together with the Surface Dock I'm using it on a 40 inch 
monitor with 4k (3840*2160 pixels). 

Keyboard is very good, also the mechanical endurance is top. 16Gb RAM should be 
enuf, same with the builtin SD (512Gb or 1Tb).
The Pen is optional, I use it only sometimes for quick drawings (maybe I'm too 
old for getting an artist here)

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Sonntag, 24. März 2019 12:57
An: profox@leafe.com
Betreff: Your laptop

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

tia,
--Mike


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


[excessive quoting removed by server]

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

AW: [NF] Looking for current summary of VFP clones

[juergen]

Hi Fletscher,

Lianja is up and running and Kickin'Ass!
https://www.lianja.com/resources/the-lianja-vision

Most of your VFP code will run unchanged. Lianja uses a VFP-compatible
Object hierarchy as well as PEMs, and has lots of extensions to the original
VFP language. You use any choice of VFP, PHP, JavaScript or Phyton to
program that beast, and it creates Desktop apps (for Win, Mac, Linux) as
well as WebApps, AppServer-centric, cloud-based, Mobile... 
Download for free, and read the roadmap.
https://www.lianja.com/resources/roadmap



With kind regards from Bavaria

Jürgen Wondzinski 
Visual FoxPro Evangelist
Microsoft "Most Valuable Professional" from 1996 to 2009, "Servoy Valued
Professional“ 2011
My XING Profile, and LinkedIn and Facebook and Google+ and Twitter and…..
GCS d+ s:+ a++ C++ !U P--- L E? W++ N++ o-- K--? w+++ O? !M--? V-- PS PE !Y?
!PGP t 5 X R tv- b DI+ D? G e++ h-- r+++ y+++




-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Fletcher Johnson
Gesendet: Mittwoch, 13. März 2019 16:45
An: profoxt...@leafe.com
Betreff: [NF] Looking for current summary of VFP clones

Hi all,

 

I was asked for a list of current options for someone who has a VFP
application and wants to migrate it to a supported language, with the least
amount of re-work.

 

I have seen many options listed, but am sure how compatible the various
alternatives are.  X# looks promising, but so do some of the others.  And
some that I thought were good options now appear to be dormant or
discontinued.  So I thought I would check with you fine folks to see if you
know where I might find a list of current alternatives and their level of
compatibility.

 

Thanks,

 

Fletcher

 

Fletcher Johnson

  fletchersjohn...@yahoo.com

  LinkedIn.com/in/FletcherJohnson

twitter.com/fletcherJ

 
strava.com/athletes/fletcherjohnson

408-946-0960 - work

408-781-2345 - cell

 



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

[excessive quoting removed by server]

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

AW: [NF] Migrating Skills From Foxpro to Xojo

[juergen]

Hi Paul,

>> rather than debate the benefits of everyone’s favorite FoxPro replacement <<

Dude, have you considered Lianja?  Then you could use VFP, Phyton, PHP and JS 
at the same time! 

Just teasing...    

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul H. Tarver
Gesendet: Sonntag, 24. Februar 2019 03:38
An: profox@leafe.com
Betreff: Re: [NF] Migrating Skills From Foxpro to Xojo

I’ve already tried python. 

There may be some love involved with FoxPro but Python was eliminated from my 
options because i wanted more of a single provider rather than a bunch of 
different pieces coming from different providers. I’m sure I’ll trigger a lot 
of blowback from Python advocates for my comment but I stated originally I 
wanted to keep this thread on point about Xojo rather than debate the benefits 
of everyone’s favorite FoxPro replacement. 

Paul


___
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/009201d4cc23$99dbaf60$cd930e20$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Error building sort key (Error 2186)

[juergen]

Maybe the result length of the GROUP BY is longer than 120 char?  That's the
maximum key length in an index, which VFP uses to sort the intermediate
results.


wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Donnerstag, 21. Februar 2019 15:51
An: 'profox@leafe.com' 
Betreff: Error building sort key (Error 2186)

Hi all

According to the help:
This error is generated when sort key truncation is about to occur,
typically during GROUP BY, ORDER BY or other sorting operations. This can
happen with use of a sort key that contains an expression, such as a Memo
field, whose length is not fixed.

The problem manifests itself when executing the following SQL (sorry about
the length of the statement):

Select Str(Nh_Year,4,0) + Str(Nh_Period,2,0)+ Transform(NH_YEAR) +
Transform(NH_NACNT) + Transform(NH_PERIOD) As Key, ; Nh_Year,
Nh_Period,Str(Nh_Year,4,0) + '/' + Str(Nh_Period,2,0)  As
YearPeriod,Nh_NType, Nh_NSubt, Nh_Nacnt, Nh_NCntr, ; Nh_Job, Nh_Project,
Sum(Nh_PtdDr) As Nh_PtdDr, -1 * Sum(Nh_PtdCr) As Nh_PtdCr, Sum(Nh_Bal) As
Nh_Bal,Sum(NH_BUDG) As Nh_Budg, ;
.99 As Variance, .99 As YTDBal, .99 As
YTDBudg, .99 As YTDVar ;
>From NHist Where NH_YEAR >= 2019 And NH_YEAR <= 2019 And NH_PERIOD >= 1 
>And NH_PERIOD <= 3 And NH_YEAR = 2019 ;
And NH_NACNT = 'A110' And NH_PERIOD = 1  And Nh_RecType = 1  ;
Group By Key Union Select Str(Nh_Year,4,0) + Str(Nh_Period,2,0)+
Transform(NH_YEAR) + Transform(NH_NACNT) + Transform(NH_PERIOD) As Key, ;
Nh_Year, Nh_Period,Str(Nh_Year,4,0) + '/' + Str(Nh_Period,2,0)  As
YearPeriod,; Nh_NType, Nh_NSubt, Nh_Nacnt, Nh_NCntr, Nh_Job, Nh_Project,
Sum(Nh_PtdDr) As Nh_PtdDr, -1 * Sum(Nh_PtdCr) As Nh_PtdCr, ;
Sum(Nh_Bal) As Nh_Bal,Sum(NH_BUDG) As Nh_Budg, .99 As Variance,
.99 As YTDBal, ;
.99 As YTDBudg, .99 As YTDVar From NHist Where
NH_YEAR >= 2019 And NH_YEAR <= 2019 ;
And NH_PERIOD >= 1 And NH_PERIOD <= 3 And NH_NACNT = 'A110' And
Empty(NH_JOB) And  Empty(NH_PROJECT) ;
And  Empty(NH_NCNTR) And Inlist(Nh_RecType,2,3)  Group By Key  InTo Cursor
_5F50SKUYV

Now I know this is a fairly complex query but it does not contain any
columns whose length is not fixed.  I wonder if anybody has come across this
error before.  I have had to resort to completely rewriting the code that
generates the SQL statement.

Many thanks

Paul Newton

[excessive quoting removed by server]

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

AW: Automating Exchange Calendar (and Outlook, possibly)

[juergen]

Hi Ted,

I would use Redemption, which offers a whole objectstack to address the
Exchangeserver directly.
http://www.dimastr.com/redemption/home.htm


wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ted Roche
Gesendet: Dienstag, 12. Februar 2019 21:09
An: profox@leafe.com
Betreff: Automating Exchange Calendar (and Outlook, possibly)

Hypothetically, if you had a VFP application and wanted to start processing
Shared group calendars in Exchange where the users have Outlook on their
desktop, how would you go about doing that?

Automate exchange with COM Add-ins or .NET code?
Automate outlook?
Run screaming into the woods? (My choice)

Anyone have libraries or utilities to recommend?


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


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://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/011001d4c36e$28b338c0$7a19aa40$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: [NF] Microsoft Account

[juergen]

Advantages:
Keeps backup of your Windows Settings, and MS Store / Windows-Apps.  
Helps locating your Laptop/Mobile/Tablet (if enabled)
OneDrive Storage

Disadvantages:
You need to remember your credeentials




-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Charles Hart Enzer, M.D.
Gesendet: Dienstag, 22. Januar 2019 21:05
An: Profox 
Betreff: Re: [NF] Microsoft Account

Advantages of Keeping Microsoft Account?
Advantages of Dropping Microsoft Account?


___
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/005001d4b2f9$1b1f8b80$515ea280$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: Custom Scrollbar

[juergen]

>> I want to create my own grid

WHY, just WHY?

Haven't yet found a problem for which I would need a homegrown grid.
What can't you do in VFP's native grid, in combination with the excellent
container hierarchy which you could add into any / every column of a grid?
Build a set of controls, save them as class, add that class to the Column,
change Column.CurrentControl to point to that class, set Column.Sparse to
.F. and presto, you can do any complicated setup and stil have the benefits
of VFP's native gridspeed.


wOOdy



___
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/019d01d4a5da$cfdfa0e0$6f9ee2a0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: REINSTALL FOX PRO 9

[juergen]

Ok I bit the bullet and translated that stuff to english (with some enormous
help of DEEPL).

Take a look here: http://woody-prolib.blogspot.com/2018/12/how-to.html 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von juer...@wondzinski.de
Gesendet: Dienstag, 11. Dezember 2018 08:10
An: 'ProFox Email List' 
Betreff: AW: REINSTALL FOX PRO 9

You may want to take a look at my install advice at 

http://woody-prolib.blogspot.com/2010/01/vfp9-komplett-installieren.html

Unfortunately written in German, but with a little help from Google
Translator you may get the whole thing up and running again in some minutes.

wOOdy





-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von GARY JEURINK
Gesendet: Dienstag, 11. Dezember 2018 04:13
An: profox@leafe.com
Betreff: REINSTALL FOX PRO 9

Help, my computer running win 10 and foxpr 9 crashed. I paid a fortune to
recover the old c-drive. Now a new computer won't let be load visual studio
to load fox pro 6 and then later fox pro 9.  Gary Jeurink. huge ap that runs
my handi-cap system.



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

[excessive quoting removed by server]

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

AW: REINSTALL FOX PRO 9

[juergen]

You may want to take a look at my install advice at 

http://woody-prolib.blogspot.com/2010/01/vfp9-komplett-installieren.html

Unfortunately written in German, but with a little help from Google
Translator you may get the whole thing up and running again in some minutes.

wOOdy





-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von GARY JEURINK
Gesendet: Dienstag, 11. Dezember 2018 04:13
An: profox@leafe.com
Betreff: REINSTALL FOX PRO 9

Help, my computer running win 10 and foxpr 9 crashed. I paid a fortune to
recover the old c-drive. Now a new computer won't let be load visual studio
to load fox pro 6 and then later fox pro 9.  Gary Jeurink. huge ap that runs
my handi-cap system.



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

[excessive quoting removed by server]

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

AW: Visual FoxPro Toolkit for .NET

[juergen]

The main usecase for the toolkit is replicating / packaging classic VFP
functions into object calls.

If you're an "oldfashioned" FoxPro guy, you're used to commands and
functions and you know them in and out. Thus you're tempted to have the same
"ease of use" with NET. That's absolutely ok, but later on you will notice
that the "real" NET way to deal with objects and their methods is notable
more flexible.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von AndyHC
Gesendet: Donnerstag, 22. November 2018 16:05
An: profox@leafe.com
Betreff: Re: Visual FoxPro Toolkit for .NET

On 22-Nov-18 1:53 PM, Alan Bourke wrote:


... so give it, say, another 16 years and it could have caught up with
Foxpro 

[excessive quoting removed by server]

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

AW: AW: Reallocating drive space

[juergen]

Yes that iTunes Backup-files is a huge spacekiller, especially if you have
"Roaming Profiles" in your Domain LogOn and LogOff then takes tens of
minutes... 

Only solution is to make a Symbolic Link of that directory to somewhere else
outside the User-directory (use MKLINK.exe for that), since Apple is too
stupid to make the backup target somehow configurable.

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Eric Selje
Gesendet: Donnerstag, 22. November 2018 03:50
An: ProFox Email List 
Betreff: Re: AW: Reallocating drive space

Multiple iTunes backups of a phone, into a subfolder of %appdata%, was a
recent hidden culprit in a client's disk issues.  I used WinDirStat but will
check out WizTree.

Eric

On Tue, Nov 20, 2018 at 2:56 PM

wrote:

> On 2018-11-20 04:40, juer...@wondzinski.de wrote:
> > Maybe you should first clean up your C drive:
> >
> > Open a CMD window with administrative Rights.
> > Start "CleanMgr /sageset:1"
> >
> > In that dialogue select all entries, beside of "User Shadow Copies"
> > Close it.  That selection is now saved as "set 1"
> >
> > Now run it:
> > CleanMgr /sagerun:1
> >
> > Everytime you need a full cleanup, just use the second commandline 
> > again.
> >
> > The trick with "sageset" is that you can enable much more cleaning 
> > tasks as with the standard interface.
> >
> > Depending on how often you had windows updates, it may well reclaim 
> > several Gigabytes of no more necessary Updates etc.
> >
> >
> > Then, also delete all stuff in %temp%, as well as \windows\temp\ (it 
> > will choke on some files in use, just skip those)
> >
> >
>
>
> Hi wOOdy,
>
> Thanks for the tip.  Just tried it.  Not much changed, probably 
> because I've already moved my temp environment setting to D:\TEMP 
> instead and recently run this cleanup as well as CCleaner.
>
> Was hoping this would get rid of old Windows Updates stuff but I guess 
> that's already been cleaned?
>
[excessive quoting removed by server]

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

AW: Visual FoxPro Toolkit for .NET

[juergen]

What do you expect from a NET Class-library from  2002 ?



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Mittwoch, 21. November 2018 15:07
An: 'profox@leafe.com' 
Betreff: Visual FoxPro Toolkit for .NET

Hi all

http://foxcentral.net/microsoft/vfptoolkitnet.htm

Does anybody have any experience with this?  Is it robust and reliable?

Thanks

Paul Newton

[excessive quoting removed by server]

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

AW: Reallocating drive space

[juergen]

Maybe you should first clean up your C drive:

Open a CMD window with administrative Rights.
Start "CleanMgr /sageset:1"

In that dialogue select all entries, beside of "User Shadow Copies"
Close it.  That selection is now saved as "set 1"

Now run it:
CleanMgr /sagerun:1

Everytime you need a full cleanup, just use the second commandline again.

The trick with "sageset" is that you can enable much more cleaning tasks as
with the standard interface.

Depending on how often you had windows updates, it may well reclaim several
Gigabytes of no more necessary Updates etc.


Then, also delete all stuff in %temp%, as well as \windows\temp\
(it will choke on some files in use, just skip those)


wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von
mbsoftwaresoluti...@mbsoftwaresolutions.com
Gesendet: Montag, 19. November 2018 19:18
An: ProFox 
Betreff: Reallocating drive space

See screenshot showing my C: drive near full and plenty of space on my
D: drive allocation:  https://www.screencast.com/t/eaW92AgbXXF.  It's the
same 512 GB SSD drive.  What's the easiest way to reallocate space, to take
XX GB from D: and apply to C: drive?

tia,
--Mike

[excessive quoting removed by server]

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

RE: disappearing methods in forms

[juergen]

>> Installation in the  default folder - C:\Program Files (x86)

That's maybe the culprit. Everything installed in "Program files" is readonly 
for normal users, thus for VFP this isn't the ideal homebase, since it cannot 
write anything in it's folder hierarchy (like temp files or support tables), or 
recompile some of the classes, etc.

You may want to set the attributes of the VFP folder and it's subfolders to 
ReadWrite, or always  run it explicitely with Administrative Rights.
And next time install it to something like c:\develop\   :)


wOOdy




-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ajit Abraham
Gesendet: Dienstag, 20. November 2018 08:34
An: profox@leafe.com
Betreff: Re: AW: disappearing methods in forms


  Installation in the  default folder - C:\Program Files (x86) My work is on 
another drive

Ajit

On 19/11/2018 19:33, juer...@wondzinski.de wrote:
> In which folder did you install your VFP ?
>



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

[excessive quoting removed by server]

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

AW: disappearing methods in forms

[juergen]

In which folder did you install your VFP ?


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ajit Abraham
Gesendet: Montag, 19. November 2018 17:06
An: profox@leafe.com
Betreff: disappearing methods in forms

Hello All,

This is the second time I am facing this issue on Windows 10.

After I compile the project to an exe, I find that entire methods of my
forms have gone empty!.
First time, when it happened, I "solved" this mysterious problem by having
an exclusion entry of my vfp program folders in Windows 10's default
Defender program.

After a long time, this happened again yesterday - To my surprise - Defender
had removed all my exclusions ! - and my methods started disappearing again.
By the way - this happened after the last update couple of days back.

Woes of Windows 10 !


Ajit








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

[excessive quoting removed by server]

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

AW: [NF] Tool for editing multiple files for huge search/replace operation

[juergen]

And, BTW,  that's just a 3Liner in VFP:

FOR i = 1 TO ADIR(aFiles, "*.txt")
STRTOFILE(STRTRAN(FILETOSTR(aFiles(i,1)), "OldText", "NewText"),
aFiles(i,1))
ENDFOR


Or, maybe for easier disassembly:

FOR i = 1 TO ADIR(aFiles, "*.txt")
cFile = aFiles(i,1)
? cFile
cContent = FILETOSTR(cFile)
cContent = STRTRAN(cContent, "OldText", "NewText", )
STRTOFILE(cContent, cFile)
ENDFOR




wOOdy  



"*´¨) 
¸.·´¸.·*´¨) ¸.·*¨) 
(¸.·´. (¸.·` * 
.·`.Visual FoxPro: It's magic ! 
(¸.·``··* 




___
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/000c01d47028$96fb4780$c4f1d680$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

AW: [NF] Tool for editing multiple files for huge search/replace operation

[juergen]

Even the "Code References" tool from FoxPro lets you do a global search and
replace over multiple files...



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von
mbsoftwaresoluti...@mbsoftwaresolutions.com
Gesendet: Montag, 29. Oktober 2018 22:18
An: ProFox 
Betreff: [NF] Tool for editing multiple files for huge search/replace
operation

Literally about 10 years ago, I'm pretty sure this list suggested a tool
that I used to update several text files in a common folder; it was a big
"replace text 123 with 456" kind of thing.  But alas, my memory is failing
me and I can't recall what the tool was called.

Anybody know of such a tool to handle large search/replace across several
text files in a same folder or even perhaps cascading tree of folders?

tia,
--Mike

[excessive quoting removed by server]

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