ProFox October 2020

profox@leafe.com

21 participants
13 discussions

Need way to change user to access protected folder
by Fred Taylor 17 Nov '20

17 Nov '20

Anybody have a way to change the user while an app is running so I can access a protected folder? Haven't done much Windows API in quite some time. Fred --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 9

now it is cxi files
by Rafael Copquin 26 Oct '20

26 Oct '20

Last week I wrote about this old VFP5 app that I inherited which had some files with the phd extension. I never had heard or encountered that kind of files but Dave Crozier helped me with them. However, digging more deeply into this old app (which BTW I need to upgrade to VFP9 and add some perks to it), I found that some of the DBF's are wrapped into a file with the CXI extension. Fortunately the old source code has the original program that wraps the dbfs into a CXI file. I thought all I had to do was recomplile in VFP9, but to my surprise, the dll available only works with VFP5 So my questions are: 1) how can I get the dll that works with VFP9 (I am not sure that there is an update for VFP9) 2) if there is not an update, then how can I get a VFP5 so I can compile my new code and make the CXI routines work. I'll appreciate some help on this Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

Tomorrow is the last day of Virutal Fox Fest
by Tracy Pearson 26 Oct '20

26 Oct '20

Hello Everyone! I have been enjoying chatting with people and getting to see some faces of people for the first time. The sessions have been worth the time to watch live. There is a lot of chatter in the chat window as well. I haven't been paying attention to the chat much. Maybe I'll get a chance to put some more faces to the names I see here. Have a good one! Tracy

5 5

COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?
by MB Software Solutions, LLC 26 Oct '20

26 Oct '20

VFP9SP3 Why would a COUNT FOR hang ("Attempting to lock") whereas my easy workaround is SELECT COUNT(*) FROM SomeCursor WHERE <<yada yada yada>> ?? tia, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

5 18

This SQL didn't update just one record but ALL records....OOPS!!!!!
by MB Software Solutions, LLC 26 Oct '20

26 Oct '20

VFP9SP2 using DBC tables. The curWorkingGroup cursor had just ONE record in it. The Carriers_To_Process table (PK = IID field) has tens of thousands. The idea is that I'm just processing small sections at a time from Carriers_To_Process. Rather than update the one or two records in the curWorkingGroup cursor that are a subset of the Carriers_To_Process, it updated ALL of the records in Carriers_To_Process, basically not respecting the JOIN condition. UPDATE carriers_to_process ; SET cSession = this.cSession ; FROM carriers_to_process p1 ; INNER JOIN curWorkingGroup g1 on g1.iid = p1.iid What's wrong with my code for this simple UPDATE SQL ? Here's the full segment to put it in context (with curToDo being the subset of Carriers_To_Process and curUniques being the unique ven_id field (so that we don't process a ven_id twice): SELECT COUNT(*) FROM curUniques WITH (BUFFERING=.T.) WHERE lSelected INTO ARRAY laCnt liTotal = NVL(laCnt[1],0) SELECT curUniques SCAN FOR lSelected && FOR EMPTY(tProcessed) AND EMPTY(tError) AND EMPTY(tignored) AND ondemand = m.tlOnDemand liCnt = liCnt + 1 _screen.Caption = "Processing " + ALLTRIM(curUniques.ven_name) + " (" + ALLTRIM(STR(curUniques.ven_id)) + ") - " + ALLTRIM(STR(liCnt)) + " of " + ALLTRIM(STR(liTotal)) *** mjb 10/23/2020 - mark the session for the ones we're processing so that subsequent runs aren't grabbing them from the initial query above SELECT iid ; FROM curToDo ; WHERE ven_id = curUniques.ven_id ; INTO CURSOR curWorkingGroup READWRITE UPDATE carriers_to_process ; SET cSession = this.cSession ; FROM carriers_to_process p1 ; INNER JOIN curWorkingGroup g1 on g1.iid = p1.iid IF this.GetRecords('tmp',curUniques.ven_id) = 1 THEN UPDATE carriers_to_process ; SET tProcessed = DATETIME() ; FROM carriers_to_process p1 ; INNER JOIN curWorkingGroup g1 on g1.iid = p1.iid ELSE UPDATE carriers_to_process ; SET tError = DATETIME() ; FROM carriers_to_process p1 ; INNER JOIN curWorkingGroup g1 on g1.iid = p1.iid ENDIF && this.GetRecords('tmp',curUniques.ven_id) USE IN SELECT('curWorkingGroup') ENDSCAN && carriers_to_process I can revert to a simple xBASE approach with SCAN and SEEK/REPLACE but figured the UPDATE SQL was more elegant and easier to view. ;-) tia, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

3 3

[NF] Only in Silicon Valley!
by Kurt Wendt 20 Oct '20

20 Oct '20

A buddy of mine sent me this on LinkedIn - I thought it was pretty darnn funny - and I thought it would be a perfect thing to share with you folks: https://media-exp1.licdn.com/dms/image/C5622AQEWmcdYTvXRRg/feedshare-shrink… -K- --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

My memo field(s) Are Bloated......
by Desmond Lloyd 17 Oct '20

17 Oct '20

Good Morning! Have a very wide dbf with about 8 memo fields . Started acteing strange like if I tried to re-index or pack memo it would seem to go so far and then freeze! Found a utility that seemed to repair the file. The only issue is that the DBF is 710mb and the associated memo file is 1.2gb! Yikes. Have ran a pack memo (with no issues) and there is no change in the size of the memo file, which I am assuming is boated. 1.) Is the memo file really bloated. 2.) Going to look at the individual memo fields and see if any one of the records has an unusually large memo field. 3.) Open to any other suggestion that you wise people could recommend.... TIA/Regards, Desmond --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 8

Virtual Fox Fest
by MB Software Solutions, LLC 17 Oct '20

17 Oct '20

Anybody else having trouble viewing the webinar? -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

5 9

Day one Virtual FoxFest has begun
by Richard Kaye 16 Oct '20

16 Oct '20

As far as I know it's not too late to register. 2 good sessions so far on SQL security and a graphics library that can be used in VFP. And cheers to Ted Roche for being a sponsor! -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 5

phdbase
by Rafael Copquin 14 Oct '20

14 Oct '20

Hi guys, it's been e long time! I just inherited an old vfp5 program that needs to be updated to VFP9, adding new routines to enhance performance and migrate the dbf's to sql server. I encountered some dbfs that have an additional file with a phd extension which I believe is generated by a program that facilitates text searches in memo files. I try to open the dbf but vfp9 says that it can't find the phd file, even though the dbf, its cdx and phd files are in the same folder. I tried to set tablevalidate to 0, set exclusive on but to no avail How can I open those dbf's? TIA Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 7

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox October 2020