ProFox September 2016

profox@leafe.com

45 participants
37 discussions

[NF] Headed to SWFox
by Tracy Pearson 13 Sep '16

13 Sep '16

My boss and I are headed to this year's SWFox conference. We will be there Thursday, Friday, and Saturday nights. We are wondering if we should rent transportation for dinners. Partly due to I am a dairy free vegetarian, and partly due to where restaurants are. We have not been to SWFox at this location before. Feel free to respond off line if you like. Thank you for any feedback, Tracy

3 4

Re: Leading Zeroes
by Gene Wirchenko 13 Sep '16

13 Sep '16

At 12:45 2016-09-12, Thierry Nivelet <tnivelet(a)foxincloud.com> wrote: >? Transform(123, '@L 99999') && 00123 Thank you. I *almost* tried that. I did not have the space between the @L and the 99999. Try it without the space, that is ? Transform(123, '@L99999') && 00123? NOPE! and see the difference. The docs do not give an example of more than one specification in the spec string. [snipped previous] Sincerely, Gene Wirchenko

1 0

Processing a long character string one character at a time
by Joe Yoder 12 Sep '16

12 Sep '16

I have a routine that processes each character in a file. The file I am working with is over 2 million characters long. I pull it into a memory variable with filetostr and then process each character with the substr command. Apparently substr has problems when dealing with a long string as the process is painfully slow. I suspect that I will be better off using the low level file routines to read one character at a time but thought maybe someone knows of a way to speed up the approach I am using now. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

Importing a CSV with carriage returns embedded in fields
by Joe Yoder 12 Sep '16

12 Sep '16

When one imports a .CSV file with carriage returns embedded in a field that is delimited by quotation marks, Foxpro ignores the quotation marks and assumes any carriage returns it finds indicate the end of a record. The file I am working with ends up with several hundred extra (garbled) records because of this fact. When the file is opened by Excel the problem does not occur. My question is if someone is aware of a solution to this problem. In this particular case, I think I can do a workaround by simply eliminating the problem field . Sooner or later I will probably get into a situation where I end up writing my own import but it hasn't happened yet. Thanks in advance for any solutions or ideas, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

Re: M$ giving more support to dbf?
by Mike 11 Sep '16

11 Sep '16

There's a python desktop package for windows.Mike Sent from my Sprint Samsung Galaxy S7 edge. -------- Original message --------From: Laurie Alvey <trukker41(a)gmail.com> Date: 9/10/16 8:12 PM (GMT-06:00) To: profoxtech(a)leafe.com Subject: Re: M$ giving more support to dbf? haven't looked at Dabo, but doesn't Python mean web based apps? Can it do desktop? Laurie On 10 September 2016 at 22:45, Darren <foxdev(a)ozemail.com.au> wrote: > V1.02 was first for me. Been with it ever since. > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ken > McGinnis > Sent: Sunday, 11 September 2016 6:08 AM > To: profoxtech(a)leafe.com > Subject: Re: M$ giving more support to dbf? > > True, but change is painful or at least it seems like it would be painful. > > I, like some others on this list started with Fox back in the 1980's and > like some others on this list, I hope god will deliver a miracle and save > us. I haven't prayed yet. Maybe that would help? > > Note that VFP9 SP2 works great with Win10, even with only 2gb memory - even > better than on Win7,8,8.1. > > > On 9/10/2016 8:46 AM, Edward Leafe wrote: > > On Sep 10, 2016, at 6:39 AM, Man-wai Chang <changmw(a)gmail.com> wrote: > > > >> Resurrect Visual Foxpro, please! Make it 64-bit at least! :) > > Well, Paul McNett and I *tried* to do that when we created Dabo, which > does pretty much everything that VFP does, but with an open license and a > future path forward. It did require learning Python instead of Xbase, but > other than that, it had data binding, support for multiple backends (even a > DBF backend, if someone had maintained it). It's been production-ready for > over a decade. > > > > Very few people were willing to make the effort to move to Dabo. Sure, > you > couldn't directly port a VFP app to Dabo, but new development work doesn't > have that problem. It really seems that people are much more willing to > invest in a product with no future from its owner than to invest in a > product with a future. It's like people who lived on the coast who have > been > flooded as sea levels rose: instead of moving to higher ground, they keep > propping themselves above the waterline and praying for a miracle. > > > > -- Ed Leafe > > > > > > > > > > > > > > > > --- StripMime Report -- processed MIME parts --- > > multipart/signed > > text/plain (text body -- kept) > > application/pgp-signature > > --- > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox(a)leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAMvTR9dGeyrCJvATNrGrm-BFxKa8ciQieyU… ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/CAMvTR9dGeyrCJvATNrGrm-BFxKa8ciQieyUQYb3eGr3Jf…

1 0

Re: Processing a long character string one character at a time
by foxdev 10 Sep '16

10 Sep '16

Problem with mline approach is the minimum length for memline is 8 bytes. -------- Original message --------From: Ted Roche <tedroche(a)gmail.com> Date: 10/09/2016 21:41 (GMT+10:00) To: profoxtech(a)leafe.com Subject: Re: Processing a long character string one character at a time Hi, Joe: Sorry, but my weekend is pretty full, so I can't answer as thoroughly as I'd like to. String functions in VFP are blazingly fast, but have to be used correctly in ways that aren't always obvious. CSV with carriage returns inside fields is not CSV, in my not-so-humble opinion. ALL DBMSes have trouble with long text fields. IAC, check out http://fox.wikis.com/wc.dll?Wiki~StringHandling for some clues. MLINE() and _MLINE against your string variable (I know it says it's about memo fields) is what you want, *I think*, but don't have time to check. On Sat, Sep 10, 2016 at 1:32 AM, Joe Yoder <joe(a)wheypower.com> wrote: > I have a routine that processes each character in a file. The file I am > working with is over 2 million characters long. I pull it into a memory > variable with filetostr and then process each character with the substr > command. Apparently substr has problems when dealing with a long string as > the process is painfully slow. > > I suspect that I will be better off using the low level file routines to > read one character at a time but thought maybe someone knows of a way to > speed up the approach I am using now. > > Thanks in advance, > > Joe > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox(a)leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4sNMe+yUXR=VhBdRU16HzhDeEDT9Yy… ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/CACW6n4sNMe+yUXR=VhBdRU16HzhDeEDT9YyM+JDOgvttU…

3 2

Southwest Fox 2016: Free components
by Rick Schummer 09 Sep '16

09 Sep '16

DBI is giving away a full license of Calendar COM (ctxCalendar; https://www.dbi-tech.com/ComponentPage_ctxCalendar.aspx) to each Southwest Fox/Southwest Xbase++ 2016 attendee (http://www.swfox.net) Calendar COM is a really great Outlook style scheduling control with three fully extensible views baked into one control: a multi-column Day View (a multiple day appointment scheduler for one resource or multiple resource appointment scheduler for one day at a time), a Week View Appointment Scheduler, and a Month Calendar / date picker. It comes in both 32-bit and 64-bit versions. DBI has been a long-time supporter of Southwest Fox and we thank them for their generous support once again this year! Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

[NF] Looking for Alpha 5 (Alpha Anywhere) users
by Mike Copeland 08 Sep '16

08 Sep '16

I know I've seen posts on here from at least one user of Alpha XBasic software. I'm now on day 15 of my 30 day trial and have a few generic questions... Stuff like: Is Alpha Anywhere mostly about Javascript/HTML5 and brings along the XBasic and Alpha5 infrastructure as a freebie? Or is the Alpha5 XBasic more integral and important than it seems to be. (It seems most tasks are accomplished with Javascript.) Is the Client/Server version ($2500 year) worth the extra $1k over the basic package, or can the server functions be accomplished in other ways? I have a copy of and have used FoxWeb, which has always seemed clunky, but it works. Could that be used in place of the Alpha Anywhere Client/Server or is that a false savings? Is the Alpha Anywhere documentation as bad as I think it is? Or am I just acting my age ("You kids! Get off my lawn!") And a few other tidbits. I'd be happy to take this off-list if it produces too much noise for everyone, but then maybe some others would find the info useful...I dunno. Thanks for any responses. Mike Copeland

6 12

[NF] Getting Outlook 365/win10 to talk to GMail
by Ted Roche 08 Sep '16

08 Sep '16

Stupid computers. Stupid competing software companies. Trying to get a client's Outlook to talk with GMail. I've done this a hundred times before on various versions of Outlook, T-Bird, and real mail clients, but this one's kicking my butt. Email: clientsname(a)clientsdomain.com PW: XXXXXXXXX - confirmed via the web interface to GMail. IMAP enabled on the gmail settings page. In Outlook, add an account imap.gmail.com, port 993, SSL smtp.gmail.com, port 587 or 465, SSL or TLS or Auto, tried all six combos. clientsname(a)clientsdomain.com, password retyped 100 times or so. SPA Authentication tried on and off, no joy. Always presented with a login dialog, and Outlook reports it cannot connect. I remember there is always a weird tweak to the combination of settings to get this to work. IIRC there's a trick to where you are supposed to add the account credentials and where you don't, and I think I've tried all the combos, although it does approach an m^n problem... Lots of cheatsheets dated 2013 and earlier, which I suspect are out of date. Any suggestions on what else to try? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

4 4

RE: [NF] Test
by Ken Dibble 07 Sep '16

07 Sep '16

I'm in Binghamton. >No problem - U R Forgiven! > >But - HEY - What the Halibut - Ur here in NY - as I can see by your >RoadRunner email domain. And, If I do remember right - Ur up in the >Syracuse area - although - these days - my memory banks tends to >fail at odd times... > >Regards, >Kurt Wendt >Senior Systems Analyst > > >Tel. +1-212-747-9100 >www.GlobeTax.com > > >-----Original Message----- >From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ken Dibble >Sent: Tuesday, September 06, 2016 7:21 PM >To: profoxtech(a)leafe.com >Subject: Re: [NF] Test > >I stand corrected. I should have Googled it first. I was surprised >to find a variety of historical developments that resulted in >various days being designated to celebrate labor. A much more >complex story than the one I thought I knew. > > >Nope! > > > >Sent from my iPhone > > > > > On Sep 6, 2016, at 2:15 PM, Ken Dibble <krdibble(a)stny.rr.com> wrote: > > > > > > > > >> 3) Labour Day weekend. A mild form of #2. Could be. > > >> > > >> Let's find out. > > >> > > >> I enjoyed mine quietly. So did you, or at least, you did > > not post about it here. > > > > > > Um, wouldn't your Labour Day be May 1? > > > > > > Ken Dibble > > > www.stic-cil.org > > > [excessive quoting removed by server]

2 1

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox September 2016