ProFox March 2016

profox@leafe.com

53 participants
65 discussions

ctSCHEDULE ActiveX control odd behavior
by Tracy Pearson 11 Mar '16

11 Mar '16

Hello, I just had a customer report they would look at a form in our program that uses the ctSCHEDULE control. I'm not sure if I just have an old version in my distribution and this behavior has already been fixed. I thought I would ask if anyone else uses this control and can reproduce it before spending a lot of time with it. Here's the trouble. With this control on a data entry form, the user can scroll in the control, then using the mouse click on another field and type. The keystrokes never come out. Clicking a button on the form works. Press the tab key when on the control, and things start to work again. ctSchedule is a DBI-Tech control: http://www.dbi-tech.com/download/demos/html/solsched7/flashhelp/welcome/welc ome_to_ctschedule.htm Thank you, Tracy

2 7

[NF] MySQL InnoDB seems to use more space than MyISAM....why??
by mbsoftwaresolutions＠mbsoftwaresolutions.com 10 Mar '16

10 Mar '16

tech: MySQL/MariaDB backend, version 5+ Anybody know why the same field structures but using the Inno engine type causes a table size to be much larger than if it's a MyISAM table type? I do realize the benefits of using InnoDB for transactions, btw. Just curious why MyISAM smaller, given same structure. Thanks, --Mike

2 3

[NF] So SQL Server is coming to Linux.
by Alan Bourke 09 Mar '16

09 Mar '16

https://www.petri.com/microsoft-deepens-ties-linux-partners-red-hat -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

10 18

[NF] Weird problems with Chrome
by mbsoftwaresolutions＠mbsoftwaresolutions.com 09 Mar '16

09 Mar '16

My Chrome (manually updated to the latest version as of yesterday, but these problems started BEFORE that) is behaving poorly. Pages that normally always worked (Facebook, LogMeIn, BG&E utility, etc.) are no longer working. They just seem to hang. Was thinking about dropping it and going back to Firefox (or gasp, IE) but wanted to ask if you blokes have any ideas I could try first. My only thought is to try and reset to the default settings, although I'm not sure what--if anything--I've tweaked. tia, --Mike

4 4

USE {table} EXCLUSIVE sometimes opens readonly.
by Tracy Pearson 08 Mar '16

08 Mar '16

I have been tracking down a very random occurrence of a table opened with the Exclusive flag throwing an error. #111 Cannot update the cursor "cursor", since it is read-only. I checked the code, no NOUPDATE flag. I brought up SysInternals Process Monitor and opened, appended a record, and closed a table 10000 times. I had suspected multiple anti-virus and on demand backup tools causing behavior problems. This Windows 7 (virtual machine) has 1 GB RAM, Kaspersky, Bitdefender, and Carbonite installed. No exclusions, and Carbonite is set to specifically backup the data folder on demand. My test actually does a Try/Catch around the USE statement, wrapped in a DO WHILE NOT USED() It seems the tools mentioned are not the direct culprit. Instead when things fail, Windows Explorer was the direct cause. Windows Explorer opens the table Read Only and with Share Read/Write and reads the first 4000 bytes. Then closes the file. Why I don't know, I don't care. I do know it only happens when the Explorer window is open to the folder where the table exist. Lucky for me, the place I open tables is via a class, so a check with ISREADONLY() will prevent this in the future. So what really happens? In Process Monitor I can clearly see I open a table in one session of VFP 9, then in another session of VFP 9 I attempt to open it again. First VFP attempts to open the table Read/Write with Share None. It gets a Sharing Violation. Then VFP attempts to open the table Read Only with Share None. There is that split moment on some machines that VFP is successful. Has anyone else seen this behavior before? Thank you for reading, Tracy

4 3

security in programming
by John R. Sowden 08 Mar '16

08 Mar '16

applications that I use need to be secure and have an audit trail. I encrypt entered passwords, compare them to encrypted stored passwords, ala linux. I am comfortable with that. My concern is relating the authorized user, with their access level to the actual programs. Currently I use the: if choice='A' .and. x=5 .and. y > 3 do the procedure endif where x is theuser's id number and Y is the user's access level. I use fp/dos 2.6. I encrypt my source on compiling. I don't use variable names that are too descriptive. I do other things to keep a program from running on a computer that is not mine. Any thoughts on a better way to connect the user data with the application? John --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

9 10

Forms and Date Environments
by Chris Davis 08 Mar '16

08 Mar '16

Hi All Just a pointer if possible. I want to create a form with one page frame and an unknown number of pages. Each page will be identical and editing one record out of a view. How am I best managing the data in this instance? Typically we would develop visually, add a view into the data environment and set control sources. Could I make use of the data environment class? Other ideas? Thanks Chris. Chris Davis Acton Gate Systems Limited Hilton Hall Business Centre Hilton Lane Essington West Midlands WV11 2BQ M: 07966 020473 *: chrisd(a)actongate.co.uk Web<mailto:chrisd@actongate.co.uk%0bWeb>: www.actongate.co.uk<http://www.actongate.co.uk/> ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 5

Re: Subclassed Methods Not Getting Executed
by Ted Roche 07 Mar '16

07 Mar '16

On Mon, Mar 7, 2016 at 1:14 PM, Gene Wirchenko <genew(a)telus.net> wrote: > > The compiler does not throw an error if you have two methods of the > same name in a class. (It should.) Whenever I searched for the method, I > found the first one. When there are two methods of the same name, VFP > executes the second. > When there are two methods (functions) of the same name in a program or procedure file, the last is executed, too. That may or may not be a bug, or a neat feature you can exploit using conditional INCLUDES. I lean towards the former. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

1 0

RE: Subclassed Methods Not Getting Executed
by Gene Wirchenko 07 Mar '16

07 Mar '16

At 04:26 2016-03-03, Dave Crozier <DaveC(a)Flexipol.co.uk> wrote: >Check you are actually pointing to the code (.prg) location that you >think you are in code!! > >Many times I have found VFP picking up programs of the same name in >different locations because my set path was screwed. I ended up finding the cause of the problem. It was not path at all, but it was related. In frustration and to try to find the extent of the problem, I started instrumenting every method in the subclass. I got most of the way through when I came across a second method called actexit(). The compiler does not throw an error if you have two methods of the same name in a class. (It should.) Whenever I searched for the method, I found the first one. When there are two methods of the same name, VFP executes the second. [snip] Sincerely, Gene Wirchenko

1 0

[NF] Apple now held for ransom
by Stephen Russell 07 Mar '16

07 Mar '16

Users that is. https://consumerist.com/2016/03/07/apple-users-targeted-with-widescale-rans… -- 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 March 2016