RE: [NF] Sending Large Files...

On 2017-05-10 08:31, Kevin J Cully wrote: I've been using this software for sending large video files between computers in my organization. It's nice because you aren't relying on a service by another company. Very fast at syncing files. https://syncthing.net/ So it's like DropBox but

Re: [NF] My old LogMeIn is sure getting around the world

On 2017-05-10 00:59, Gene Wirchenko wrote: At 12:47 2017-05-09, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I stopped using LMI last year. But occasionally get alerts that someone failed to log into my account (even though I no longer have any active accounts with them). Today's

[NF] My old LogMeIn is sure getting around the world

I stopped using LMI last year. But occasionally get alerts that someone failed to log into my account (even though I no longer have any active accounts with them). Today's attempt came from Vietnam! LogMeIn ID: **@* Time of Event: 5/9/2017 5:46 AM From IP Address: 113.161.89.45 From

Re: Question about determining when record not showing after filter applied

On 2017-05-09 06:36, Alan Bourke wrote: IMO the best approach is to use autoinc id columns in tables with a primary or candidate key instead of relying on the record number, and base grids etc on cursors with the relevant subset of data instead of using filters. Well sure but when working

Re: Question about determining when record not showing after filter applied

On 2017-05-08 16:52, John Weller wrote: Could you not check to see if the filter applies to the current record? That is if filter is applied to myfield = .t. Then is myfield = .f. Too many conditions on the filtering clause to make this approach likeable.

RE: Question about determining when record not showing after filter applied

On 2017-05-08 16:50, Richard Kaye wrote: Yep. Store the recno to a memvar before you set the filter. GO memvar. Check for EOF. You'll probably want to set lockscreen while you're doing all that stuff. Good tip about the LOCKSCREEN. ___ Post

Re: Question about determining when record not showing after filter applied

On 2017-05-08 16:49, Ted Roche wrote: See what GO (RECNO()) does. "Record is out of range" error. I suppose I'll just put a TRY/CATCH around it and in the CATCH put a GO TOP. (These recordsets are a handful of records, so not concerned about any penalty about GO TOP vs. LOCATE.)

Re: Question about determining when record not showing after filter applied

On 2017-05-08 16:45, Fred Taylor wrote: You have to move the record pointer to get the filter to "kick in". You might try SKIP 1 IN yourtable and SKIP -1 IN your table and see if you come back to the same record # you started at. Fred Hi Fred (and Richard!), That sounds like a workable

Question about determining when record not showing after filter applied

VFP9SP2 After applying a filter to a grid cursor, I want to know if the current record pointer (not moved since the filter applied) is on a record that is affected by the filter? That is, if the record pointer is on a record that is no longer visible due to the filter, I want to reset the

Re: [NF] Friday Afternoon Discussion: Passwords

On 2017-05-06 15:05, Ted Roche wrote: Double-bonus goes to sites that double-check with an SMS or similar. "Something you know (password) and something you have (cellphone)" makes for good two-factor authentication. I was thinking of adding that to my FabNet software. Shouldn't be hard to

Re: GetFile() problem (VFP9, Win 10)

On 2017-05-05 04:59, Alan Bourke wrote: Maybe take a look at the SHSpecialFolder method in the VFP2C32 .fll library. https://github.com/ChristianEhlscheid/vfp2c32 Although it's another lib to ship etc. What's one more very small sized FLL to include? No big deal at all!?

Re: [NF] Microsoft Surface Pro 3 for sale -- what's a good fair price?

That's odd...this post shows up several days after I sent it. Oh well. I've already had the replacement post go through and done. On 2017-05-03 16:10, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I've been needing a replacement laptop for awhile now. My old Dell Latitude 5530 is

[NF] Microsoft Surface Pro 3 for sale -- what's a good fair price?

I've been needing a replacement laptop for awhile now. My old Dell Latitude 5530 is about 5-6 years old I think. Got a buddy of mine (so friend's discount to be included!) who's got an extra Windows Surface Pro 3 laptop he's willing to sell me. Told me to tell him what's a fair price. He's

Re: Trying again....Microsoft Surface Pro 3 for sale

On 2017-05-04 16:05, Kurt at VR-FX wrote: Since the spec's stated: Windows 10 Pro Then of course VFP should run on it! You having a Slow day today in the Marbles dept.??? ThanksYES! ___ Post Messages to: ProFox@leafe.com Subscription

Re: Trying again....Microsoft Surface Pro 3 for sale

On 2017-05-04 15:32, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: (This never showed up from yesterday...subject was [NF] Microsoft Surface Pro 3 for sale -- what's a good fair price?) I've been needing a replacement laptop for awhile now. My old Dell Latitude 5530 is about 5-6 years old

Re: Southwest Fox 2017: Speakers and Sessions

On 2017-05-03 17:40, Rick Schummer wrote: Speakers (http://www.swfox.net/Speakers.aspx) and sessions (http://www.swfox.net/SessionsSWFox.aspx) for Southwest Fox 2017 have been announced. Hi Rick, Are there as many sessions as in the past? Just curious as I looked through them. Thanks,

Trying again....Microsoft Surface Pro 3 for sale

(This never showed up from yesterday...subject was [NF] Microsoft Surface Pro 3 for sale -- what's a good fair price?) I've been needing a replacement laptop for awhile now. My old Dell Latitude 5530 is about 5-6 years old I think. Got a buddy of mine (so friend's discount to be included!)

Re: [NF] Senior .NET C# Developer Job Opportunity

On 2017-05-03 16:21, Thierry Nivelet wrote: Foxpro devs allegedly can't be found, at least are faithful .Net devs probably have too many opportunities to keep them faithful A funny and unexpected drawback of 'popular' languages. Very true, Thierry! If you don't pay them well, they'll find a

Re: Getting count of rows in a text file -- best approach?

On 2017-05-02 10:23, Stephen Russell wrote: Ok, who else chuckled when the database guy doesn't use data to get a count but is going to count text file lines instead? Seriously I found that funny. It's all a matter of where you're doing the processing! Up front BEFORE you load it,

Re: Getting count of rows in a text file -- best approach?

On 2017-05-02 06:43, Ted Roche wrote: It is true and yet it is not. Rick Strahl wrote an article showing there are things you can do (and not do) with HUUGE files read in using FileToStr(): https://www.west-wind.com/wconnect/weblog/ShowEntry.blog?id=882 Since the Original Poster (anyone

Re: Getting count of rows in a text file -- best approach?

On 2017-05-02 05:57, Thierry Nivelet wrote: Mentioned in "Visual Foxpro system capacities" Yes but as Fred said, it looks like you can load greater than 16 MB. I could swear I did. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] Online databases

On 2017-05-02 07:21, Garrett Fitzgerald wrote: Hey, all. I'm playing with the idea of writing an app for community band librarians to store their catalogs in. I actually use a Google Sheets file for the Bangor Band, because I'm worried about maintainability for the next person, but I've had a

Re: Getting count of rows in a text file -- best approach?

On 2017-04-26 16:05, Fred Taylor wrote: Sure looks like you can load larger than 16MB. Though the help file does say a 16MB limit on memory variables. Fred Perhaps the Help file is outdated? That guy from the Fox team must have been let go before he could update it.

Re: VFP9 and Windows 10 PDF printer

On 2017-04-26 22:31, Mike wrote: I use XFRX and it works well. Probably the biggest difference is that XFRX is not free. Looks like XFRX has some really cool features too besides just creating a PDF. Check out their website for the latest. ___

Re: VFP App: Sluggish response on network....

On 2017-05-01 10:17, Desmond Lloyd wrote: Good Morning, Have an application that has been running for years, we add transactions via one form that displays the transactions in a grid. When adding we pop a form, when saving I do the old append blank gather memvar thing. Has worked well

Re: Getting count of rows in a text file -- best approach?

On 2017-04-29 06:50, Laurie Alvey wrote: Hi All, This is all very ingenious, but I am curious to know why you would want to know the number of lines. Laurie As the original poster, I'll answer: we want to compare the # of records sent this year compared to what they sent us last year.

RE: Excel automation to get the SUM("R:R")

On 2017-05-01 10:20, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2017-04-26 16:08, Richard Kaye wrote: Looks to me like your current solution is storing a formula in a remote cell which you said you wanted to avoid. Good point. I had (temporarily) relented on that. Just tried

RE: Excel automation to get the SUM("R:R")

On 2017-04-26 16:08, Richard Kaye wrote: Looks to me like your current solution is storing a formula in a remote cell which you said you wanted to avoid. Good point. I had (temporarily) relented on that. ___ Post Messages to: ProFox@leafe.com

[NF] Steve Ballmer Serves Up a Fascinating Data Trove (USAFacts.org)

https://mobile.nytimes.com/2017/04/17/business/dealbook/steve-ballmer-serves-up-a-fascinating-data-trove.html Nice to see he's giving back like this. Seriously. Kudos, Monkeyboy. Well done. ___ Post Messages to: ProFox@leafe.com Subscription

RE: Getting count of rows in a text file -- best approach?

On 2017-04-26 12:31, Brant E. Layton wrote: Just a reminder - STRTOFILE and FILETOSTR are limited by the size of a memory variable - 16,384K bytes (16,777.184 bytes). Had to fix some software that was truncating PDF files at 16 MB... || Looked up the Visual Foxpro System Capabilities:

Re: Codeplex is shutting down, VFPX.org is spinning up

You mean so that it's still self-updating? On 2017-04-26 12:01, Fernando D. Bozzo wrote: I suppose that it will need some rework to work with Github El 26/4/2017 5:59 p. m., escribió: On 2017-03-31 20:51, Fernando D. Bozzo wrote: No shit...

Re: Codeplex is shutting down, VFPX.org is spinning up

On 2017-03-31 20:51, Fernando D. Bozzo wrote: No shit... moving all the projects will be a hard. Binaries, version history, documentation, bye bye Thor :_( Why would you say "bye bye Thor" ?? ___ Post Messages to: ProFox@leafe.com Subscription

RE: Excel automation to get the SUM("R:R")

Ignore that last lineI fixed it with COUNTA. Just forgot to delete that part before pressing "Send" On 2017-04-26 11:55, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: My DetailClaims logic is wrong though; it's counting ALL rows in the column, and I just wanted to the populated

RE: Excel automation to get the SUM("R:R")

Thanks, Richard. I may try that. Here's what I had for now: WITH oExcel.ActiveSheet as EXCEL.Worksheet .Range("AA96").Formula = "=COUNTA(R:R)" DetailClaims = .Range("AA96").Value - 1

Excel automation to get the SUM("R:R")

Excel 2013, VFP9SP2 Range Object model: https://msdn.microsoft.com/en-us/library/office/ff838238.aspx I've got my handy "Microsoft Office Automation With Visual Foxpro" book out from HWP, trying to see where I can get the value of a range. In this case, when I just select the entire

RE: Codeplex is shutting down, VFPX.org is spinning up

On 2017-04-25 17:48, Rick Schummer wrote: And it will be forwarded to the new home of VFPX just as soon as we get it firmly established. The migration is underway already. Rick White Light Computing, Inc. www.whitelightcomputing.com Thanks

Re: Codeplex is shutting down, VFPX.org is spinning up

On 2017-03-31 16:07, Ted Roche wrote: The wise Rick Schummer and company registered vfpx.org, so stay tuned for migration news. For now, this is re-routing to http://vfpx.codeplex.com/. Just FYI... ___ Post Messages to: ProFox@leafe.com

Re: Getting count of rows in a text file -- best approach?

On 2017-04-21 16:47, Ted Roche wrote: On Fri, Apr 21, 2017 at 4:37 PM, wrote: Testing showed these two pretty much a dead heat: RowCount = OCCURS(CHR(13),FILETOSTR(m.Filename)) RowCount = ALINES(aCrap,FILETOSTR(m.Filename)) But on the

RE: Getting count of rows in a text file -- best approach?

On 2017-04-21 11:24, Richard Kaye wrote: Only when it fits the situation. :-) Dirty? Really? One line of code returns the number of rows in your string. Which was your original question. My solution was 1 line too: RowCount = OCCURS(CHR(13),FILETOSTR(m.Filename)) Benchmark it and

Re: Getting count of rows in a text file -- best approach?

On 2017-04-21 11:27, Gianni Turri wrote: On Fri, 21 Apr 2017 17:02:23 +0200, Gianni Turri wrote: On Fri, 21 Apr 2017 10:44:34 -0400, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VF9SP2 Currently, I'm simply doing this for now: RowCount =

Re: Text file import

On 2017-04-21 11:28, Peter Cushing wrote: On 21/04/2017 16:13, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I'll take a quick second to remind folks too of VFP2C32.FLL for accessing files greater than 2GB too. Functions are FGetSex Hope that doesn't take you to a dodgy site ;-) Peter

RE: Getting count of rows in a text file -- best approach?

On 2017-04-21 10:47, Richard Kaye wrote: ALINES()? Is that your answer for everything today? lol Nah, that feels no less dirty than my approach. My bet is that would require as many (if not more) processing cycles, but of course only testing would show conclusively if at all. Thanks

STREXTRACT (was RE: Text file import)

On 2017-04-20 11:56, Kevin J Cully wrote: oRec.Fld01 = STREXTRACT(cFulLField, "|", "|", 1) oRec.Fld02 = STREXTRACT(cFulLField, "|", "|", 2) oRec.Fld03 = STREXTRACT(cFulLField, "|", "|", 3) && Might be a memo field Wow! Never heard of this function before, so I looked it

Re: Text file import

On 2017-04-20 11:13, Ted Roche wrote: A parsing routine is usually the fastest. LLFF's (don't forget to use _MLINE) or FileToStr() or Append to Memo and then parse each come out about even in terms of processing time and code, unless the file is really extreme ( 10 Gb, or million byte lines or

RE: Text file import

I'll take a quick second to remind folks too of VFP2C32.FLL for accessing files greater than 2GB too. Functions are FGetSex, FCloseEx, FReadEx, FOpenEx, etc. --Mike On 2017-04-20 13:21, Paul H. Tarver wrote: In this case, I would probably get each line of data to memory or a cursor as

Re: SQL sum

On 2017-04-20 09:43, Jean MAURICE wrote: BIG ERROR ! you MUST NOT have m as local alias. Choose another letter !! The Foxil That's another reason why I never use single-letter aliases. Learned that tip from Ed Leafe last century, as I recall, when I was first working in VFP5/6. I

Getting count of rows in a text file -- best approach?

VF9SP2 Currently, I'm simply doing this for now: RowCount = OCCURS(CHR(13),FILETOSTR(m.Filename)) Is there a better (read: FASTER) way? These are tab delimited text files so I can't really use FSEEK or FSIZE(m.Filename) (which requires SET COMPATIBLE ON) because I can't be sure of each

Re: Thor missing on VFPX (was RE: Checking in on FOXCHARTS) (DISREGARD)

On 2017-04-19 16:02, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2017-04-19 08:48, Richard Kaye wrote: Try using Thor before Codeplex is completely off-line. I think it might have the various bits and pieces you're looking for. I'd also get his chart designer class as it's very

Thor missing on VFPX (was RE: Checking in on FOXCHARTS)

On 2017-04-19 08:48, Richard Kaye wrote: Try using Thor before Codeplex is completely off-line. I think it might have the various bits and pieces you're looking for. I'd also get his chart designer class as it's very helpful with tweaking charts in realtime. Also, Jim hangs out in a Thor Google

Re: Checking in on FOXCHARTS

On 2017-04-19 09:07, Gianni Turri wrote: Found! https://vfpx.codeplex.com/releases/view/18515 Thanks, Gianni! Now I can't find Thor's on VFPX. Going to create a new thread on that now. ___ Post Messages to: ProFox@leafe.com Subscription

Re: Checking in on FOXCHARTS

On 2017-04-19 12:01, Koen Piller wrote: Hi, Post your question(s) about Foxcharts on Foxite.com, many people using this fabolous coding (FoxCharts) are frequently visiting this forum, I am sure you well get usefull answers. Regards, Koen Thanks, Koen! I'll check out foxite.com and post

Re: Checking in on FOXCHARTS

On 2017-04-18 23:06, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: 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

Checking in on FOXCHARTS

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

Re: [NF] Gartner predicting things "dead" again and the user community reaction....deja vu?

On 2017-04-17 18:13, Ted Roche wrote: And I hear it's the year of the Linux desktop. BWAHAHAHAHA!!! That originally was what...15 years ago? More? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

[NF] Gartner predicting things "dead" again and the user community reaction....deja vu?

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

Re: Fuzzy Name Searching

On 2017-04-12 17:22, Mike wrote: I found a Levenshtein function somewhere last year and have been using it with MariaDB as a function on the MariaDB server, called from my VFP 9 application. It's exceptionally fast and works pretty well. My application needs to get "as close as" matches to a

Re: [NF] What's in your event log?

On 2017-04-13 11:25, Ted Roche wrote: Yup, using IPStuff or BLAT to send emails out of VFP is a piece of cake. SMTP good, MAPI Bad. I know you have always said this--AND I BELIEVE YOU!!!--but I've used CDO in my automatic bug reporting for years with success.

Re: VFP EXE and RDS random crashes

On 2017-04-11 09:19, Wollenhaupt, Christof wrote: What I'm seeing in the Windows application log when this happens are mainly C6 errors. C6 errors occur when VFP opens a file using memory mapping (APP, EXE, DLL, mostly), accesses a part of the file that is mapped into memory and the file

Re: Easy way to get UNC from drive mapping?

On 2017-04-11 15:17, Mike wrote: Methinks Microsoft moved the cheese... ROFLMBO! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Easy way to get UNC from drive mapping?

On 2017-04-10 17:15, Mike wrote: FWIW, the REGISTRY solution you sent a link to doesn't work well for me. I have 2 mapped drives to a local server (same subnet as my workstation) and 4 mapped drives to remote servers via VPN. The REGISTRY key you send the link to only has one of the 6

Re: [NF] Recommendation on a 3rd party VPN service?

On 2017-04-08 20:51, Malcolm Greene wrote: Wondering if any of you are using a 3rd party VPN service and if so, which services would you recommend or suggest I avoid? My use case: MacBook, iPhone/iPad devices while traveling. Here's my short list (in no particular order): - Private Internet

Easy way to get UNC from drive mapping?

I use GETFILE() to select a file from the network. I want the resulting filename (saved elsewhere) to have the UNC drive mapping instead of the mapped drive letter. Just wanted to check to see if anyone has this before I stick-build it using registry classes. (See

Re: What's your SET ANSI setting? (VFP9SP2)

On 2017-04-08 06:51, Ted Roche wrote: If you leave them both OFF, you won't run into trouble. Use == for "exactly equals" and you don't need to mess with the setting command. But set them both ON if that's what you want. With the two settings different, SEEK and SELECT yield different results.

Re: Retrospective properties - the magic of inheritance

On 2017-03-31 10:45, Fernando D. Bozzo wrote: Yes, that work, but take care of using more than 3 subclass levels, because sooner or later you could start having a nightmare with code maintenance and even strange errors. VFP doesn't always do a very good job with many subclass levels. I've

Re: Codeplex is shutting down, VFPX.org is spinning up

On 2017-04-03 06:26, Ted Roche wrote: Thankfully, it's not the Gates/Ballmer eras any more, so perhaps we'll see a kinder, gentler Microsoft. M$ seems to be so much better since Ballmer left. Several didn't care for MonkeyBoy, including yours truly.

What's your SET ANSI setting? (VFP9SP2)

Just ran across an instance where I had SET EXACT ON but didn't specify SET ANSI (for which the default is OFF). After seeing a query for CHICAGO contain results including others like CHICAGO HEIGHTS, I investigated and thought my SET EXACT was OFF. Nope, it was ON but my SET ANSI was OFF.

[NF] Software craftsmanship

Good article: https://www.linkedin.com/pulse/what-software-craftsmanship-david-max "Our view at LinkedIn — and I’m saying this not because somebody designated me to define company policy, but rather because this is just how we talk about craftsmanship here (it’s even on our internal Wiki

RE: VFP9SP2 report error with _pagetotal variable

On 2017-03-27 13:23, Richard Kaye wrote: [Page ]+ALLTRIM(TRANSFORM(_pageno))+IIF(_pagetotal>1,[ of ]+ALLTRIM(TRANSFORM(_pagetotal)),[]) This is the expression I use. I can't recall seeing it misbehave. -- rk Hi Richard, This only misbehaves when you select that the group starts on a NEW

RE: VFP9SP2 report error with _pagetotal variable

On 2017-03-27 13:10, Richard Kaye wrote: How do you have REPORTBEHAVIOR set? I tried it with 80 and 90, both. Same problem. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

Re: VFP9SP2 report error with _pagetotal variable

On 2017-03-27 11:49, Bill Anderson wrote: Mike, I haven't looked at the video, just a WAG here... http://tinyurl.com/lpjp7b3 Apply the patches and retest. Bill Anderson Hi Bill! Went there, clicked the link to appply the hot fix and got: Microsoft Developer Network > Samples > The page

VFP9SP2 report error with _pagetotal variable

See https://www.screencast.com/t/8bj9GNQk for what's happening. Outermost group is CUST_ID. In Report Writer, Data Grouping tab, I've selected Group starts on NEW PAGE NUMBER 1 (the last radio option). I must admit I've never used this option before; most of my reports are always the New

Re: Finding geographical areas around a city name or zip code (SOLVED)

Here's the math I used in VFP using the lat/long of both endpoints to determine the distance: FUNCTION CalcDistance(StartingLat as Number, StartingLong as Number, EndingLat as Number, EndingLong as Number) as Number RETURN 3956 * 2 * ASIN(SQRT((SIN((StartingLat - EndingLat) * pi()/180 /

Re: Finding geographical areas around a city name or zip code

So I've done some searching on google and found easy pages where I can basically seed the URL with the points and then screen-scrape the distance between the two points, like this:

Re: Monday Survey Question

5. Would you buy VFP books if you could find them? Did Whil ever clear out his storage space? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

XFRX ReportsInCloud.com (was RE: Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.)

New feature from the XFRX folks: http://www.reportsincloud.com/ Looks pretty cool! On 2017-03-16 18:00, José Enrique Llopis wrote: I use XFRX http://www.eqeus.com/ Jose Enrique Llopis www.multilinkcrm.com ___ Post Messages to:

RE: Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.)

On 2017-03-17 10:33, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I've used PDFCreator for years and years as a "printer" that creates PDFs. Also free. BullZip and FinePrint -- can these be integrated into your program? Just curious. My need here is for Excel and Word outputs most of

RE: Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.)

I've used PDFCreator for years and years as a "printer" that creates PDFs. Also free. BullZip and FinePrint -- can these be integrated into your program? Just curious. My need here is for Excel and Word outputs most of the time, but I'm still curious for the heck of it for integration with

Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.)

Wanted to see what folks are using for this? Years ago I had XFRX for various outputs. tia, --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Finding geographical areas around a city name or zip code

(to be done in VFP9SP2 existing app) Customer need: to grab/query towns near a certain zip code or city name, akin to like when you use an app where you're looking for a car and say "show me matches within 50 miles." I'm thinking latitude/longitude and google somehow, but I thought I'd poll

Re: R.I.P. Marcia Akins

On 2017-03-14 15:48, Vince Teachout wrote: On 3/14/2017 10:01 AM, Jean Laeremans wrote: Some of you who participate on the Universal Thread might already be aware of this. This morning Andy Kramek emailed me and told me of the very untimely passing of Marcia Akins. I'm so sorry to hear of

Re: FoxInCloud V 2.24 released, integrating Bootstrap

On 2017-03-02 11:34, Thierry Nivelet wrote: Hi, Just let you know (if you don't already) that FoxInCloud 2.24 can now build a Responsive Web Application out of any 'legacy' VFP desktop application. More details on blog post: http://bit.ly/2lY4CsV What did Bootstrap replace in it? Native

Re: VFP Codeplex site down?

Blame the Russian hackers. On 2017-02-27 15:19, Fred Taylor wrote: I didn't even notice that when I brought the page up. Also, isn't it http://vfpx.codeplex.com/ for the main page? (note the vfpx) Fred On Mon, Feb 27, 2017 at 12:37 PM, Ted Roche wrote: I got a really

Re: Scope Resolution ::

On 2017-02-21 13:39, Ted Roche wrote: The most valuable thing I learned about JavaScript (from the O'Reilly "JavaScript: The Good Parts" by Doug Crockford, a very, very short book) is that JS is not OOP. It is object-based, everything can be an object, but it only has prototype inheritance of

Re: Diffing VCXs

On 2017-02-20 15:53, Alan Bourke wrote: By that, are you saying "just have VCXes for the visual stuff and put all the non-visual code in PRGs." Yep. In fact I don't think UI code/markup/metadata lends itself well to source control in any language on any platform. I'm betting you're right

Re: Integrating FoxBin2PRG (was Re: Diffing VCXs)

I want to get setup with BitBucket asap, and I've already printed out Rick Borup's session from 2015 as a reference guide. On 2017-02-20 18:12, Fernando D. Bozzo wrote: Hi Mike: We are using it with PlasticSCM, the best DVCS I know of, compared with SourceSafe, CVS, SVN, and Git. Git is

Re: Diffing VCXs

On 2017-02-08 06:01, Alan Bourke wrote: All this is why IMO the best approach is to have as much code as possible in programmatic classes and treat VCX files as atomic units. By that, are you saying "just have VCXes for the visual stuff and put all the non-visual code in PRGs." Typically,

Integrating FoxBin2PRG (was Re: Diffing VCXs)

On 2017-02-07 18:27, Fernando D. Bozzo wrote: Hi Rick! ...I think you should definetly take a look at FoxBin2Prg. It will make your team's (1 dev or more) life easier. We use it in 2 teams with 8+ people each one, and a LOT of merging of VCX and SCX every day, without problems. Hi

RE: Diffing VCXs

On 2017-02-01 10:04, Richard Kaye wrote: The enhanced SCCTEXT is a VFPx project. Looking at the SCCTEXTx.PRG, I see Fernando was a part of this Fernando D. Bozzo (fdbo...@gmail.com)

RE: Scope Resolution ::

On 2017-02-16 12:52, Gene Wirchenko wrote: but this use of the Scope Resolution operator allowed me to jump 2 levels in the OOP hierarchy, Gene. DODEFAULT(x,y) would have ran the method 1 above, and that's not what I needed. Like I said, at first, it didn't seem very OOP to me, but

RE: Scope Resolution ::

On 2017-02-14 17:29, Gene Wirchenko wrote: At 01:54 2017-02-14, Dave Crozier wrote: Mike, It is extremely hands in certain circumstances and can save you loads of extra programming work. However like yourself I tend to forget about it (as opposed to never knowing about

RE: Trying to create shortcut text

On 2017-02-14 10:44, Richard Kaye wrote: I would avoid using standard VFP hot keys. VFP uses CTRL-D for DO program... Good point ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

Re: Trying to create shortcut text

On 2017-02-14 09:51, Alan Bourke wrote: You're not including the key you need to press to make it happen, e.g.: On Key Label SHIFT+F1 keyboard "[dbo]." DOH! Yes, of course. That's exactly it. Anything to type less and keep carpel tunnel from getting me sooner. ON KEY LABEL CTRL+D

Re: Trying to create shortcut text

On 2017-02-14 09:53, Stephen Russell wrote: You can just place a single period there instead if you want on TSQL. [SERVER\INSTANCE].dbName.dbo.TradingPartners is also found: [SERVER\INSTANCE].dbName..TradingPartners Do you have other schemas? We've got a slick framework whereby we don't

RE: Trying to create shortcut text

On 2017-02-14 09:45, Richard Kaye wrote: Record a macro. :-) Great idea...but that only fixes my current setup. I want to have this ability in our dev tool too so other developers can just check a box and have that ability as well. ___ Post

Trying to create shortcut text

My days are filled with T-SQL coding now, so I wanted to create a shortcut key sequence to insert the [dbo] in front of things when needed. This doesn't work: ON KEY LABEL KEYBOARD "[dbo]." Ideas? tia. ___ Post Messages to: ProFox@leafe.com

Re: TaskPane entry for ProFox outdated

On 2017-02-13 15:44, Mike wrote: mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2017-02-10 11:52, Ed Leafe wrote: I haven't touched VFP since early 2008. I don't even own a copy of it anymore. I saw on here that you can find a copy on ebay for less than $20, if you're so inclined.

So what tech do you like to work in nowadays? (was Re: TaskPane entry for ProFox outdated)

On 2017-02-10 11:52, Ed Leafe wrote: I haven't touched VFP since early 2008. I don't even own a copy of it anymore. Ed (and others), What tech do you find yourself enjoying nowadays? I don't just mean doing it for a paycheck, but something that you REALLY like, akin to the golden days

Scope Resolution ::

Wow...got a tip from my boss to subclass something and use the Scope Resolution operator to call the parent class. At first, I was skeptical as I thought it was kinda kludgey, as the last time I saw :: code 15+ years ago, I was like "what the heck is that?" but after implementing it today,

Re: TaskPane entry for ProFox outdated

On 2017-02-10 11:52, Ed Leafe wrote: I haven't touched VFP since early 2008. I don't even own a copy of it anymore. I saw on here that you can find a copy on ebay for less than $20, if you're so inclined. hahaha ___ Post Messages to:

Re: TaskPane entry for ProFox outdated

On 2017-02-09 14:01, Ed Leafe wrote: On Feb 8, 2017, at 11:36 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Apparently this doesn't work anymore when clicking on the ProFox Email List (under Community in the Task Pane startup): https://leafe.com/mailman/listinfo/profox Who do we

<    2   3   4   5   6   7   8   9   10   11   >