ProFox October 2017

profox@leafe.com

53 participants
61 discussions

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

[NF] Open systems Drive you crazy
by Stephen Russell 15 Nov '17

15 Nov '17

Great watch here. Super Hacker George Hotz: I Can Make Your Car Drive Itself for Under $1,000 https://www.youtube.com/watch?v=aqdYbwY9vPU I like how he looks at a problem. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

14 26

[NF] LogMeIn -- Richard
by mbsoftwaresolutions＠mbsoftwaresolutions.com 07 Nov '17

07 Nov '17

What version are you using, Richard? LMI Pro, or LMI Rescue?

3 9

How many of you use foreign key constraints and References in your database schema?
by mbsoftwaresolutions＠mbsoftwaresolutions.com 02 Nov '17

02 Nov '17

At the day gig, they use FK constraints and References in their Oracle database schema. Honestly, I got into that years ago with VFP but then kinda fell off that wagon over the years, preferring to just handle some things in the BizObj of the solution rather than put more rules in the backend database. The idea was that if I changed backend databases, I wouldn't need to rewrite a whole bunch of specific DBMS code. Where's your preference in design with these in mind?

8 13

VFP10 Advanced was FoxPro DevCon in Frankfurt
by Dave Crozier 01 Nov '17

01 Nov '17

About time we had a discussion section for this. Must admit it had flown under my radar until the reference to it was posted here. Any more information from anyone may be welcome to us all. Dave --------------------------------------------------------------- This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --------------------------------------------------------------- Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time

8 20

[NF] INT vs MEDIUMINT vs SMALLINT vs TINYINT
by mbsoftwaresolutions＠mbsoftwaresolutions.com 31 Oct '17

31 Oct '17

Ok, in today's "the sky is the limit" (in terms of space), do we really care about 1 or 2 bytes for an integer field type for a primary key? I'm redesigning FabMate Classic to use a MySQL (MariaDB) database backend now because my client is still experiencing problems with the VFP database (index problems, etc.). His network guy (as usual) says everything on the Windows Server 2016 network is fine and the problems only started when they upgraded the client workstations from Win7 to Win10. Whatever. This thread is about primary key size WHEN YOU KNOW THAT THE MAX VALUE WON'T GO OVER (whatever the limit is at each field type: 255 for tinyint, etc.) The OCD part of me wants to define the smallest type possible, whereas the "let's set it and never worry about it" part of me says "just make everything INT." Weigh in on your thoughts on which type you'd use. tia, --Mike

7 25

[NF] Firefox Focus: "the privacy browser"
by mbsoftwaresolutions＠mbsoftwaresolutions.com 30 Oct '17

30 Oct '17

Interesting...just saw this today: https://play.google.com/store/apps/details?id=org.mozilla.focus

1 0

FoxPro DevCon in Frankfurt
by Jürgen Wondzinski 30 Oct '17

30 Oct '17

Hi guys, just a shameless marketing towards the 24th FoxPro DevCon in Frankfurt, with english sessions from Tamar Granor, Doug Hennig and Rick Schummer! Especially interesting will be Dougs newest thing: a complete rewrite of VFPs Project Manager, which is then called Project Explorer. Also dont miss Ricks session about Thor enhancements (and you could then ask for the changes with GitHub :) or fighting DataCorruption and adding Graphics to your apps) Take a look at http://devcon.dfpug.de/ , you cant get a better deal than that. And if that speaker list doesnt provide you enuf value, then what about Plenty of german food, and free beer at night! :) Its Thursday til Saturday 16th to 18th November, in OberUrsel, a small but romantic town north of Frankfurt. No need to organize a car, you have public transportation from airport up to the hotel. Pricing is a little bit irritating, since there are several discounts you could apply for if youre a German Usergroup member, or an EarlyBird-Booker or had previous visits. You also could visit only one or two or all three days If in doubt just email the organizer directly at konferenz(a)dfpug.de Hope to see you at DevCon! wOOdy "*´¨) ¸.·´¸.·*´¨) ¸.·*¨) (¸.·´. (¸.·` * .·`.Visual FoxPro: It's magic ! (¸.·``··*

10 21

WG: recno() function in tsql
by Jürgen Wondzinski 30 Oct '17

30 Oct '17

Von: rafael.copquin [mailto:rafael.copquin@gmail.com] Gesendet: Donnerstag, 26. Oktober 2017 22:09 An: Jürgen Wondzinski <juergen(a)wondzinski.de> Betreff: RE: AW: AW: recno() function in tsql That's it. Thank you Rafael Enviado desde mi dispositivo Samsung -------- Mensaje original -------- De: Jürgen Wondzinski <mailto:juergen@wondzinski.de> Fecha: 26/10/2017 12:18 (GMT-03:00) A: 'Rafael Copquin' <mailto:rafael.copquin@gmail.com> Asunto: AW: AW: recno() function in tsql Hi Rafael, ah, you want a freshly generated SEQUENCE number of your foundset. See this: https://stackoverflow.com/questions/13100000/how-can-i-create-a-temporary-s… wOOdy -----Ursprüngliche Nachricht----- Von: Rafael Copquin [mailto:rafael.copquin@gmail.com] Gesendet: Donnerstag, 26. Oktober 2017 17:09 An: Jürgen Wondzinski Betreff: Re: AW: recno() function in tsql Hi Woody It's been a long time! Welcome back! FYI, I always build all my tables with autoincrementing primary keys. In this particular case the table I am dealing with has 10000 records. The primary keys go from 1 to 10000. But i want to select a small set based on a date range (it is a sales table) I just want the first column of the selected cursor to contain the record number and the other columns the rest of the data. So I should be getting something like this: RecordNo ID Date etc 1 5421 2017-06-15 2 5422 2017-06-15 3 5423 2017-06-16 etc Rafael El 26/10/2017 a las 12:00, Jürgen Wondzinski escribió: > In SQL each record has to have a PrimaryKey (Field) for identifying it, since SQL doesn't know of records, it knows about result-sets instead. > > The RECNO() in xBase is just the same concept: a unique identifier for the current session, not meant for a longterm relation setting. If you designed your SQL table without a unique identifier, then you're out of luck :) > > > wOOdy > > -----Ursprüngliche Nachricht----- > Von: ProFox [mailto:profox-bounces@leafe.com] Im Auftrag von Rafael Copquin > Gesendet: Donnerstag, 26. Oktober 2017 16:34 > An: profox > Betreff: recno() function in tsql > > Is there an equivalent to the VFP recno() function in T-SQL? > > I'd like to create the following select statement in T-SQL: > > select recno(),otherfields..... from database.dbo.table > > If there is not, what would be a substitute? > > Rafael Copquin > > > [excessive quoting removed by server]

4 8

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox October 2017