ProFox March 2018

profox@leafe.com

48 participants
49 discussions

Miriam Liskin
by Richard Kaye 22 Mar '18

22 Mar '18

I hadn't heard that name in ages until it popped up in my RSS feed for the Fox WIKI. http://fox.wikis.com/wc.dll?Wiki~MiriamLiskin R.I.P. -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 5

Error 108 on an INSERT INTO MyVFPTable
by mbsoftwaresolutions＠mbsoftwaresolutions.com 22 Mar '18

22 Mar '18

VFP9SP2 app/Win10 Pro workstation/Win2012 Server Got a bug report from a client today that threw a 108 "File is in use by another user" on an INSERT INTO statement (all VFP9 dbc tables). Found it interesting that the VFP Help file says that's on a USE, DELETE, or RENAME command (but not INSERT INTO).

7 11

_VFP vs _SCREEN
by mbsoftwaresolutions＠mbsoftwaresolutions.com 22 Mar '18

22 Mar '18

(I checked the ProFox archive but searching for _VFP _SCREEN (with underscore, with underscored escaped, and without underscore) did not turn up any matches or at least the ones applicable). I know we've discussed this somewhere in the past but could not find the reference.) I was adding another "global" application attribute for a signal flag for later code to reference, and I realized I've always used the _SCREEN object. Would seem more logical to reference the _VFP object. Your thoughts on this design decision? tia, --Michael

4 5

Silent/behind-the-scenes installation of MariaDB from VFP (or from Inno Setup)
by mbsoftwaresolutions＠mbsoftwaresolutions.com 20 Mar '18

20 Mar '18

I'm going to be distributing a free single user (localhost) version of one of my VFP9SP2 fat client apps, and I'd like to install MariaDB behind the scenes easily (meaning without me having to manually install it on every machine). Does anyone have experience with exactly or something like this (preferably the former!) ? tia, --Mike

2 1

Testing tells the tale (SYS 3054) -- "BETWEEN(a,b,c)" equivalent to "a BETWEEN b and c"
by mbsoftwaresolutions＠mbsoftwaresolutions.com 20 Mar '18

20 Mar '18

VFP9SP2 WestWind WebConnection App on WinServer 2012 I was looking at a notoriously slow query to see about optimizing it. Using SYS(3054,11,"cmemvar"), I was able to do so, but during my testing, I found that using MyDate BETWEEN Arg1 and Arg1 was the same optimization-wise as BETWEEN(MyDate,Arg1,Arg2). Somewhere in history, I thought that using VFP's native BETWEEN(field,d1,d2) was NOT Rushmore friendly. However, testing with SYS(3054) showed otherwise! Just an interesting find this weekend for me whilst debugging. Carry on! --Mike

5 6

VFP Service
by Chris Davis 16 Mar '18

16 Mar '18

Hi All In the past I have followed this article https://blogs.msdn.microsoft.com/calvin_hsia/2004/12/13/creating-a-vfp-appl… Does anyone have any advice about how to approach this on Server 2016 as I believe SRVANY is no longer an option. Regards Chris --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 6

[NF] Reporting in Python (Django)
by Ajit Abraham 14 Mar '18

14 Mar '18

Hello everybody, I am exploring Django for my next project. Most of the examples that I found is making the report in html and then exporting it to a pdf. Having worked (and still working) with Visual Foxpro reports, all these years, I am looking out for a similar experience with Django/Python. I tried Gaetan's Appy Framework which takes an odt document as template and merges with xml data to produce pdf via a service which has to run in the background. It is ok, but it is stuck with the old version of Python and I had great difficulty in attempting complex VFP type of reports. Then I looked at JasperReport. I can design the report using JasperReport Studio. But still there are too many steps involved in spitting out the pdf. Before I make the final leap to Jasper, I want to ask those who are working with Python - as to what they are using for a GUI reporting tool similar to VFP and that which does not involve a reporting service to be run in the background! Thanks Ajit Abraham

11 27

Using the files on github
by Michael Savage 13 Mar '18

13 Mar '18

I want to play gain. How can I download the latest project files. I'm looking at OOP menu, THOR etc. Mike --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 5

Using Thor from github
by Michael Savage 12 Mar '18

12 Mar '18

Can I use Thor tools from github? if so how? TIA, Mike --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

How to block internet access from within a VFP executable
by Paul Newton 12 Mar '18

12 Mar '18

Hi all I have a VFP executable (MyExecutable.EXE) which has a form containing an OLEBrowser control. I want to temporarily block internet access from this form using the Windows (7) firewall. I have created a new Outbound Rule pointing to MyExecutable.EXE but the form still loads and displays a web page. Any ideas? Many thanks Paul Newton

5 13

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox March 2018