ProFox August 2016

profox@leafe.com

49 participants
61 discussions

[NF] training vids for a variety of software at a cheap price
by Stephen Russell 10 Aug '16

10 Aug '16

I have had a subscription to this company for 5 years now to keep up on stuff that is changing. They get pretty deep on what the video is presenting so it is not a 5 min glossy hello world ever. http://www.learnnowonline.com/dev-it-video?utm_source=cp&utm_medium=email&u… Here is the list on what they offer in the subscription. They were 100% M$ but have ventured out to a lot more in the past few years. Probably ending Friday 8-12 $49.00 for unlimited viewing of all that content. I look to see the SQL Server new version videos as well as SharePoint and Reporting and Analysis Services. Regular price is 99.00 so this is 1/2 off. ------------------------------ Open Source <http://www.learnnowonline.com/courses/open%20source> - AngularJS - Bootstrap - JavaScript - jQuery - Linux - Python - Ruby on Rails - More Security <http://www.learnnowonline.com/courses/security> - CompTIA Security+ - Ethical Hacking - OWASP Java <http://www.learnnowonline.com/courses/java> - AJAX - DOJO - Hadoop - Java SE - JSON - JSP - Spring - More ------------------------------ SharePoint <http://www.learnnowonline.com/courses/sharepoint> - Administration - Business Users - Development - Power Pivot - Power Users - Site Owners Microsoft SQL Server <http://www.learnnowonline.com/courses/sql%20server> - Administration - Analysis Services - Business Intelligence - Development - Integration Services - Reporting Services Microsoft Visual Studio <http://www.learnnowonline.com/courses/visualstudio> - .NET - AJAX - ALM Tools - ASP.NET - C# - Lightswitch - LINQ - More ------------------------------ IT Pro <http://www.learnnowonline.com/courses/it%20tools> - Windows Server - CompTIA A+ - CompTIA Net+ - Hardware - ITIL - PMP Mobile <http://www.learnnowonline.com/courses/mobile> - Android - HTML5 for Mobile - iOS - jQuery for Mobile - Cross Platform - Xamarin - MonoTouch - More Cloud/UX Design <http://www.learnnowonline.com/courses> - Windows Azure - SQL Azure - UX Design - Expression Builder - Windows 8 Design -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Re: Minor VFP Bug on Filter Expressions
by Gene Wirchenko 10 Aug '16

10 Aug '16

At 02:14 2016-08-10, Laurie Alvey <trukker41(a)gmail.com> wrote: >Mmm. Just tried it - no difference. There doesn't seem to be any error >checking. Yup. I thought I would warn about this gotcha so people knew, just like I warned about no error given when a method name is duplicated in code in a class. [snip] Sincerely, Gene Wirchenko

1 0

Re: Minor VFP Bug on Filter Expressions
by Gene Wirchenko 10 Aug '16

10 Aug '16

At 22:08 2016-08-09, Laurie Alvey <trukker41(a)gmail.com> wrote: >Not sure if this is relevant, but SET FILTER does not come into effect >until the record pointer moves, Try this: >SET FILTER TO <invalid expression> >GO TOP >BROWSE Nope. No error is thrown, and the browse is empty. [snip] Sincerely, Gene Wirchenko

1 0

Minor VFP Bug on Filter Expressions
by Gene Wirchenko 10 Aug '16

10 Aug '16

Hello: I just ran into a minor bug in VFP on filter expressions. I typed the following: use cwko order tag cwkow set filter to clcode="KAK and left(wccode,2)="SP" browse and got an empty browse. What? I missed the closing quote after "KAK". That second line should have been: set filter to clcode="KAK" and left(wccode,2)="SP" I did *not* get an error on the original set filter line or the browse despite the filter expression being invalid. Sincerely, Gene Wircheko

3 3

Width and Decimal (VFP) vs Precision and Scale (SQL)
by Paul Newton 08 Aug '16

08 Aug '16

Hi all It's probably best if I explain this by example. Let's say we have a field in VFP with Width 4 and Decimal 2. In a browse the maximum value that we can enter is 9.99 (as would be expected). BUT by means of a REPLACE we could end up with values of 99.9, 999 or even 9999 without getting numeric overflow. Because of this, and because we want to write away the VFP data to SQL Server we have been setting the equivalent SQL Server field (or more strictly column) to a Precision of 6 and Scale 2. Similarly a VFP field of Width 8 and Decimal 3 would have an equivalent SQL Server column of Precision 11 and Scale 3. This isn't really very satisfactory and I was wondering how other people deal with this. Ideally our code should not allow a replace with values (in the first example) greater than 9.99. Of course VFP does complain if we try to replace the value with 99999 (Numeric overflow. Data was lost) We would have preferred it if VFP were to complain in ALL cases where the replacement value is greater than 9.99 but, alas, that is not the case. Any thoughts, comments or suggestions would be very welcome. Paul Newton

3 7

[NF] One Note
by Charles Hart Enzer, M.D. 08 Aug '16

08 Aug '16

OS is WIN 10 Home I removed Office. How do I stop OneNote being the default folder for downloads, attachments, eBooks, Kindle Books and such like? And since I don't want to use OneNote, how do I removed the folder? *CharlesCharles Hart Enzer, M.D., FAACAPVolunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: http://TinyURL.com/EnzerMD <http://TinyURL.com/EnzerMD>* *“There is no passion to be found playing small -- in settling for a life** that is less than the one you are capable of living.”* * Nelson Mandela* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Re: Bad getwordnum
by Claudio 05 Aug '16

05 Aug '16

> ----- Original Message ----- > > Instead of using Getwordnum, split the string in an array using > ALINES(yourarray,yourstring,3,',') > > You can then access to each word, even if it's a null string. > > Gérard. > > [excessive quoting removed by server] > > Absolute awesome!!! This appear to be another "undocumented functionality", isn't it? (ALINES would be intended to split rows instead of words) Learning never stops.

10 13

Development platform/language
by Mike Copeland 05 Aug '16

05 Aug '16

Just sitting here on a hot July Friday and pondering development platforms and languages. In the past a lot of discussion has focused on Python, and there's always Ruby, etc., and I'm impressed with XOJO...what I've seen so far. Of course Microsoft is still a player, but other than Visual Foxpro, what is the current "most likely to succeed" development platform/language in this group's opinion? Just throwing it out there...curious what the pulse is and where things seem to be going in mid-2016. Have a great weekend! Mike Copeland

9 18

ODBC connections to Oracle problem
by Fletcher Johnson 04 Aug '16

04 Aug '16

Hi all, Long time, no chat.. But I still lurk. It's good to see this much chatter on such a great product. Anyway, I have a former (and now current) client who has 2 applications written in VFP 8 or 9 that talk to an Oracle server. The programs were written back in 2000, with the last build being around 2006 or so. At that time, it was working with Oracle 8i. They have set up some new computers and installed Oracle 11. They have no access to Oracle 8i (Oracle long since discontinued it.) Even if a 3rd party still has it available, due to various reasons, they could not use a version from any source other than the original manufacturer. The problem is that their initial attempts to get it working did not work. They have some people working on it, but I thought I would check with you to see if any of you have any ideas why it might not work (and better, what to do to fix it.) The problem seems to be around the TNS approach they used to route to the correct server. I did find some source code, but not sure if it is the same as what is in the .exe they run. So my preference is to get it to run without having to create a new exe. Anyway, I appreciate any suggestions you may have. Fletcher Fletcher Johnson <mailto:FletcherSJohnson@Yahoo.com> FletcherSJohnson(a)Yahoo.com <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson <http://beknown.com/FletcherJohnson> beknown.com/FletcherJohnson twitter.com/fletcherJ <https://www.strava.com/athletes/fletcherjohnson> strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

RE: Windows 10 Anniversary Update Massively Broken
by Ken Dibble 04 Aug '16

04 Aug '16

That's why it's Russian Roulette. In Russia, mess clean up YOU! (Apologies to Yakov Smirnov) Ken Dibble www.stic-cil.org >Nice one! Of course, in original version - you can't clean up your >own mess!! Somebody else has to do it for you. > >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 Ted Roche >Sent: Thursday, August 04, 2016 2:58 PM >To: profoxtech(a)leafe.com >Subject: Re: Windows 10 Anniversary Update Massively Broken > >On Thu, Aug 4, 2016 at 1:58 PM, Kurt Wendt <Kurt_Wendt(a)globetax.com> wrote: > > So - it's the Windows version of Russian Roulette! :-) > >Well, except you don't get any vodka... > >... and you have to clean up the mess after you lose ;^) > > >-- >Ted Roche >Ted Roche & Associates, LLC >http://www.tedroche.com > [excessive quoting removed by server]

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox August 2016