ProFox January 2019

profox@leafe.com

34 participants
33 discussions

Re: String Reference to Object
by Gene Wirchenko 25 Feb '20

25 Feb '20

At 11:07 2018-02-15, Gene Wirchenko <genew(a)telus.net> wrote: >At 10:57 2018-02-15, "Fernando D. Bozzo" <fdbozzo(a)gmail.com> wrote: >>To talk with an example, if you have this: >> >>oObj = createobject("custom") >>reference = "oObj" >> >>The you have at least 3 options: >> >>1) The way you know => &reference..referredto >> >>2) Using evaluate => =Evaluate(reference + ".referredto") >> >>3) My preferred: Caching the object and then using it: >> >>oRef = Evaluate(reference) >>? oRef.refered1 >>? oRef.refered2 >>... > > I was hoping to avoid evaluate(), but your third way makes > sense. I will check if it works in all the contexts I am thinking > of. (I was using "object" and "reference" rather loosely.) Unfortunately, it does not work in my usual use case: as an alias. Example: use ccli where=evaluate("ccli") && Nope ? where.clcode Sincerely, Gene Wirchenko

9 9

Re: AW: Custom Scrollbar
by Gene Wirchenko 25 Mar '19

25 Mar '19

At 06:06 2019-01-10, Frank Cazabon <frank.cazabon(a)gmail.com> wrote: >Gene, I've knocked up a quick demo which I hope meets your >requirements and emailed you the link to the download on google drive. I was beat last week, and did not get to it. I have a couple days off (today and tomorrow) and am digging into it. Preliminary: I should have stated code only. Never mind. Converting it to code only will help me learn. <BEG> I do not use database containers. I hope this does not break your solution. I was concerned because of the validation rules, but this, at least, does not appear to be an issue. Focus should be set on a control in the grid at the start. I assume that there is a simple statement to do that. Validation of each column is not done at the start of row-level validation. This is important. What if the data displayed is invalid? I may be able to get this myself. I have not done much yet, but this looks as if it works. So how did I miss it? I think bad documentation is to blame, but while converting it to code, I ought to find out. I think I probably got snookered by Before/AfterRowColChange(). [snip] Sincerely, Gene Wirchenko

3 5

Google API for Geocoding ... Again
by Dave Crozier 04 Feb '19

04 Feb '19

Fellow Gentlemen, I posted a request about doing geocoding requests to receive back a Lat/Long dataset for various addresses a few weeks ago and now find that Google do in fact provide a Geocoding service: https://developers.google.com/maps/documentation/geocoding/start The responses back from the requests are all JSON from a Java Script API run by Google. I have looked over Rick's Westwind site to try and get a start on using this method to get back a JSON response but seem to be getting nowhere fast. Anyone got any ideas on a simple & neat way of retrieving this data back using VFP programmatically? Either that or anyone know a free Geocoding site that would handle up to 100 name and address calls per day ideally by sending a text file and receiving one back which could be automated from the VFP end. Never even looked at Web services in anger before so it all seems a little baffling and terribly long winded at the moment unless I am missing something obvious. Note I don't want to have to drop into an intermediate program/language to accomplish this, if possible. Dave

9 23

Converting .scx to .prg
by Gene Wirchenko 02 Feb '19

02 Feb '19

Hello: How do I convert a .scx to a .prg? I have found most of the pieces of code, but I do not see how the contained objects are created. (I was expecting to find a form .Init().) Sincerely, Gene Wirchenko

7 6

Re: ERD with a table with strange keys
by Gene Wirchenko 29 Jan '19

29 Jan '19

At 09:22 2019-01-26, Ted Roche <tedroche(a)gmail.com> wrote: [snip] >To avoid this kind of refactoring later in the process, my rule has always >been that every table has a unique, non-data-bearing PK which uniquely >identifies the record from birth to death. You will never have to deal with >all the RI code involved in changing primary keys because the data values >(category or country codes) change, and avoid intricate and bothersome >code. Why not? What if someone creates a second restriction row with the same category, country, and any other factors? Couldn't this create an integrity nightmare? In my client billing app, I have a few tables that have a date range for when each row is valid. This does mean that I have to handle the lookup into these tables. [snip] Sincerely, Gene Wirchenko

2 1

[NF] Looking for a little Python/Django help
by Fletcher Johnson 29 Jan '19

29 Jan '19

Hi all, I have to work on a small Python project using Django. Given what I have seen, it shouldn't be too difficult. But I haven't really used either product and have a few, relatively easy questions. Currently, I am using Microsoft Code (although I could use Visual Studio, PyCharm, or some other IDE) on a windows platform. I can write a simply python app and have it run without issue. But trying to get Python running inside a virtual environment and getting Django configured correctly is giving me a head ache. I know what I need to do, just not where to set the values I need to set. Anyway, if anyone out there is available for Skype chat, Google hangout, or even an old fashioned phone call, I would really appreciate it. Thanks, Fletcher Fletcher Johnson <mailto:FletcherSJohnson@Yahoo.com> FletcherSJohnson(a)Yahoo.com <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson twitter.com/fletcherJ <https://www.strava.com/athletes/fletcherjohnson> strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

9 13

[NF] Microsoft Account
by Charles Hart Enzer, M.D. 23 Jan '19

23 Jan '19

None of my machines is connected to my Microsoft Account I don't use Outlook. I am considering *joining* my laptop and desktop to Microsoft Account to solve Network Credentialing: - Homegroup gone since usdated WIN 10 - Change name of Desktop with attached printer - Laptop no longer finds network printer *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May, 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *If a problem has no solution, * * it may not be a problem, * *but a fact -- not to be solved, * * but to be coped with over time* -- Shimon Peres, Ninth President of Israel --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

This is a test please ignore.
by Alan Bourke 22 Jan '19

22 Jan '19

A test. -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 5

Hey, can you test this...
by Fletcher Johnson 16 Jan '19

16 Jan '19

Hi all, I use Chrome. I have a number of passwords saved. But I think I found a security issue and was wondering if anyone wanted to see if they had the same result (or already knows about it.) Today, I was messing around with Chrome. I clicked on log out and then use another account. I created a new one using a non gmail account. When it came up, I still had all the same bookmarks, etc. So I went into settings and chose reset (advanced, at the bottom) as well as changed the default startup to be a new page. I then closed Chrome and rebooted the computer. I start Chrome, and log in using the new email ID, I still see all the previous bookmarks. And if I go to settings, passwords, I can see all the passwords for all the sites that belonged to my real Gmail account. But I am logged in using the new email ID account. The funny thing is if I go to settings/passwords, I can see all the passwords. But if I click on the option to view and manager saved passwords in your Google Account - on that web page, it says I have none... Very strange. And yes, the passwords are *'ed out, but if you click on the eye icon and enter the windows login password, you can then see them as pure text. Just curious to see if anyone else can replicate it. Fletcher Fletcher Johnson <mailto:FletcherSJohnson@Yahoo.com> FletcherSJohnson(a)Yahoo.com <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson twitter.com/fletcherJ <https://www.strava.com/athletes/fletcherjohnson> strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

9 9

Genes scroll bar - DBC usage question
by Fletcher Johnson 14 Jan '19

14 Jan '19

Gene, Given the cool things that you get from a DBC, why do you choose not to use it? Just curious, Fletcher Fletcher Johnson FletcherSJohnson(a)Yahoo.com LinkedIn.com/in/FletcherJohnson twitter.com/fletcherJ strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell -----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Gene Wirchenko Sent: Monday, January 14, 2019 3:28 PM To: ProFox Email List Subject: Re: AW: Custom Scrollbar At 06:06 2019-01-10, Frank Cazabon <frank.cazabon(a)gmail.com> wrote: >Gene, I've knocked up a quick demo which I hope meets your >requirements and emailed you the link to the download on google drive. I was beat last week, and did not get to it. I have a couple days off (today and tomorrow) and am digging into it. Preliminary: I should have stated code only. Never mind. Converting it to code only will help me learn. <BEG> I do not use database containers. I hope this does not break your solution. I was concerned because of the validation rules, but this, at least, does not appear to be an issue. Focus should be set on a control in the grid at the start. I assume that there is a simple statement to do that. Validation of each column is not done at the start of row-level validation. This is important. What if the data displayed is invalid? I may be able to get this myself. I have not done much yet, but this looks as if it works. So how did I miss it? I think bad documentation is to blame, but while converting it to code, I ought to find out. I think I probably got snookered by Before/AfterRowColChange(). [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server]

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox January 2019