ProFox November 2017

profox@leafe.com

45 participants
61 discussions

[ADMIN] Fixing the held message issue
by Ed Leafe 29 Nov '17

29 Nov '17

I *think* I’ve fixed the issue where messages sent to ProFox from ProFoxTech subscribers were being held. Apologies to anyone who tried to post emails this afternoon while I was working on it; please resend them. -- Ed Leafe

1 0

[ADMIN] Fixing the held message issue
by Ed Leafe 29 Nov '17

29 Nov '17

1 0

[NF] C# Apps Deployment
by Dave Crozier 29 Nov '17

29 Nov '17

People far and wide! In VFP we are all used to writing the app, generating an .exe and placing it on a server for everyone to use in a network environment, no problem. Being somewhat of a philistine, up until my machine when "Pete Tongue" last week I have always used Visual Studio 2008 for my C# development but decided to "upgrade" my development environment to Visual Studio 2012 as it has a lot more features. So far so good apart from when you come to deploy your package as 2012 doesn't have an inbuilt deployment packager but a free paired down version of Installshield is available or you can use the VS2012 On Click deployment facility which I have never used before. The Installshield approach wants to install the app on your local machine so I feel that this is a no go solution as I want one .exe to update on a remote server. As for the One Click solution I can't make head not tail of it and it is also geared towards .ASP web apps and not Desktop apps. Anyone got any ideas, or will I have to resort to the good old or newer (in my case) Inno Setup. Hints and pointers appreciated. The biggest problem with this app is that there are a set of third party .dll's that have to be installed and registered on the local machine as simply placing them in the executable folder on the server doesn't work ... as it would do with VFP. Thanks in anticipation. Dave --------------------------------------------------------------- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --------------------------------------------------------------- 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

5 4

[NF] Experience with Firebird (nee' Interbase), recommended tools?
by Ted Roche 28 Nov '17

28 Nov '17

Anyone here have experience with Firebird, formerly the Borland Database Engine, later Interbase? (The engine's had a pretty complete rewrite since 2000, so recent experience is more helpful) I've been called on for a consult for a client using Firebird as a backend for a 3rd-party extension to Quickbooks and would appreciate: 1. Recommendations for tools to work with it, 2. Cautions for things to look out for (e.g., "Transactions are not what you think they are") 3. General comments and TGIF snarkiness. References: https://en.wikipedia.org/wiki/Firebird_(database_server) http://www.firebirdsql.org/ https://github.com/FirebirdSQL/firebird Happy weekend, Ted -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

3 5

[ADMIN] Fat fingers
by Ed Leafe 28 Nov '17

28 Nov '17

Ugh - never make a change when you are focused on something else. I did just that, and created a syntax error in one of the scripts that determines if the poster is a subscriber. So anything sent to the list in the last 8 hours or so disappeared into the bit bucket. Please re-send. -- Ed Leafe

1 0

[ADMIN] Posts missing
by Gianni Turri 28 Nov '17

28 Nov '17

Hi Ed, today my posts didn't get through. What's wrong with my posts? I have sent two, in reply to "Extra spaces in CSV file generated from VFP9SP2 when using Varchar fields". Anyway, please release only the latter. Gianni

1 0

Extra spaces in CSV file generated from VFP9SP2 when using Varchar fields
by mbsoftwaresolutions＠mbsoftwaresolutions.com 28 Nov '17

28 Nov '17

Just an interesting find I wanted to share. When I create my cursor with traditional c(N) widths, the CSV export does NOT have any extra spaces added to the output. pseudoid,zip3,prov03,prov03other,prov06,prov07,prov07other,prov08 "Pseudo1","333","C001","","10","C021","","C025" "Pseudo2","333","C001","","20","C021","","C026" "Pseudo3","333","C001","","30","C021","","C019" But when I use varchar v(N) field declarations, it appends spaces to the end of the field values: pseudoid,zip3,prov03,prov03other,prov06,prov07,prov07other,prov08 "Pseudo1 ","333","C001"," ","10 ","C021"," ","C025" "Pseudo2 ","333","C001"," ","20 ","C021"," ","C026" "Pseudo3 ","333","C001"," ","30 ","C021"," ","C019" Here's the declaration: CREATE CURSOR curProvData (iid i, PseudoID c(20), Zip3 c(3), Prov03 c(4), Prov03Other c(254), Prov06 c(8), Prov07 c(4), Prov07Other c(254), Prov08 c(4))

4 5

[NF] "If it ain't broke..."
by mbsoftwaresolutions＠mbsoftwaresolutions.com 27 Nov '17

27 Nov '17

My apps for literally over a decade now have used the MyODBC 3.51 driver to connect to MySQL (and now MariaDB), database version 10+. It still works great and so my inkling is to stay with this old ODBC 3.51 version, but wanted to poll the virtual office here and see if others thought a more compelling reason to upgrade the ODBC version to something more recent. tia, --Mike

5 5

VFP9SP2 Error trying to install PEDEditor.app from github download
by mbsoftwaresolutions＠mbsoftwaresolutions.com 27 Nov '17

27 Nov '17

Trying to get a new installation of VFP updated and wanted to use the latest PEMEditor. Downloaded it and got this error when trying to run it from the IDE (via DO PEMEditor.APP): https://www.screencast.com/t/r0CpOhWGD Looks like some bugs in the code perhaps. Thought I'd try to fix it, so I recompiling the Source\*.PRG files but still get "source not found" in the debugger. Has anybody else had this problem? If so, how'd you resolve it? tia, --Mike

3 7

[NF] Great paper on SQL Data
by Stephen Russell 27 Nov '17

27 Nov '17

I Do Declare written by Joe Celko. "Joe Celko highlights some key areas that SQL developers need to be aware of in order to more effectively write SQL code, and offers heuristics for guidance." You will have to give Idera your info to register. https://www.idera.com/resourcecentral/whitepapers/i-do-declare-sql-programm… this tip was good. Add a CHECK() constraint for the actual range of the attribute. One of my favorite horror stories was an order entry system that allowed negative quantities. The application treated the negative quantity as a return or refund and sent a check. Order -5000 items at $50 each and wait for the check in the mail! The most common constraints that should be used, but are usually skipped, are to establish cardinals: -- 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 ---

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox November 2017