ProFox April 2018

profox@leafe.com

36 participants
51 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] Maybe THIS is the year for Linux....lol
by mbsoftwaresolutions＠mbsoftwaresolutions.com 09 Aug '18

09 Aug '18

http://tech.firstpost.com/news-analysis/the-great-linux-game-25-years-and-m… How many times have they said "Maybe this year!?!?!"

4 6

AGETFILEVERSION Fail
by Paul H. Tarver 02 May '18

02 May '18

Has anyone ever had any problem with AGETFILEVERSION() failing to return values after an ODBC connection is made? I'm using the Oracle ODBC Driver and until the SQLCONNECT() command is issued AGETFILEVERSION() works perfectly. After I issue the SQLCONNECT() command and get a valid handle, AGETFILEVERSION() will not return any values. I have to exit VFP and restart it, then, AGETFILEVERSION() works again until I make another connection to Oracle via ODBC. I've used the Oracle's ODBC driver previously with no ill affect. But now.Grrrrrr! Paul --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 15

Class Definition Not Found
by Chris Davis 02 May '18

02 May '18

Bit of a vague question but is anyone aware of any mis match of run time DLL's that might result in the error message in the subject. Maybe the VFP runtimes or the VC ones. Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 13

VFP runtimes link
by mbsoftwaresolutions＠mbsoftwaresolutions.com 30 Apr '18

30 Apr '18

https://github.com/VFPX/VFPRuntimeInstallers Just FYI for the ProFox archives. Thanks to wOOdy for emailing this to my corporate account.

1 0

Resetting VFP
by Gene Wirchenko 27 Apr '18

27 Apr '18

Hello: Sometimes, the coding is a breeze, and sometimes, it is not. Suppose, because of bugs, incomplete functionality, etc., you have just hung up VFP. Is there a way to reset VFP? Something that always works? I know I can abort it and then restart it, but I have had to do so dozens of times. The thrill palls. Sincerely, Gene Wirchenko

5 4

Re: VFP TSQL concordance
by Brant E Layton 27 Apr '18

27 Apr '18

I call SQL stored procedures, sending just a string containing parameters, frequently. Build the string containing the EXEC call, with the parameters, and send it off via ODBC... *Brant Layton* *Principal Consultant* *Digital Computing and Consulting, Inc.* 480.964.1316 On 4/27/2018 8:04 AM, profoxtech-request(a)leafe.com wrote: > Re: VFP TSQL concordance --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

Re: Resetting VFP
by Gene Wirchenko 27 Apr '18

27 Apr '18

At 10:42 2018-04-27, Fred Taylor <fbtaylor(a)gmail.com> wrote: >On Fri, Apr 27, 2018 at 10:21 AM, Gene Wirchenko <genew(a)telus.net> wrote: > > > Hello: > > > > Sometimes, the coding is a breeze, and sometimes, it is not. > > > > Suppose, because of bugs, incomplete functionality, etc., you have > > just hung up VFP. > > > > Is there a way to reset VFP? Something that always works? > > > > I know I can abort it and then restart it, but I have had to do so > > dozens of times. The thrill palls. >CANCEL >CLOSE ALL >CLEAR ALL > >usually works for me. I meant hung up, when VFP is not accepting command input. Sincerely, Gene Wirchenko

2 1

VFP TSQL concordance
by Paul Newton 27 Apr '18

27 Apr '18

Hi all There is a document in Ed's download area giving concordances between VFP(6) and VB6. I am looking for something similar showing concordances between VFP and TSQL. Has anybody come across such an animal? Many thanks Paul Newton

4 5

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2018