ProFox October 2019

profox@leafe.com

40 participants
47 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: Exporting Tables
by MB Software Solutions, LLC 06 Nov '19

06 Nov '19

On 10/31/2019 11:17 AM, Gene Wirchenko wrote: > At 07:38 2019-10-30, Stephen Russell <srussell705(a)gmail.com> wrote: >> Why not Import from SQL Server or Access? You can then make a backup >> file >> from SQL or just copy the access one to give to others who cannot use >> Fox >> tables. > > Because the tables are VFP tables. > Steve's world is only SQL Server. <eg> -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

3 2

RE: Exporting Tables
by Tracy Pearson 06 Nov '19

06 Nov '19

Gene, I have not seen a difference in the output of the two commands. You might want to consider looking at Craig Boyd's post about exporting and importing from Excel. It doesn't mention Memo fields that I could see. https://www.sweetpotatosoftware.com/blog/index.php/2008/09/30/using-excel-20 07-file-formats-in-vfp-9-0/ HTH, Tracy -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Gene Wirchenko Sent: Wednesday, October 30, 2019 9:58 AM To: profoxtech(a)leafe.com Subject: Exporting Tables Hello: I am having to do a bunch of data export so have had a closer look at the commands. 1) I am wondering if there is a difference between <vfp> COPY TO ... TYPE ... </vfp> and <vfp> EXPORT TO ... TYPE ... </vfp> where the type is XLS or XL5. 2) I know that memo columns are not exported so for tables with them, I am creating a cursor with the memo columns replaced with C(254) columns. In a few cases, this will result in data being clipped. Short of programming my exports to use Office Automation, is there a way around this? (I mean that is not a kludge. For example, I could create multiple columns each with a piece of the memo, but that would be horribly ugly.) Sincerely, Gene Wirchenko [excessive quoting removed by server]

4 5

Re: Exporting Tables
by Koen Piller 31 Oct '19

31 Oct '19

Gene, Vilhelm made fabulous classes to export DBF tables with memofields in MSExcel, MSWord, MSAcces have you tried any of them already? Koen Op do 31 okt. 2019 om 16:17 schreef Gene Wirchenko <gene(a)shaw.ca>: > At 07:38 2019-10-30, Stephen Russell <srussell705(a)gmail.com> wrote: > >Why not Import from SQL Server or Access? You can then make a backup file > >from SQL or just copy the access one to give to others who cannot use Fox > >tables. > > Because the tables are VFP tables. > > [snip] > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server]

2 1

Re: Exporting Tables
by Gene Wirchenko 31 Oct '19

31 Oct '19

At 07:38 2019-10-30, Stephen Russell <srussell705(a)gmail.com> wrote: >Why not Import from SQL Server or Access? You can then make a backup file >from SQL or just copy the access one to give to others who cannot use Fox >tables. Because the tables are VFP tables. [snip] Sincerely, Gene Wirchenko

1 0

A FoxPro Transition @ UCLA...
by Kurt at VR-FX 31 Oct '19

31 Oct '19

Hello there folks, I'm looking to get some feedback from the hive mind of this group. And, I will admit, I'm doing this kind of last minute. Too many things going on lately, and I have not had a chance to do my true due diligence! Such as thorough research via prior postings in this forum. So as some of you may already know, I had a first interview for a programmer job at UCLA. The second interview is coming up, it's supposed to be this Thursday, but I might try to postpone until Friday. Too much stuff going on in my life lately, including doing 2 different part time jobs and an extended relative who passed away recently, that's the reason I'm going down to LA for an in-person interview, since the last interview I did via Skype. It looks like UCLA really wants to move away from Foxpro, as they know it's a dead language. But, they want to move to something similar to VFP. I suspect its also because the 1 and only programmer there, who's been there for like 30 years and may be retiring soon - doesn't want to learn something Totally new. And, also wants to minimize the transition! They are asking me to propose what I think is the best option. They have mentioned several options such as Fox-in-Cloud, the Alpha software, and even Servoy. They did not bring up things like Lianja, XoJo, or X# the open source X-base language. I know that Fox-in-Cloud even offers a type of Conversion Assistant - which looks really Great! But, once its converted and running in the cloud - I'm assuming that making updates to the system actually means programming in something that is not actually FoxPro - as I think its Javascript & HTML. But, I could be wrong - and am sure Thierry will correct me. There was also some recent discussion on X# which looked like a potentially great option. But, I heard that via the last posting - the FoxPro version of the code wasn't really ready yet! They also told me that they have already been working with Alpha SW - and in discussions with them for several months. Which makes me think they are already leaning towards Alpha. A quick review of old postings in this forum did not show a lot of discussion or users of Alpha. It would really be great to hear from some Alpha users! Anyway - any and all input would be greatly appreciated. I've seen Numerous discussions about a number of these technologies here in the forum over the years. But, honestly - I never truly got involved with any of them - until NOW! Regards, Kurt

15 26

lists
by Matt Slay 30 Oct '19

30 Oct '19

2 1

SWFox 2019 recap
by Tracy Pearson 30 Oct '19

30 Oct '19

I am back to calm after the first day back to work. I had a great time at the conference and hope to stay connected with those I met. I answered an email this morning and thought about the conversation I had with Richard Kaye. <grin> Good conversations, good information, and a fun time. I hear I did well as my first time speaking at the conference. Maybe we can get more ProFoxers to go in 2020. See you around! Tracy

4 6

Re: Exporting Tables
by Ted Roche 30 Oct '19

30 Oct '19

On Wed, Oct 30, 2019 at 9:58 AM Gene Wirchenko <gene(a)shaw.ca> wrote: > 1) I am wondering if there is a difference between > where the type is XLS or XL5. > Nope, according to: https://www.tedroche.com/hackfox7/s4g059.html "Both COPY TO and EXPORT copy selected data to another file. We can't see much reason to use EXPORT, since COPY TO can do everything it does and more. (In fact, we're fairly convinced EXPORT exists only because IMPORT does.)" > 2) I know that memo columns are not exported so for tables with > them, I am creating a cursor with the memo columns replaced with > C(254) columns. In a few cases, this will result in data being > clipped. Short of programming my exports to use Office Automation, > is there a way around this? (I mean that is not a kludge. For > example, I could create multiple columns each with a piece of the > memo, but that would be horribly ugly.) > For some projects, I created a textmerge file, named it something.CSV and use textmerge to export the PK and commas and text delimiters and the memo fields. Rejoining the two data sources was left as an exercise for the receiver. Be wary of the need to escape text delimiters if used within the memo field, i.e., O'Reilly or "Sold "As Is" " -- 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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox October 2019