ProFox January 2019

profox@leafe.com

34 participants
33 discussions

[OT] : Hello (Again)
by Adam Buckland 14 Jan '19

14 Jan '19

Good afternoon Profoxers, After a 2 year rollercoaster ride I’m back doing tech things and it feels great. Two years ago what can only be described as the UK shitstorm hit my family business that had been trading profitably since 1971. In some respects it was good that my father had passed on as he would have been devastated to see all we had built destroyed inside 18 months. 28 people lost their jobs, I became very depressed and considered many options including the worst possible. Fortunately my wife and children pulled me through the blackness that was surrounding me and following 5 months working in a school teaching Design Technology and Food I decided that this was a way back for me to rebuild myself. I struggled to get my qualifications from the 1980’s accepted and have found myself doing the final year of a bachelors degree in order to get on a teaching course. There are only five people doing this course (it only started last year) and none of them have any industry experience. Whilst I want to say “This wouldn’t happen in the real world” I know I have to bite my tongue, do it how they want to get those letters after my name. Advanced Databases is a thing… Well it would be advanced if you hadn’t been working with them since dBase III and Ingres. I’m using good old Foxpro to access the SQL Server they use although I have moved from Version 6 to 9 now! Have to do stuff in Java and target at Android phones – Steep learning curve there. If there is anyone who either has worked on a crowdfunding site or an international trading system web facing please say hello, I’d love to pick your brains and will happily pay in beer tokens! Regards, Adam Buckland PS Are Michael Madagain and Dr P Thesian still about? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

[ADMIN] Testing new mail relay
by Ed Leafe 13 Jan '19

13 Jan '19

Many of you have had problems receiving mail from the list, as my domain is hosted on a server in the cloud, and many ISPs have blanket blocks on any IP addresses from cloud providers like mine (Digital Ocean). I’m testing out a new relay service, Mailgun (https://www.mailgun.com/) So far it seems to be running well, but if any of you on the receiving end of things notices a problem, please let me know. One other issue is the cost: it’s free if the total # of emails sent is under 100K, but gets expensive above that. Last year the highest number of emails sent in a month was 280 in May, which is about 133,000 total emails, and that would have cost $120 for that month (ouch!). So I’m not sure if I will keep it, but it’s worth a trial at least. -- Ed Leafe

14 26

Moving/dragging form leaves a trail of images of the form behind it
by Paul Newton 11 Jan '19

11 Jan '19

Hi all At the moment I have just one form that is displaying this behaviour. Has anybody seen this before? Any ideas as to cause or solution? Many thanks Paul Newton

4 5

RE: AW: Custom Scrollbar
by Gene Wirchenko 11 Jan '19

11 Jan '19

At 12:47 2019-01-10, Frank Cazabon <frank.cazabon(a)gmail.com> wrote: >All columns have different validation rules. There is no input mask >to force the text column to only accept numbers. You can put >alphabetic characters in there too. Then it uses the rule specified >earlier by Gene. You can download it and look at it and read Gene's >specification in his last message here. My spec was never intended to be bullet-proof, just adequate for a very basic but non-trivial grid. "non-trivial" means that it shows working and workable implementation some things of importance to me. I intend that numeric values be entered for numeric columns. Really, this is a simple example. Yes, I would have input masks in app code. Yes, I would have many other things as well. This is not app code. Anyone thinking that this code would be of use in a real app is overthinking the situation. Run and scream after looking at the code if you want. Print out a copy of the code, and burn it. Whatever you want. Thanks for you time, Frank and anyone else who has contributed. [snip] Sincerely, Gene Wirchenko

1 0

RE: AW: Custom Scrollbar
by Gene Wirchenko 11 Jan '19

11 Jan '19

At 12:39 2019-01-10, Frank Cazabon <frank.cazabon(a)gmail.com> wrote: >What control? The text? > >This is a quick knock up for Gene to check out, all I've put in is >what he specifically asked for so it's a bare minimum thing. ... and that is exactly what I want. I want something simple enough that I can fairly easily rip it to pieces figuring out how it works but not so simplistic that it does not scale to something useful. I will check it out. Maybe, I will have missed a couple things that will come up later and need a bit more help, but maybe, at that point, I will be able to handle them myself. I do not expect people to put in a lot of work on this. I just need help out of the pit. I would be pleased to find that I can get Grid working as I need. I do not believe it yet, but I have always been willing. Remember that ~15 years some have mentioned? This is the first time I have gotten some Grid code to chew on. Sincerely, Gene Wirchenko

1 0

RE: AW: Custom Scrollbar
by Gene Wirchenko 11 Jan '19

11 Jan '19

At 12:23 2019-01-10, Richard Kaye <rkaye(a)invaluable.com> wrote: >Control not constrained to digits only? thetext is a character string. It is not constrained at all except by the validation that it can not be "". evennr and weirdnr are integers so digits (and signs) only. [snipped previous] Sincerely, Gene Wirchenko

1 0

Re: AW: Custom Scrollbar
by Gene Wirchenko 11 Jan '19

11 Jan '19

At 08:10 2019-01-10, Koen Piller <koen.piller(a)gmail.com> wrote: >Frank, >Downloading and installing the file Gene.zip was easy done succesfull. >The form: I am not able to enter a value in column #Weird if I have entered >8 in the column text. Is that how it is supposed to work? I came up with some simple rules to test validation. They are arbitrary, but they are also simple. (No sense having them be complicated for a proof of concept.) Regarding weirdnr: 1) weirdnr is supposed to be divisible by 3. 2) It is also supposed to have the same even-oddness as the first character of thetext. Example 1: With thetext of "An example", "A" has a value of 65 which is odd, so weirdnr must be odd. Since it must also be divisible by 3, it must be one of {3, 9, 15, ...} or the negative of one of them. Example 2: With thetext of "Brilliant or bad example", "B" has a value of 66 which is even, so weirdnr must be even. Since it must also be divisible by 3, it must be one of {0, 6, 12, 18, ...} or the negative of one of them. The above assumes Frank implemented correctly what I asked for, and for that matter, that I wrote what I intended. I have just gotten home from work -- I am working full-time outside of IT -- and have not looked at his code yet. I might not get to look at it in detail for a few days. But I will. This is the first potential grid example that works for my value of "works". If I have been overlooking something, I want to know about it. Mind you, I am going to try to break it, too. I want something solid and to know that I have something solid. [snip] Sincerely, Gene Wirchenko

1 0

Re: AW: Custom Scrollbar
by Gene Wirchenko 10 Jan '19

10 Jan '19

At 05:28 2019-01-08, Frank Cazabon <frank.cazabon(a)gmail.com> wrote: >Gene, back in April last year you were asking if anyone could write >code to your specification regarding the grid problems you were >having. I don't recall ever seeing your specification, maybe if you >posted it someone might be able to do the code for you. At that time, I was also having difficulties posting to the list. I thought I had come up with something, but maybe, it did not make it and I mistakenly deleted it. Let me specify something simple: Consider a cursor or table of: thetext c(20) evennr n(3) weirdnr n(3) The validations are: thetext>"" evennr%2=0 weirdnr%3=0 and the row-level validation is: asc(thetext)%2=weirdnr%2 When a control-level validation error occurs, throw an appropriate message box and then set focus to the control with the erroneous value. For a row-level validation: 1) All control-level validations should be done first. Start with the current control, then do all the others from left to right. The first that fails gets the message box, and checking stops. Then, do the row-level validation. If it fails, throw an aoppropriate message box and then set focus to the control in the first column from the left of the values that are checked. (In the example above, thetext is left of weirdnr, so set focus to thetext.) Part 2: The columns can now be rearranged in any order. Despite this: The coontrol-level validations should still set focus to the correct control. The column-level validations done at the start of the row-level validation should be done in the order current then left-to-right. NOTE THAT THIS COULD NOW BE A DIFFERENT ORDER. The row-level validation should still set focus to the leftmost involved control. NOTE THAT THIS MIGHT BE A DIFFERENT CONTROL. (Example: If weirdnr gets moved to the left of thetext, row-level validation failing should set focus to weirdnr.) This is basic functionality that I want/need. I have been unable to get this to work with VFP's Grid despite my efforts. [snip] Sincerely, Gene Wirchenko

5 13

VFP Work in San Diego???
by Kurt ＠ Gmail 10 Jan '19

10 Jan '19

Hello there folks, I thought I would ping the group about the above Subject line question. Actually did a quick search of my own ProFox archives before sending this out - but, it turned up empty for SD(No - NOT Sugar-Daddies)/San Diego! So - was curious to know if any of you are located in SD - I believe someone is. And, if anyone knows of any possible VFP work down there. I know some folks will chime in and suggest I should be looking for work in other tech/programming languages. But, seriously - no need for that - as I know what many will say. Am just curious to know about VFP work for now - since its much easier for me to get with my background. I've actually been searching for 3DP work in the Silicon Valley area - but, not getting a good response to my applications. TIA, Kurt

2 4

Re: Custom Scrollbar
by Gene Wirchenko 09 Jan '19

09 Jan '19

At 08:18 2019-01-06, Jean Laeremans <laeremans.jeanmarie(a)gmail.com> wrote: >If memory serves me right he must be at it for at least 15 years. No, it is just that I have never had the free time to go all the way with it. (It is lower priority than my other work.) During that time, I have tried to make VFP's Grid work and have failed despite solid efforts. [snip] Sincerely, Gene Wirchenko

5 4

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox January 2019