ProFox July 2019

profox@leafe.com

39 participants
51 discussions

ADMIN: Profox archives, Internal Server Error
by Ted Roche 12 Jul '19

12 Jul '19

Error: Internal Server Error The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

Re: Figured out how I was getting around that Page.Init "bug" not working as expected in my subclass
by Gene Wirchenko 11 Jul '19

11 Jul '19

At 08:43 2019-07-10, "MB Software Solutions, LLC" <mbsoftwaresolutions(a)mbsoftwaresolutions.com> wrote: >2 things: 1. thankfully I had source code backups 2. I'm very glad I >documented (commented) it well with my datestamp too. I always code >to help me later down the road when I lose my mind. I try to comment appropriately, but sometimes, I miss putting down what ends up being a critically missing detail years later. If my code were less reliable, then maybe, I would have looked at it sooner and would be more familiar with it for when I finally have to change it. The "Set it and forget it." mentality does have the problem of "forget it". [snip] Sincerely, Gene Wirchenko

1 0

VFP Data / Node / MariaDB
by Chris Davis 11 Jul '19

11 Jul '19

I have been experimenting (more like messing around) with ways to create an API to VFP data. The reason for this is to be able to leave our existing or other third party VFP apps doing what they do but provide the information within them to other parties via an API. I quite easily created a simple REST API using Node/Express and a ODBC/OLEDB package, but I found the package providing the connection to the data source either lacking documentation or difficult to setup. Having started my thoughts with stacks, like the MEAN stack I knew there was so much information and so many packages out there that make working with data sources like Mongo/MySQL etc so easy. I then ventured into MariaDB and its CONNECT engine type allowing me to add data as a table into a MariaDB database from an external source, it’s not importing this data just linking to it. Once added which was a simple as CREATE TABLE customers ENGINE=connect table_type=ODBC connection=’DSN=mydbc’ I could query away. Going back to node I can now use packages which help me use MariaDB as a datasource 😊 Just wondered if any of you had been down this route, or similar? Because some of the applications I need to do this with are not ours I don’t have the option of saying why are we still using VFP data instead of a backend like Mysql or SQL Server in the first place. TIA Chris.

2 3

Re: Figured out how I was getting around that Page.Init "bug" not working as expected in my subclass
by MB Software Solutions, LLC 10 Jul '19

10 Jul '19

2 things: 1. thankfully I had source code backups 2. I'm very glad I documented (commented) it well with my datestamp too. I always code to help me later down the road when I lose my mind. :-) On 7/10/2019 11:18 AM, Gene Wirchenko wrote: > At 07:48 2019-07-09, "MB Software Solutions, LLC" > <mbsoftwaresolutions(a)mbsoftwaresolutions.com> wrote: >> Found some code from last year that told the tale: >> https://www.screencast.com/t/eHBKVzcvz >> >> I was simply removing the page after the fact in the Form.Init based >> on user preferences. > > And you probably felt somewhat foolish when you realised that > your previously-written, previous-brilliant code was the cause. > > I just had that myself. Actually, I am just finishing up with that. > > I had to severely hack up one of my forms handling classes. How > severely? > > I had to override a main method so that a bunch of other methods > normally used would never be called. In one case, I had to override a > method from about a page of code down to just a return statement. > > Then, I found that I had removed a bit too much functionality and > had to debug that. > > One of my OOP peeves bit here. That is when I have to write a > new subclass and have to override significant parent code. Flipping > back and forth between the two classes gets old very fast. > > One of the great things about OOP is that you can write a class > and then forget about it. That is also one of the nasty things. (I > had not looked at the class much in the past several years.) > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server]

1 0

Re: Figured out how I was getting around that Page.Init "bug" not working as expected in my subclass
by Gene Wirchenko 10 Jul '19

10 Jul '19

At 07:48 2019-07-09, "MB Software Solutions, LLC" <mbsoftwaresolutions(a)mbsoftwaresolutions.com> wrote: >Found some code from last year that told the tale: >https://www.screencast.com/t/eHBKVzcvz > >I was simply removing the page after the fact in the Form.Init based >on user preferences. And you probably felt somewhat foolish when you realised that your previously-written, previous-brilliant code was the cause. I just had that myself. Actually, I am just finishing up with that. I had to severely hack up one of my forms handling classes. How severely? I had to override a main method so that a bunch of other methods normally used would never be called. In one case, I had to override a method from about a page of code down to just a return statement. Then, I found that I had removed a bit too much functionality and had to debug that. One of my OOP peeves bit here. That is when I have to write a new subclass and have to override significant parent code. Flipping back and forth between the two classes gets old very fast. One of the great things about OOP is that you can write a class and then forget about it. That is also one of the nasty things. (I had not looked at the class much in the past several years.) Sincerely, Gene Wirchenko

1 0

[NF] X# update regarding VFP support
by Johan Nel 10 Jul '19

10 Jul '19

Hi VFPers, With the latest paid (FOX member) release of X# there are a couple of touch points regarding VFP that might be of interest to you. The public free opensource version is expected around 20 July, depending bugs found via user testing. Announcement: * FPT writing in the DBFCDX RDD, and also reading of FlexFile arrays stored in FPT files * Added support for the VFP Collations in the CDX driver * Added FieldGetBytes() and FieldPutBytes() to store binary data (encrypted passwords) to a DBF without having to worry about unwanted side effects of Ansi - Unicode translations. * Several changes in the SDK libraries. The biggest change is that both System Classes and RDD (Replaceable Database Driver) Classes are now compiled with a target platform AnyCPU, so they can be used in X64 apps. We have also removed some late bound code from these class libraries, so the code should perform somewhat faster. XBase greetings, Johan Nel FOX member : Friends of XSharp https://xsharp.info George, South Africa.

2 2

Figured out how I was getting around that Page.Init "bug" not working as expected in my subclass
by MB Software Solutions, LLC 09 Jul '19

09 Jul '19

Found some code from last year that told the tale: https://www.screencast.com/t/eHBKVzcvz I was simply removing the page after the fact in the Form.Init based on user preferences. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

1 0

Super bizarre page.init bug on form.pageframe -- it never runs! (VFP9SP2)
by MB Software Solutions, LLC 05 Jul '19

05 Jul '19

I added 2 pages to my existing pageframe so that I could add more functionality to this form. There are pages that I conditionally instantiate based on user settings. But for these 2 new pages (automatically added via the IDE after I set the pageframe.PageCount from 11 to 13), their Init events never run. I'm baffled. See soundless Camtasia demo I put together to show this: https://www.screencast.com/t/eZ1EyfDewnw I'm hoping somebody can see something obvious that is eluding me! tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

7 12

Remote FoxPro Work???
by Kurt at VR-FX 04 Jul '19

04 Jul '19

Yeah - I know - these days - that's a pretty crazy request. I know some of you have followed me a bit - and know I lost my job in Nov 2017 - where I was working down on Wall Street. Then, moved to Cali to look for a job - could NOT find work in San Francisco. Even applied to UCLA for a programming job - did 2 rounds of interviews - and the people there saying they were impressed with me - during both interviews. Only to NOT get the job. Then, finally, getting a "job" down here in San Diego. Actually getting to do 3D Design work for clients, as well as running 3D Printing jobs. But, sadly - its SUCKING! Its not a regular job - not salaried - not even part time pay. Its contractor pay - per job - and it does NOT pay well enough. Been here for over 9 weeks now - and its again put me in a BAD financial situation... So - as a total "shot in the dark" - I figured I would post here again and see if there is any possible remote FoxPro work. And, I know - almost no companies these days are still working w/VFP. And, sure, I know it would be better to work in some other newer more modern tech. - but, I don't have any of those tools in my tool belt. So - all I really have is VFP & MS SQL. Anyway - just figured I would take a stab and post here... Regards -Kurt

11 19

Re: Super bizarre page.init bug on form.pageframe -- it never runs! (VFP9SP2)
by MB Software Solutions, LLC 04 Jul '19

04 Jul '19

I'm thinking my next step in SET EVENTTRACKING ON. Ugh. This stuff makes your hair fall out. On 7/4/2019 12:08 AM, Gene Wirchenko wrote: > At 13:27 2019-07-03, Frank Cazabon <frank.cazabon(a)gmail.com> wrote: >> Are you sure that what you are running is what you are editing? > > I second this. > > I am currently suffering from something like this. I have to > hack my form handling for a special case. I have some methods of my > form handling that are not usually overridden being overridden, some > to doing nothing. It is great fun jumping between the two classes. > There is a lot of event handling, too. SET STEP ON and ON and ON. > > [snip] > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server]

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox July 2019