ProFox November 2018

profox@leafe.com

42 participants
44 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

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

[NF] Broken Windows
by Ted Roche 10 Dec '18

10 Dec '18

Something is seriously wrong at MSFT. https://www.thurrott.com/windows/windows-10/189344/windows-10-version-1809-… The re-release of the "Feature Update 1809" i.e., the new version of windows for September '18, hence 1809, is deleting user's data, again. I strongly recommend you turn off Updates as best you can. I've set all our machines here to "Metered" connections and set "Feature" updates to a 365 day delay and Security updates to a 30 day delay. I think Windows has gotten too complex for MS to understand. Shadow directories and fake redirections and everything dependent not on the OS or the File System, but the Registry, may just be a step too far. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

12 26

Fwd: Urgent requirement for the position of : Programmer IV@ Torrance CA
by Richard Quilhot 08 Dec '18

08 Dec '18

Anyone looking for VFP gig in CA? Rick Q quilhotr(a)gmail.com ---------- Forwarded message --------- From: Kulwinder Singh <kulwinders(a)etalentnetwork.com> Date: Thu, Nov 29, 2018 at 5:20 PM Subject: Urgent requirement for the position of : Programmer IV@ Torrance CA To: <quilhotr(a)gmail.com> Hi, Currently, I am recruiting candidates for one of my requirement as mentioned below. If you have a matching profile, please send me the updated resume along with contact details at the earliest. *Job Title: Programmer IV Project Location : **Torrance CA* Skills Required and Job Description: *Visual FoxPro development experience required* Job Description/Skills Hours:8:00am to 5:00pm Work Week 1 - Monday, 2 - Tuesday, 3 - Wednesday, 4 - Thursday, 5 - Friday Description/Comment:Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs. May require an associate's degree in a related area and 5-8 years of experience in the field or in a related area. Familiar with standard concepts, practices, and procedures within a particular field. Relies on limited experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision; typically reports to a project leader or manager. A certain degree of creativity and latitude is required. Additional Job Details:Visual FoxPro development experience required. SQLServer experience a plus. Sincerely yours, KulwinderSingh E TalentNetwork http://etalentnetwork.com 8251 Greensboro Drive McLean VA kulwinders(a)etalentnetwork.com (877) 715-3865 Ext 1161 Note: Please allow me to reiterate that I have chosen to contact you either because your resume has been posted to one of the internet job sites to which we subscribe, or because you have previously submitted your resume to our company. I assumed that you are either looking for a new employment opportunity, or you are interested in investigating the current job market. If you would prefer I contact you at a later date, please indicate your date of availability so that I may honor your request. In any event, I respectfully recommend you continue to avail yourself to the employment options and job market information we provide with our e-mail notices. You have received this message because either you have contacted our Company to express interest in employment, or you have posted your Resume in an area accessible to recruiters or HR professionals, which implies an interest in being contacted regarding employment opportunities. If you would prefer to no longer receive any emails whatsoever from our Company, you may opt out at anytime by clicking here <http://jobs.tscti.com/optout.jsp?d=313231355f7175696c686f747240676d61696c2e…> . Lookup Candidate <http://jobs.tscti.com/employers/open_candidate.jsp?canid=039278604148737957…> --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 7

Re: Fwd: Urgent requirement for the position of : Programmer IV@ Torrance CA
by Gene Wirchenko 30 Nov '18

30 Nov '18

At 15:14 2018-11-29, Richard Quilhot <quilhotr(a)gmail.com> wrote: >Anyone looking for VFP gig in CA? Sure, but my CA is Canada. [snip] Sincerely, Gene Wirchenko

1 0

Re: Test One Two Three
by Gene Wirchenko 30 Nov '18

30 Nov '18

At 09:02 2018-11-29, Ted Roche <tedroche(a)gmail.com> wrote: >Four Five Six. > >Anybody home? Yes. That was close for you. Imagine missing out on Friday posts. Sincerely, Gene Wirchenko

1 0

MyODBC
by Graham Brown 29 Nov '18

29 Nov '18

Hi Does anyone know how to switch on the logging function in the ODBC driver please. MyODBC says use "option=4" in the sqlstringconnect but this doesn't appear to do anything. Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

Test One Two Three
by Ted Roche 29 Nov '18

29 Nov '18

Four Five Six. Anybody home? -- 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 5

[ADMIN] Problem with list archives
by mbsoftwaresolutions＠mbsoftwaresolutions.com 29 Nov '18

29 Nov '18

I wanted to review past posts for protecting your distributed EXEs. I recall I asked about this a couple years ago. I found this in my 'armadillo' search: https://leafe.com/archives/msg/506233 However, when clicking the "View entire thread" (https://leafe.com/archives/full_thread/506233) the site then failed and just said "No results were found. Please try again." (Flashing the big "E" in the sky for Ed Leafe to come save the day with the List management!!!!)

3 6

MyODBC not updating tables
by Graham Brown 28 Nov '18

28 Nov '18

Hello I've just had to revisit a foxpro app I wrote about 10 years ago. This just reads an excel spreadsheet, generates an SQL statement and fires it at a MySQL database. I'm using MyODBC 5.1 and Foxpro 8. This is a sample of the SQL. insert into aw_due (f_mem_rn,f_supplier_rn,f_mem_name,f_supp_name,f_date,f_value,f_mem_code,f_x ls_ref) values (544,0, 'AB ','An','1990/01/01',3735.49,'117 ','9999'); The code opens a connection with nMySQL=Sqlstringconnect("Driver=MySQL ODBC 5.1 Driver;SERVER=mysql.abc.com;UID={aw};PWD={test};DATABASE={aw16};port=52905") and sqlexec(nMySQL,cSQL) It has worked for years but the client recently moved to a new hosting company. No errors at runtime, no data arrives in the table but I can run these commands in PHPMyAdmin so the SQL commands are fine. Has anybody seen anything like this please? Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox November 2018