ProFox

profox@leafe.com

2704 discussions

Virtual Fox Fest 2021 (Oct): Call for Speakers
by Rick Schummer 21 May '21

21 May '21

We're excited to offer you Virtual Fox Fest 2021 (October), a three-day online conference presenting the latest in Microsoft Visual FoxPro development techniques and interoperability with other technologies. This conference provides a venue for VFP developers to come together virtually to learn more about how our fellow developers are using and extending VFP. For details about Virtual Fox Fest, please see https://virtualfoxfest.com. The conference is going to be on October 14th, 20th, and 26th, 2021. We've issued the Call for Speakers (https://virtualfoxfest.com/CallForSpeakers.aspx) for Virtual Fox Fest. If you are interested in presenting, please read the document referenced in that page and consider submitting sessions. Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Navigating structure using list boxes?
by Joe Yoder 21 May '21

21 May '21

I am an infrequent user of VFP and have never mastered the GUI. I need to allow a user to choose storage locations from the structure below for several fields on a screen where the possible choices are in a structure several layers deep. Is there a control to handle this or a simple way to roll my own? This is a simple representation of the locations to chose from.: Shop/Cabinet/Shelf1 Shop/Cabinet/ Drawer1 Shop/Bench/Shelf1 Office/Bench/Drawer1 Office/Cabinet/ Drawer1 Office/Cabinet/Shelf1 Office/Bench/Shelf1 Office/Bench/Drawer1 Trailer/Bench/Drawer1 Trailer/Cabinet/ Drawer1 Trailer/Cabinet/Shelf1 TrailerBench/Shelf1 Trailer/Bench/Drawer1 Even though the Drawers and Shelves appear to repeat they are all different and can add up to 150 choices for a location in my office. I clearly do not want to scroll through the entire list to make a choice. Any help would be appreciated. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 3

Searching classes and forms for something specific
by Tracy Pearson 20 May '21

20 May '21

Is there a search tool out there that can search for criteria such as the following: The Column.Sparse is set to False. That same Column has a TextBox baseclass in it. I have already slowly parsed most instances of the Sparse property in my search. I know I can write something that can search for this specific query as well. I'm curious if there is a tool to help in the future. Thank you, Tracy

5 6

<> "" vs. NOT EMPTY(field1) in SQL and the former is better than the latter
by MB Software Solutions, LLC 12 May '21

12 May '21

In case you weren't aware that NOT EMPTY appears to be unable to use Rushmore optimization... There is a regular index on the order.srep field. I added the SETs to emulate the environment per legacy code. The results are why I changed the original author's NOT EMPTY(field1) SQL to field1 <> "" instead: CLEAR OPEN DATABASE c:\temp\test SHARED SET ANSI OFF SET EXACT OFF SET NEAR ON LOCAL lcOpt as String ? SYS(3054,12,"lcOpt") SELECT distinct srep FROM test!order WHERE srep <> "" INTO CURSOR crap #IF .F. Results: SELECT distinct srep FROM test!order WHERE srep <> "" INTO CURSOR crap Using index tag Srep to rushmore optimize table order Rushmore optimization level for table order: partial #ENDIF SELECT distinct srep FROM test!order WHERE NOT EMPTY(srep) INTO CURSOR crap #IF .F. Results: SELECT distinct srep FROM test!order WHERE NOT EMPTY(srep) INTO CURSOR crap Rushmore optimization level for table order: none #ENDIF -- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com

1 1

SET ANSI OFF
by MB Software Solutions, LLC 12 May '21

12 May '21

I was investigating why a simple query (SELECT DISTINCT srep FROM order WHERE srep <> "") worked on my machine and yet when deployed, it did NOT work. Instead of returning several dozen names, it was returning zero. Now..."why did it work before?" Well, I had changed the query from using WHERE NOT EMPTY(srep) to what you see at the top of this post. I figured it was the SET ANSI and confirmed it. I see the original developer explicitly says in the startup code SET ANSI OFF. I just can't understand why. This is very old code so I ask those who've been in the Fox game since 2.x days---was this an advantage when using some sort of xBase approach? I realize from VFP help that SET ANSI ON basically makes sure string comparisons are of equal length. I'm nervous about changing the value at startup because there are probably areas where the code is COUNTING on it. I see they also have SET NEAR ON and SET EXACT OFF. I guess code where I'm putting my own SQL in there (or changing it), I should save their settings, set as I would normally work (EXACT ON, ANSI ON, NEAR OFF), and then restore their settings. Kinda like that WorkAreaSave class that I learned (from Andy/Marcia?) way back when to use a lightweight class in a local variable to save the current work area when you start a procedure/function and then it restores it because the LOCAL variable is released on exit. -- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com

1 0

Free Windows 10 development VMs
by Alan Bourke 11 May '21

11 May '21

FWIW, for Windows 10 application development and testing purposes you can download free virtual machines for VMWare, Hyper-V, Virtualbox and Parallels from: https://developer.microsoft.com/en-us/windows/downloads/virtual-machines/?W… These VM images come with these items pre-installed. * Windows 10, version 2004 (10.0.19041.0) * Windows 10 SDK, version 2004 (10.0.19041.0) * Visual Studio 2019 <https://developer.microsoft.com/windows/downloads?WT.mc_id=-blog-scottha> with the UWP, .NET desktop, and Azure workflows enabled and also includes the Windows Template Studio extension * Visual Studio Code * Windows Subsystem for Linux enabled with Ubuntu installed * Developer mode enabled The catch? They expire, although not for two months. Great for testing or messing around without screwing up your main dev environment. -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

RE: Drag and Drop code
by Jürgen Wondzinski 08 May '21

08 May '21

Just wondering: Why not use Grids with AllowCellSelection = .f. and HighLightStyle = 2 ? You'll get so much more possibilities (optical as well as technical) in comparison to Listboxes But back to your problem: So you want to drag players from the left list to any of those Team groups as well as criss-cross ? wOOdy -----Ursprüngliche Nachricht----- Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von MB Software Solutions, LLC Gesendet: Montag, 3. Mai 2021 21:44 An: ProFox Email List <profox(a)leafe.com> Betreff: Drag and Drop code Many many moons ago I did some drag and drop code, but I have forgotten completely and it's no longer in my possession anyway. I want to drag names amongst a screen full of listboxes: https://www.screencast.com/t/6M8XxvSFV I know I need to code in the OLEDragDrop event and native VFP Help sucks, not really showing me anything. I was thinking the oDataObject was the listbox where the drag started but no. I tried to SET STEP ON but VFP says "CANCEL or SUSPEND is not allowed." LPARAMETERS oDataObject, nEffect, nButton, nShift, nXCoord, nYCoord LOCAL loLB as ListBox loLB = oDataObject wait window loLB.ListCount && this fails SET STEP ON && this doesn't work either I have the properties set correctly to allow me to drag from one list to another but now I'm stuck. Going to search the archives next but throwing this out there in the meantime. Was hoping to have drag/drop implemented by the time I had a ZOOM call with my fellow hockey captains to set the teams tonight! tia, --Michael -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server]

2 6

_framewk,vct is missing or invalid, but it isn't and it's not.
by Ted Roche 04 May '21

04 May '21

Rebuilding a project that includes c:\program files (x86)\microsoft visual foxpro 9\wizards\_framewk.vcx gives the error Memo file c:\program files (x86)\microsoft visual foxpro 9\wizards\_framewk.VCT is missing or invalid. But it isn't and it's not. I copied both _framewk files from another machine where it works, no change. I opened the file exclusively and tried to PACK and get the same error. I copy the two files to C:\temp and they pack fine, and compile classlib works there (after I also copied over _framewk.h) but moving the files back to the above directory and attempting a build project, rebuild all throws the same error. This is a permissions issue with the program files (x86) folder and I've tried turning off the "Read Only" settings and in the folder permissions granting Modify and Write to the Users group, but the errors continue. Any suggestions on how to get the Program files (x86) to be read-write for VFP? Moving the files to the project folder would be my preference, but it is not my project. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 16

Drag and Drop code
by MB Software Solutions, LLC 03 May '21

03 May '21

Many many moons ago I did some drag and drop code, but I have forgotten completely and it's no longer in my possession anyway. I want to drag names amongst a screen full of listboxes: https://www.screencast.com/t/6M8XxvSFV I know I need to code in the OLEDragDrop event and native VFP Help sucks, not really showing me anything. I was thinking the oDataObject was the listbox where the drag started but no. I tried to SET STEP ON but VFP says "CANCEL or SUSPEND is not allowed." LPARAMETERS oDataObject, nEffect, nButton, nShift, nXCoord, nYCoord LOCAL loLB as ListBox loLB = oDataObject wait window loLB.ListCount && this fails SET STEP ON && this doesn't work either I have the properties set correctly to allow me to drag from one list to another but now I'm stuck. Going to search the archives next but throwing this out there in the meantime. Was hoping to have drag/drop implemented by the time I had a ZOOM call with my fellow hockey captains to set the teams tonight! tia, --Michael -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

2 2

VFP9 (and VFPA) on Windows 10 -- wish Mr. Chen would fix the visual bugs!
by MB Software Solutions, LLC 03 May '21

03 May '21

I finally moved my dev to a Windows 10 laptop. Was using Win7 forever prior. The window dialog border "phantoms/shadows" is very annoying. It'd be great if Mr. Chen fixed in addition to the other bugs he's fixed! (I think I have his name wrong...I've looked on his http://www.baiyujia.com/vfpadvanced/f_vfpa_gotovfpa64.asp site but I just see CCB)

4 6

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox