ProFox November 2016

profox@leafe.com

55 participants
67 discussions

2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
by mbsoftwaresolutions＠mbsoftwaresolutions.com 03 Nov '16

03 Nov '16

On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file. I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? tia, --Mike

2 2

Friday Poll (while dl'ing MS Flash Patch)
by Ted Roche 03 Nov '16

03 Nov '16

So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

16 22

Renaming a project
by mbsoftwaresolutions＠mbsoftwaresolutions.com 03 Nov '16

03 Nov '16

If you wanted to rename a project, would you create a new PJX with the right/desired name, or would you just rename the existing PJX/PJT? Just curious.

3 3

M$ OCX Date Picker Problem!
by Kurt Wendt 03 Nov '16

03 Nov '16

Hello there ProFoxers! 1st of all - Happy TGIF! I'm trying to find out who else may have this particular problem. Here's the URL to an image of the Date Picker being used within a system here at my job: http://imgur.com/a/ZlGZu Initially - the problem with the Date Picker caused the system to Crash. Why you might ask? Because the system was trying to set a default date for the Date picker. This was the specific error that was being thrown: "Ole IDispatch exception code 0 from DTPicker: A date was specified that does not fall within the MinDate and MaxDate properties..." At first I wasn't sure what was causing the problem. Turns out - I went to another screen that had the Date Picker running on it - which is the above screen. When I went into that screen - the dates were set to 9/1 - 9/30/16. This is because this report is generally run on the 1st of the month for the prior month. So - upon trying to set the dates to Oct month range - then the problem is apparent. Notice the grey circle around the 25th of the month - although you probably can't see it in this screen shot. But, the picker no longer allows you to pick ANY Date Beyond the 25th of October! And, trying to set the default date to end of Oct. during the startup of another report screen - That is what caused it to Crash. Needless to say - this is an OCX from M$ - and its fairly standard. So - I figured others may be using it in their systems - which are May NOT be FoxPro systems. If so - you will ALSO have the problem. So - I'm curious - has anyone else here experienced the problem? Thanks! Kurt Wendt Senior Systems Analyst [GlobeTax_SecondaryLogo_TwoColor_Lo]<https://www.globetax.com/> One New York Plaza - 34th Floor New York, NY 10004-1936, USA Tel. +1-212-747-9100 Direct +1-212-405-8246 www.GlobeTax.com<https://www.globetax.com/> GlobeTax does not provide or offer, and this is not, tax, investment or legal advice. This email and any attachments hereto is intended only for use by the addressee(s) and may contain confidential information. If you are not the intended recipient of this email, please immediately notify the sender at +1-212-747-9100 and permanently delete the original and any copies of this email. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/png ---

3 4

Word doc on invoice
by Sytze de Boer 02 Nov '16

02 Nov '16

My client enters invoice details using Word.exe I need to print the word document on a Fox report I know there may be better ways, but this is how it has to run. I can only find 1 way to do this. i.e. Convert the Doc file to a Jpg file. I have this working except for the fact the conversion is screwing the size/font of the original Doc file. Are there other ways? -- Kind regards, Sytze de Boer --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

What is the maximum number of Tags i can have in a CDX file?
by Michael Madigan 02 Nov '16

02 Nov '16

What is the maximum number of Tags i can have in a CDX file? Specifically for a FPW 2.6 database. I can't find this number anywhere. Thanks --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 5

Excel automation - insert picture into a cell
by Peter Cushing 01 Nov '16

01 Nov '16

Hi, Just want to see if anyone has any experience of inserting pictures into Excel using Excel 2010 onwards. Been doing this for years using Excel 2000 (Yeah, I know a bit old but works great) and outputs an .XLS with some example code: cFile = "\somefolder\somefile.jpg" cOutfile "\myfolder\outfile.xls" objexcel = CREATEOBJECT('excel.application') objexcel.Workbooks.Add OBJexcel.Rows("2:2").RowHeight = 77 objexcel.Range("A2").Select objexcel.ActiveSheet.Pictures.Insert(cFile).Select objexcel.Selection.shaperange.height = 77 * add more pics into different cells objexcel.ActiveWorkbook.SaveAs(cOutfile, xlWorkbookNormal) objexcel.ActiveWorkbook.Close objexcel.Quit We usually output a spreadsheet of data and leave the first column blank so we can move through it and insert a picture. Now we need to move to Office 365 to get a bit more up to date and output .XLSX files. :-( I'm using office 2013/VFP 9 and the pictures it inserts are just links so that when you send it to somebody they can't view them. Done lots of searching of the internet and the archives etc and found an extra parameter for the insert: objexcel.ActiveSheet.Pictures.Insert(cFile,.t.).Select but this seems to make no difference set to .t. or .f. There seems to be another way of doing it using shapes. objexcel.application.activesheet.shapes.addpicture("H:\img_0536.jpg",.f.,.t.,1,1,100,100) but I then need to move them to the correct location so still playing with that option. Any help appreciated. Thanks, -- Peter Cushing IT Department WHISPERING SMITH This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. 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. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960

2 2

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox November 2016