ProFox April 2017

profox@leafe.com

44 participants
50 discussions

SQL sum
by Tom Dawson 21 Apr '17

21 Apr '17

Hi All I have a stock table which records the locations and quantities of various items. The layout of the table is like so: |stock id| |location| |quantity| I want to be able to add a total field into the table which is a total of each unique stock id. To do this I tried to use a sum(quantity) followed by a group by. The problem is grouping by id ignores the distinct location info. For example stock id location quantity 1 A 10 1 B 20 2 C 50 2 D 50 Becomes: stock id location quantity Total 1 A 10 30 2 C 20 100 Although the totals are right the group by has cause me to lose my distinct location info, what I really want is stock id location quantity Total 1 A 10 30 1 B 20 30 2 C 50 100 2 D 50 100 I'm sure it's relatively but I'm obvious missing something. Thanks in advance Tom --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 8

Text file import
by Matt Wiedeman 21 Apr '17

21 Apr '17

Hello everyone, I need to setup a job to import a pipe delimited text file. This is easy enough but one of the fields is larger than 254 characters. If I use a memo field, it does not import that field. I started to setup a routine to step through each character and store the fields manually but I would rather not do it that way. Does anyone have a function or tip they can share to resolve this situation?

8 12

Referring to a Column
by Gene Wirchenko 21 Apr '17

21 Apr '17

Hello: Suppose I wish to refer to a column. I have the alias in *text* form. What is the best way to access the column? By best, I mean a short, clear way that: 1) can be used in both reads or writes on the column and 2) is in-line: I do not want to have to define a variable with an expression and then use that in a later line. I have the rather ugly evaluate(aliasasstr+".colname") which I have used for years on occasion. Now, I am modifying a report where I will have to use this sort of access more than a few times. Am I overlooking something cleaner? Sincerely, Gene Wirchenko

6 9

Re: Referring to a Column
by Gene Wirchenko 21 Apr '17

21 Apr '17

At 16:47 2017-04-20, Ted Roche <tedroche(a)gmail.com> wrote: >EVAL() is pretty brief. When you have four parameters of a method call using it, it seems much longer. >Consider standardizing the alias, for example, > >USE (aliasstr) alias TARGET AGAIN IN 0 > >Now, the report can refer to Target.fieldname with no need to wrap it >in a function. Interesting, but it does not fit my pattern (described next). >Of course, the actual problem you're trying to solve might be more >complex. Please share. I use an alias of the name of the program running in front of any specific name so I can see where a table/cursor was opened. I just bit the bullet and did it anyway. It sure would be nice if (aliasasstr+".colname") worked. [snip] Sincerely, Gene Wirchenko

2 1

Checking in on FOXCHARTS
by mbsoftwaresolutions＠mbsoftwaresolutions.com 19 Apr '17

19 Apr '17

I've asked in the past; last was about 4 years ago. So I'm asking again, as I'd like to put something simple together to pitch it to a client. WHO IS USING FOXCHARTS NOWADAYS? I just subscribed to scribd (trial membership) in order to get Jim Nelson's white paper of how to use it. Getting directions seemed to be a challenge. They weren't on the FoxCharts VFPX page.

4 8

[NF] Gartner predicting things "dead" again and the user community reaction....deja vu?
by mbsoftwaresolutions＠mbsoftwaresolutions.com 19 Apr '17

19 Apr '17

from https://www.theregister.co.uk/2017/03/03/pizza_roaches_and_java/: section header: "Dead again" [Last year, a report from Gartner declaring the end of Java EE’s dominance invigorated all the latent tension in the community. As one of the report’s authors put it: "People don't need 90 per cent of the stuff sitting in Java EE to build modern enterprise applications.” Predictably, such statements drove counter-arguments of analyst payola and ignorance in the ever-delightful ad hominem style (I'm looking forward to finding out how much of a moron I am this time in the comments section - KISSES!). Vendors who benefited from a decline in Java EE only offered wry smiles and download figures, while the original analysts gave the equivalent of a tired shruggie as they stuck by their guns and pdf-splained their original analysis.] Reminded me of the almighty wisdom of Gartner from the eyes of the VFP developer many moons ago...

3 3

ADMIN: SPAM was Re: Fw: good news
by Ted Roche 17 Apr '17

17 Apr '17

Besides being garbled BASE64 email (see https://www.base64decode.org/) I suspect this is SPAM and/or malware, and not Al. On Mon, Apr 17, 2017 at 4:41 PM, Al <al(a)gatwicksoftware.com> wrote: > WW8hIA0KDQpJJ3ZlIGdvdCBnb29kIG5ld3MgZm9yICB5b3UhIFlvdSBhcmUgZ29pbmcgdG8gYmUg > c3VycHJpc2VkKSkpICBQbGVhc2UgcmVhZCBpdCAgaGVyZSAgaHR0cDovL3d3dy5taW5yYXp2LnJ1 > L2NsZWFybHkucGhwP2Y4ZjkNCg0KQmUgd2VsbCwgQWwNCg0K > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server]

2 2

Fw: good news
by Al 17 Apr '17

17 Apr '17

WW8hIA0KDQpJJ3ZlIGdvdCBnb29kIG5ld3MgZm9yICB5b3UhIFlvdSBhcmUgZ29pbmcgdG8gYmUgc3VycHJpc2VkKSkpICBQbGVhc2UgcmVhZCBpdCAgaGVyZSAgaHR0cDovL3d3dy5taW5yYXp2LnJ1L2NsZWFybHkucGhwP2Y4ZjkNCg0KQmUgd2VsbCwgQWwNCg0K--- StripMime Report -- processed MIME parts ---multipart/alternative text/plain (text body -- kept) text/html---

2 1

[NF] Chromebook OOBE
by Ted Roche 17 Apr '17

17 Apr '17

Not Fox, Not even Windows, but interesting tech I thought I'd share. As Family Area Network SysAdmin, I set up and support machines for a couple of relatives. One was interested in browsing and broadcasting free movies from archive.org and slideshows and personal files to his TV. I set up a Google Chromecast and picked up an inexpensive refurbed ASUS Chromebook 15 from NewEgg ($130). Essentially, the laptop is a 16Gb SSD running Chrome OS and Chome browser. No Windows to infect and update and "have you turned it off and back on" tech support. Decent screen 13x7 and 15" decent audio, HDMI and 2 USB3 ports. Supposed 12 hour battery, and 802.11ac wifi. ChromeOS has some decent accessiblity features that display extra-large cursors and graphics and some zoom and magnify features for those with limited vision. Yes, everything you do is transmitted to Google who use it to target you with ads. Added EFF's Privacy Badger and HTTPS Everywhere to the browser. Can't run Windows apps locally, but there are some RDP solutions as well as web-based, of course. Could run Linux if you really wanted to, but for this use case, this seems like a pretty sweet consumer machine at a very reasonable price. Bonus Google Hangouts means video phone calls and screen sharing (also in Chrome Remote Desktop) for tech support. Anyone else using Chromebooks? Good or bad experiences to share? Warnings on things to avoid? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

5 5

Re: Fuzzy Name Searching
by Gene Wirchenko 14 Apr '17

14 Apr '17

At 06:46 2017-04-14, Ken Dibble <krdibble(a)stny.rr.com> wrote: [snip] [Gene:] >> I have a couple of anvils around my neck, too. They prevent >> my system from easily being multi-user. One was a reasonable >> trade-off at the time, but the downside continues to bite. The >> other was an argument I lost, because my boss does not understand >> relational databases. > >Pointy-haired, I presume? No. Originally, he needed the system fast. On relational issues, he has his own needs which conflict somewhat; AFAICS, it is a question of him not understanding the importance of the issue to the code side and not wanting the trade-off. >>[snip] >> >>>No, I don't have a loader program. I would have to introduce >>>internet download capabilities in order to provide that, and >>>that's a headache I don't need. >> >> Loader programs are not difficult to set up on a local >> network. Still not an option? > >No, because there are other completely separate organizations, far >away from here, using the software. I would either have to fork the >project to leave I thought that might be the case, but. [snip] Sincerely, Gene Wirchenko

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2017