ProFox September 2018

profox@leafe.com

32 participants
28 discussions

Re: ON KEY usage in your apps
by Gene Wirchenko 20 Sep '18

20 Sep '18

At 18:18 2018-09-18, Gene Wirchenko <genew(a)telus.net> wrote: >At 14:03 2018-09-18, mbsoftwaresolutions(a)mbsoftwaresolutions.com wrote: >>VFP9SP2 on Win7/8/10 pcs >> >>I really never fully took advantage of this gem in VFP. In my >>apps, I haven't allowed editing in grids in probably 14 >>years. Some of my users seem to want that though so I'm thinking >>of allowing such ability now. >>I was thinking of using ON KEY to pop up a lookup form to add data >>records to the grids (instead of that native whatever way of doing >>an APPEND blank in the native VFP grid). >> >>In the past, I've really just used ON KEY to pop up the help file on demand. >> >>In what other ways have you used ON KEY in your designs? > > I use > on key label "ctrl+0" * >so .null. can not be entered into controls. > > I also enjoy the minor joke of > * >being executable in this control. Note that it does not mean the same as > on key label "ctrl+0" I forgot about my setup code. I use on key label <function key> for deleting my app's .fxp files, compiling my app, and starting my app with various options. Sincerely, Gene Wirchenko

1 0

Re: ON KEY usage in your apps
by Gene Wirchenko 19 Sep '18

19 Sep '18

At 20:37 2018-09-18, mbsoftwaresolutions(a)mbsoftwaresolutions.com wrote: >On 2018-09-18 21:18, Gene Wirchenko wrote: >> I use >> on key label "ctrl+0" * >>so .null. can not be entered into controls. > >Clever!!!! Thank you, but ... I do not think of the above as particularly clever; it is simply something that I worked out to avoid nulls. I happened to think that way; you did not. With something else, it may go the other way. Because we can communicate our discoveries/solutions/what-have-yous, we each end up with more as a result. This is a big reason why I like forums and lists. On another point, I had an icase() function about five years before Microsoft added it to VFP. Except for that Microsoft's version has selected parameter evaluation and mine has all parameters evaluated -- not something programmers can control in the VFP language -- our icase()s work the same. I wonder if Microsoft came up with the idea themselves -- not that difficult; it seemed obvious to me -- or glommed onto my idea (which I had posted publicly). Either way is fine with me, just as I do not mind anyone using the above bit of code. Sincerely, Gene Wirchenko

2 1

Re: ON KEY usage in your apps
by Gene Wirchenko 19 Sep '18

19 Sep '18

At 14:03 2018-09-18, mbsoftwaresolutions(a)mbsoftwaresolutions.com wrote: >VFP9SP2 on Win7/8/10 pcs > >I really never fully took advantage of this gem in VFP. In my apps, >I haven't allowed editing in grids in probably 14 years. Some of my >users seem to want that though so I'm thinking of allowing such ability now. >I was thinking of using ON KEY to pop up a lookup form to add data >records to the grids (instead of that native whatever way of doing >an APPEND blank in the native VFP grid). > >In the past, I've really just used ON KEY to pop up the help file on demand. > >In what other ways have you used ON KEY in your designs? I use on key label "ctrl+0" * so .null. can not be entered into controls. I also enjoy the minor joke of * being executable in this control. Note that it does not mean the same as on key label "ctrl+0" Sincerely, Gene Wirchenko

2 1

Print salary receipts to a pdf image
by Rafael Copquin 14 Sep '18

14 Sep '18

I have the following requirement: Print a salary receipt to a company form, previously generated as a pdf file The application calculates the monthly salaries of the company's personel and issues a salary receipt for each employee. Now they print the receipt to a preprinted form with te company logo and the Treasurer's signature But they want to have the blank form, with the logo and static text, including the officer's signature on the form, to be filled with the salary data, employee name, deductions, etc and print the whole on a blank sheet by a laser printer. In this way the company will save the cost of having preprinted forms. They will simply use a letter size sheet to print each receipt What do you suggest, please? What about FoxyPreviewer, or any other software? Perhaps ask the printing company to scan a blank form and produce a pdf file, or another image file? Please advise Thank you Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

11 19

Example of T-SQL exception handling within a transaction?
by Malcolm Greene 14 Sep '18

14 Sep '18

Anyone have an example of how to trap and exception within a T-SQL transaction and save diagnostic details on why the transaction failed to an error log? If you insert the exception data to an error table this information gets lost when you rollback the transaction. I'm sure I'm missing something obvious :) Thanks, Malcolm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 3

alter column in sql server
by Rafael Copquin 12 Sep '18

12 Sep '18

I need to import a DBF table into SQL Server However, all the fields in the DBF table begin with the suffix ST (a previous programmer built the table in 1992, with the notion that all fields should have a specific suffix related to the table's purpose) But I just want the sql server table to have all its fields without that suffix, ie: STACCT should become ACCT, STNAME should become NAME and so on, The DBF table has 60 fields. I would like to issue an ALTER TABLE statement directly in the SQL Server Management Studio to remove the ST suffix from all its fields. But I have no idea on how to build a stored procedure with something similar to a DO WHILE loop in SQL Server, such that it would read a field name, remove the ST suffix and alter the name as desired. And then pass to the next field and do the same In fact, I must do the same with all the DBF tables from the old DOS system, because I am converting it to a VFP9 app with a SQL Server back end. Please show me a code snippet that would do that Thank you in advance Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 7

VFP FTP Class Upload to Files Section
by Dave Crozier 11 Sep '18

11 Sep '18

Guys, Tried to upload to the files section but keep getting an error: "400 Bad Request The server could not comply with the request since it is either malformed or otherwise incorrect. No file specified" Maybe Ed could take a look at why this is happening… In the meantime please let me know if you want me to email the zipped class/demo to you directly. 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 ---

2 4

Backup in SQL Server
by Rafael Copquin 11 Sep '18

11 Sep '18

I am using the free tool (SQL Back Up Master) to perform backups of the different SQL Server databases. I installed it in my clients's computers, admonishing them to back up their work every day, so I would not be responsible if any data loss occurs. Most of my clients use it with no problems, but sometimes, they "forget" to do their daily backup. (they are just too lazy or too much in a hurry to go home after work, to spend the few minutes it takes to do the back up) So I was thinking of embedding a back up routine in my app that would fire when they shut down the app. My idea is to call a stored procedure to do the backup. However I do not know how to write such a procedure. Could you help me on this, please? Basically I want the database to be zipped (as SBM does) and send it to any cloud repository, such as dropbox, google drive, one drive or an ftp site Thanks Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 5

Good old fashioned FTP need from VFP app
by mbsoftwaresolutions＠mbsoftwaresolutions.com 10 Sep '18

10 Sep '18

Got a client need for me to FTP some data of theirs to a 3rd party vendor. Nothing fancy, just regular FTP (not SFTP, not FTP-S). Many moons ago I interacted with Robert Abrams VFP class (wow...I think that was VFP5 days?!?!?). What do folks use nowadays for FTP from a VFP app? tia, --Mike

10 12

Problem with VFP's debugger not seeing C# object's properties
by mbsoftwaresolutions＠mbsoftwaresolutions.com 10 Sep '18

10 Sep '18

VFPSP2 consuming C# (maybe version 3.5 or later?) See screenshot: https://www.screencast.com/t/bb0Xfu2KuMpC Is there a way I can have the C# guy somehow expose the properties somehow? tia, --Mike

3 4

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox September 2018