ProFox

profox@leafe.com

2704 discussions

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

[NF] What's in your event log?
by Ted Roche 14 Apr '17

14 Apr '17

Every morning, I get emails from my Linux servers with the output of 'logwatch' summarizing interesting events that occurred the day before, often leading to some corrective action. Does anyone have an equivalent utility for Windows machines? A client called with a support issue and I logged onto their machine and reviewed the Event Log. It was full of interesting stuff, some of which I'm still trying to resolve. One of the more interesting was a C0000118-something "AirSpace" error that was caused by an Office log which was locked to a max size of 1Mb and needed to be cleared manually, rather than being set to Overwrite or Rotate. Every time the client got a "Do you want to save your changes?" error, all the details were written to the log. The change was easy to apply, once the error became known. There was nothing in the desktop UI nor pop-up notices that this was happening. I know this is more a sysop question than a developer question, hence [NF] for Not Fox but not Off-Topic. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

4 5

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox