ProFox November 2019

profox@leafe.com

34 participants
44 discussions

FoxBin2Prg Form.Property = "" becomes .F.
by Tracy Pearson 02 Apr '20

02 Apr '20

I have just recently started to use FoxBin2Prg to store my VCX and SCX files as text versions in Git. Some of my forms have properties set to a have nothing in it. VFP displays this as "(none)". When I use FoxBin2Prg to put this particular form in to the SC2 form, the back to the SCX form this property becomes a .F. Just putting this out there for those that might use this tool. Tracy

5 8

Re: String Reference to Object
by Gene Wirchenko 25 Feb '20

25 Feb '20

At 11:07 2018-02-15, Gene Wirchenko <genew(a)telus.net> wrote: >At 10:57 2018-02-15, "Fernando D. Bozzo" <fdbozzo(a)gmail.com> wrote: >>To talk with an example, if you have this: >> >>oObj = createobject("custom") >>reference = "oObj" >> >>The you have at least 3 options: >> >>1) The way you know => &reference..referredto >> >>2) Using evaluate => =Evaluate(reference + ".referredto") >> >>3) My preferred: Caching the object and then using it: >> >>oRef = Evaluate(reference) >>? oRef.refered1 >>? oRef.refered2 >>... > > I was hoping to avoid evaluate(), but your third way makes > sense. I will check if it works in all the contexts I am thinking > of. (I was using "object" and "reference" rather loosely.) Unfortunately, it does not work in my usual use case: as an alias. Example: use ccli where=evaluate("ccli") && Nope ? where.clcode Sincerely, Gene Wirchenko

9 9

RE: So, about this VFPA thing...
by Jürgen Wondzinski 28 Jan '20

28 Jan '20

Just to be clear: There are TWO versions of VFPA ("A" like the Hex notation of "10") a) the patched version of your existing VFP9 installation. This implies that it's stil a 23Bit version. This is the version you most probably want to use immediately. Download the 32Bit on the bottom of: http://baiyujia.com/vfpadvanced/f_vfpa_about.asp It needs a current VFP9 installation with SP2, and then creates a new directory with a patched new VFP9.exe and also copies all of the other files of your VFP9 source directory. Thus, after installation you just rename the old VFP9 directory to something different, and rename the new directory to the original name, and all your Registrykeys and Links will work without interruption. b) a new VFP10 err... VFPA compiler for 64 bit executables. Stil with some compatibility problems, and I'm not sure if I would ever need it, but: http://baiyujia.com/vfpadvanced/f_vfpa_gotovfpa64.asp -----Ursprüngliche Nachricht----- Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von Vince Teachout Gesendet: Samstag, 23. November 2019 04:43 An: ProFox Email List <profox(a)leafe.com> Betreff: So, about this VFPA thing... Apparently, I've been under a rock, and there's a magically enhanced VFP9 SP2 that fixes some bugs, can run concurrently with vfp9, and supports 64 bits. Before I download something, am I on the right site: http://baiyujia.com/vfpadvanced/f_vfpa_about.asp ? Thanks! [excessive quoting removed by server]

3 7

SQL Dump
by Chris Davis 01 Dec '19

01 Dec '19

Hi All Is there any tricks I am missing which would speed up a dump of a VFP table into a SQL table. I have predifined by SQL statement something like this "insert into mytable (myfield) values (?m.myfield)" I am then scanning through the VFP table performing a scatter memvar and then executing the SQL. It works it just seems to take alot longer than I imagined it would. Thanks IA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 14

Re: So, about this VFPA thing...
by Ted Roche 29 Nov '19

29 Nov '19

On Fri, Nov 29, 2019 at 1:42 PM Gene Wirchenko <gene(a)shaw.ca> wrote: > Newbie! I started with dBASE II version 2.02 which was > apparently the very first version. > Amateurs. I debugging WANG's Key File Access Method (branded ISAM) before Intel had invented the 8008. And that was my fourth computer system. We can play this game all day. I have coded with "ohs" https://dilbert.com/strip/1992-09-08 -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Re: So, about this VFPA thing...
by Gene Wirchenko 29 Nov '19

29 Nov '19

At 08:07 2019-11-26, Koen Piller <koen.piller(a)gmail.com> wrote: >OK alright. My first impression on Alan's remark was a negative, meaning >negative in the sense of the product, like this product is a hack, it is no >good to use. Now meanwhile I have looked around and found on Wiki an >explication of 'hack' :* Hacking is finding applications that are not >intended by the creator of the resource, especially with regard to >computers. Complexity does not play a role here, on the contrary, easy and >fast alternative solutions are preferred. The use of a clothes peg to >prevent a trouser leg from coming between a bicycle chain is basically a >hack. "Normal" inventions and improvements are therefore not hacks, as long >as they are used for what they are made for.* >This makes me think Alan is not correct and I conclude VFPA is an >improvement. >Besides, the history of Alan's use: since 1991, I am proud to tell you I >was there before 1990, started with dBaseII jumped from dBaseIV to FoxPro >for DOS into now VFP9SP2. Newbie! I started with dBASE II version 2.02 which was apparently the very first version. If it is modification of a binary, it is a hack. It might be a very good hack because of improvements it makes, but it is still a hack. Sincerely, Gene Wirchenko

1 0

Fatal error issuing CALCULATE command
by Paul Newton 29 Nov '19

29 Nov '19

Hi all I think I have come across a possibly undocumented limitation to the maximum number of expressions in a CALCULATE command. In my case a fatal error occurred when trying to CALCULATE the SUMs of 32 different fields in a cursor. It took a while to establish what was going on, but when I reduced the number of expressions to 31 the error no longer occurred. Has anybody else encountered this issue? Many thanks Paul Newton

13 54

Using XML String as part of query in SQL Server
by Frank Cazabon 27 Nov '19

27 Nov '19

Hi, I need to write an SQL Server Stored Procedure or just a simple SELECT Query that accepts an XML string which is basically a list of IDs that I want to use to filter data from a table. Example XML (created using CURSORTOXML): <?xml version = "1.0" encoding="Windows-1252" standalone="yes"?> <VFPData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="mySchema.xsd"> <c_agreements> <imemonumber>1</imemonumber> </c_agreements> <c_agreements> <imemonumber>2</imemonumber> </c_agreements> <c_agreements> <imemonumber>3</imemonumber> </c_agreements> <c_agreements> <imemonumber>4</imemonumber> </c_agreements> <c_agreements> <imemonumber>5</imemonumber> </c_agreements> </VFPData> I then need to: SELECT iMemoNumber, AgreementDate, Amount FROM Agreements WHERE iMemoNumber IN (<<the XML list>>) Or maybe SELECT iMemoNumber, AGreementDate, Amount FROM Agreements INNER JOIN << my XML data on the iMemoNumber >> My Google search terms have failed to produce what I am looking for. Anybody have the solution? -- Frank. Frank Cazabon

2 4

How common is Table Buffering with DBFs??
by Matt Slay 26 Nov '19

26 Nov '19

For a while when my app was still on DBFs (instead of Sql Server) I used Table Buffering, with TableUpdate() and TableRevert() on all my CRUD forms. I remember that it could get tricky keeping it all working correctly in the UI, but in the end I had a pretty good pattern in place. I took the path of making the user take the form into Edit Mode, then they could Save or Cancel, and I handled TableUpdate() or TableRevert() accordingly. Anyway, I'm just trying to get a feel for how broadly used is Table Buffering is in DBF-based apps?? It it a low number like 10%, or maybe 30%? Did any of the other XBase language every have this table buffering paradigm in them? I'm probing into this as (self-assigned) research so I can enlighten the X# Dev Team if this is something they may face as a common pattern in VFP apps if anyone tried to move this sort of app over to X# one day. -- *Matt Slay*, President Jordan Machine Co. 355 Clow Lane PO Box 170339 Birmingham, AL 35217 Ph: 205-849-5050 Fx: 205-849-5075 mattslay(a)jordanmachine.com <mailto:mattslay@jordanmachine.com> http://www.JordanMachine.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 6

Fwd: Gartner Analyst Relations
by MB Software Solutions, LLC 25 Nov '19

25 Nov '19

I still get slightly agitated when I see the name "Gartner" -- you all remember that?!?!? -------- Forwarded Message -------- Subject: Gartner Analyst Relations Date: Thu, 21 Nov 2019 21:18:58 +0000 From: Noonan,Devin <Devin.Noonan(a)gartner.com> To: mbabcock(a)mbsoftwaresolutions.com <mbabcock(a)mbsoftwaresolutions.com> Hi Michael, I’m reaching out to better understand if MB Software Solutions, LLCwould be a fit to work with our analyst community for thought leadership and strategic insight. I am spearheading a new Gartner channel that focuses on high growth startups and emerging tech/service providers, and would love to discuss how Gartner can contribute to MB Software Solutions, LLC's continued growth. Do you have 30 minutes for a phone call this week or next to discuss this further? Kind regards, Devin Devin Noonan Business Development Director *Gartner* Direct: +1 (239) 900-8405 | Mobile: +1 (732) 977-4929 gartner.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 13

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox November 2019