ProFox

profox@leafe.com

2704 discussions

"Cannot locate the Microsoft Visual FoxPro Support Library"
by Ted Roche 03 Feb '17

03 Feb '17

Hey, kids: I know I've gotten this working before, but it's Friday, and my IQ decreases exponentially as the weekend approaches. Ancient client install that mostly runs VFP7 SP1. They have a little utility app they run monthly to archive data. It's been "moved" to a new machine by one of their IT techs. Both the main app, running in VFP7SP1, and vFoxRun run fine on this machine, but clicking on this .EXE throws the error in the subject line. If I run the .EXE from the vFoxRun command window, it also runs okay. Hunh, what? I tried running regsvr32 on all the files in the c:\Program FIles\Common Files\Microsoft\VFP folder. I downloaded the VFP7SP1 and VFP9SP2 runtime installers from CodePlex. All ran with no errors. I don't recall the pedigree of the file. Is there any way we can get it to tell us what it is looking for? Up-to-date Windows 7 SP1 32-bit Dell Optiplex 9020, 4 Gb of RAM, black. What am I missing, besides the weekend? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

5 5

SQL Backend Question
by Paul H. Tarver 03 Feb '17

03 Feb '17

Ok, I've lurked here long enough. I've been subscribed to this list for several months and I have thoroughly enjoyed the questions and answers that have come through during that time. I'm even a little star-struck when I see the names of Foxpro experts that I have depended upon for years to help educate me to be a better Foxpro programmer. Thank you all for all you do in this list group. Now it is time for me to ask what is probably going to sound like a dumb question coming from someone who has been using Foxpro since Foxlan but I figure I have nothing to lose here and everything to gain. For the past few years I have been honing my skills as a developer of data interfaces and until recently, the few full-fledged data entry projects I've build relied upon native Foxpro dbf files. However, my interface work has been depending more and more upon using SQL pass-through language to issue queries against various SQL backend systems and I have been pretty successful at retrieving data from various systems and then re-formatting that data for other uses. For a while now, I've been contemplating building a data-entry and maintenance system from the ground up that depends completely upon using a SQL database (Firebird, MySQL, MS SQL, Postgres or something similar). My problem is that I have all these data handling classes built into a couple of simple toolbars that I can drop on form and provide the standard Add, Delete, Undo, Save and Exit functionality as well as a vcr toolbar to skip between records. These tools include all of the code necessary to detect changes enable various buttons based on conditions, etc. stuff we are all familiar with. Now I'm trying to wrap my head around the whole concept of changing the way I depend upon Foxpro to handle much of the behind the scenes table activity and create a new user interface that conforms to the how SQL works while maintaining as much of the familiar functionality I'm so happy with in Foxpro. Does anyone have any recommendations for where I should go to learn more about the best practices for developing user interfaces that work efficiently with SQL backends, and what do I need to know about how to collect data and insert it into the sql tables, detect user changes to flag for saving data. In some software they seemed to have ditched the Add, Delete, Undo, Save, Exit concept to just save everytime there is keystroke. And in other systems, they keep parts of that old style of user interaction. Are there any libraries that can be purchased or downloaded to handle some of the behind the scenes data manipulation for SQL that I can use to learn how this stuff should work. For something that seems to be easy, I'm having a hard time letting go of my 20+ years of doing things the Foxpro way to make the transition. Any thoughts? Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

9 15

DBF why you suck so bad.
by Alan Bourke 03 Feb '17

03 Feb '17

Of course they don't really, as evidenced by the fact they're still around after all these years. However if someone was unconvinced as to why SQL Server (or any other big-iron database like PostgreSQL, Maria, Oracle ) is better going forward, purely in terms of the data layer, what would you say in addition to the items below ? * Scalable * Secure in terms of authentication and authorisation * Not malware vector at a file level, as such * Can be backed up while in use * Logging * Speed especially with many connections * Modern reporting and analytics tools geared up to talk to it * Modern development stacks are designed to work with it * Cloud-deployable * Things that should happen server side can happen with sprocs * Multi-user locking and access won't be messed up inadvertently by future OS versions or patches * Supported Thanks -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

RE: CleverFox Backup
by Rick Schummer 01 Feb '17

01 Feb '17

Hi Mike, Sorry for the delay in responding, it is tax season and our software generates 1099s so my time for forums and this list is very limited. I'm glad I took a quick break and saw this today. Yes, I'm a partner at Forward Thinking Software along with Frank Perez. We started building it in late 2014, and went public at Southwest Fox 2015 by showing our beta version and getting feedback from other developers. It went into production in January 2016 and has been rolling for the last year. It has already saved several customers from multiple ransomware attacks, and many others from the normal common hardware failures and power problems, and of course protects from theft, fire and other natural disasters. SET MARKETING ON && for those who are not interested We built this product out of a need to protect our vertical market and custom software customers who do not have an IT person or do not do a good job at backups. It is something we have needed for several years, especially with the advent of the ransomware discussed. It turns out the process of doing the backups was not difficult (time consuming, yes), but the management of the backups, scheduling, monitoring, and reoccurring billing are not trivial. CleverFox Backup backs up VFP data (DBC and/or free tables) even if they are open in shared mode, something other backups sometimes fail to do, or will only do when they table gets closed. It also can do SQL Server backups too, which is perfect for those who are using SQL Server Express, or better. All on a scheduled basis, configurable to be done multiple times a day, week, or month. All it requires is Windows XP and better, and an Internet connection. Management of the backups is done via the Web-based management console either by the customer, their IT people, or you as the developer if given permission by the customer. Naturally it keeps a history of backups in the cloud, and even the local computer depending on how you configure it. Mostly it is a management of the gigabytes allotted. On-the-fly backups can also be initiated via the Web site. Monitoring can be done via the Web site. Emails are configurable upon success, failure or missing (in the case when the user shuts down the computer over the scheduled time). If backup is missed, the backup is performed soon after reboot once the service gets loaded and connects to the Web server. Restores can be initiated from the Web to copy the ZIP file down to the computer. You can also use the System Tray applet to download backups. Someone has to decompress the file from there. Frank also built a REST API for developers who want to interact with the data on the backend of our system too. We have sample code for VFP developers to interact with the API. All the data returned from the API shows up in cursors. The API is documented on the CleverFoxBackup.com site. Plans start as low as US$9.95 a month per device (normally the computer where the data resides). The lowest level works for most customers just fine as VFP data compresses with high efficiency. One side benefit we did not consider when we first put this together is the ability to use the backups to restore to a test folder, or bring down for diagnostics when the software is having a problem and it is related to data. I'm using this feature this morning to set up a test environment for a customer. I'm not just a partner, I am a user. We have this on our own servers, we have it on numerous customer servers and workstations, and several other developers are using it for their customers. We handle all the billing automatically on a monthly basis, and share revenue with partners who are referring their customers to use the software. Give me a call if you (or anyone else on the list) are interested. 586.254.2530. SET MARKETING OFF Rick White Light Computing, Inc. www.whitelightcomputing.com -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions(a)mbsoftwaresolutions.com Sent: Tuesday, January 10, 2017 10:23 To: profoxtech(a)leafe.com Subject: CleverFox Backup Rick's snippet from from my last thread: > Ransomware is probably the number one reason we get new subscriptions > to CleverFox Backup these days. People get hit, find giant hole in > their disaster recovery plan, and then get on with solid, scheduled > offsite backups. Rick -- This is the first I'm hearing about this software...sounds great! I'd love to recommend this to my few DBF clients. Is this your company? When did you start it? --Mike [excessive quoting removed by server]

8 13

ProFox List Statistics for January 2017
by List Administrator Account 01 Feb '17

01 Feb '17

================================================== ProFox List Statistics January 2017 ================================================== Subscriber Count at End of Month: ProFox: 287 ProFoxTech: 187 ================================================== Total Posts: 169 (Down 24.89% from December 2016) Total [OT] Posts: 0 (Down 100.0% from December 2016) Total [NF] Posts: 48 (Down 58.26% from December 2016) Daily Message Counts for January 2017 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 2 T 3 - 3 W 4 - 3 F 6 - 20 S 7 - 2 S 8 - 8 M 9 - 27 T 10 - 17 W 11 - 12 T 12 - 2 M 16 - 8 W 18 - 16 T 19 - 2 F 20 - 6 S 21 - 1 S 22 - 2 W 25 - 12 T 26 - 7 F 27 - 8 S 28 - 2 S 29 - 1 M 30 - 5 T 31 - 3 Message Counts By Day of Week for January 2017 ------------------------------------------------ DOW Count --- ----- Sun - 13 Mon - 40 Tue - 23 Wed - 43 Thu - 11 Fri - 34 Sat - 5 Distinct Posters to the List (changes relative to December 2016) ------------------------------------------------ Non-OT messages: 48 (Up 6.67%) OT messages: 0 (Down 100.0%) NF messages: 21 (Down 25.0%) Total number: 48 (Up 6.67%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 17 Dave Crozier 2. 15 mbsoftwaresolutions(a)mbsoftwaresolutions.com 3. 12 Ted Roche 4. 11 Alan Bourke 5. 10 Richard Kaye 6. 8 Stephen Russell 7. 7 Kurt Wendt 8. 6 Tracy Pearson 9. 6 Gene Wirchenko 10. 5 Mike Copeland 11. 5 Man-wai Chang 12. 5 Ed Leafe 13. 4 José Enrique Llopis 14. 4 Paul Hill 15. 4 Paul Newton 16. 3 AndyHC 17. 3 Fernando D. Bozzo 18. 3 Michael Madigan 19. 3 Peter Cushing 20. 2 List Administrator Account Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 20 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Alan Bourke 2. 5 Stephen Russell 3. 4 mbsoftwaresolutions(a)mbsoftwaresolutions.com 4. 3 Dave Crozier 5. 3 Ted Roche 6. 3 Mike Copeland 7. 3 Gene Wirchenko 8. 2 Ken Dibble 9. 2 Malcolm Greene 10. 2 Ed Leafe 11. 2 AndyHC 12. 2 Richard Kaye 13. 2 Michael Madigan 14. 2 Joe Yoder 15. 1 Fernando D. Bozzo 16. 1 Charles Hart Enzer, M.D. 17. 1 Ken McGinnis 18. 1 Wollenhaupt, Christof 19. 1 Kurt @ VR-FX 20. 1 Kurt Wendt Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 17 Dave Crozier 2. 15 mbsoftwaresolutions(a)mbsoftwaresolutions.com 3. 12 Ted Roche 4. 11 Alan Bourke 5. 10 Richard Kaye 6. 8 Stephen Russell 7. 7 Kurt Wendt 8. 6 Tracy Pearson 9. 6 Gene Wirchenko 10. 5 Mike Copeland 11. 5 Man-wai Chang 12. 5 Ed Leafe 13. 4 José Enrique Llopis 14. 4 Paul Hill 15. 4 Paul Newton 16. 3 AndyHC 17. 3 Fernando D. Bozzo 18. 3 Michael Madigan 19. 3 Peter Cushing 20. 2 List Administrator Account Top 12 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 Dave Crozier 2. 3 mbsoftwaresolutions(a)mbsoftwaresolutions.com 3. 2 List Administrator Account 4. 2 Joe Yoder 5. 2 Stephen Russell 6. 1 Ted Roche 7. 1 Tracy Pearson 8. 1 Kent Belan 9. 1 Charles Hart Enzer, M.D. 10. 1 Alan Bourke 11. 1 Andrew Stirling 12. 1 Gene Wirchenko Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 22 VFP tables likely victims for ransomware? 2. 20 3 days no posts.... 3. 17 [NF] It's PYthon not Py-THAWN. 4. 14 CleverFox Backup 5. 13 Has anyone implemented List & Label? 6. 12 New Year Brain Teaser... 7. 10 RIP Sytze 8. 9 Anybody there? 9. 6 [NF] LogMeIn security alerts 10. 6 [NF] Happy Holidays to All! 11. 6 [NF] Hardware vs Software Router/Firewall Recommendations 12. 6 Restrict access to multi clients 13. 6 Zooming fonts in FoxPro IDE code windows 14. 4 [NF] great disclaimer 15. 3 [NF] Related Comic 16. 2 RIP Sytze de Boer (was: Has anyone implemented List & Label?) 17. 2 [NF] Bowie interview on the Internet 1999 18. 2 Start the New Year with a brainteaser... 19. 2 [NF] Syslog server advice 20. 1 ProFox List Statistics for December 2016 Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 22 VFP tables likely victims for ransomware? 2. 20 3 days no posts.... 3. 17 [NF] It's PYthon not Py-THAWN. 4. 14 CleverFox Backup 5. 13 Has anyone implemented List & Label? 6. 12 New Year Brain Teaser... 7. 10 RIP Sytze 8. 9 Anybody there? 9. 6 [NF] LogMeIn security alerts 10. 6 [NF] Happy Holidays to All! 11. 6 [NF] Hardware vs Software Router/Firewall Recommendations 12. 6 Restrict access to multi clients 13. 6 Zooming fonts in FoxPro IDE code windows 14. 4 [NF] great disclaimer 15. 3 [NF] Related Comic 16. 2 RIP Sytze de Boer (was: Has anyone implemented List & Label?) 17. 2 [NF] Bowie interview on the Internet 1999 18. 2 Start the New Year with a brainteaser... 19. 2 [NF] Syslog server advice 20. 1 ProFox List Statistics for December 2016

1 0

[NF] Syslog server advice
by Joe Yoder 31 Jan '17

31 Jan '17

I'm thinking to setup a syslog server on my workstation to catch entries from a remote machine over the internet. Does anyone have a free favorite to recommend or warn against? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

[NF] Related Comic
by Gene Wirchenko 30 Jan '17

30 Jan '17

Hello: You might find this amusing: http://www.sheldoncomics.com/archive/120626.html Sincerely, Gene Wirchenko

3 2

3 days no posts....
by Dave Crozier 28 Jan '17

28 Jan '17

Just to let the rest of the world know we are still here! Dave

12 15

RE: 3 days no posts....
by Jerry Wolper 26 Jan '17

26 Jan '17

> I'm not really here - I'm just a hologram... I thought you were a 3-D print job. -Jerry --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

RE: 3 days no posts....
by Gene Wirchenko 26 Jan '17

26 Jan '17

At 09:58 2017-01-25, "Tracy Pearson" <tracy(a)powerchurch.com> wrote: >Dave Crozier wrote on 2017-01-25: > > Just to let the rest of the world know we are still here! >Good to know. Apparently I'm still here too. You are here? I thought I was the one doing that. Sincerely, Gene Wirchenko

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox