ProFox February 2019

profox@leafe.com

39 participants
27 discussions

Re: false news....
by Gene Wirchenko 26 Feb '19

26 Feb '19

At 09:00 2019-02-25, Ted Roche <tedroche(a)gmail.com> wrote: >On Mon, Feb 25, 2019 at 11:38 AM Ed Leafe <ed(a)leafe.com> wrote: > > > They are presumably being used as PKs for tables representing humans, no? > > Then the vast majority of potential records would have null values, since > > most humans are not citizens of the USA. > >Ur either Muricans, or your not. ;) Maybe. I was a "US person" for the purposes of having a certificate of deposit. It meant US citizen or entitled to work in the USA. >But seriously, there are some non-citizens with SSNs, and citizens, >without. So, yeah, Matt's really sorry and promises not to do it again. Someone should make up a list "Lies Programmers Believe About Identifying Numbers". Sincerely, Gene Wirchenko

1 0

Trying to track down why an error is occurring
by Tracy Pearson 25 Feb '19

25 Feb '19

I recently pulled down Thor and am trying it out. On the two machines I have tried this on I get the same result. After opening the "Check for Updates" dialog, I can run updates or cancel them without a problem. Then I click on the background of _Screen. I get an error. I have SET COVERAGE TO c:\temp\testcoverage.csv I have written an errorcatcher.prg and set the ON ERROR do errorcatcher I have opened DEBUG and set Trace Between Calls If I type something in the Command window to throw an error, the error is caught. If I click on the white background, the error is not caught. Does anyone have another idea on how to capture this error? Microsoft Visual FoxPro OK Help Property 'cthordispatcher' value is too long. I've already posted the problem in the Thor Issue tracker. Doug Hennig was not able to reproduce it.

2 7

[OT] Nothing runs like the Fox
by Ed Leafe 25 Feb '19

25 Feb '19

Ok, this is a stretch, but this past Monday I had my left knee replaced. It's a long story [0], but I got a kick out of the fact that my surgeon's name was Fox! [1] So while I'm not running like a Fox yet, I'm progressing better than I could have hoped for, and should be running within a few months. [0] https://blog.leafe.com/out-with-the-old/ [1] https://www.drfoxortho.com/ -- Ed Leafe

7 8

Foxite?
by Dave Crozier 22 Feb '19

22 Feb '19

Is Foxite still up and running or has it been retired? Can’t seem to get access to a couple of articles I bookmarked some time ago. Dave Crozier Software Development Manager Flexipol Packaging Ltd. ﴾⚆ᨎ⚆﴿ 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 --- 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 ---

5 5

Cryptovirus hit one of my clients
by mbsoftwaresolutions＠mbsoftwaresolutions.com 22 Feb '19

22 Feb '19

Got a call from a client today who was having some sort of error with the program/website (WestWind WebConnection). I remoted in to see that EVERY file had been renamed to something like Filename.ext.decrypt12345(a)qq.com. Told them their IT vendor would have to restore from their last backup (which they said was just hours prior, thankfully). Ouch. Especially when you're website is used all over the nation and Canada. If they had been using MySQL/MariaDB/SQL-Server/PostgreSQL/etc instead of a file-server database, this wouldn't have been possible, right?

2 1

VFP application issues on new server
by Chris Davis 22 Feb '19

22 Feb '19

Hi All We have an app, which has lived on windows PC's and a windows server (on premisis) for years which has worked without issue. Nothing fancy going on! It has now been moved onto two virtual machines, both on the same host in the cloud. One machine is acting as the file server and one as a RDS box. All the users are connecting in using a remote desktop. The client side of the app is designed in such a way that locally on the client it uses dedicated files in %appdata%. The app works but the user are experiencing regular 2005 and 1104 error messages. Simply waiting a period of time (usually over a minute) whatever the issue is clears and the app continues. Any idea what it is about this environment that causes this issue? We have ruled out the anti virus solution used by having it uninstalled, but the problems persist. TIA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

9 14

Error building sort key (Error 2186)
by Paul Newton 22 Feb '19

22 Feb '19

Hi all According to the help: This error is generated when sort key truncation is about to occur, typically during GROUP BY, ORDER BY or other sorting operations. This can happen with use of a sort key that contains an expression, such as a Memo field, whose length is not fixed. The problem manifests itself when executing the following SQL (sorry about the length of the statement): Select Str(Nh_Year,4,0) + Str(Nh_Period,2,0)+ Transform(NH_YEAR) + Transform(NH_NACNT) + Transform(NH_PERIOD) As Key, ; Nh_Year, Nh_Period,Str(Nh_Year,4,0) + '/' + Str(Nh_Period,2,0) As YearPeriod,Nh_NType, Nh_NSubt, Nh_Nacnt, Nh_NCntr, ; Nh_Job, Nh_Project, Sum(Nh_PtdDr) As Nh_PtdDr, -1 * Sum(Nh_PtdCr) As Nh_PtdCr, Sum(Nh_Bal) As Nh_Bal,Sum(NH_BUDG) As Nh_Budg, ; 999999999999.99 As Variance, 999999999999.99 As YTDBal, 999999999999.99 As YTDBudg, 999999999999.99 As YTDVar ; >From NHist Where NH_YEAR >= 2019 And NH_YEAR <= 2019 And NH_PERIOD >= 1 And NH_PERIOD <= 3 And NH_YEAR = 2019 ; And NH_NACNT = 'A110 ' And NH_PERIOD = 1 And Nh_RecType = 1 ; Group By Key Union Select Str(Nh_Year,4,0) + Str(Nh_Period,2,0)+ Transform(NH_YEAR) + Transform(NH_NACNT) + Transform(NH_PERIOD) As Key, ; Nh_Year, Nh_Period,Str(Nh_Year,4,0) + '/' + Str(Nh_Period,2,0) As YearPeriod,; Nh_NType, Nh_NSubt, Nh_Nacnt, Nh_NCntr, Nh_Job, Nh_Project, Sum(Nh_PtdDr) As Nh_PtdDr, -1 * Sum(Nh_PtdCr) As Nh_PtdCr, ; Sum(Nh_Bal) As Nh_Bal,Sum(NH_BUDG) As Nh_Budg, 999999999999.99 As Variance, 999999999999.99 As YTDBal, ; 999999999999.99 As YTDBudg, 999999999999.99 As YTDVar From NHist Where NH_YEAR >= 2019 And NH_YEAR <= 2019 ; And NH_PERIOD >= 1 And NH_PERIOD <= 3 And NH_NACNT = 'A110 ' And Empty(NH_JOB) And Empty(NH_PROJECT) ; And Empty(NH_NCNTR) And Inlist(Nh_RecType,2,3) Group By Key InTo Cursor _5F50SKUYV Now I know this is a fairly complex query but it does not contain any columns whose length is not fixed. I wonder if anybody has come across this error before. I have had to resort to completely rewriting the code that generates the SQL statement. Many thanks Paul Newton

4 9

SFTP
by Chris Davis 20 Feb '19

20 Feb '19

Me again, sorry! I have been using vfpconnection for sometime now, very useful! However I have now got a ftp server that I wont connect to. The url I have been given starts SFTP, vfpconnection only seems to support FTPS. When I use FTPS I just send up with a SSL error when tracing it through. Should I be looking for another solution that maybe supports newer protocols or am I missing something? Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 10

Southwest Fox 2019: Call for Speakers
by Rick Schummer 19 Feb '19

19 Feb '19

We've issued the Call for Speakers for Southwest Fox 2019: http://www.swfox.net/CallForSpeakers.aspx. If you are interested in presenting, please read the document referenced in that page and consider submitting sessions via the Geek Gatherings Submission Web site. Southwest Fox 2019 is going to be held October 24-27, 2019 in Gilbert, Arizona. Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Automating Exchange Calendar (and Outlook, possibly)
by Ted Roche 13 Feb '19

13 Feb '19

Hypothetically, if you had a VFP application and wanted to start processing Shared group calendars in Exchange where the users have Outlook on their desktop, how would you go about doing that? Automate exchange with COM Add-ins or .NET code? Automate outlook? Run screaming into the woods? (My choice) Anyone have libraries or utilities to recommend? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 5

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox February 2019