ProFox

profox@leafe.com

2704 discussions

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

Parsing a JSON object
by Paul Newton 12 Feb '19

12 Feb '19

Hi all I am investigating the use of Chilkat's tools for parsing JSON objects but I am having trouble developing a generic routine. For example, take the following: Local loJsonObject As 'Chilkat_9_5_0.JsonObject' Local lcStrJsonObject, lnNumPets lcStrJsonObject = '{"pets":[{"name":"jack","breed":"terrier"},{"name":"john","breed":"bulldog"},{"name":"joe","breed":"terrier"}]}' loJsonObject = CreateObject('Chilkat_9_5_0.JsonObject') loJsonObject.Load(lcStrJsonObject) i = 0 lnNumPets = loJsonObject.SizeOfArray("pets") DO WHILE i < lnNumPets loJsonObject.I = i ? STR(i) + ": " + loJsonObject.StringOf("pets[i].name") + "," + loJsonObject.StringOf("pets[i].breed") i = i + 1 ENDDO What I am trying to do is make the code generic such that I do not need to refer to "pets", "name" and "breed". Any help would be much appreciated. I have found a generic method for parsing JSON arrays but so far have been unable to do so for JSON objects Paul Newton

2 2

Pipe Delimited
by Chris Davis 08 Feb '19

08 Feb '19

Is it possible to export a cursor/table to Pipe Delimited with Headers without rolling my own? Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

Name your lnaguages.
by Stephen Russell 07 Feb '19

07 Feb '19

https://twitter.com/shanselman/status/1092319147118247936 -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox