RE: Installing VFP 9.0 on Windows 10

[Jürgen Wondzinski]

See Installation steps 
here:http://woody-prolib.blogspot.com/2018/12/how-to.htmlVon meinem/meiner 
Galaxy gesendet
 Ursprüngliche Nachricht Von: Joe Yoder  
Datum: 03.06.23  19:27  (GMT+01:00) An: profoxt...@leafe.com Betreff: 
Installing VFP 9.0 on Windows 10 Im getting "This App can't run on your PC when 
I try to run Setup.Does someone have a sharable installation cheat sheet with 
the details ofsteps and service packs to use?I have a laptop with VFP 9.0 
working just fine but I believe it wasinstalled before the machine was upgraded 
to Windows 10.Thanks in advance,Joe--- StripMime Report -- processed MIME parts 
---multipart/alternative  text/plain (text body -- kept)  
text/html---___Post Messages to: 
ProFox@leafe.comSubscription Maintenance: 
https://mail.leafe.com/mailman/listinfo/profoxOT-free version of this list: 
https://mail.leafe.com/mailman/listinfo/profoxtechSearchable Archive: 
https://leafe.com/archivesThis message: 
https://leafe.com/archives/byMID/CABQeDnVtSLVoo+U58Z6f+3nL0L-8QQCEv9YykJXQEaY=5t4...@mail.gmail.com**
 All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
___
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/r4f052z53heo9rq.rz...@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: Byte Arrays in VFP

[Jürgen Wondzinski]

A "ByteArray" is just a stream of Bytes (i.e. a file) and you can address
any position directly by offset.

cBytes = FileToStr(Getfile())
? LEN(cBytes)

cBytes = STUFF(cBytes, 5648, 5, "Hello")
&& replace 5 Bytes at 5648 with a string; or insert or delete bytes. See
help on that STUFF  :)

StrToFile(cBytes, PutFile())&& write Bytestream back to disk with new
name


Another option is just using LLFFs (LowLevelFileFunctions):

nHandle = FOPEN(GetFile())
FSEEK(nHandle, 5648, 0)
FRWITE(nHandle, "Hello")
FCLOSE(nHandle)

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Joe Yoder
Gesendet: Dienstag, 2. Mai 2023 04:33
An: profoxt...@leafe.com
Betreff: Byte Arrays in VFP

I want to pull a 3.5 meg file into a Byte Array in Fox, make some changes to
individual bytes, and write the array back to another file.
The only way I have found to do so is to build the array one character at a
time.  Is there a better way to do this?
Thanks in advance for any input ,

Joe


[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/01b801d97cc4$0b793f70$226bbe50$@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: Fun with REPORT FORM...SUMMARY

[Jürgen Wondzinski]

Not sure I understand what you want to do: First you say "I want to print
summary only", then you say "I DON'T want the summary to print"

wOOdy
 
-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Richard Kaye
Gesendet: Donnerstag, 15. Dezember 2022 17:53
An: profox@leafe.com
Betreff: Fun with REPORT FORM...SUMMARY

Anyone have any tricks for printing a summary band ONLY when the SUMMARY
clause is used. IOW if I make a plain old REPORT FORM blah I don't want the
summary band to print.

--

rk



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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: 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/00a301d910aa$067b02f0$137108d0$@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: Help with a regular expression

[Jürgen Wondzinski]

Argh... Replace cDummy with cResult

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Montag, 12. Dezember 2022 14:55
An: profox@leafe.com
Betreff: Re: AW: Help with a regular expression

Hi wOOdy

Thanks for both your replies.  I am not sure if it can be done at all using 
VBScript.RegExp but it would be nice if it could. Your AcidTest function has a 
problem with cDummy ...

Paul


___
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/050a01d90e32$2169b630$643d2290$@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: Help with a regular expression

[Jürgen Wondzinski]

Hi Paul,

this would be a pure VFP solution:
**
? AcidTest("Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid (2.13)")
? AcidTest("Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid")

FUNCTION AcidTest(cText)
LOCAL cResult, nCount

nCount  = OCCURS("(", cText)
cResult = STREXTRACT(cText, "(", ")", nCount)
IF LEN(CHRTRAN(cDummy, "0123456789.", "")) # 0
cResult ="FAIL"
EndIf
Return cResult
 ** 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Montag, 12. Dezember 2022 14:10
An: profox@leafe.com
Betreff: Help with a regular expression

Hi all

I've been very quiet for a while so I thought it was about time I chimed in 
again. I have come across the use of a regex expression in another language 
which works like this:

acid1 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid (2.13)"
acid2 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid"

NumberAtEnd:= proc(S::string)
description
 "Extract a parenthesized number, possibly containing periods, from the end 
of a string":
local r;
 if StringTools:-RegMatch("\\(([0-9.]*)\\)$", S, r$2) then r else FAIL fi 
end proc:

NumberAtEnd(acid1) returns "2.13"
NumberAtEnd(acid2) returns "FAIL"

How can this be done in VFP?  Many thanks

Paul Newton
***

*



[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/04ec01d90e2f$a3dd6e70$eb984b50$@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: Help with a regular expression

[Jürgen Wondzinski]

Hi Paul,

you could always just use RegEx in VFP:

oRE = CreateObject("VBScript.RegExp")
oRE.Pattern = "\\(([0-9.]*)\\)$"
? oRE.Test(acid1)
? oRE.Test(acid2)

That said, I haven't played with that pattern, but it doesn't return your 
desired result. 

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Montag, 12. Dezember 2022 14:10
An: profox@leafe.com
Betreff: Help with a regular expression

Hi all

I've been very quiet for a while so I thought it was about time I chimed in 
again. I have come across the use of a regex expression in another language 
which works like this:

acid1 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid (2.13)"
acid2 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid"

NumberAtEnd:= proc(S::string)
description
 "Extract a parenthesized number, possibly containing periods, from the end 
of a string":
local r;
 if StringTools:-RegMatch("\\(([0-9.]*)\\)$", S, r$2) then r else FAIL fi 
end proc:

NumberAtEnd(acid1) returns "2.13"
NumberAtEnd(acid2) returns "FAIL"

How can this be done in VFP?  Many thanks

Paul Newton
***

*



[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/04d601d90e2d$289f8380$79de8a80$@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: VFP9 starts in a folder it creates instead of the HOME() folder

[Jürgen Wondzinski]

Q2hlY2sgdGhlIHNldHRpbmcgb2YgImhvbWUgZGlyZWN0b3J5IiBhcyB3ZWxsIGFzIHRoZSBzZXR0
aW5nIG9mIHRoZSBhZGRpdGlvbmFsIGNoZWNrYm94LiBZb3UnbGwgZmluZCB0aG9zZSBpbiB0b29s
cyAvIG9wdGlvbnMuwqBWb24gbWVpbmVtL21laW5lciBHYWxheHkgZ2VzZW5kZXQK


--- 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/rde825ya4kmrrav.rz...@mo4-p00-ob.smtp.rzone.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: VFP9 installation on a new machine

[Jürgen Wondzinski]

Note to myself: Never post from my Mobile again.  :(

Readable formatting:
May I selfishly point you to Woody-prolib.blogspot.com ?

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Jürgen Wondzinski
Gesendet: Sonntag, 30. Oktober 2022 18:09
An: ProFox Email List 
Betreff: RE: VFP9 installation on a new machine

May I selfishly point you toWoody-prolib.blogspot.com? Von meinem/meiner Galaxy 
gesendet
 Ursprüngliche Nachricht Von: Paul Newton 
 Datum: 30.10.22  16:38  (GMT+01:00) An: 
Profox@leafe.com Betreff: VFP9 installation on a new machine Hi allIt's a long 
time since I had to install VFP9 and a couple of things have arisen.  I 
installed the original RTM and applied SP2 but I have two different files, both 
purportedly SP2.VFP9.0sp2-KB925841-X86-Enu.exe 
(34.8MB)VFP9.0sp2-KB955370-X86-Enu.exe (1.9 MB)According to www.berezniker.com/ 
the one I need (and used) is the first one but I wondered if anybody knows 
anything about the other one (the KBs are no longer available even on the web 
archive).I then appliedHotfix 3 for SP2  - VFP90SP2-KB968409-ENU.EXE  (10.8 
MB)ActiveX security updates - VFP9.0sp2-KB958371-X86-Enu.exe (4.6 
MB)GDIPLUS.DLL security updates - VFP9.0sp2-KB971105-X86-Enu.exe (1.9 MB)In the 
past I have also installed the VFPCOM utility,the OLE DB provider and MSXML 4.0 
Service Pack 2 and I'm wondering if I should do so again.  Any thoughts?Many 
thanksPaul Newton--- StripMime Report -- processed MIME parts 
---multipart/alternative  text/plain (text body -- kept)  
text/html---___Post Messages to: 
ProFox@leafe.comSubscription Maintenance: 
https://mail.leafe.com/mailman/listinfo/profoxOT-free version of this list: 
https://mail.leafe.com/mailman/listinfo/profoxtechSearchable Archive: 
https://leafe.com/archivesThis message: 
https://leafe.com/archives/byMID/75dfa2e2-713e-5ab8-68df-3ccf88ff4...@gmail.com**
 All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
[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/012601d8ed0e$8ccab6d0$a6602470$@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: VFP9 installation on a new machine

[Jürgen Wondzinski]

You seem to have enabled the "enhanced security" in Win11, which only allows to 
run certificate-signed EXEs. Those installers are basically from 2009, where 
those topics were unknown :) You could either disable that setting in Win11, or 
wait until someone will sign those installers. Which rem8nds me, that we would 
really need to update those to the newest Windows dlls  so much work, 
so less time. Von meinem/meiner Galaxy gesendet
 Ursprüngliche Nachricht Von: Paul Newton 
 Datum: 30.10.22  18:57  (GMT+01:00) An: 
profox@leafe.com Betreff: Re: VFP9 installation on a new machine JürgenTrying 
to run VFP9SP2RT.exe from C:\Temp\Woody gives "This app can't run on your PC", 
trying to run as Admin gives "Windows cannot find 
C:\Temp\Woody\VFP9SP2RT.EXE"PaulOn 30/10/2022 17:36, Jürgen Wondzinski wrote:> 
Nope. Win 11 is just Win10 with some new UI, from a VFP perspective. Von 
meinem/meiner Galaxy gesendet>  Ursprüngliche Nachricht Von: 
Paul Newton  Datum: 30.10.22  18:20  (GMT+01:00) 
An: profox@leafe.com Betreff: Re: VFP9 installation on a new machine Thanks 
JürgenThat's a great help.  I wonder if there are any gotchas for Win 11 as 
opposed to Win 10?PaulOn 30/10/2022 17:08, Jürgen Wondzinski wrote:> May I 
selfishly point you toWoody-prolib.blogspot.com? Von meinem/meiner Galaxy 
gesendet>  Ursprüngliche Nachricht Von: Paul 
Newton  Datum: 30.10.22  16:38  (GMT+01:00) 
An:Profox@leafe.com  Betreff: VFP9 installation on a new machine Hi allIt's a 
long time since I had to install VFP9 and a couple of things have arisen.  I 
installed the original RTM and applied SP2 but I have two different files, both 
purportedly SP2.VFP9.0sp2-KB925841-X86-Enu.exe 
(34.8MB)VFP9.0sp2-KB955370-X86-Enu.exe (1.9 MB)According towww.berezniker.com/  
the one I need (and used) is the first one but I wondered if anybody knows 
anything about the other one (the KBs are no longer available even on the web 
archive).I then appliedHotfix 3 for SP2  - VFP90SP2-KB968409-ENU.EXE  (10.8 
MB)ActiveX security updates - VFP9.0sp2-KB958371-X86-Enu.exe (4.6 
MB)GDIPLUS.DLL security updates - VFP9.0sp2-KB971105-X86-Enu.exe (1.9 MB)In the 
past I have also installed the VFPCOM utility,the OLE DB provider and MSXML 4.0 
Service Pack 2 and I'm wondering if I should do so again.  Any thoughts?Many 
thanksPaul Newton--- StripMime Report -- processed MIME parts 
---multipart/alternative  text/plain (text body -- kept)  
text/html---___Post Messages 
to:ProFox@leafe.comSubscription  
Maintenance:https://mail.leafe.com/mailman/listinfo/profoxOT-free  version of 
this list:https://mail.leafe.com/mailman/listinfo/profoxtechSearchable  
Archive:https://leafe.com/archivesThis  
message:https://leafe.com/archives/byMID/75dfa2e2-713e-5ab8-68df-3ccf88ff4...@gmail.com**
  All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.> 
___> 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/rde825y9uh99p4i.rz...@mo4-p00-ob.smtp.rzone.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.___Post Messages to: 
ProFox@leafe.comSubscription Maintenance: 
https://mail.leafe.com/mailman/listinfo/profoxOT-free version of this list: 
https://mail.leafe.com/mailman/listinfo/profoxtechSearchable Archive: 
https://leafe.com/archivesThis message: 
https://leafe.com/archives/byMID/2ff5b752-f70b-b307-861e-70e47c04b...@gmail.com**
 All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.> 
___> 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/rde825y9uhamp5o.rz...@mo4-p00-ob.smtp.rzone.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 ar

Re: VFP9 installation on a new machine

[Jürgen Wondzinski]

Nope. Win 11 is just Win10 with some new UI, from a VFP perspective. Von 
meinem/meiner Galaxy gesendet
 Ursprüngliche Nachricht Von: Paul Newton 
 Datum: 30.10.22  18:20  (GMT+01:00) An: 
profox@leafe.com Betreff: Re: VFP9 installation on a new machine Thanks 
JürgenThat's a great help.  I wonder if there are any gotchas for Win 11 as 
opposed to Win 10?PaulOn 30/10/2022 17:08, Jürgen Wondzinski wrote:> May I 
selfishly point you toWoody-prolib.blogspot.com? Von meinem/meiner Galaxy 
gesendet>  Ursprüngliche Nachricht Von: Paul 
Newton  Datum: 30.10.22  16:38  (GMT+01:00) 
An:Profox@leafe.com  Betreff: VFP9 installation on a new machine Hi allIt's a 
long time since I had to install VFP9 and a couple of things have arisen.  I 
installed the original RTM and applied SP2 but I have two different files, both 
purportedly SP2.VFP9.0sp2-KB925841-X86-Enu.exe 
(34.8MB)VFP9.0sp2-KB955370-X86-Enu.exe (1.9 MB)According towww.berezniker.com/  
the one I need (and used) is the first one but I wondered if anybody knows 
anything about the other one (the KBs are no longer available even on the web 
archive).I then appliedHotfix 3 for SP2  - VFP90SP2-KB968409-ENU.EXE  (10.8 
MB)ActiveX security updates - VFP9.0sp2-KB958371-X86-Enu.exe (4.6 
MB)GDIPLUS.DLL security updates - VFP9.0sp2-KB971105-X86-Enu.exe (1.9 MB)In the 
past I have also installed the VFPCOM utility,the OLE DB provider and MSXML 4.0 
Service Pack 2 and I'm wondering if I should do so again.  Any thoughts?Many 
thanksPaul Newton--- StripMime Report -- processed MIME parts 
---multipart/alternative  text/plain (text body -- kept)  
text/html---___Post Messages 
to:ProFox@leafe.comSubscription  
Maintenance:https://mail.leafe.com/mailman/listinfo/profoxOT-free  version of 
this list:https://mail.leafe.com/mailman/listinfo/profoxtechSearchable  
Archive:https://leafe.com/archivesThis  
message:https://leafe.com/archives/byMID/75dfa2e2-713e-5ab8-68df-3ccf88ff4...@gmail.com**
  All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.> 
___> 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/rde825y9uh99p4i.rz...@mo4-p00-ob.smtp.rzone.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.___Post Messages to: 
ProFox@leafe.comSubscription Maintenance: 
https://mail.leafe.com/mailman/listinfo/profoxOT-free version of this list: 
https://mail.leafe.com/mailman/listinfo/profoxtechSearchable Archive: 
https://leafe.com/archivesThis message: 
https://leafe.com/archives/byMID/2ff5b752-f70b-b307-861e-70e47c04b...@gmail.com**
 All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
___
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/rde825y9uhamp5o.rz...@mo4-p00-ob.smtp.rzone.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: VFP9 installation on a new machine

[Jürgen Wondzinski]

May I selfishly point you toWoody-prolib.blogspot.com? Von meinem/meiner Galaxy 
gesendet
 Ursprüngliche Nachricht Von: Paul Newton 
 Datum: 30.10.22  16:38  (GMT+01:00) An: 
Profox@leafe.com Betreff: VFP9 installation on a new machine Hi allIt's a long 
time since I had to install VFP9 and a couple of things have arisen.  I 
installed the original RTM and applied SP2 but I have two different files, both 
purportedly SP2.VFP9.0sp2-KB925841-X86-Enu.exe 
(34.8MB)VFP9.0sp2-KB955370-X86-Enu.exe (1.9 MB)According to www.berezniker.com/ 
the one I need (and used) is the first one but I wondered if anybody knows 
anything about the other one (the KBs are no longer available even on the web 
archive).I then appliedHotfix 3 for SP2  - VFP90SP2-KB968409-ENU.EXE  (10.8 
MB)ActiveX security updates - VFP9.0sp2-KB958371-X86-Enu.exe (4.6 
MB)GDIPLUS.DLL security updates - VFP9.0sp2-KB971105-X86-Enu.exe (1.9 MB)In the 
past I have also installed the VFPCOM utility,the OLE DB provider and MSXML 4.0 
Service Pack 2 and I'm wondering if I should do so again.  Any thoughts?Many 
thanksPaul Newton--- StripMime Report -- processed MIME parts 
---multipart/alternative  text/plain (text body -- kept)  
text/html---___Post Messages to: 
ProFox@leafe.comSubscription Maintenance: 
https://mail.leafe.com/mailman/listinfo/profoxOT-free version of this list: 
https://mail.leafe.com/mailman/listinfo/profoxtechSearchable Archive: 
https://leafe.com/archivesThis message: 
https://leafe.com/archives/byMID/75dfa2e2-713e-5ab8-68df-3ccf88ff4...@gmail.com**
 All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
___
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/rde825y9uh99p4i.rz...@mo4-p00-ob.smtp.rzone.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

[Jürgen Wondzinski]

See here: https://twitter.com/rschummer/status/1568592684910088195

That thread references stupid discussions similar to this one:
https://github.com/mattslay/GoFish/issues/14



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Donnerstag, 29. September 2022 10:12
An: profoxt...@leafe.com
Betreff: fox.wikis.com

What's going on there then?

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


--- 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/00e801d8d3e0$81c201e0$854605a0$@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: Nulls and generated HTML

[Jürgen Wondzinski]

Have you tried the SET NULLDISPLAY TO " "  setting?

I think, that this "Generate HTML" menuoption uses the _GENHTML program,
thus you could change the generation to your expectations.

Then there's the "WebPublishing Wizard" (under Tools / Wizards), you'll find
the sourcecode in VFP9\Tools\xsource\VFPSource\Wizards\wzweb
That one is coming with more "fancy" styles (from the 2000 aera), but maybe
it works better with NULLs.

wOOdy




-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Joe Yoder
Gesendet: Dienstag, 27. September 2022 19:34
An: profoxt...@leafe.com
Betreff: Nulls and generated HTML

I have a table deliberately created with null values in numeric fields.
This allows browsing the table and seeing zero value fields as blank rather
than zero..  i want to print the table and expected to use the HTML
generator on the file menu but it turns out that the nulls mess up the
formatting of the output.

Is there away to have the html generator treat the nulls as blanks?
Another non null way to browse a table without zeros in empty numeric
fields?

Thanks in advance,
joe


--- 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/028e01d8d2b3$2dad2310$89076930$@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: Creating a hyperlink on a PDF via XFRX.

[Jürgen Wondzinski]

Hi Alan,

since the Comments field of a Report-object doesn't get preprocessed by
XFRX, your various attempts cannot get you the expected results.

You could either modify the XFRX sourcecode (if you have bought the full
package), or contact Martina via supp...@eqeus.com to add that
functionality.

I also seem to remember, that you could rewrite the content of the
reportfile fields on the fly with some trick, thus you could rewrite the
content before it gets processed by XFRX. 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Dienstag, 23. August 2022 17:45
An: profoxt...@leafe.com
Betreff: Creating a hyperlink on a PDF via XFRX.

I'm reporting to PDF using XFRX. I need to create a hyperlink to an internet
URL. 

The method XFRX uses for this is via a string in the Comments field of a
report expression, so for example if I add a report expression with value =
"Click Here"  and put this in the comments:

#UR A HREF="https://www.rte.ie; 

Then the created PDF will have a clickable "Click Here" link to that site.
However I need to take the URL from a table field, i.e. not a static string,
but I can't get it to work. I've tried:

#UR A HREF=#+mytable.myfield
#UR A HREF=mytable.myfield
#UR A HREF=eval(mytable.myfield)

Has anyone ever done this ?


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



--- 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/031201d8b721$2ee234d0$8ca69e70$@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: Pictures in a table

[Jürgen Wondzinski]

Hi Ken,
There is now that funny thing called BLOB-Field. Your advice was relevant
for those dark times where we only had that General fieldtype. Now, the BLOB
is a Memofield like the General-Field, but it just stores Binary data
without any OLE-Information. You basically write the picture-file content
into that field, therefor you can always restore it to a real picture file
or just bind it to the PictureVal property of an ImageControl.

Create table Pictures (title C(50), content W) 
Insert into Pictures (title, content) Values ("My Picture", GetPict("JPG") )

On your form you just add an image control and set 
Pictureval = "Pictures.content")





-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ken Watkins
Gesendet: Montag, 15. August 2022 20:36
An: ProFox Email List 
Betreff: Pictures in a table

Hi ProFoxers.

I haven't posted in a decade or two, but I'm still hanging around.

I am writing an app for my son to manage his business. He's a therapist and
routinely jots down notes on a small notepad during his client sessions. He
later adds typewritten notes into the client record but he also takes a
picture of his handwritten notes and copies/pastes it into the client
record. He's been using OneNote to accomplish this but he wants to move away
from that. So I started my app and it creates the client records and the
memo fields needed for the notes but I can't figure out what to do with the
picture.

Now I know that the standard advice is "do not store the picture in a
General field, store the path to the picture..."  But I'm wondering if there
is a device or third party app that I could use to link the picture to the
client record. I even thought about him using a tablet with an electronic
pen to store his scribblings and somehow tie that into my Foxpro table.

Just looking for ideas on how to incorporate images with Foxpro records
elegantly.

Thanks.

Ken Watkins

--
This email has been checked for viruses by Avast antivirus software.
www.avast.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/023901d8b14f$89f4e390$9ddeaab0$@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: FoxyPreViewer on high resolution screens

[Jürgen Wondzinski]

It seems that this issue was solved in the V3.x versions, according to that
page:
https://www.foxypreviewer.com/p/new.html

And
http://www.foxypreviewer.com/p/usingv300.html

Thus you may want to download the latest version from there.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Dr. Joerg Arand
Gesendet: Mittwoch, 27. Juli 2022 12:02
An: 'ProFox@leafe.com' 
Betreff: FoxyPreViewer on high resolution screens

Hi all,

I have a problem with foxyprewviewer and high resolution screens.

IF the scaling of display fonts is set to more then 100%,  the report is
rendered large than expected and thus often no longer fits into the print
area.
I think it's a Problem of GDI+
Does anybody have an idea for a Workaround?

Greatings
Dr. med. Jörg Arand
Oberarzt


___
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/00d501d8a1a2$fac15de0$f04419a0$@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: FoxyPreViewer on high resolution screens

[Jürgen Wondzinski]

The easy way out: set display scaling to 100% 
:)
Maybe you'll find a solution here:
https://www.foxite.com/archives/foxypreviewer-resolution-fonts-481872.ht
m

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Dr. Joerg Arand
Gesendet: Mittwoch, 27. Juli 2022 12:02
An: 'ProFox@leafe.com' 
Betreff: FoxyPreViewer on high resolution screens

Hi all,

I have a problem with foxyprewviewer and high resolution screens.

IF the scaling of display fonts is set to more then 100%,  the report is
rendered large than expected and thus often no longer fits into the print
area.
I think it's a Problem of GDI+
Does anybody have an idea for a Workaround?

Greatings
Dr. med. Jörg Arand


___
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/00d301d8a1a1$8b290ec0$a17b2c40$@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] Monitor woes

[Jürgen Wondzinski]

Seems that one would be your choice:
https://www.amazon.com/dp/B010BEDSE4

Found here:
https://www.productchart.com/monitors/

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/021901d885a5$6b31e640$4195b2c0$@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] Monitor woes

[Jürgen Wondzinski]

Maybe search here on your needs:
https://www.displayspecifications.com/en/display-finder

Click on top-left on filter, set size to 17 - 21, Resolution to 1920x1080
and check the results  :)


Another one is https://versus.com/en/monitor
I haven't been able to see a Resolution filter on that one, though



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Dienstag, 21. Juni 2022 19:12
An: profox@leafe.com
Betreff: Re: [NF] Monitor woes

There is another model, Viewsonic VA2055SM which has similar specs but which
includes DVI-D output - would that be a better option?

Your thoughts, Jurgen?

Paul Newton

On 21/06/2022 16:42, Alan Bourke wrote:
> VGA only. Well, you can get DVI or HDMI to VGA converters but this is no
different than the first monitor, a VGA connection is a D-SUB type
connection. The old Atari joystick style!
>


--- 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/021701d885a4$e6a47d20$b3ed7760$@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] Monitor woes

[Jürgen Wondzinski]

Never use a D-SUB connector in todays world! D-SUB is analog, all video is 
digital nowadays. Thus that monitor must be really old, if it only has a D-Sub. 
Any Analog2Digital adapter means quality loss.

There are so many good digital monitors on the market, why do you picked that 
old stuff?
If you need a reliable source, just go to www.dell.com, their monitors are 
really stable and for long usage.


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Dienstag, 21. Juni 2022 15:32
An: profox@leafe.com
Betreff: [NF] Monitor woes

Hi all

I have just taken delivery of a 20" monitor which the vendor assured me has a 
resolution of 1920x1080.  It doesn't, its native resolution is 1600x900.

I have identified another Viewsonic monitor from a different vendor which 
definitely has a 1920x1080 resolution but it only has a D-sub connector. Is 
this something I should be concerned about (I know that I can get a D-sub to 
HDMI or D-sub to DisplayPort cable).

Thanks

Paul Newton

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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/013c01d88575$706c4040$5144c0c0$@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: Problem setting ActiveX control property (Folderview and Fileview controls)

[Jürgen Wondzinski]

Try addressing the Array with numbers instead of names. Foxpro has no concept 
of Names instead of rownumbers for parameters. (only in collections)

i.e. figure out what row index that "Name" has. 
Then use it like
MyFileView.ColumnWidth(5,0) = 240

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/00c601d87c19$b1386780$13a93680$@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: fox wiki down for anyone else?

[Jürgen Wondzinski]

Working againVon meinem/meiner Galaxy gesendet
 Ursprüngliche Nachricht Von: Alan Bourke 
 Datum: 30.05.22  18:47  (GMT+01:00) An: 
profoxt...@leafe.com Betreff: Re: fox wiki down for anyone else? Yes 503 here. 
Steven Black is the hombre responsible IIRC--   Alan Bourke  alanpbourke (at) 
fastmail (dot) fm___Post Messages 
to: ProFox@leafe.comSubscription Maintenance: 
https://mail.leafe.com/mailman/listinfo/profoxOT-free version of this list: 
https://mail.leafe.com/mailman/listinfo/profoxtechSearchable Archive: 
https://leafe.com/archivesThis message: 
https://leafe.com/archives/byMID/235b3b93-f139-41c3-a27c-99a2490f8...@www.fastmail.com**
 All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.
___
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/q06426y4ugqa7gc.rz...@mo4-p00-ob.smtp.rzone.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: fox wiki down for anyone else?

[Jürgen Wondzinski]

U3RldmUgaXMgZml4aW5nIGl0IHhjdXJyZW50bHlWb24gbWVpbmVtL21laW5lciBHYWxheHkgZ2Vz
ZW5kZXQKLS0tLS0tLS0gVXJzcHLDvG5nbGljaGUgTmFjaHJpY2h0IC0tLS0tLS0tVm9uOiBKZWZm
IFJvYmVydHMgPGplZmZscm9iZXJ0c0BnbWFpbC5jb20+IERhdHVtOiAzMC4wNS4yMiAgMTg6NDEg
IChHTVQrMDE6MDApIEFuOiBQcm9Gb3ggRW1haWwgTGlzdCA8cHJvZm94QGxlYWZlLmNvbT4gQmV0
cmVmZjogZm94IHdpa2kgZG93biBmb3IgYW55b25lIGVsc2U/IEkgaGF2ZW4ndCBiZWVuIGFibGUg
dG8gcHVsbCB1cCBwYWdlcyBvbiBmb3ggd2lraSAoaHR0cHM6Ly9mb3gud2lraXMuY29tLylmb3Ig
c2V2ZXJhbCBkYXlzLiBJcyBhbnlvbmUgZWxzZSBoYXZpbmcgdGhpcyBwcm9ibGVtPyBJZiBzbywg
ZG9lcyBhbnlvbmVrbm93IHdobyBtYWludGFpbnMgdGhpcyBzaXRlPyBJIHdhcyBwbGF5aW5nIGFy
b3VuZCB3aXRoIGxpbmtlZCBzZXJ2ZXJzIGluU1FMIFNlcnZlciAyMDE0IGFuZCB0aGVyZSB3YXMg
c29tZSBjb2RlIHRoZXJlIEkgd2FzIGdvaW5nIHRvIHB1dCBpbnRvIG15bm90ZXMuLS0gSmVmZiBS
b2JlcnRzIHwgamVmZmxyb2JlcnRzQGdtYWlsLmNvbS0tLSBTdHJpcE1pbWUgUmVwb3J0IC0tIHBy
b2Nlc3NlZCBNSU1FIHBhcnRzIC0tLW11bHRpcGFydC9hbHRlcm5hdGl2ZcKgIHRleHQvcGxhaW4g
KHRleHQgYm9keSAtLSBrZXB0KcKgIHRleHQvaHRtbC0tLV9fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fUG9zdCBNZXNzYWdlcyB0bzogUHJvRm94QGxlYWZlLmNv
bVN1YnNjcmlwdGlvbiBNYWludGVuYW5jZTogaHR0cHM6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbWFu
L2xpc3RpbmZvL3Byb2ZveE9ULWZyZWUgdmVyc2lvbiBvZiB0aGlzIGxpc3Q6IGh0dHBzOi8vbWFp
bC5sZWFmZS5jb20vbWFpbG1hbi9saXN0aW5mby9wcm9mb3h0ZWNoU2VhcmNoYWJsZSBBcmNoaXZl
OiBodHRwczovL2xlYWZlLmNvbS9hcmNoaXZlc1RoaXMgbWVzc2FnZTogaHR0cHM6Ly9sZWFmZS5j
b20vYXJjaGl2ZXMvYnlNSUQvQ0FNYW5kcTloQ1FzSHJfeFBQZE5taWFVMlRlQW5YNHM1LUV6Q01q
aWtBLVlLV0FMZURRQG1haWwuZ21haWwuY29tKiogQWxsIHBvc3RpbmdzLCB1bmxlc3MgZXhwbGlj
aXRseSBzdGF0ZWQgb3RoZXJ3aXNlLCBhcmUgdGhlIG9waW5pb25zIG9mIHRoZSBhdXRob3IsIGFu
ZCBkbyBub3QgY29uc3RpdHV0ZSBsZWdhbCBvciBtZWRpY2FsIGFkdmljZS4gVGhpcyBzdGF0ZW1l
bnQgaXMgYWRkZWQgdG8gdGhlIG1lc3NhZ2VzIGZvciB0aG9zZSBsYXd5ZXJzIHdobyBhcmUgdG9v
IHN0dXBpZCB0byBzZWUgdGhlIG9idmlvdXMu


--- 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/q06426y4ugoi7fz.rz...@mo4-p00-ob.smtp.rzone.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: Foxfest Tomorrow.... Help

[Jürgen Wondzinski]

At least you're on the "Who's coming" list at VirtalFoxFest.com   :)



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Dave Crozier
Gesendet: Mittwoch, 4. Mai 2022 15:26
An: ProFox Email List 
Betreff: Foxfest Tomorrow Help

I do not seem to have received any login info regarding getting access to the 
conference tomorrow desp[ite having received registration info and payment 
confirmation from Rick and the gang.

Has anyone else had this issue as I don’t want to miss the party tomorrow.

I have emailed i...@geekgatherings.com as to 
the issues I am having but not received anything back as of yet.

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

Mob: 07967 671080


___
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/01e501d85fbd$d43461d0$7c9d2570$@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 Tools~Options~Controls~ActiveX controls

[Jürgen Wondzinski]

A totally uninformed way to get rid of those entries:
a) In that VFP options listbox you get shown everything from the Registry hive 
"Computer\HKEY_CLASSES_ROOT" or 
"Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Classes\", which also has a "CLSID" as 
subnode. 
b) Use that curly brackets UID from that CLSID-Subnode to search for the real 
class data. Here you find a subnode "InprocServer32" which points you to the 
real file (normally a dll or ocx). 
c) Check if that's still available at that stored path. If not, delete all 
trailing Keys (the entries on the left tree), which have the CLSID reference to 
that UID.
d) if there's no entry for that CLSID UID, then you can also delete that first 
finding.

e) always do a Registry backup first (yea, "Backups are for wimps" :) )
f) there are some tools ("Registry Cleaner") which can do those deletes 
"automagically", but they mostly do also other stuff, thus be careful. 

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Sonntag, 1. Mai 2022 16:40
An: profox@leafe.com
Betreff: VFP9 Tools~Options~Controls~ActiveX controls

Hi all

Two things in the dialog referred to in the subject:

1.  The list shows some controls which are of an older version which I no 
longer need or use.  For example AXControl V6 and AXControl V8.  I want to 
somehow remove the older controls from the list (they do not appear as 
Installed Controls in the ActiveX catalog of the Component Gallery - even when 
I refresh the controls list)

2. There are several controls listed as "Unknown Type".  I have no idea what 
they are or where they have come from but I would like to get rid of them as 
well.

Any help or suggestions will be much appreciated.

Paul Newton


[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/035a01d85d74$0d94e180$28bea480$@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: Issues with referencing an array in a form

[Jürgen Wondzinski]

Why not just use the RowSourceType 3 (SQL Statement) in your combobox? 

Put this into your control
RowSourceType=3
RowSource= "Select dist Str(year(start),4) from leases into cursor curYears"

In Destroy, if no private Datasession:
Use in select("CurYears")




[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/00cf01d85876$c4a59200$4df0b600$@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: Virtual FoxFest 2022

[Jürgen Wondzinski]

Seems to work right now again.

For the lurkers: https://virtualfoxfest.com/

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Dave Crozier
Gesendet: Mittwoch, 13. April 2022 15:16
An: ProFox Email List 
Betreff: Virtual FoxFest 2022

Gents,
I have been trying all day to register for the event at the supplied address: 
http://geekgatherings.com/registration and the site will not load and simply 
times out.

Has anyone else had or does have an issue with the site?

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

Mob: 07967 671080

﴾⚆ᨎ⚆﴿



Flexipol® Packaging Ltd
T 01706 222 792
E dcroz...@flexipol.co.uk
W https://www.flexipol.co.uk/
Follow us: 
Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH

​This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.
  
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any attachments received as Flexipol 
Packaging Ltd will not in any event accept any liability whatsoever once an 
e-mail and/or any attachment is received.
  
 It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

-
​​
​Terms & Conditions:
 Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. 
("The Company") has received in cash or cleared funds payment in full of the 
price of the goods and all other goods agreed to be sold by the seller to the 
buyer for which payment is then due. Until such time as the property in the 
goods passes to the buyer, the buyer shall hold the goods as the seller's 
fiduciary agent and bailee and keep the goods separate from those of the buyer 
and third parties and properly stored protected and insured and identified as 
the seller's property but shall be entitled to resell or use the goods in the 
ordinary course of its business. Until such time as the property in the goods 
passes to the buyer the seller shall be entitled at any time

Disclaimer

The information contained in this communication from the sender is 
confidential. It is intended solely for use by the recipient and others 
authorized to receive it. If you are not the recipient, you are hereby notified 
that any disclosure, copying, distribution or taking action in relation of the 
contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been 
automatically archived by Mimecast Ltd, an innovator in Software as a Service 
(SaaS) for business. Providing a safer and more useful place for your human 
generated data. Specializing in; Security, archiving and compliance. To find 
out more visit the Mimecast website.


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

[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/01c201d84f3e$1c415540$54c3ffc0$@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: Converting RTF to HTML

[Jürgen Wondzinski]

Hi Paul,

just downloaded it. Thanks for your contribution!

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von
paul.newton.h...@gmail.com
Gesendet: Mittwoch, 2. März 2022 20:24
An: profox@leafe.com
Cc: 'Darren' 
Betreff: Converting RTF to HTML

Hi all

I spent some time looking for a utility to convert RTF to HTML and asked for
help.  Darren very kindly offered to help and came up with a solution based
on RtfPipe,  a  .NET library available on nuget

We are making it temporarily available here
https://drive.google.com/drive/folders/1-K64g4NuEJmk0patx_U80DZte6j9uMHJ?usp
=sharing

If anybody thinks it deserves to be made available on Ed's download section,
I will submit it for approval. 

 

Paul Newton

 



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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/02b801d82ef9$94104be0$bc30e3a0$@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: [SPAM] RE: Problem moving controls on a form at runtime

[Jürgen Wondzinski]

Remember: ActiveX Controls are essentially mini Windows programs contained in 
their own (borderless) window. VFP creates a hole in it's own form-window where 
that ActiveX is then peeking through. For the user there is no visual 
difference, but programmatically it's a foreign module. With making it 
invisible, VFP just closes that hole in it's window, and then reopens it, which 
then forces the ActiveX module to use that hole...

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von paul.newton.h...@gmail.com
Gesendet: Sonntag, 27. Februar 2022 13:21
An: profox@leafe.com
Betreff: RE: [SPAM] RE: Problem moving controls on a form at runtime

Many thanks Christof

I hadn't but I have now and it works - quite bizarre.  Do you have any kind of 
explanation?

Paul


___
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/006c01d82bfb$7534a640$5f9df2c0$@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: No classes in REGISTRY.VCX

[Jürgen Wondzinski]

Sounds like you have installed your VFP folder in the \program files\
branch? 
Don't do that. Never. Never install any VFP DevTools into that folder.
You don't have write permissions there, and Windows redirects all writes to
the VirtualStore.

Look into %LOCALAPPDATA%\VirtualStore\ if you'll find that broken copy there

For a working VFP installation method see also
http://woody-prolib.blogspot.com/


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von
paul.newton.h...@gmail.com
Gesendet: Donnerstag, 24. Februar 2022 12:21
An: profox@leafe.com
Betreff: No classes in REGISTRY.VCX

Hi all

 

When I open REGISTRY.VCX from its usual location (in folder FFC), there are
no classes present.

 

I have a good copy elsewhere and when I open it the expected classes are
there.

 

So, I copied the VCX and VCT from the good location to the FFC folder but
still opening it from FFC there are no classes present.

 

The VFP home folder is excluded from virus checking.

 

I am completely baffled (and very, very frustrated) .

 

Paul Newton



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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00e601d82973$6c3cc750$44b655f0$@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: Report to Microsoft PDF Printer creates text as images.

[Jürgen Wondzinski]

Hi Alan,

Yes that's a known problem for the "new" Printengine of VFP9.
Just do a SET REPO 80 to use the old engine, which will then produce pure
textbased PDFs.


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Dienstag, 22. Februar 2022 12:26
An: profoxt...@leafe.com
Betreff: Report to Microsoft PDF Printer creates text as images.

We have a customer who when printing a particular report from a Visual
Foxpro application sometimes selects the Microsoft PDF Printer (installed
with MS Office). This then prompts for a PDF file to save the report output
to. They then open the PDF in Acrobat Reader or whatever and need to select
and copy some text from it.

The problem is that sometimes the PDF is rendered as an image so no
individual elements are selectable in Acrobat Reader. All fonts on the
layout are standard Arial. There are no settings on the PDF printer to
adjust and nothing on the VFP side that I can see would affect it.

Replicating this process with the report layouts in question on my PC works
fine.

Has anyone ever come across this ?


-- 
  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/020301d827fc$454807e0$cfd817a0$@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: Problem trying to run a Powershell script as an Explorer shell command (Fox related)

[Jürgen Wondzinski]

Maybe you should just run VFP9.EXE /REGSERVER  with Admin privileges.

After that, start VFPCLEAN.APP from within VFP9, to restore all other
Registry settings.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von
paul.newton.h...@gmail.com
Gesendet: Freitag, 7. Januar 2022 23:43
An: profox@leafe.com
Betreff: Problem trying to run a Powershell script as an Explorer shell
command (Fox related)

Hi all

 

I have been toying on and off over several years with a method of opening
VFP with a MODIFY command when double-clicking a file in Explorer.  For
example, double-clicking on a PJX in Explorer should open VFP with the
command MODIFY PROJECT  NOWAIT.


___
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/034701d804a1$8b203860$a160a920$@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] Windows 10 32 bit on current Hardware

[Jürgen Wondzinski]

I don't know any reason, why a regular PC would block installation of a
32Bit Windows version. Haven't heard about that.

If everything fails, you could always just install a Win32 version in a
local HyperV or VM-Player.

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Philip Borkholder
Gesendet: Donnerstag, 4. November 2021 15:39
An: profox@leafe.com
Betreff: Re: [NF] Windows 10 32 bit on current Hardware

Hello,

I have a customer who is still running a FoxPro 2.6 application and has been
for years.
Their hardware is getting old and their IT/Network group is telling me that
they've tried to install WIndows 10 32 bit on several new workstations and
both Intel and AMD CPU based PC's are denying the ability to install the 32
bit version of Windows 10.
They say neither AMD nor Intel are allowing the 32 bit installation to
start.

Has anyone run into this recently? Does anyone have any suggestions or work
arounds?
There are a lot of "well it should work" comments I've been given but has
anyone actually been able to do it on new hardware?

Thanks,

Philip B.
Vicksburg, MI

[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/02fb01d7d18c$1e4dc9c0$5ae95d40$@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: FP Advisors?

[Jürgen Wondzinski]

Ok, now he has it doubled, since I also sent it to him :)  
Unfortunately, I can't help with such old FoxTalks. They switched to PDFs only 
in 1997. As far as I remember, before that they had some strange homegrown 
electronic format packaged as an EXE. 
I redirected him to Rainer Becker, who took over the FoxTalk business from 
Pinnacle. Maybe he has those files somewhere.

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ted Roche
Gesendet: Montag, 25. Oktober 2021 21:23
An: profox@leafe.com
Betreff: Re: FP Advisors?

I've also got the PDFs, from the CD collection, and extracted the page and sent 
it to Peter.

He's also looking for his first article, from FoxTalk, July '92. Sadly, my 
paper magazines went into recycling a while ago.

If anyone has this issue, let me know .


___
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/02fb01d7c9e3$6abefe60$403cfb20$@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: FP Advisors?

[Jürgen Wondzinski]

Yes of course! I still have all literature around FoxPor available in my
shelf. 
FoxPro Advisor is available here on paper as well as PDF. 
I looked up the 93-10 PDF, and yes: there's a one-page about JKEY.
If Peter sends me an email, then I'll forward it to him

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Eric Selje
Gesendet: Samstag, 23. Oktober 2021 18:07
An: ProFox Email List 
Betreff: FP Advisors?

Anybody still have their FP Advisors around? Peter Diotte is looking for an
article he wrote on JKey in the Oct '93 edition. Are these available online?

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/05fb01d7c82d$dbe63660$93b2a320$@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] ML & Python anyone?

[Jürgen Wondzinski]

Hi Peter,

for that you'll use the free (!) Community Edition.
https://www.lianja.com/resources/blog/38-development-news/178-compare-lianja-app-builder-editions



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Peter Cushing
Gesendet: Montag, 4. Oktober 2021 15:15
An: profox@leafe.com
Betreff: Re: [NF] ML & Python anyone?

Lianja looks interesting but a little pricey for my purposes.  I won't be 
building any apps but just some data mining/ML.

Thanks,

Peter Cushing
IT Department
WHISPERING SMITH



___
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/026b01d7b923$92385c00$b6a91400$@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] ML & Python anyone?

[Jürgen Wondzinski]

If you're able to speak Python, you could as well take a look at 
www.Lianja.com, which is basically VFP11 with Python, PHP, JavaScript and 
TypeScript compilers added. Uses the VFP object-model including its 
Container-Hierarchy and classes. Can use any database (besides of it's own 
SQLServer), generates classic Desktop apps for Win, Mac and Linux. Creates 
Mobile Apps. It's also easy to build cloudbased AppServers and SaaS 
installations. 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Peter Cushing
Gesendet: Freitag, 1. Oktober 2021 15:16
An: profox@leafe.com
Betreff: Re: [NF] ML & Python anyone?

Interesting.  Just recently downloaded python and was looking at doing some ML. 
 Also downloaded pytorch to hopefully do this.  Got to learn some python first, 
then try to apply it.   Lots to learn and will have a look at the videos on 
here.  Thanks,


Peter Cushing
IT Department
WHISPERING SMITH



___
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/009601d7b6ca$53967fa0$fac37ee0$@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: Line by Line Relationship in Two Databases

[Jürgen Wondzinski]

What's a PDB file? 
Assuming that you meant DBF, and that Data to Display is a One-to-Many relation 
and that the master record in data has a unique Item per record and that 
Display carries that Item on all relevant records..

USE DataIN 0 ORDER Date
USE Display IN 0 ORDER item

SELECT Display
BROWS LAST NOWAIT

SELECT Data
SET RELATION TO Item INTO Display
BROWS LAST NOWAIT

Now just position both windows side by side, scroll through Data and see 
Display refresh accordingly.



___
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/01b601d7b14f$08e4e3f0$1aaeabd0$@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: "Eric Rapaport" at Microsoft

[Jürgen Wondzinski]

Wouldn't he then be either mentioned on http://www.foxprohistory.org/ or in
the FoxTales book?

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/005901d7ae48$06824d00$1386e700$@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: Social Media buttons

[Jürgen Wondzinski]

Not sure where's the problem with those buttons. Add Commandbutton, add the
necessary picture, change PicturePosition to show only picture and hide
caption. Then add a Hyperlink control, add the necessary URL and call it
from your button.click.



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von kbe...@mchsi.com
Gesendet: Sonntag, 15. August 2021 17:31
An: ProFox Email List 
Betreff: Social Media buttons

Hello,
I have not posted in a while but still have many active VFP apps still in
use !!

Had a request to add social media buttons, so users could share pictures on
facebook, twitter ect.

Did the usual searches but did not find anything. Has anyone added social
media buttons?

Is there an library I can include to give me the options?

Thanks,
Kent


[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/022701d7937b$dcfe41f0$96fac5d0$@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 pop-up windows (like the Find window dialog in Code References, and sometimes the entire Debug window)

[Jürgen Wondzinski]

Maybe Doug Hennig's whitepaper will be of some help:
https://doughennig.com/papers.aspx
There look for "Handling Multiple Monitors"

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/001001d78e10$7cac0c30$76042490$@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: Time variables

[Jürgen Wondzinski]

There is no "Time only" variable type in VFP. Thus, you'll need to go with a
default date attached to your time portion.
I normally use the 1.1.2020 for that. As long as you always use the same
date part, your time calculations will be not affected from that additional
baggage. 

In Excel you can just display the time part. 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Joe Yoder
Gesendet: Montag, 26. Juli 2021 18:36
An: profoxt...@leafe.com
Betreff: Time variables

I want to build a cursor of time fields for export to Excel.  The DateTime
format allows a simple for next loop to increment the time value by a
specified number of seconds.

Is there a function that allows the extraction of the time portion of a
DateTime variable as a time value not as a string?  It seems one could pull
out the hours and minutes as characters and convert them to time via CTOT
but this results in a DateTime result with an embedded date.

Thanks in advance,

Joe


--- 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/072201d7823e$3162a2d0$9427e870$@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.

PDF printing on WINE & Win98

[Jürgen Wondzinski]

Ok, now it's my turn for a problem solving:

I inherited a customer, who runs a VFP6 app on a WINE on Linux setup. The 
emulated Windows version is a Win98.
The original developer and SysAdmin left the company. (After looking at the 
codebase, I now know why)
I was able to successfully recompile it in VFP9 and fix some idiotic things.
 
Now the customer wants to print reports to PDF and then create an email (pure 
text), attach that PDF and mail it by SMTP.

All that without using the new printengine (that is slower than molasses on 
that installation), and no COM object (since WINE is version 1.1.9 from 2006)

Has anybody experience with a simple DLL only solution for that scenario?

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/018b01d76ccf$8eb14010$ac13c030$@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: FPW26a

[Jürgen Wondzinski]

Yeah, if you really care to be a masochist, you could run Win3.11 as your 
development platform for sure.
Me can think of more pleasant and tickling nastiness than that 

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Dienstag, 29. Juni 2021 10:28
An: profox@leafe.com; profoxt...@leafe.com
Betreff: Re: FPW26a


On Mon, 28 Jun 2021, at 3:14 PM, Jürgen Wondzinski wrote:
> Alan, he's talking of FoxPro 2.6 for WINDOWS. No DOS involved here.
> 

Hi Jürgen, entirely possible, install Windows 3.11 under DosBox-X and then copy 
your FPW stuff over from your main filesystem using a shared location.

https://i.postimg.cc/Th87r8xq/screen1.png
https://i.postimg.cc/c1KdMQZr/screen2.png


[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/005801d76cc2$5e3229c0$1a967d40$@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: FPW26a

[Jürgen Wondzinski]

Alan, he's talking of FoxPro 2.6 for WINDOWS. No DOS involved here.


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Montag, 28. Juni 2021 14:09
An: profoxt...@leafe.com
Betreff: Re: FPW26a

Networking would probably be easier with Windows 98 but to be honest I'd use
DosBox-X and just run it in a window and not bother with virtualisation.

--
  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/035d01d76c27$ef2458e0$cd6d0aa0$@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: FPW26a

[Jürgen Wondzinski]

You should use the latest Windows to support FWP26, and that would be WinXP.
Not sure why you want to use Win31 (impossible to run FPW), or Win98 (which is 
stil way to old)

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Charles Hart Enzer, M.D.
Gesendet: Sonntag, 27. Juni 2021 17:25
An: Profox 
Betreff: FPW26a

I want to run FPW26a from a Virtual Disk, Oracle VM Virtualbox

What are the advantages of guesting with

   - WIN3.1
   - WIN98SE

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/02bd01d76bf4$e7989dd0$b6c9d970$@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: SP2 Download?

[Jürgen Wondzinski]

Hi Eric,

nothing frustrating at all. Just read here:
http://woody-prolib.blogspot.com/2018/12/how-to.html

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Eric Selje
Gesendet: Mittwoch, 16. Juni 2021 02:43
An: ProFox Email List 
Betreff: SP2 Download?

Ok, where does one get Service Pack 2 these days? Also, do I need SP1 first?
This is frustrating.

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/002d01d76280$6857cf00$39076d00$@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: Printing PDF's

[Jürgen Wondzinski]

Shouldn't this be done with a simple ShellExecute(0,"print","yourFile.pdf") ?

That's the same as when you rightclick in Explorer on your file and chose 
"Print".
Whatever is configured on that PC as default service for PDFs will get that job.

wOOdy




-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Chris Davis
Gesendet: Montag, 7. Juni 2021 10:10
An: profox@leafe.com; profoxt...@leafe.com
Betreff: RE: Printing PDF's

Thanks for the replies, but I'm not printing to a PDF ... I am printing an 
existing PDF to the printer.



___
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/063a01d75bb1$ba73cfd0$2f5b6f70$@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: Formset goofy

[Jürgen Wondzinski]

Think of FormSets as a predecessor for Pageframes. It was the 2.x way of
switching several Pages/Forms into the users workspace.

Thus for todays UI I would recommend using a single form with embedded
Pageframe.

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/00f601d752fa$fe6962a0$fb3c27e0$@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: Searching classes and forms for something specific

[Jürgen Wondzinski]

Maybe that's what you're looking for:
VFPX VFP-Editors:
https://github.com/ggreen86/VFP-Editors

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Tracy Pearson
Gesendet: Mittwoch, 12. Mai 2021 04:12
An: profox@leafe.com
Betreff: Searching classes and forms for something specific

Is there a search tool out there that can search for criteria such as the
following:
The Column.Sparse is set to False. That same Column has a TextBox baseclass
in it.

I have already slowly parsed most instances of the Sparse property in my
search. 
I know I can write something that can search for this specific query as
well.
I'm curious if there is a tool to help in the future.

Thank you,
Tracy


[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/012801d7477c$db9a7a90$92cf6fb0$@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: Drag and Drop code

[Jürgen Wondzinski]

Hi Mike,

yes I used the native VFP DragDrop, because 
a) we are only dragging inside a VFP form
b) less overhead
c) less coding
d) not much to go wrong 

If you're in need of D between different apps, then you need to go the 
OLEDrag way. But a pure "inside VFP" D doesn't need the whole overhead of 
that OLE Fluff, and you're done with 3 lines of code.

wOOdy




-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Freitag, 7. Mai 2021 21:01
An: profox@leafe.com
Betreff: Re: AW: Drag and Drop code

Hi wOOdy,

I had time today to look at it moreso.  Looks like you're using the classic 
Drag method vs OLEDragDrop.  Hey, whatever works!  Am I right to say that 
native Fox objects like this (as opposed to pictures or
whatever) are better suited for the non-OLE Drag methods?

tia,
--Mike


___
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/021801d7439e$6d2c6a00$47853e00$@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: _framewk,vct is missing or invalid, but it isn't and it's not.

[Jürgen Wondzinski]

As a rule of thumb: FoxPro as a Development system must not get installed in
%Program Files% ! That directory hive is only for Runtime apps, and such
those files are not allowed to write into that folders (Virus Prevention).
If they need to write program-specific files, those go into %Program Data%.
And: that's a GOOD THING (tm)!  
If you insist to install under %program files%, you need to invoke all
permissions on that folder.  Since not all programs adhere to those
principles, MS invented that VirtualStore, which is a really clever way to
keep those stupid programs running and stil don't let viruses get into the
secured area. 

Unfortunately, FoxPro is too old for adhering to those Established Security
Rules, that's why you should always install it to a different non-secured
and non-supervised folder (like c:\Develop).  See also
http://woody-prolib.blogspot.com/ for installation of VFP9 in a modern
world.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ted Roche
Gesendet: Dienstag, 4. Mai 2021 15:25
An: profox@leafe.com
Betreff: _framewk,vct is missing or invalid, but it isn't and it's not.

Rebuilding a project that includes c:\program files (x86)\microsoft visual
foxpro 9\wizards\_framewk.vcx gives the error

Memo file c:\program files (x86)\microsoft visual foxpro
9\wizards\_framewk.VCT is missing or invalid.

But it isn't and it's not.

I copied both _framewk files from another machine where it works, no change.
I opened the file exclusively and tried to PACK and get the same error. I
copy the two files to C:\temp and they pack fine, and compile classlib works
there (after I also copied over _framewk.h) but moving the files back to the
above directory and attempting a build project, rebuild all throws the same
error.

This is a permissions issue with the program files (x86) folder and I've
tried turning off the "Read Only" settings and in the folder permissions
granting Modify and Write to the Users group, but the errors continue.

Any suggestions on how to get the Program files (x86) to be read-write for
VFP? Moving the files to the project folder would be my preference, but it
is not my project.


--- 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/027a01d74119$2640fca0$72c2f5e0$@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: Drag and Drop code

[Jürgen Wondzinski]

Hi Mike

Funny, I just created a sample for you. See source here:
https://1drv.ms/u/s!AujNq3xu6Q4_nYk-vAOY_wxoN97qEw?e=uF4yXu

Just a Quick'nDirty Example how you could do a Drag'n'Drop with Grids.
In pure coincidence I had a trainee for VFP onmy side, thus we did a learning 
session out of it.
We just recreated it based on your screenshot, we take no punishment for wrong 
scores or misspelled names :)

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Dienstag, 4. Mai 2021 04:36
An: profox@leafe.com
Betreff: Re: Drag and Drop code

Done with grids instead:  https://www.screencast.com/t/5X7Mn6QDb5

Honestly, I think I used listviews ONCE in my 26 year history of FoxPro, and 
that was to echo a processing status on a dedicated Report/Print Server using 
VFP5/6 on a Novell Netware client network at KePRO, Inc in Harrisburg, PA.  :D


On 5/3/2021 5:22 PM, MB Software Solutions, LLC wrote:
> Hi wOOdy!
>
> Oh believe me...grids would be S MUCH EASIER   I'm gonna 
> rebuild this with grids insteadbut my meeting with the Team 
> Captains was tonight at 8pm so I wasn't sure I'd get it done in time.
> SWMBO wants to go grab some dinner now too.  Ugh.
>
> Yes...I wanted to grab between sources to "trade" players from one 
> listbox/grid to the other.
>
>
> On 5/3/2021 4:59 PM, Jürgen Wondzinski wrote:
>> Just wondering:
>> Why not use Grids with AllowCellSelection = .f. and HighLightStyle = 2 ?
>> You'll get so much more possibilities (optical as well as technical) 
>> in comparison to Listboxes
>>
>> But back to your problem:
>> So you want to drag players from the left list to any of those Team 
>> groups as well as criss-cross ?
>>
>> wOOdy
>>
>>
>> -Ursprüngliche Nachricht-
>> Von: ProFox  Im Auftrag von MB Software 
>> Solutions, LLC
>> Gesendet: Montag, 3. Mai 2021 21:44
>> An: ProFox Email List 
>> Betreff: Drag and Drop code
>>
>> Many many moons ago I did some drag and drop code, but I have 
>> forgotten completely and it's no longer in my possession anyway. I 
>> want to drag names amongst a screen full of listboxes:
>> https://www.screencast.com/t/6M8XxvSFV
>>
>> I know I need to code in the OLEDragDrop event and native VFP Help 
>> sucks, not really showing me anything.
>>
>> I was thinking the oDataObject was the listbox where the drag started 
>> but no.  I tried to SET STEP ON but VFP says "CANCEL or SUSPEND is 
>> not allowed."
>>
>> LPARAMETERS oDataObject, nEffect, nButton, nShift, nXCoord, nYCoord 
>> LOCAL loLB as ListBox loLB = oDataObject wait window loLB.ListCount 
>> && this fails
>>
>> SET STEP ON  && this doesn't work either
>>
>>
>> I have the properties set correctly to allow me to drag from one list 
>> to another but now I'm stuck.  Going to search the archives next but 
>> throwing this out there in the meantime.  Was hoping to have 
>> drag/drop implemented by the time I had a ZOOM call with my fellow 
>> hockey captains to set the teams tonight!
>>
>> tia,
>> --Michael
>>
>>
>>
>> --
>> 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/001101d740a3$630a1110$291e3330$@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: Drag and Drop code

[Jürgen Wondzinski]

Just wondering:
Why not use Grids with AllowCellSelection = .f. and HighLightStyle = 2 ? 
You'll get so much more possibilities (optical as well as technical) in 
comparison to Listboxes

But back to your problem:
So you want to drag players from the left list to any of those Team groups as 
well as criss-cross ?

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Montag, 3. Mai 2021 21:44
An: ProFox Email List 
Betreff: Drag and Drop code

Many many moons ago I did some drag and drop code, but I have forgotten 
completely and it's no longer in my possession anyway. I want to drag names 
amongst a screen full of listboxes: 
https://www.screencast.com/t/6M8XxvSFV

I know I need to code in the OLEDragDrop event and native VFP Help sucks, not 
really showing me anything.

I was thinking the oDataObject was the listbox where the drag started but no.  
I tried to SET STEP ON but VFP says "CANCEL or SUSPEND is not allowed."

LPARAMETERS oDataObject, nEffect, nButton, nShift, nXCoord, nYCoord LOCAL loLB 
as ListBox loLB = oDataObject wait window loLB.ListCount  && this fails

SET STEP ON  && this doesn't work either


I have the properties set correctly to allow me to drag from one list to 
another but now I'm stuck.  Going to search the archives next but throwing this 
out there in the meantime.  Was hoping to have drag/drop implemented by the 
time I had a ZOOM call with my fellow hockey captains to set the teams tonight!

tia,
--Michael



--
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/01f701d7405f$25343c10$6f9cb430$@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: File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1

[Jürgen Wondzinski]

Just a heads-up for SMB3: VFP is completely capable of SMB3. 
I have a customer with a clustered Hyper-V Server (i.e two identical boxes
in parallel mode), running a VM with my DBF files as a regular
fileserver-share. That's a Restaurant-System in 24/7 mode; i.e. those DBF
files are always in use. The HyperV-server does his routinely updates and
occasionally reboots and then switches the VMs from one machine to the other
without interruption of the SMB3 connection, even though the other box has
(of course) a different network card, IPs etc.
Just for testing, I tried to run a Client with SMB1 only connection and got
plenty problems with lost connections and dataaccess troubles. 

SMB3 is vital and necessary for all modern Windows Server operations, don't
shut that off or you will get killed by some admin.
SMB1 is not needed anymore in todays worlds.

As long as you have local (Client) DataCaching and OpLocks disabled,
everything is ok.  In your VFP EXE at startup check those Registry keys from
Christof's list, and yell if they are wrong.  No, you can't change them from
inside your EXE, since those are machinewide settings and therefor require
AdminRights.

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/03e301d731d0$dc77db40$956791c0$@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] New hardware - network port and HDD

[Jürgen Wondzinski]

Another gotcha:
>> The new HDD (WD Red 3.5" Internal Hard Drive) has a <<

You will definitely not get a 3.5" platter into your laptop. Laptops have
2.5" or 1.8" cages.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Sonntag, 21. März 2021 23:28
An: profox@leafe.com
Betreff: [NF] New hardware - network port and HDD

Hi all

Please note my change of address - as a result of recently being made
redundant.  I have recently taken delivery of an HP Omen 17" laptop.  I am
used to having an ethernet port which accepts what I would call a standard
Cat5 plug but the port on the new laptop does not accept that plug which is
obviously too big.  The manual describes the port as RJ-45 (network) jack.
What would I need in order to connect my Cat5 plug into the RJ-45 socket?

The new laptop has a 512GB SSD and a 1TB HDD.  The only info I have about
the 1TB drive is that it is 7200rpm.  Can I simply replace it with a 4TB
model running at 5400RPM?  The new HDD (WD Red 3.5" Internal Hard Drive) has
a

   - SATA III 6 Gb/s interface.  Would I need to check  that for
   compatibility?

Many thanks

Paul Newton



___
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/09b201d71f0d$f4d03280$de709780$@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] New hardware - network port and HDD

[Jürgen Wondzinski]

>> Is it likely that the laptop will accept a 15mm HDD <<

I wouldn't expect that. Since you have a folded network-connector, me thinks 
that your laptop is very thin. Thus a 15mm HD would not fit. Those thick HDs 
are normally for Server usage.  Just screw around  and look for the HD 
enclosure. 

Also I wouldn't go with a mechanical HD in a Laptop anymore. Samsung has 
already 1, 2 and 4 TB SSDs. Ok, pricing for that 4Tb is a little bit steep 
(about 400-500 $), but if you need that much space 

wOOdy
 


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Montag, 22. März 2021 09:49
An: profox@leafe.com
Betreff: Re: [NF] New hardware - network port and HDD

Thanks Tracy - got it connected after a bit of jiggling around.  Is it likely 
that the laptop will accept a 15mm HDD (as opposed to the newer 7mm profile)?

Paul

On Sun, 21 Mar 2021 at 23:39, Tracy Pearson  wrote:

> Hi Paul,
>
> Some laptops RJ-45 ports have a piece that drops down. This part is 
> where the tab on the cable catches.
>
> SATA drives are backwards compatible. SATA ports are also backwards 
> compatible. They just won't be as fast.
>
> How that helps,
> Tracy
>
> On March 21, 2021 6:28:09 PM EDT, Paul Newton 
> 
> wrote:
> >Hi all
> >
> >Please note my change of address - as a result of recently being made 
> >redundant.  I have recently taken delivery of an HP Omen 17" laptop.  
> >I am used to having an ethernet port which accepts what I would call 
> >a standard
> >Cat5 plug but the port on the new laptop does not accept that plug 
> >which is obviously too big.  The manual describes the port as RJ-45 
> >(network) jack.
> >What would I need in order to connect my Cat5 plug into the RJ-45 
> >socket?
> >
> >The new laptop has a 512GB SSD and a 1TB HDD.  The only info I have 
> >about the 1TB drive is that it is 7200rpm.  Can I simply replace it 
> >with a 4TB model running at 5400RPM?  The new HDD (WD Red 3.5" 
> >Internal Hard
> >Drive)
> >has a
> >
> >   - SATA III 6 Gb/s interface.  Would I need to check  that for
> >   compatibility?
> >
> >Many thanks
> >
> >Paul Newton
> >
> >
> >--- 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/CABvSqAAUj3WgJc_BbyRV_2zzgWxaqw_V-RX=
> 0sk4ky_2ujr...@mail.gmail.com
> >** All postings, unless explicitly stated otherwise, are the opinions 
> >of the author, and do not constitute legal or medical advice. This 
> >statement is added to the messages for those lawyers who are too 
> >stupid to see the obvious.
> >
> >Report [OT] Abuse:
> >
> http://leafe.com/reportAbuse/CABvSqAAUj3WgJc_BbyRV_2zzgWxaqw_V-RX=0SK4
> ky_2ujr...@mail.gmail.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/099b01d71f0d$5d3be040$17b3a0c0$@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 on 64bit Machine

[Jürgen Wondzinski]

VFP3 won't run because it can manage only 512MB (or 768MB with version 3.0b)
of RAM.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Dienstag, 9. März 2021 10:19
An: profox@leafe.com; profoxt...@leafe.com
Betreff: Re: VFP on 64bit Machine

I don't see any reason why Visual Foxpro 3 wouldn't run, it's just a 32-bit
application. The only issues you might find with older versions of any
software is the installer not running if it's a very old Installshield or
something, or if it installs and tries to register a 16-bit component that
would have worked on 32-bit Windows. But I don't think that's the case with
VFP.

--
  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/064401d714c7$38802a90$a9807fb0$@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 on 64bit Machine

[Jürgen Wondzinski]

Since all Win64 always have 32Bit subsystem (called SysWow64), the earliest 
native 32Bit version was VFP5.


wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Charles Hart Enzer, M.D.
Gesendet: Dienstag, 9. März 2021 09:40
An: Profox 
Betreff: VFP on 64bit Machine

Which is the Earliest Version of Visual Foxpro to run under Windows 10, 64 bit 
machine?

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/060e01d714c2$ae34b620$0a9e2260$@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: ProFox List Statistics for February 2021

[Jürgen Wondzinski]

>> The amazing laws of small numbers 

And please note that absolutely staggering precision in calculations:
 >> (Up 163.329998% from January 2021)

It's almost like FoxPro with SET DECI TO 15!

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ted Roche
Gesendet: Montag, 1. März 2021 16:39
An: profox@leafe.com
Betreff: Re: ProFox List Statistics for February 2021

You're just a chatterbox!

And a three-way tie for 2nd, 3rd, 4th, and a 4-way tie for 5th and 6th! The 
amazing laws of small numbers.

On Mon, Mar 1, 2021 at 8:57 AM Richard Kaye  wrote:



___
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/044601d70ec2$f63c4bf0$e2b4e3d0$@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] Thoughts on ultra-wide screen monitors?

[Jürgen Wondzinski]

I'm using a LG 34UC88 with 3440x1440 resolution as main monitor, 
together with a Iiyama ProLite PL2395 in portrait mode (1200x1920) for Word,
PDFs and website (to minimize that stupid downscrolling)

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Malcolm Greene
Gesendet: Sonntag, 21. Februar 2021 17:34
An: profox@leafe.com
Betreff: [NF] Thoughts on ultra-wide screen monitors?

Curious if any of you have switched to an ultra wide screen screen monitors
and what your experience has been. By "ultra wide" I mean something wider
than 30" with a 3440 X 1440 or higher resolution and 16:9 or 21:9 aspect
ratios. 

1. Did you stay with the ultra wide or return to your original setup?
2. Did you keep your original monitors or move all your activity to the
ultra-wide display?
3. If you're happy with your ultra-wide recommendations on vendor and model
4. Pros, cons?

My primary workstation is a MacBook Pro running Big Sur.

Thanks!



--- 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/03d601d70886$230c2f80$69248e80$@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: Anyone There?

[Jürgen Wondzinski]

"there"? Where?

:=)

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von John Weller
Gesendet: Mittwoch, 10. Februar 2021 12:20
An: profox@leafe.com
Betreff: Anyone There?

Is anybody there?

 

John

 

John Weller

07976 393631

 



--- 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/01d501d6ffc0$774395d0$65cac170$@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] Macbook Upgrade

[Jürgen Wondzinski]

>> Did you know that they used octal numbering?

Jepp, that's why after 7 the next is 10

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/03e701d6fb43$73a608d0$5af21a70$@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] Macbook Upgrade

[Jürgen Wondzinski]

Hi Ken!

>> Special shout-out to wOOdy, harking back to the CompuServe days. <<

UhOh :) Thank You, Sir! 

Those CIS days.. 100015,676 to the rescue :)

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/032e01d6fb38$0708dcd0$151a9670$@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: ProFox List Statistics for 2020

[Jürgen Wondzinski]

Hi Ed,

Thanks for checking! The count now seems correct, but my name is stil mangled.

That "AW" is from a germanized Outlook (short for "Antwort"), don't know how 
French and Spanish versions are dealing with that

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ed Leafe
Gesendet: Sonntag, 3. Januar 2021 23:17
An: ProFox Mailing List 
Betreff: Re: ProFox List Statistics for 2020

On Jan 3, 2021, at 13:36, Jürgen Wondzinski  wrote:
> 
> Somehow that calculation is broken. It lists me as the one with the 
> most started threads. Definitely not true ...

It was assuming that all replies to a thread started with “Re: “. Your replies 
start with “AW: “. I’ve updated the code to exclude that variation from the new 
threads.

Are there any other language-specific reply prefixes I should also be aware of?

> It also can't get my name / umlaut correctly. Duh.. 

It’s correct in the database, but somehow the Python2 code was mangling the 
character set. I’ve just updated the script to Python 3, and it appears to be 
correct now. I’m going to re-send the yearly stats with these updates.


-- Ed Leafe







[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/03aa01d6e223$606bf970$2143ec50$@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: ProFox List Statistics for 2020

[Jürgen Wondzinski]

Somehow that calculation is broken. It lists me as the one with the most
started threads. Definitely not true ...

It also can't get my name / umlaut correctly. Duh.. 

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von List Administrator
Account
Gesendet: Freitag, 1. Januar 2021 07:13
An: profox@leafe.com
Betreff: ProFox List Statistics for 2020




Top 20 Contributors by Number of New Threads Started

|Posts   Contributor   |

  1.   31JChttps://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/031201d6e207$afc24040$0f46c0c0$@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: Error 108 - File is in use by another user on INSERT INTO line

[Jürgen Wondzinski]

Hi Mike,

see HELP for SET TABLEVALIDATE.  You either haven't set that setting (then the 
default value is 1+2) or you got it wrong :)

The "correct" value would be 1+4 = 5  or a plain 0


wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Dienstag, 15. Dezember 2020 19:00
An: ProFox Email List 
Betreff: Error 108 - File is in use by another user on INSERT INTO line

VFP9SP2 - Citrix/VMWare server, Win10 desktop image on client

My error handling tripped on this simple line:

 INSERT INTO broker!doclinks
(ifileid,idoctypeid,crange) VALUES
(thisform.oFile.iid,liDocTypeID,ALLTRIM(loObj.txtRange.value))

VFP Help says this about Error 108:

Visual FoxPro 9.0 SP2 

File is in use by another user (Error 108) 

You have attempted a USE, DELETE, or RENAME command on a file that is being 
used by another user on a network.


I don't see why this line of code would throw an Error 108. I guess I'll 
add a simple TRY/CATCH around it to retry it "N" number of times (via DO 
WHILE loop with flag and counter), but tossing this out to the group for 
your thoughts.

Thanks,
--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/0be301d6d322$ab5d3710$0217a530$@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: SCX form included in EXE is not found on DO FORM line

[Jürgen Wondzinski]

Hi Mike,

Maybe, when compiling the EXE you are not saving tot he project folder? Always 
(!) save your exe to the project-root folder.
Next idea: When calling the form, use the relative pathing to that form: i.e. 
DO FORM forms\myform.scx

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Sonntag, 6. Dezember 2020 04:32
An: ProFox Email List 
Betreff: SCX form included in EXE is not found on DO FORM line

VFP9SP2 - Win 7 Pro

43 second demo showing the problem: https://www.screencast.com/t/ZjyWYqFI

The SCX form is included in the EXE.  I'm running the EXE.  DO FORM  
errors saying that the form is not found. Makes no sense to me.  Now the app (a 
legacy app that I inherited which is very dirty) changes the path but 
stillif the SCX form is included in the EXE, why in the world would it not 
be found on DO FORM frmMyForm???

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/040c01d6cc77$2aaacee0$80006ca0$@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] Missing codec - This item was encoded in a format that's not supported

[Jürgen Wondzinski]

First try to play them with VLC from www.VLC.org.  Comes with a whole bunch
of decoders. It can convert to different outputs, too. 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Dienstag, 10. November 2020 12:51
An: 'profox@leafe.com' 
Betreff: [NF] Missing codec - This item was encoded in a format that's not
supported

Hi all

I have a number of AVIs which I recorded for training purposes a long time
ago (probably when running Windows 7).  Now, when I try to play these AVIs I
get the message as in the subject.  Now running Windows 10 (2004).  Any
ideas where/how I can install a codec which will enable them to play?  Many
thanks.

Paul Newton


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/086d01d6b759$5fe9d2a0$1fbd77e0$@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: Bookmarks in XFRX report previewer

[Jürgen Wondzinski]

Just as a sidenote: Martina Jindrová (the developer of XFRX) is a regular in
Foxite.com. That would be the easiest way to get your answer :)

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Sonntag, 8. November 2020 00:21
An: 'profox@leafe.com' 
Betreff: Bookmarks in XFRX report previewer

Hi all

I have recently downloaded the latest version of XFRX (19.1) and I am trying
for the first time to implement bookmarks in the previewer.  I have a simple
report (no groups) with a detail section which contains several lines for
each account - something like this (AccountRef etc correspond to field names
in the underlying table/cursor)

AccountRef  AccountName
AccAddress1
AccAddress2

I know that I have to use comment fields in the report designer with
expressions like #UR ... (let's call them directives) I want the
bookmarks to appear as the account name, but two different AccountRefs could
possibly have the same AccountName.  Should I put the directive in the
AccountRef comment or the AccountName comment and what exactly should the
directive be?  

I am thinking that the directive should be in the AccountRef field but that
should display AccountName as the bookmark.  Or am I barking up the wrong
tree?  I have tried this in the AccountRef field on the report #UR
OUTLINE=AccountName but that is not working.  The bookmarks pane is there
but there are no bookmarks displayed.  Perhaps I need more than the one
directive?

Any help/suggestions would be much appreciated.

Paul Newton

[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/008901d6b5b4$5c7cecc0$1576c640$@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: now it is cxi files

[Jürgen Wondzinski]

Hi Rafael,
CXI files are Virtual Volumes, which have been compressed with the COMPAXION 
library from XITECH.  Inside that CXI volumes the DBFs (or any other file) are 
stored in a compressed and crypted format. Unfortunately, XiTech seems out of 
business.

What you should do: Fire up VFP5, load the VFP5 specific COMPAXION 
cpaxvfp5.fll, and then use the CPAX_LIST("yourVolume.cxi", aFiles) function for 
an array of filenames in that volume, and then do a 
CPAX_EXTRACT("YourVolume.cxi", "Filename", "NewLocationPath") for every file to 
transfer the content to a "outside" location.

Another maybe easier way would be the use of the CPAX.EXE, a commandline tool: 
cpax.exe -l yourVolume.cxi   && for a list of files in that volume
Cpax.exe -e yourVolume.cxi yourFile newDestination

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Rafael Copquin
Gesendet: Montag, 26. Oktober 2020 21:37
An: ProFox Email List 
Betreff: Re: now it is cxi files

Hi Tracy
It is an FLL named cpaxvfp5.fll
When I try to run the code I get the message that COMPAXION is FoxPro version 
reliant.
BTW, the code used in the old app is

SET TALK OFF
SET LIBRARY TO CPAXVFP5.FLL
SET TALK ON


nRetVal=CPAX_Move('datos.cxi','bases.*')
SET TALK OFF
SET LIBRARY TO


___
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/005d01d6abe8$b21066b0$16313410$@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: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?

[Jürgen Wondzinski]

>> You never have to count the table rows itself 

But but... wouldn't this only be relevant if you just want the raw
RecordCount?  

As soon as you would do a COUNT FOR (or COUNT WHERE for you SQL guys) the
metadata or systemtables don't help you a dime.  And VFP's queryEngine is so
intelligent that it can optimze a COUNT FOR by asking the indices, as long
as the FOR condition is equal to an indexkey. 
BTW: since SQLServer got VFP's Rushmore logics, it should be the same there
too.


wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Stephen Russell
Gesendet: Montag, 26. Oktober 2020 02:01
An: ProFox Email List 
Betreff: Re: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*)
works with no issue. Why?

The example was to do a count(*) in VFP.  You don't have these system
tables.

SELECT SCHEMA_NAME(schema_id) AS [SchemaName], [Tables].name AS [TableName],
SUM([Partitions].[rows]) AS [TotalRowCount] FROM sys.tables AS [Tables] JOIN
sys.partitions AS [Partitions] ON [Tables].[object_id] =
[Partitions].[object_id] AND [Partitions].index_id IN ( 0, 1 )
-- WHERE [Tables].name = N'name of the table'
GROUP BY SCHEMA_NAME(schema_id), [Tables].name;

You never have to count the table rows itself.  I wasn't going to show this
thinking that it wasn't viable in VFP.

those lawyers who are too stupid to see the obvious.


___
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/057001d6ab6e$c1d803c0$45880b40$@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: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?

[Jürgen Wondzinski]

COUNT does indeed a Filelock, which has the effect that the result doesn't get 
changed in between the time it needs to traverse the table.

Thus if someone is just editing a record and altering your FOR field: what 
should COUNT (or CALC or SUM etc) take into account?  That's why it's waiting 
until he's finished. Of course, for a perfect waiting experience, you should 
SET REPROCESS correctly.

A SQL COUNT just takes a snapshot of the buffered data before the edit. 


wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Donnerstag, 22. Oktober 2020 21:24
An: ProFox Email List 
Betreff: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works 
with no issue. Why?

VFP9SP3

Why would a COUNT FOR hang ("Attempting to lock") whereas my easy workaround is 
SELECT COUNT(*) FROM SomeCursor WHERE  <>   ??

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/02df01d6a978$46c084c0$d4418e40$@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: phdbase

[Jürgen Wondzinski]

Hmm... If you deleted the CDX, then the call to the PHD() function in one of 
the indexkeys was deleted, thus you don't know how it was indexed anymore. 
Hopefully you still have a backup :)   

BTW: I just verified that the VFP5 libray is working without problems in VFP9.

The author of PHdBase, Jim Korenthal, seems to have died in 2011.  Send me a PM 
if you need the full helpfile.  Here's the Quickstart blurb:

+-+
¦phd: Quick Start ¦
+-+

If you're using Visual FoxPro or FoxPro for Windows, copy PHDBASE.BMP to the 
same directory where you've copied PHDBASE.MSG.

You may want to add one of these to CONFIG.FP and/or CONFIG.FPW:

phdbase language = English  (uses default, PHDBASE.MSG)
phdbase language = French   (uses PHDBASE.FRE file)
phdbase language = German   (uses PHDBASE.GER file)
phdbase language = Spanish  (uses PHDBASE.SPA file)
phdbase language = Italian  (uses PHDBASE.ITA file)

Now start FoxPro and type this in the command window:

set talk on
set library to phdbase.fll

Press enter to bring down PhDbase's signon screen.  Then type this in the 
command window:

use phdhelp && the helpfile for the product
=phd("index topic, details, numbers, keep all")

You've created a PhDbase full text index on PhDbase's own help file.  You only 
need to create this index once, since PhDbase automatically keeps your indexes 
up to date as the data changes.

The file PHDHELP.PHD contains the index you've just created.  There are only 
100 records in PHDHELP.DBF, but for larger files, PhDbase typically creates 
indexes of less than 1/10th the size of the original data!  And if you have a 
fairly fast computer you've already noticed that PhDbase can index millions of 
bytes of data per minute.

Let's try a few PhDbase searches.  Note that the number of "hits" may vary 
somewhat depending on your version of the PhDbase help file.

=phd("<>")
finds and displays 11 records

=phd("<>")
finds and displays 13 records

=phd("<>")<-- a "boolean search"
finds and displays  4 records

=phd("<>")   <-- a "proximity search"
finds and displays  2 records

=phd("<>")<-- a "fuzzy search"
finds and displays 13 records

No matter what speed computer you're using, you've noticed that all of these 
searches are virtually instantaneous!

If you wish, press F1 when any of these searches displays for information on 
using PhDbase's hypertext system.  You can also issue the command =phd("help") 
at any time to access PhDbase's built-in mini-help feature.

You can get rid of the help file's PhDbase index by typing:

=phd("unindex")

Okay, at this point you should have a feel for what PhDbase III is all about.  
Note that the PhDbase library must be loaded ("set library to phdbase") before 
you USE any file which has a PhDbase index.  If you forget to load the library, 
you'll get a message saying "PHD.PRG not found" when you try to USE your file.  
If you wish to keep a file but no longer use it with PhDbase, please read the 
section entitled "phd: Removing an Index."

Happy searching!

---


   


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Rafael Copquin
Gesendet: Dienstag, 13. Oktober 2020 20:52
An: ProFox Email List 
Betreff: Re: phdbase

Hi Woody
Thanks for the info. I did as you suggested, but also deleted the cdx and phd 
files and could open the dbf with no problem.
Thanks again
Best regards
Rafael



___
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/054e01d6a1fb$96972780$c3c57680$@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: phdbase

[Jürgen Wondzinski]

Hi Raphael,

PhdBase needs a Library, which you normally find as PHDBASE.FLL (on the
original disk it is saved as phdbase.v50).  Set this before opening your
files.
I'm not sure if there is a VFP9 compatible FLL, my archives only show a VFP5
compatible version.

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Rafael Copquin
Gesendet: Dienstag, 13. Oktober 2020 19:58
An: ProFox Email List 
Betreff: phdbase

Hi guys, it's been e long time!

I just inherited an old vfp5 program that needs to be updated to VFP9,
adding new routines to enhance performance and migrate the dbf's to sql
server.

I encountered some dbfs that have an additional file with a phd extension
which I believe is generated by a program that facilitates text searches in
memo files.

I try to open the dbf but vfp9 says that it can't find the phd file, even
though the dbf, its cdx and phd files are in the same folder.

I tried to set tablevalidate to 0, set exclusive on but to no avail

How can I open those dbf's?

TIA

Rafael Copquin


--- 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/044c01d6a18e$c4faff60$4ef0fe20$@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 Apps/DBFs with AMD Processor

[Jürgen Wondzinski]

>> I still notice commands in the help file I've never seen before :)

It couldn't harm to finally READ the revised helpfile from VFPX.org. 
After 15 years of stable existence, it shouldn't change anymore. 
Maybe it would be a good time to start discovering shocking new details of
VFP9?  :)

wOOdy 


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Alan Bourke
Gesendet: Montag, 21. September 2020 16:21
An: profoxt...@leafe.com
Betreff: Re: VFP Apps/DBFs with AMD Processor

> Today, I'm still trying to wring the most out of VFP9 and I often feel 
> like I'm still only scratching the surface.

I still notice commands in the help file I've never seen before :)

--
  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/06f001d6903a$85672280$90356780$@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 Apps/DBFs with AMD Processor

[Jürgen Wondzinski]

I'm not aware of any processor related problems with VFP9 and Win10. 
wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Philip Borkholder
Gesendet: Mittwoch, 16. September 2020 20:28
An: profox@leafe.com
Betreff: VFP Apps/DBFs with AMD Processor

Hello all,

Not much activity lately.
I searched the Archives for this issue but didn't find clarity.
In past years I always heard it's best to have Intel processors on
workstations when using VFP apps.

Have any of you had any problems using AMD processors and Windows 10 with
VFP apps?
Any version of AMD processor a better choice?

Thanks,
Philip Borkholder
Vicksburg, MI


[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/040101d68c6a$36467ee0$a2d37ca0$@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 application on client invoking class from EXE on server

[Jürgen Wondzinski]

Hi Mike,

you start the main exe on your local PC. It runs in the RAMspace of your local 
PC. It doesn't matter where you're going to fetch the sourcecode, modules or 
classes from.  VFP doesn't care if it was stored on a local disk C:, D: or a 
remote disk called \\server\SomeStuff\. All it knows: I'm running on this PC, 
therefor it will read your ini on your local PC.

It would be different if you'd run a DCOM component on that server via 
CreateObjectX(), because that instance would get started on the server, and you 
would get a remote objectreference.


wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Donnerstag, 10. September 2020 22:06
An: ProFox Email List 
Betreff: VFP application on client invoking class from EXE on server

VFP9SP2 Win10 clients, Win 2K12R2 Server

If MyClientApp.exe on the client creates an instance of a class from a VFP EXE 
on the Server, and that MyServer.Exe has code that reads configuration values 
from an INI file there on the server, I'm wondering if it will function 
properly.  I don't have the setup to quickly test that theory so I thought I'd 
ask here.

MyServer.exe is usually always run on the Server.  It uses a SETTINGS.INI file 
to determine where the data is located as well as other property values set at 
run time.

This client has a VFP app that runs on everybody's virtual space and I want to 
hook into an existing class from MyServer.exe but don't want to copy the code 
to the other app.

Ideas/comments/suggestions?

tia!
--Mike

[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/04bc01d687c2$3f577630$be066290$@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] State of .NET webinar

[Jürgen Wondzinski]

This would take place on Wednesday, 26.August 17:00 UTC ( 13:00 EST / 19:00 
Germany)  ??

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Stephen Russell
Gesendet: Montag, 17. August 2020 15:46
An: ProFox Email List 
Betreff: [NF] State of .NET webinar

Marcus used to be a FoxPro developer.

We've created a series of State of .NET online events each focusing on a 
specific .NET topic. This installment covers various ways of doing *web 
development with Microsoft technologies & platforms*.

Join Markus Egger (EPS Software President, Chief Software Architect and 
Microsoft Regional Director) as he continues our online series with his “State 
of Microsoft Web Development” presentation.

Topics covered in this event include:

   - ASP.NET 
Core
   - Razor Pages
   - Blazor (client-side and server-side)
   - Deployment to Windows and Linux Servers
   - Progressive Web Apps
   - Client-side frameworks (Vue.js, Angular, React)
   - Azure Static Pages

Attendees will come away with an understanding of which technologies to use for 
which scenario.

*Note*: Only registered attendees will receive the live stream URL via email 
the morning of the event.
Register here:
https://u14306485.ct.sendgrid.net/ls/click?upn=-2FlhZWJjobIdHG3rVYRj6ZHvtoiGCsxBe6GWqxUAIrhAGF6aPhrJCluVzNECGdOp6bZ4Q2i7aF9poTppvkfrkK6-2F4gYViqoSvTQgM-2BO54f-2BI-3DdLpH_6MNhH-2F9xC4B4dmryIkr-2BKfBAvtS41u-2BD3PfFZMqGl3tPwuFowY8IwZIYjfxUC7ZeNpUR-2F1R0iCDI6-2BbXVoyFkOSA07aQfj8-2FaY-2Br680FEjkHl-2BtB1MSSJ6SIFDPev4boLT4X-2BtyRSsqACQNQt1K1IX-2Be9v2qQrDyqmbU4soNSBA1fSmV3EYFyiSJRxzy85ZsJl4-2FsYRgO3TqBjglyCNKVwLhwleLppMdNyXGZh-2FHzBraETqazMfV416BJ0a76x4xZdL-2FozOieGL4kkzQUvSgBQ-3D-3D


___
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/010901d674d3$26c4ee10$744eca30$@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: ODBC for VFP Tables

[Jürgen Wondzinski]

You need to use the c:\Windows\sysWow64\OdbcAd32.exe for configuring 32Bit
drivers.

Also there are no 64bit drivers from Microsoft.
And you can use 32Bit Drivers only from 32Bit Apps. Thus: Never ever install
Office 64bit.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Desmond Lloyd
Gesendet: Montag, 10. August 2020 23:43
An: ProFox Email List 
Betreff: ODBC for VFP Tables

Need to add the FoxPro ODBC drivers on a server (2012R2) and they do not
show uip on the list.  Is there a way to add the 32 and 64 bit drivers for
VFP Tables?

TIA,
regards,
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/040b01d66fc0$45733370$d0599a50$@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: ODBC for VFP Tables

[Jürgen Wondzinski]

VFP's ODBC driver understands only DBF/DBC up to version 6. This means: All
those new fieldtypes, database events etc from Version 7,8,9 render the MS
ODBC driver useless, since he can't open such tables.

VFP7: Database Events
VFP8: AutoInc, 
VFP9: VarChar, VarBinary, Blob

The MS OLEDB driver is more modern, and understands all of that stuff.

There are also Thirdparty ODBC drivers available, which are fully equipped.
The "Advantage Database Server" (now from SAP) has a free ODBC driver.

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Eric Selje
Gesendet: Dienstag, 11. August 2020 03:53
An: ProFox Email List 
Betreff: Re: ODBC for VFP Tables

You can see my old blog post

for how to add ODBC drivers, but if you're looking to add ODBC drivers for
*VFP* tables, they stopped working after version 7 I believe.

Eric



___
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/039401d66f90$8df11890$a9d349b0$@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: Cannot build GoFish5

[Jürgen Wondzinski]

Maybe you've got a oversensible Virusscanner? SCT once was a threat.
Try to exclude all VFP filetypes 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Paul Newton
Gesendet: Montag, 3. August 2020 16:42
An: 'profox@leafe.com' 
Betreff: Cannot build GoFish5

Hi all

I have downloaded the source for GoFish5 but cannot rebuild the project or
app.  I am getting messages like "The memo file gofish_results.sct is
missing or is invalid".  Any ideas?

Paul Newton

[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/00a301d669c6$0176c3d0$04644b70$@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 Error 108: File is in use by another user.

[Jürgen Wondzinski]

Ouch. Some old memories :) Glad to be indirectly helping! 

wOOdy

-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Freitag, 31. Juli 2020 23:43
An: profox@leafe.com
Betreff: Re: VFP9SP2 Error 108: File is in use by another user.

Yeah I stopped using DBFs in 2004!  Took over Jeff Johnson's (RIP) client a 
few years back when he passed which is an all Fox backend.

I added the SET TABLEVALIDATE TO 0.  Will see if that helps.  I don't have any 
RLOCKs or FLOCKs on this table.  In this case, it's a simple logging table that 
only gets INSERT INTO commands to it. Never UPDATE or DELETE.

Thanks for the lead, Frank!!!


On 7/31/2020 4:11 PM, Frank Cazabon wrote:
> I haven't used dbfs in years and can't say I've ever got this error but this 
> might help:
>
> https://www.tek-tips.com/viewthread.cfm?qid=686993


___
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/007a01d66822$fa9a20b0$efce6210$@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] WIN 10 Won't Update App

[Jürgen Wondzinski]

Maybe the MS Store is blocked by some intelligent(?) SysAmin... 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Charles Hart Enzer, M.D.
Gesendet: Donnerstag, 9. Juli 2020 20:43
An: Profox 
Betreff: [NF] WIN 10 Won't Update App

When trying to update apps on PC, error:

"the feature you are trying to use is on a network resource that is unavailable"

OS

   - WIN 10 Pro
   - Version 1909
   - Latest Quality Update
   - 2020-06 Cumulative Update for Windows 10 Version 1909 for x64-based
   Systems (KB4560960)

Apps include

   - Chrome
   - Everynote
   - HanDBase
   - Calibre

-- 


___
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/00ae01d656a0$f0ffa450$d2feecf0$@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] Workstation Installation Incompatible after WIN10 Upgrade

[Jürgen Wondzinski]

There's an update to VMWare (Version 15.5) for this error.  I'm running 15.5.6 
without any problems. 



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Charles Hart Enzer, M.D.
Gesendet: Samstag, 4. Juli 2020 16:23
An: Profox 
Betreff: [NF] Workstation Installation Incompatible after WIN10 Upgrade

For versions of VMWare Workstations 12 thru 15, *Troubleshooter* Program 
reports "Incompatible Program"


Host is WIN 10 Pro 64 Bit Version 1909


C Drive is am SSD

Installing to F Drive


Error installing Workstation 15

*Setup cannot continue.  The Microsoft Runtime DLL installer failed to complete 
installation*

-- 


*Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), FAACAP* *Aliyah 
: Cincinnati to Jerusalem 
's German Colony 
 May 2017*



*Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical 
CenterWebSite: **EnzerMD.com *
*Publications* 

*Retirement is **not What You are Retiring from* *Retirement is about What You 
are Retiring to*


--- 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/006401d6521f$47eb6000$d7c22000$@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: Bizarre scenario solved by READWRITE clause on end of SELECT SQL

[Jürgen Wondzinski]

The INDEX on DELETED is absolutely ok, if you do it as a BINARY index. The 
BINARY index is basically the rushmore map. Each record is represented as one 
bit, thus the resulting indexmap is way smaller and faster than the traditional 
indexing map.


[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/012401d64ad0$070ffe70$152ffb50$@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: Greg Reichert / GLRsoftware.com

[Jürgen Wondzinski]

Sorry for that base64. Stupid mobile phone can't do pure text mails anymore,
it seems.

As for the zip files: Yea, the link is there, but WayBack doesn't archive
the files itself, only the 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/012201d64acf$448cc450$cda64cf0$@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.

Greg Reichert / GLRsoftware.com

[Jürgen Wondzinski]

Anybody knows what happened with Greg Reichert and his domain glrsoftware.com? 
He had some very nifty VFP code parts there. I'm looking for his SysObj class; 
because I have only a damaged zip from that ☹

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/031501d64a09$3f3dbca0$bdb935e0$@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: This code doesn't work on this guy's new HP machine (but works on his own machine) -- both Win10 -- maybe a firewall issue?

[Jürgen Wondzinski]

Here's another one without using any fancy IE or XML stuff. Just plain OS
functions...


CLEAR
? GetURLContent("http://www.atoutfox.org/ip.asp;, .T.)
? GetURLContent("http://ipecho.net/plain;)



FUNCTION GetURLContent

LPARAMETERS cURL, lBodyOnly

LOCAL cFile, cResult
cFile = REPLICATE(CHR(0), 260)
cResult = ""

DECLARE INTEGER URLDownloadToCacheFile IN urlmon;
INTEGER lpUnkcaller, STRING szURL, STRING @szFileName,;
INTEGER dwBufLength, INTEGER dwReserved, INTEGER pBSC

IF URLDownloadToCacheFile(0, cURL, @cFile, LEN(cFile), 0,0)  = 0
cFile = RTRIM(cFile)
cResult = FILETOSTR(cFile)
DELETE FILE (cFile)
ENDIF

IF lBodyOnly
cResult = STREXTRACT(cResult, "", "",1,1)
ENDIF

RETURN cResult


[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/000201d644e8$a986bf10$fc943d30$@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: This code doesn't work on this guy's new HP machine (but works on his own machine) -- both Win10 -- maybe a firewall issue?

[Jürgen Wondzinski]

Maybe test with this code:

CLEAR
? GetHTTPContent("http://www.atoutfox.org/ip.asp;, .T.)
? GetHTTPContent("http://ipecho.net/plain;)

***
FUNCTION GetHTTPContent
***
LPARAMETERS cURL, lBodyOnly

LOCAL oHTTP as Msxml2.ServerXMLHTTP, cErrorText, cHTML, lErrorState
STORE "" TO cErrorText, cHTML

TRY 
ohttp = CREATEOBJECT("Msxml2.ServerXMLHTTP")
CATCH 
cErrortext = "Cannot instanciate MSXML2"
lErrorstate = .t.
ohhtp = .NULL.
ENDTRY

IF VARTYPE(oHTTP) = "O" 
TRY
oHTTP.OPEN("GET",cUrl,.F.)
oHTTP.SEND()
CATCH
lErrorState = .T.
cErrortext = "Open/Send failed"
ENDTRY
ENDIF

IF NOT lErrorState
cHtml = oHTTP.responseBody

IF NOT INLIST(VARTYPE(cHTML),"Q","C") OR EMPTY(cHTML) 
lErrorState = .T.
cErrortext = "error on response"
ELSE
* convert unicode to utf
cHtml = STRCONV(cHTML,9)
ENDIF
ENDIF

IF lErrorState
cHTML = "Error: " + cErrorText
ELSE
IF lBodyOnly
cHTML = STREXTRACT(cHTML, "", "",1,1)
ENDIF
ENDIF

RETURN cHTML


___
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/028501d6448e$fb2ccb70$f1866250$@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: Memo bloat

[Jürgen Wondzinski]

Just to add a little tidbit information for "why is this FPT behaviour done
that way": 

In the early days of dBase / FoxBase, computers only has those 640kB of RAM,
from which only about 500 or so have been usable. And in FoxBase we had
whopping 64kB as reserved space for variables. Some of us might still
remember that time :)

With the invention of MultiUser programming we learned to GATHER/SCATTER our
tablefields to temporarily keep a copy in memory as well as revert data in
case of problems. The same approach is used internally by the dataengine: To
be able to revert interactive changes, the engine has to save a copy of the
fields.  That approach works well with standard C/N/D/L fields, but what to
do with Memofields, which even at those dark ages already had a maximum of
lunatic 2 GigaWatts, err GigaBytes?  You can't just copy 2 GBytes to a
MemVar (with 640k Memory!) Thus they decided to approach a different path
for editing Memos: Memofields get always edited at disklevel, in contrast to
Charfields, which get edited on a MemVar.  To get Multiuser working, they
always locked the original Memoblock(s), copied the content to the end of
the memofile and edited there. If the user reverts the edit, then they just
scrap the just appended junk and release the lock on the original
memoblock(s), but if the user saves the changes, then the new blocknumber is
recorded in the DBF field-pointer, and the old memoblocks are then no more
referenced, thus leaving them in the memofile as junk or useless filler.

Thus, with every edit a FPT will always grow for the size of the original
blocks (plus the blocks to fit additional edits), and it always grows in
multiples of the allocated blocksize. 

At VFP8 betatest times (as far as I remember) they tried to change that
behaviour of "always copy to a new block" to only occur if the table is used
sharable. In VFP9 this is not the case, a FPT also grows in exclusive mode.
The above revert-logic also debunks the "if the edit isn't changing the
original length, it will not grow" myth :) .

The block size is just a preallocated tablespace for your edit. It also pays
to analyze the best blocksize-setting for your data and do a SET BLOCKSIZE
TO x before creating a new FPT (you cannot change the blocksize of an
existing FPT). There's a gotcha here: Values from 1 to 32 are Multiples of
512 Bytes (which therefor results to blocksizes from 512 Bytes to 16384
Bytes), and from 33 to 32768 they are taken literally. (Default is 64
bytes).  A value of 0 results in "no preallocated blocksize", the block
grows as needed, but will therefor always get appended. Blocksize 0 is used
on all Metadata files (SCX, MPX, VCX, FRX etc)

Another gotcha: ? SET("BLOCK") just tells you the setting for newly created
MemoTables, you need to use SYS(2012) to get the blocksize of the currrent
table.

BTW 1: It also is not possible to do some sort of recycling those dead
junkspaces in a FPT, since you don't know beforehand how big the needed
space would be to store your new data and find a fitting dead space.  

BTW 2: Blocks are always used in consecutive sequence, there's no way to
connect several fragments spread over the FPT. Only the first blocknumber
gets stored in the DBF-to-FPT pointerfield.   
That's why we have the PACK MEMO command, which just copies the referenced
block-chains to a new file.





-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Christof Wollenhaupt
Gesendet: Dienstag, 26. Mai 2020 16:09
An: ProFox Mailinglist 
Betreff: Re: [SPAM] Memo bloat

Hi Alan,

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

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

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

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

-- 
Christof


___
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/02d801d63399$a067d320$e1377960$@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 

AW: Decompile FoxPro Windows 2.6?

[Jürgen Wondzinski]

Hi Ted,

Decompiling that EXE will give you a complete project with with all
PRG/SPR/MPR files (No scx/sct, because in 2.6 the SCX/SCT was generated to
SPR via GenScrn.prg). No mangled variable-names, they survive decompiling. 

That project you could recompile with VFP9 and it would run on Win10, the UI
could need some tweaking, but that would be just a little finetuning in
those SPRs. There are several utilities available to recreate the scx from
an spr, thus you could then transport them into VFP9 and enhance there.

If you need someone for decompiling, just holler. 


wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Ted Roche
Gesendet: Donnerstag, 23. April 2020 15:51
An: profox@leafe.com
Betreff: Re: Decompile FoxPro Windows 2.6?

Thanks for the offer. I'll look into this.

Of course, that would leave me with uncommented FPW code and garbled
variable names, better than nothing. Nailing down the algorithms and
documenting the data structures is the first step in planning a migration to
a runtime created in this century.

The organization would like a cloud-based web app they could run to keep
their inventory in sync, and also support off-line ops since they are often
beyond the reach of the internet (yes, there are still places like that.)
But that's beyond the scope of what I can do for them as a charitable
donation. I'll work with them to see if they might be able to find some
grant funding, or perhaps I can pick this up as a 20% project.

But first, a Band-Aid (tm) to get them to stop using Windows XP

It looks like there might be another work-around, enabling the 16-bit VDM on
32-bit windows 10.
https://www.groovypost.com/howto/enable-16-bit-application-support-windows-1
0/



On Thu, Apr 23, 2020 at 9:35 AM Tracy Pearson  wrote:

> Is that something ReFox can do? I have access to a working ReFox if 
> you like to try it.
>
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> Ted Roche
> Sent: Thursday, April 23, 2020 9:17 AM
> To: profoxt...@leafe.com
> Subject: Decompile FoxPro Windows 2.6?
>
> A charitable service organization have a custom FPW 2.6 EXE they use 
> for some calculations and inventory, and are desperate to get it 
> working on something more recent than Windows XP. So far, no source 
> code has turned up.
>
> What's out there that would let me decompile an FPW 2.6 EXE?
>
> I'm donating my time on this, so free would be nice, but I'll spend a 
> few $$$ if needed.
>
> Ideas?
>
> --
> 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: 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/00a501d6199f$437872f0$ca6958d0$@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: Office automation using VFP 10 64-bit version

[Jürgen Wondzinski]

Are you absolutely sure that you have Office 64bit installed? Since it's not
only me, but MS itself to state that it's technically impossible, I really
doubt it.  :)  If yes, you would be the first to made it magically happen.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Charlie Coleman
Gesendet: Samstag, 18. April 2020 18:36
An: ProFox Email List 
Cc: profoxt...@leafe.com
Betreff: Re: Office automation using VFP 10 64-bit version

Not to beat this to utter death and disfigurement...

I definitely used Automation from 32-bit VFP into 64-bit Outlook. So are we
saying that if I go to 64-bit VFP (the "VFP 10") that suddenly that same
code would not work?

-Charlie

[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/008401d615a8$673ba720$35b2f560$@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: Office automation using VFP 10 64-bit version

[Jürgen Wondzinski]

Yepp. No OLE-Automation from VFP x64 to any 32Bit product.  And no admin would 
install the Office x64 version, since it even states in the setup, that you 
should use that x64 only if you have really, really, really big XLSX files etc. 
Bigger than 2 Gb. And it also states that Com/OLE problems.

https://support.office.com/en-us/article/choose-between-the-64-bit-or-32-bit-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261

You can check the version of your installed office somewhere under File / 
Options 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Freitag, 17. April 2020 15:21
An: profox@leafe.com
Betreff: Office automation using VFP 10 64-bit version

(Renamed subject for this specific question for easier archive searching later 
in life...)

wOOdy -- Charlie had responded to your answer on my 64-bit thread.  What do you 
think?


On 4/16/2020 2:50 PM, Charlie Coleman wrote:
> Quick question. Are you all saying there is no Automation available to MS
> Office products in the 64-bit world?
>
> I recently wrote a quick VFP app to 'automate' Outlook (ref:
> createobject('outlook.application')) to generate and send a bunch of
> emails. The Outlook 365 was 64-bit (I think). Are you saying I would not
> have been able to do that if I would have used the 'VFP 10' runtimes, etc?
> I understand ActiveX/FLLs that were compiled 32-bit would be an issue - if
> they did not have a 64-bit version included.
>
> -Charlie
>
>
> On Thu, Apr 16, 2020 at 1:30 PM MB Software Solutions, LLC <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
>> Ah yes, the automation angle.  Temporarily forgot about that. Thanks,
>> wOOdy!
>>
>>
>> On 4/16/2020 1:24 PM, Jürgen Wondzinski wrote:
>>> You are correct, there is no reason to have a 64bit FoxPro application
>> for a regular Desktop app. It is different for building the middle-tier of
>> a distributed app or a Webserver extension. But on a regular desktop you
>> gain nothing, but inherit a lot of problems: No support for regular 32bit
>> ActiveX or FLL components. No COM-control of Office or other 32Bit stuff.
>>> Thus you better use the 32Bit version of VFPA, which is really highly
>> recommended, since it cures a lot of old bugs.
>>> wOOdy
>>>
>>>
>>>
>>> -Ursprüngliche Nachricht-
>>> Von: ProFox  Im Auftrag von MB Software
>> Solutions, LLC
>>> Gesendet: Donnerstag, 16. April 2020 17:28
>>> An: ProFox Email List 
>>> Betreff: 64-bit app via the Chen version
>>>
>>> I finally I downloaded the VFPA runtime files and am going to use that
>> IDE and develop/deploy with this "VFP 10" version since many here have
>> spoken of it without much negativity.
>>> Question:  what would be the benefit of using the 64-bit version IF I'M
>> NOT USING DBFS (because in my MBSS apps, I use MariaDB/MySQL as the
>> backend, not VFP).  I just don't see the benefit other than for marketing
>> my apps to say "they're 64-bit using the VC++ 10 runtimes."
>>> 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/022401d614e5$2fdbab40$8f9301c0$@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: 64-bit app via the Chen version

[Jürgen Wondzinski]

You are correct, there is no reason to have a 64bit FoxPro application for a 
regular Desktop app. It is different for building the middle-tier of a 
distributed app or a Webserver extension. But on a regular desktop you gain 
nothing, but inherit a lot of problems: No support for regular 32bit ActiveX or 
FLL components. No COM-control of Office or other 32Bit stuff.

Thus you better use the 32Bit version of VFPA, which is really highly 
recommended, since it cures a lot of old bugs.

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Donnerstag, 16. April 2020 17:28
An: ProFox Email List 
Betreff: 64-bit app via the Chen version

I finally I downloaded the VFPA runtime files and am going to use that IDE and 
develop/deploy with this "VFP 10" version since many here have spoken of it 
without much negativity.

Question:  what would be the benefit of using the 64-bit version IF I'M NOT 
USING DBFS (because in my MBSS apps, I use MariaDB/MySQL as the backend, not 
VFP).  I just don't see the benefit other than for marketing my apps to say 
"they're 64-bit using the VC++ 10 runtimes."

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/012d01d61413$d220fe00$7662fa00$@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: MSXML6 instead of MSXML4

[Jürgen Wondzinski]

In addition, you may read my "VFP9 installation instructions on modern
Windows" at https://woody-prolib.blogspot.com/ 

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Dr. Jörg Arand
Gesendet: Montag, 30. März 2020 20:02
An: profox@leafe.com
Betreff: MSXML6 instead of MSXML4

Hi,
I want to use the VFP9-XMLAdapter without installed MSXML4
Is it possible to redirect XML4 to XML6?

Regards
Dr. med. Jörg Arand
Pappelweg 1
72076 Tübingen
Tel. +49 170 5151971
Mail: Neodat(at)web.de

[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/01fc01d60aab$6ff411c0$4fdc3540$@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: MSXML6 instead of MSXML4

[Jürgen Wondzinski]

Hi Jörg,
Maybe you could use the _vfp.VFPXMLProgId Property to create a COM-Object
which references the MSXML6 stack.

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Dr. Jörg Arand
Gesendet: Montag, 30. März 2020 20:02
An: profox@leafe.com
Betreff: MSXML6 instead of MSXML4

Hi,
I want to use the VFP9-XMLAdapter without installed MSXML4
Is it possible to redirect XML4 to XML6?

Regards
Dr. med. Jörg Arand
Pappelweg 1
72076 Tübingen
Tel. +49 170 5151971
Mail: Neodat(at)web.de

[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/01fa01d60aab$18c1ae80$4a450b80$@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] X# Summit

[Jürgen Wondzinski]

I posted your anouncement in the German FoxPro Usergroup forum.  Maybe it will 
generate some interest :)

wOOdy


-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von Johan Nel
Gesendet: Donnerstag, 6. Februar 2020 14:39
An: profox@leafe.com; profoxt...@leafe.com
Betreff: [NF] X# Summit

Hi all,

October is going to be a busy month it seems.  The X# team plan a conference in 
Germany for those who cannot make it to SWFOX.

https://www.xsharp.info/articles/x-summit-2020

Johan Nel
George, South Africa.


[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/006a01d5dd26$e757bbc0$b6073340$@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: So, about this VFPA thing...

[Jürgen Wondzinski]

Hi Mike,

a) THE VFPA thingy modifies the DEVELOPMENT version, and that one has to be on 
SP2.  

b) The file you downloaded from github (VFP9SP2RT) is the RUNTIME installer, 
and of course does not touch your dev-system.

c) therefor you need the SP2 for VFP9 development, so that you at least get 
version 7423. This is done by downloading https://github.com/VFPX/VFP9SP2Hotfix3

d) I once wrote all about that stuff in my blog at 
http://woody-prolib.blogspot.com/ that's a step-by-step guide to install VFP9 
on modern boxes.

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox  Im Auftrag von MB Software Solutions, LLC
Gesendet: Montag, 27. Januar 2020 21:20
An: profox@leafe.com
Betreff: Re: So, about this VFPA thing...

So I got a new Win10 Pro laptop at the Corporate gig and installed VFP9 on it. 
It was NOT patched...so the version is Visual FoxPro
09.00..2412 for Windows.

I downloaded the VFPA 32 bit from (a) below and when I go to run it, it fails 
with this error: https://www.screencast.com/t/XVR3hDpLXOB

I'm guessing that's because I've not patched the default installation to 
9.0.0.7423?

Wanted to ask while I search for the VFP9SP2HotFix 3 installer. (I had tried 
one from wOOdy I thought but got a resource error earlier today...will try 
again now since I've uninstalled and reinstalled.)

tia,
--Mike


On 11/23/2019 6:39 AM, Jürgen Wondzinski wrote:
> Just to be clear: There are TWO versions of VFPA ("A" like the Hex 
> notation of "10")
>
> a) the patched version of your existing VFP9 installation. This 
> implies that it's stil a 23Bit version.
> This is the version you most probably want to use immediately.
> Download the 32Bit on the bottom of:
> http://baiyujia.com/vfpadvanced/f_vfpa_about.asp
> It needs a current VFP9 installation with SP2, and then creates a new 
> directory with a patched new VFP9.exe and also copies all of the other 
> files of your VFP9 source directory.  Thus, after installation you 
> just rename the old VFP9 directory to something different, and rename 
> the new directory to the original name, and all your Registrykeys and 
> Links will work without interruption.
>
> b) a new VFP10 err... VFPA compiler for 64 bit executables.
> Stil with some compatibility problems, and I'm not sure if I would 
> ever need it, but:
> http://baiyujia.com/vfpadvanced/f_vfpa_gotovfpa64.asp
>
>
>
> -Ursprüngliche Nachricht-
> Von: ProFox  Im Auftrag von Vince Teachout
> Gesendet: Samstag, 23. November 2019 04:43
> An: ProFox Email List 
> Betreff: So, about this VFPA thing...
>
> Apparently, I've been under a rock, and there's a magically enhanced
> VFP9 SP2 that fixes some bugs, can run concurrently with vfp9, and 
> supports
> 64 bits.
>
> Before I download something, am I on the right site:
> http://baiyujia.com/vfpadvanced/f_vfpa_about.asp ?
>
> Thanks!
>
>
>
>
>
[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/015301d5d5b6$7f22aa00$7d67fe00$@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: May the Open Source Be With You: INTL and SDT!

[Jürgen Wondzinski]

In that same area we should also mention:

The "Hacker’s Guide to Visual FoxPro"  is also now online and OpenSource
https://hackfox.github.io/


-Ursprüngliche Nachricht-



--- 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/017901d5cc74$6b4479a0$41cd6ce0$@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.