ProFox December 2019

profox@leafe.com

40 participants
18 discussions

{NF] WIN 10 and LibreOffice
by Charles Hart Enzer, M.D. 10 Dec '19

10 Dec '19

Which version of LibreOffice works with WIN 10? Program Compatibility Troubleshooter says each version is incompatible and not fixed: [image: image.png] *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May, 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Tiny Country, Huge Dreams* *ארץ זעירה, **חלומות ענקיים* *עם ישראל חי* --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/png ---

6 10

Intl and Report Labels
by Frank Cazabon 05 Dec '19

05 Dec '19

Hi, has anyone here used Steven Black's Intl code for translating their applications? I have written some code which will open all my FRX files and convert each label to a text field with the expression of the label being called in i(). So if i had a label with the text as "Client" I would end up with a text box with the expression as: i("Client"). This works but ends up with me then having to modify each report to slightly adjust the text box's positioning to get it to line up with surrounding objects properly. Is this the best way to do this or is there another recommended way? Maybe some hook in the reportlistener to automatically call i() on the label itself? -- Frank. Frank Cazabon

1 0

Programatically saving the Outlook signature when using automation code
by MB Software Solutions, LLC 05 Dec '19

05 Dec '19

Problem: need to preserve Customer's email signature in Outlook automation code. Tech: VFP9SP2 app using the latest Outlook client. This is an update to the 8/21/2019 thread I started about using Outlook to create an email with file attachments. Got that code working (see below) but now need to find a way to preserve the customer's Outlook email signature. As the code is below, it creates a blank email and does NOT use their signature. I'm going to research this with fresh eyes tomorrow but wanted to throw this out in case others could chime in. * start outlook LOCAL oOutlook as Outlook.Application, oNamespace as Outlook.NameSpace, oMailItem as Outlook.MailItem, lcFilename as String, lcRange as String, llOK as Logical, lcDir as String LOCAL oRecipient as Outlook.Recipient oOutlook = CREATEOBJECT("Outlook.Application") #DEFINE olFolderDisplayNormal 0 #DEFINE olMailItem 0 #DEFINE olCC 2 #DEFINE olBCC 3 #DEFINE olOriginator 0 #DEFINE olTo 1 oNameSpace = oOutlook.GetNameSpace("MAPI") oExplorer = oOutlook.Explorers.Add(oNameSpace.Folders[1],olFolderDisplayNormal) oMailItem = oOutlook.CreateItem(olMailItem) WITH oMailItem .Subject = ALLTRIM(this.txtSubject.Value) .Body = ALLTRIM(this.edtBody.Value) *** mjb 10/21/2019 - added defensive coding for L vs. N and empty too IF ((VARTYPE(this.chkEmail.Value)="L" AND this.chkEmail.Value) OR (VARTYPE(this.chkEmail.Value)="N" AND this.chkEmail.Value = 1)) AND NOT EMPTY(this.txtEmail.Value) THEN .Recipients.Add(ALLTRIM(this.txtEmail.Value)) ENDIF *** mjb 10/21/2019 - added CC IF ((VARTYPE(this.chkSRep.Value)="L" AND this.chkSRep.Value) OR (VARTYPE(this.chkSRep.Value)="N" AND this.chkSRep.Value = 1)) AND NOT EMPTY(this.txtSalesRepEmail.Value) THEN oRecipient = .Recipients.Add(ALLTRIM(this.txtSalesRepEmail.Value)) oRecipient.Type = olCC ENDIF * first add the built PDF from MergeDocuments above IF liCnt > 0 THEN .Attachments.Add(lcFile) ENDIF && liCnt > 0 * any non-PDFs to attach? SELECT curEmailThese SCAN FOR UPPER(JUSTEXT(cfilename)) <> "PDF" .Attachments.Add(ADDBS(ALLTRIM(curEmailThese.cpath))+ALLTRIM(curEmailThese.cfilename)) ENDSCAN .Display() && Save() *.Send() ENDWITH

3 4

[NF] World class enterprise system in X#
by Johan Nel 04 Dec '19

04 Dec '19

Azyra Systems report that their large scale Enterprise System used by 100+ logistics businesses in 12 countries is now built with X# as the principal language and Microsoft Sql Server as the database. Jimmy Cahill, Joint CEO of Azyra, told us /“We are delighted with the unrivalled coding efficiency, compilation speed and runtime performance. X# not only allowed us to modernise our tried and tested code and business logic but put us at the forefront of everything IT.” / /“We freely mix X# and C# giving our development team access to everything they need to race ahead of our competition. For example, we’ve moved the GUI to WPF and our designers are busy adding charts and dashboards everywhere for visual appeal and to give our //clients immediate insights to their business.”/ /“The X# Team have done a magnificent professional job of building on and completing the work done by generations of the xBase community. They have set the scene for the xBase syntax to be recognised as a much more efficient and elegant language than C# - and by far the best language for teaching object orientated development.”/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

World class enterprise system in X#
by Johan Nel 04 Dec '19

04 Dec '19

1 0

Calling code in parent's parent class
by Paul Newton 03 Dec '19

03 Dec '19

Hi all Let's say that I have the following situation: GreatGrandParent -> GrandParent -> Parent -> Class In Class I want to bypass the code in Parent but call the code in either GrandParent OR GreatGrandParent. Is this possible and, if so, how? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

SQL Dump
by Chris Davis 01 Dec '19

01 Dec '19

Hi All Is there any tricks I am missing which would speed up a dump of a VFP table into a SQL table. I have predifined by SQL statement something like this "insert into mytable (myfield) values (?m.myfield)" I am then scanning through the VFP table performing a scatter memvar and then executing the SQL. It works it just seems to take alot longer than I imagined it would. Thanks IA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 14

ProFox List Statistics for November 2019
by List Administrator Account 01 Dec '19

01 Dec '19

================================================== ProFox List Statistics November 2019 ================================================== Subscriber Count at End of Month: ProFox: 292 ProFoxTech: 181 ================================================== Total Posts: 196 (Up 18.79% from October 2019) Total [OT] Posts: 0 (Unchanged from October 2019) Total [NF] Posts: 4 (Down 86.21% from October 2019) Daily Message Counts for November 2019 ------------------------------------------------ DOW Date Count --- ---- ----- F 1 - 4 S 2 - 2 M 4 - 3 T 5 - 1 W 6 - 11 T 7 - 15 F 8 - 1 T 12 - 3 W 13 - 2 T 14 - 8 F 15 - 7 M 18 - 1 T 19 - 2 W 20 - 18 T 21 - 25 F 22 - 26 S 23 - 5 S 24 - 2 M 25 - 17 T 26 - 18 W 27 - 5 T 28 - 6 F 29 - 10 S 30 - 4 Message Counts By Day of Week for November 2019 ------------------------------------------------ DOW Count --- ----- Sun - 2 Mon - 21 Tue - 24 Wed - 36 Thu - 54 Fri - 48 Sat - 11 Distinct Posters to the List (changes relative to October 2019) ------------------------------------------------ Non-OT messages: 35 (Down 10.26%) OT messages: 0 (Unchanged) NF messages: 4 (Down 71.43%) Total number: 35 (Down 10.26%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 38 MB Software Solutions, LLC 2. 21 Alan Bourke 3. 13 Eric Selje 4. 11 Koen Piller 5. 11 Frank Cazabon 6. 10 Gene Wirchenko 7. 9 Stephen Russell 8. 9 Tracy Pearson 9. 8 Paul Newton 10. 7 Jürgen Wondzinski 11. 5 Chris Davis 12. 5 AndyHC 13. 4 Charlie Coleman 14. 4 Richard Kaye 15. 4 Vince Teachout 16. 4 Ed Leafe 17. 4 Paul H. Tarver 18. 3 Kurt at VR-FX 19. 2 Jean Laeremans 20. 2 Darren Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 4 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 MB Software Solutions, LLC 2. 1 <juergen(a)wondzinski.de> 3. 1 M Jarvis 4. 1 krdibble(a)stny.rr.com Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 38 MB Software Solutions, LLC 2. 21 Alan Bourke 3. 13 Eric Selje 4. 11 Koen Piller 5. 11 Frank Cazabon 6. 10 Gene Wirchenko 7. 9 Stephen Russell 8. 9 Tracy Pearson 9. 8 Paul Newton 10. 7 Jürgen Wondzinski 11. 5 Chris Davis 12. 5 AndyHC 13. 4 Charlie Coleman 14. 4 Richard Kaye 15. 4 Vince Teachout 16. 4 Ed Leafe 17. 4 Paul H. Tarver 18. 3 Kurt at VR-FX 19. 2 Jean Laeremans 20. 2 Darren Top 15 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Jürgen Wondzinski 2. 4 MB Software Solutions, LLC 3. 2 Johan Nel 4. 2 Paul Newton 5. 2 Stephen Russell 6. 2 Chris Davis 7. 1 List Administrator Account 8. 1 Vince Teachout 9. 1 Matt Slay 10. 1 <juergen(a)wondzinski.de> 11. 1 Frank Cazabon 12. 1 Jean Laeremans 13. 1 M Jarvis 14. 1 krdibble(a)stny.rr.com 15. 1 Tracy Pearson Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 24 So, about this VFPA thing... 2. 18 File Sync 3. 18 Fatal error issuing CALCULATE command 4. 17 X# code for drag and drop 5. 16 VFP Advanced (was Fwd: Fatal error issuing CALCULATE command) 6. 16 Exporting Tables 7. 14 SQL Dump 8. 12 Gartner Analyst Relations 9. 11 We''re getting old ;) 10. 8 AW: So, about this VFPA thing... 11. 8 The JVP line still exists after all these years 12. 5 Windows 10 X to support Win32 apps 13. 5 Using XML String as part of query in SQL Server 14. 4 How common is Table Buffering with DBFs?? 15. 3 VFP TSQL concordance 16. 3 AW: How common is Table Buffering with DBFs?? 17. 2 SWFOX - X# training session now availabe on YouTube 18. 2 joke 19. 2 Fwd: Gartner Analyst Relations 20. 2 Treeview of choice for VFP app? Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 24 So, about this VFPA thing... 2. 18 File Sync 3. 18 Fatal error issuing CALCULATE command 4. 17 X# code for drag and drop 5. 16 VFP Advanced (was Fwd: Fatal error issuing CALCULATE command) 6. 16 Exporting Tables 7. 14 SQL Dump 8. 12 Gartner Analyst Relations 9. 11 We''re getting old ;) 10. 8 AW: So, about this VFPA thing... 11. 8 The JVP line still exists after all these years 12. 5 Windows 10 X to support Win32 apps 13. 5 Using XML String as part of query in SQL Server 14. 4 How common is Table Buffering with DBFs?? 15. 3 VFP TSQL concordance 16. 3 AW: How common is Table Buffering with DBFs?? 17. 2 SWFOX - X# training session now availabe on YouTube 18. 2 joke 19. 2 Fwd: Gartner Analyst Relations 20. 2 Treeview of choice for VFP app?

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox December 2019