ProFox December 2021

profox@leafe.com

19 participants
12 discussions

ProTip: Still using the Project Manager?
by Tracy Pearson 05 Jan '22

05 Jan '22

If you are still using the Project Manager and are on a High DPI screen. When you move the window around it is not a very pleasant experience. This code will put the window in an outer window that does not have the border issue. DEFINE WINDOW MyProjectWIndow ; FROM 0,0 ; TO WROWS("Project Manager"),WCOLS("Project Manager") ; CLOSE FLOAT GROW ZOOM MINIMIZE NOMDI ; TITLE "Project Manager" ; FONT WFONT(1,"Project Manager"), WFONT(2, "Project Manager") SHOW WINDOW MyProjectWindow ACTIVATE WINDOW "Project Manager" IN MyProjectWindow MOVE WINDOW "Project Manager" TO 0,0 And if you want the Project Manager to live outside the VFP window, and be available in the Windows Task Bar change the SHOW WINDOW command to this. SHOW WINDOW MyProjectWindow IN macdesktop If you do not need it in the Windows Task Bar, you could change the DEFINE WINDOW line to include this. IN DESKTOP The project manager needs to be open before you run this. You could add a this before it. MODIFY PROJECT 'TheAwesomeProject' NOWAIT Do you sometimes maximize windows you don't mean to? Change ZOOM to NOZOOM. Works in VFP 9 and VFP Advanced. OR You could use Doug Hennig's Project Explorer https://github.com/DougHennig/ProjectExplorer Happy Coding! Tracy

5 12

Anyone on here involved with Virtual Fox Fest?
by Chris Davis 01 Jan '22

01 Jan '22

Any idea if this link will be made available again? https://virtualfoxfest.com/2020/ Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

Windows 11 ads and unexpected restarts on Win 10 Pro
by MB Software Solutions, LLC 27 Dec '21

27 Dec '21

My Win10Pro dev machine decided to reboot overnight without any warning to me TWICE in the past week, and it had me quite pissed off. Thankfully my code was all saved (or at least 99% of it), but admittedly, I often leave my VFP window open and pick up where I left off the next day. As some of you may recall, I designed an app for managing my Beer League Hockey group (called the "Babs Hockey Fraternity" on Facebook--locations in two states now!), and initially, because it was so quick to get it up and going, I used a VFP DBC backend. I also use Mr. Chen's VFP 10 exclusively for that too. After a few crashes from VFP 10 corrupting the DBFs, I swapped out to the MariaDB backend instead. (I've been using MySQL/MariaDB since I saw Bob Lee's n-tier presentation at GLGDW back in 2003.) Anyhooo.....did anybody else get a similar behavior recently, with your computer asking you if you wanted the free upgrade to Win 11? -- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com

6 9

CABuilder
by Graham Brown 22 Dec '21

22 Dec '21

Hi all I use Paul's CABuilder tool under vfp8 to create Cursor Adapters. Just lately it has started failing under Windows 8. Database is SQL so I'm ticking the convert date/time to date option, selecting SQL and ODBC. It runs through all the tables then says I don't have something installed and asks for the setup. Doesn't say what it is missing and putting the original disc in tells me it can't find the setup files. Will trace the code to see if I can find any clues but has anyone seen this before? Regards Graham -- 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 ---

2 2

Just to set the mood for Christmas
by Dave Crozier 17 Dec '21

17 Dec '21

I know we have had some form of this poem submitted to Profox on many previous years (I think by Ted) so here is a version I found. Merry Xmas everyone The computers were whirring; they never do stop. The power was on and the temperature right, in hopes that the input would feed back that night. The system was ready, the program was coded, And memory drums had been carefully loaded; While adding a Christmassy glow to the scene, The lights on the console, flashed red, white and green. When out in the hall there arose such a clatter, The programmer ran to see what was the matter. Away to the halfway he flew like a flash, Forgetting his key in his curious dash. He stood in the halfway and looked all about, When the door slammed behind him, and he was locked out. Then, in the computer room what should appear, But a miniature sleigh and eight tiny reindeer; And a little old man, who with scarcely a pause, Chuckled: "My name is Santa...the last name is Claus." The computer was startled, confused by the name, Then it buzzed as it heard the old fellow exclaim: "This is Dasher and Dancer and Prancer and Vixen, And Comet and Cupid and Donner and Blitzen." With all these odd names, it was puzzled anew; it hummed and it clanked, and a main circuit blew. It searched in its memory core, trying to "think"; Then the multi-line printer went out on the blink. Unable to do its electronic job, It said in a voice that was almost a sob: "Your eyes ~ how they twinkle ~ your dimples so merry, Your cheeks so like roses, your nose like a cherry, Your smile ~ all these things, I've been programmed to know, And a data-recall, I am more than so-so; But your name and your address (computers can't lie), Are things that I just cannot identify. You've a jolly old face and a little round belly, that shakes when you laugh like a bowlful of jelly; My scanners can see you, but still I insist, Since you're not in my program, you cannot exist!" Old Santa just chuckled a merry "ho,ho," And sat down to type out a quick word or so. The keyboard clack-clattered, its sound sharp and clean, As Santa fed this "data" to the machine: "Kids everywhere know me; I come every year; The presents I bring add to everyone's cheer; But you won't get anything ~ that's plain to see; Too bad your programmers forgot about me." "Merry Christmas to All," as he pulled out its plug! ~Author Unknown~ Dave Crozier Software Development Manager Flexipol Packaging Ltd. Mob: 07967 671080 ﴾⚆ᨎ⚆﴿ Flexipol® Packaging Ltd T 01706 222 792 E DCrozier(a)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 ---

3 2

T'was the Night Before Crisis [NF]
by Ted Roche 17 Dec '21

17 Dec '21

'Twas the night before crisis, and all through the house, Not a program was working, not even a browse. The programmers were wrung out, too mindless to care, Knowing chances of shipping hadn't a prayer. The users were nestled all snug in their beds, While visions of inquiries danced in their heads. When out in the lobby there arose such a clatter, That I sprang from my cube to see what was the matter. And what to my wondering eyes should appear, But a SUPER PROGRAMMER, oblivious to fear. More rapid than eagles, his programs they came, And he whistled and shouted and called them by name: On Update! On Add! On Inquiry! On Delete! On Batch Jobs! On Closing! On Functions Complete! His eyes were glazed over, his fingers were lean, >From weekends and nights in front of the screen. A wink of his eye, and a twist of his head, Soon gave me to know I had nothing to dread. He spoke not a word, but went straight to his work, Turning specs into code, then he turned with a jerk. And laying his finger on the ENTER key, The system came up, and worked perfectly. The updates, updated; the deletes, they deleted; The inquiries, inquired; and the closing completed. He tested each whistle, he tested each bell, With nary an abend, and all had gone well. The system was finished, the tests were concluded, The client's last changes were even included! And the client exclaimed with a snarl and a taunt, "It's just what I asked for, but NOT what I want" (attributed variously, my copy came from here[1]) [1] http://www.mdarwin.ca/humour/night-before-xmas/night-before-crisis.phtml https://web.archive.org/web/20070923102738/http://www.mdarwin.ca/humour/nig… Merry Christmas, happy Qwanza, merry Solstice, happy Saturnalia and so forth to all!

2 1

Fwd: VFP9 SP2 run a batch file
by Ken McGinnis 17 Dec '21

17 Dec '21

sry, that should have gone to the list. Here it is -------- Forwarded Message -------- Subject: Re: VFP9 SP2 run a batch file Date: Thu, 16 Dec 2021 20:29:35 -0500 From: Ken McGinnis <kamcginnis(a)gmail.com> To: Ted Roche <tedroche(a)gmail.com> Ted, Thank you for that. I needed a place to start looking. I have not yet changed to win11. I had so much trouble with win10 that I decided to wait until I hear that the thing is working. I think I'll look for a workaround for now. First step is to get more specific information. Ken On 12/16/2021 6:56 PM, Ted Roche wrote: > On Thu, Dec 16, 2021 at 5:08 PM Richard Kaye <rkaye(a)invaluable.com> wrote: >> Kinda tough for folks here to do anything other than offer sympathy >> without the fine details. 😊 >> > Well, sure. But if anyone's got Win11 and a similar app, you might > luck out and get something like "command.com is no longer on the path > and you need to add it to AUTOEXEC.NT" or something. > > A quick internet search on "Windows 11 shell to CMD" type searches > seems to indicate there's some kind of new terminal app that can run > CMD and PowerShell. So, that might have something to do with it. > [excessive quoting removed by server]

1 0

RE: VFP9 SP2 run a batch file
by Richard Kaye 16 Dec '21

16 Dec '21

Kinda tough for folks here to do anything other than offer sympathy without the fine details. 😊 -- rk From: ProfoxTech <profoxtech-bounces(a)leafe.com<mailto:profoxtech-bounces@leafe.com>> On Behalf Of Ken McGinnis Sent: Thursday, December 16, 2021 4:56 PM To: profoxtech(a)leafe.com<mailto:profoxtech@leafe.com> Subject: VFP9 SP2 run a batch file Good question. My support team just said it won't work. Same set up in Windows 10 works fine. I will try to get more information. Ken

2 1

looking for a multi-user alternative to view gmail emails
by Ken McGinnis 16 Dec '21

16 Dec '21

looking for a multi-user alternative (to MS Exchange) to view gmail emails For more than 10 years I have been using a gmail account for users to send support questions. I had that gmail account linked (somehow) to MS Exchange hosted by Rackspace. This was recommended by someone on this list. It has been working for >10 years and I have long-since forgotten how I set all that stuff up. Now Rackspace no longer supports Exchange 2007 and the Outlook 2007 client that we use to access exchange and see the emails that came into gmail. Hope that makes sense. I think it should be simple to have imap and/or POP in the gmail account activated (which it/they is/areprofox(a)leafe.com) It seems like Exchange should be able to 'poll' the gmail server and download the email (hope that makes sense). Somehow the people at Rackspace don't know what I am talking about?? the support person today says I need to set up MX records in gmail so gmail will send to exchange? that does not make any sense to me. I admit that I may not be the youngest person on this list, but I am still alive and I love VFP and most of the support issues. Anyone out there know what I am missing? Thx in advance Ken -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

7 12

sftp for vfp6?
by Jeff Roberts 10 Dec '21

10 Dec '21

Could anyone recommend a class or control I can use to add the ability to send a file using sftp without too much complication to a VFP6 app? The ocx we've using forever only does FTP. I looked at the old version of West Wind Client Tools that works with VFP 6 but it looks like it only does FTP as well. -- Jeff Roberts | jefflroberts(a)gmail.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 7

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox December 2021