ProFox November 2023

profox@leafe.com

9 participants
4 discussions

Chilkat version 1.3 release
by Bill Anderson 08 Dec '23

08 Dec '23

Folks, Version 96 compatibility completed. Version 96 is a pretty big release, including the new DNS class. Located some methods and properties missing from the Chilkat release notes and added them. Found one more class missing a Version property. As ever, documentation fixes and additions, minor code fixes. Let me know what you think... https://github.com/billand88/ChilkatVFP Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

ZPL
by Chris Davis 15 Nov '23

15 Nov '23

Hi All Would anyone have any suggestions of how best to approach sending ZPL commands to a compatible printer? If the printer is on the network I can get this to work using ChilKat such as https://www.example-code.com/foxpro/socket_connect.asp But I have also found that you can get ZPL to a printer that is connected via USB or network using the Generic / Text Only Driver ... this works with a simple example from https://labelary.com/viewer.html but if the commands become more extensive (maybe because an image has been included) then this method goes wrong I think because the driver is doing something relating to page size? But not sure. If possible I would like a native VFP method of connecting to either a USB or Network connected ZPL printer and be able to send whatever I like ... thoughts? TIA Chris Davis --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 10

WG: Base64 and Excel automation
by Dr. Joerg Arand 07 Nov '23

07 Nov '23

Hi All, I have 2 questions: 1. Base64 I want to insert base64 encrypted data (PDF/DOCX) into a HL7 message. My first idea was to use STRconvert. But during the first test I noticed the following problem. The text Polyfon zwitschernd aßen Mäxchens Vögel Rüben, Joghurt und Quark should be in Base64. UG9seWZvbiB6d2l0c2NoZXJuZCBhw59lbiBNw6R4Y2hlbnMgVsO2Z2VsIFLDvGJlbiwgSm9naHVydCB1bmQgUXVhcms= But Foxpro ( strconv(lcText,13) ) returns UG9seWZvbiB6d2l0c2NoZXJuZCBh32VuIE3keGNoZW5zIFb2Z2VsIFL8YmVuLCBKb2dodXJ0IHVuZCBRdWFyaw== The problem seems to be in the letter "ß". Without ß the encoding works. I know I could also use e.g. Chilcat, but I would prefer to use internal Foxpro functions. Does anyone have an idea? 1. Excel Automation I want to insert data into a formatted Excel sheet . At the moment I write the data into the cells using OLE ....Cells(xy).value= xyz This works but is very slow. Is there a way to insert data from Foxpro e.g. into a Range object and save time? Thanks, Dr. Jörg Arand --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

ProFox List Statistics for October 2023
by List Administrator Account 01 Nov '23

01 Nov '23

================================================== ProFox List Statistics October 2023 ================================================== Subscriber Count at End of Month: ProFox: 305 ProFoxTech: 184 ================================================== Total Posts: 37 (Up 164.29% from September 2023) Total [OT] Posts: 0 (Unchanged from September 2023) Total [NF] Posts: 0 (Unchanged from September 2023) Daily Message Counts for October 2023 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 T 3 - 4 W 4 - 2 T 5 - 7 F 6 - 6 S 8 - 1 F 13 - 1 T 24 - 2 S 29 - 1 M 30 - 12 Message Counts By Day of Week for October 2023 ------------------------------------------------ DOW Count --- ----- Sun - 3 Mon - 12 Tue - 6 Wed - 2 Thu - 7 Fri - 7 Distinct Posters to the List (changes relative to September 2023) ------------------------------------------------ Non-OT messages: 13 (Up 18.18%) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 13 (Up 18.18%) Top 14 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 8 Virgil Bierschwale 2. 6 Kurt Wendt 3. 5 Graham Brown 4. 4 Eric Selje 5. 3 Joe Yoder 6. 2 Frank Cazabon 7. 2 Paul H. Tarver 8. 1 List Administrator Account 9. 1 Bill Anderson 10. 1 Eric Selje 11. 1 Ted Roche 12. 1 Tracy Pearson 13. 1 <juergen(a)wondzinski.de> 14. 1 Alan Bourke Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 14 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 8 Virgil Bierschwale 2. 6 Kurt Wendt 3. 5 Graham Brown 4. 4 Eric Selje 5. 3 Joe Yoder 6. 2 Frank Cazabon 7. 2 Paul H. Tarver 8. 1 List Administrator Account 9. 1 Bill Anderson 10. 1 Eric Selje 11. 1 Ted Roche 12. 1 Tracy Pearson 13. 1 <juergen(a)wondzinski.de> 14. 1 Alan Bourke Top 6 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 Joe Yoder 2. 2 Graham Brown 3. 1 List Administrator Account 4. 1 Eric Selje 5. 1 Kurt Wendt 6. 1 Bill Anderson Top 9 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 10 FW: SQL Upsize 2. 8 Unemployed Destitute FoxPro Guy 3. 4 ProFox List Statistics for September 2023 4. 4 Programatically placing text boxes on a form - continued 5. 4 Log4VFP or Log4Fox 6. 3 Programatically placing text boxes on a form 7. 2 Classlib setting in VFP 8. 1 ChilkatVFP 1.24 released 9. 1 SQL Upsize Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 9 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 10 FW: SQL Upsize 2. 8 Unemployed Destitute FoxPro Guy 3. 4 ProFox List Statistics for September 2023 4. 4 Programatically placing text boxes on a form - continued 5. 4 Log4VFP or Log4Fox 6. 3 Programatically placing text boxes on a form 7. 2 Classlib setting in VFP 8. 1 ChilkatVFP 1.24 released 9. 1 SQL Upsize

3 2

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox November 2023