ProFox

profox@leafe.com

2704 discussions

FoxBin2Prg and DBF files
by Tracy Pearson 07 Feb '19

07 Feb '19

Does anyone that uses the FoxBin2Prg app convert DB2 files back to DBFs? >From the documentation it looks like it should convert back and forth. I'm getting the following error: 2019-02-07T16:32:52 ---------------------------------------------------------------------------- ------------------------ Error 1098, File [C:\Work\pconebody\PCOnebody_MetaData.db2] is not supported convert, 4087 FoxBin2Prg: [C:\WORK\TOOLS\FOXBIN2PRG\FOXBIN2PRG.EXE] (EXE Version: v1.19.51) tc_InputFile = [C:\WORK\PCONEBODY\PCONEBODY_METADATA.DB2] Source file: C:\Work\pconebody\PCOnebody_MetaData.db2

2 2

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

ProFox List Statistics for January 2019
by List Administrator Account 01 Feb '19

01 Feb '19

================================================== ProFox List Statistics January 2019 ================================================== Subscriber Count at End of Month: ProFox: 293 ProFoxTech: 182 ================================================== Total Posts: 166 (Up 163.49% from December 2018) Total [OT] Posts: 2 (Up 100.0% from December 2018) Total [NF] Posts: 15 (Down 44.44% from December 2018) Daily Message Counts for January 2019 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 2 T 3 - 11 F 4 - 7 S 5 - 1 S 6 - 5 M 7 - 10 T 8 - 12 W 9 - 30 T 10 - 28 F 11 - 7 S 12 - 2 S 13 - 3 M 14 - 8 T 15 - 5 W 16 - 2 M 21 - 6 T 22 - 2 W 23 - 2 T 24 - 6 S 26 - 3 M 28 - 7 T 29 - 7 Message Counts By Day of Week for January 2019 ------------------------------------------------ DOW Count --- ----- Sun - 8 Mon - 31 Tue - 28 Wed - 34 Thu - 45 Fri - 14 Sat - 6 Distinct Posters to the List (changes relative to December 2018) ------------------------------------------------ Non-OT messages: 34 (Up 9.68%) OT messages: 2 (Up 100.0%) NF messages: 8 (Down 55.56%) Total number: 34 (Up 9.68%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 17 Gene Wirchenko 2. 13 Ed Leafe 3. 12 Kurt @ Gmail 4. 11 Fletcher Johnson 5. 9 Richard Kaye 6. 9 Alan Bourke 7. 8 Tracy Pearson 8. 8 Frank Cazabon 9. 7 Koen Piller 10. 7 Ted Roche 11. 7 Fernando D. Bozzo 12. 7 mbsoftwaresolutions(a)mbsoftwaresolutions.com 13. 6 Dave Crozier 14. 4 Charles Hart Enzer, M.D. 15. 4 Peter Cushing 16. 3 John Weller 17. 3 Jean Laeremans 18. 3 Paul Newton 19. 3 Man-wai Chang 20. 2 Malcolm Greene Top 2 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ 1. 1 50% Adam Buckland 2. 1 14% Dave Crozier Top 8 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 Fletcher Johnson 2. 2 Charles Hart Enzer, M.D. 3. 2 Kurt @ Gmail 4. 2 Alan Bourke 5. 2 Ed Leafe 6. 1 <juergen(a)wondzinski.de> 7. 1 Koen Piller 8. 1 Kurt at VR-FX Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 17 Gene Wirchenko 2. 13 Ed Leafe 3. 12 Kurt @ Gmail 4. 11 Fletcher Johnson 5. 9 Richard Kaye 6. 9 Alan Bourke 7. 8 Tracy Pearson 8. 8 Frank Cazabon 9. 7 Koen Piller 10. 7 Ted Roche 11. 7 Dave Crozier 12. 7 Fernando D. Bozzo 13. 7 mbsoftwaresolutions(a)mbsoftwaresolutions.com 14. 4 Charles Hart Enzer, M.D. 15. 4 Peter Cushing 16. 3 John Weller 17. 3 Jean Laeremans 18. 3 Paul Newton 19. 3 Man-wai Chang 20. 2 Malcolm Greene Top 12 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 Fletcher Johnson 2. 2 List Administrator Account 3. 2 Tracy Pearson 4. 2 Gene Wirchenko 5. 2 <juergen(a)wondzinski.de> 6. 2 Adam Buckland 7. 1 Charles Hart Enzer, M.D. 8. 1 Johan Nel 9. 1 Kurt @ Gmail 10. 1 Ed Leafe 11. 1 Paul Newton 12. 1 Alan Bourke Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 AW: Custom Scrollbar 2. 32 [ADMIN] Testing new mail relay 3. 18 VSS to git conversion 4. 11 [NF] Looking for a little Python/Django help 5. 10 Hey, can you test this... 6. 9 ProFox List Statistics for 2018 7. 8 Custom Scrollbar 8. 6 Converting .scx to .prg 9. 5 Moving/dragging form leaves a trail of images of the form behind it 10. 5 VFP Work in San Diego??? 11. 4 The future of Xbase 12. 4 ERD with a table with strange keys 13. 4 This is a test please ignore. 14. 2 [NF] Microsoft Account 15. 2 VFPx Project Explorer and git 16. 2 Google API for Geocoding ... Again 17. 1 [ADMIN] This is a test please ignore. 18. 1 ERD with a table with strange keys 19. 1 AW: [NF] Microsoft Account 20. 1 ProFox List Statistics for December 2018 Top 1 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 2 [OT] : Hello (Again) Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 AW: Custom Scrollbar 2. 32 [ADMIN] Testing new mail relay 3. 18 VSS to git conversion 4. 11 [NF] Looking for a little Python/Django help 5. 10 Hey, can you test this... 6. 9 ProFox List Statistics for 2018 7. 8 Custom Scrollbar 8. 6 Converting .scx to .prg 9. 5 Moving/dragging form leaves a trail of images of the form behind it 10. 5 VFP Work in San Diego??? 11. 4 The future of Xbase 12. 4 ERD with a table with strange keys 13. 4 This is a test please ignore. 14. 2 [OT] : Hello (Again) 15. 2 [NF] Microsoft Account 16. 2 VFPx Project Explorer and git 17. 2 Google API for Geocoding ... Again 18. 1 [ADMIN] This is a test please ignore. 19. 1 ERD with a table with strange keys 20. 1 AW: [NF] Microsoft Account

1 0

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

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox