Re: [NF] Windows updates August problems?
Later, "Restart Now or Restart Later?" revealed that some of the recent updates STILL were not successfully installed. Restarted. Lather, rinse and repeat the above three times. A recent Win 10 update broke the Update History. Could that be why the user thinks nothing has been installed? http://www.computerworld.com/article/3214488/microsoft-windows/windows-10-1607-cumulative-update-kb-4034658-wipes-out-update-history.html Windows Automatic Updates. Just Say No. (TM) Ken Dibble www.stic-cil.org ___ Post Messages to: ProFox@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/85.50.12431.BC9AB895@cdptpa-omsmta03 ** 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.
Re: [NF] Windows updates August problems?
I would roll back the updates individually, then reboot to see if that helped. CONTROL PANEL UPDATE AND SECURITY UPDATE HISTORY UNINSTALL UPDATES Look for the most recent "Installed on" and start un-installing. Only other idea would be to make sure all the drivers (video, chipset, NIC, etc) are as up-to-date as possible. Mike Copeland Ted Roche wrote: One of our office workstations has been very unhappy since the shutdown Tuesday asked to install updates. Dell Precision M6800 Workstation i7 2.80GHz, 16 Gb RAM, dual 1Gb HDDs Windows 10 Pro Version 1607 (14393.1593) Got the usual "Updating..." when restarting this morning. And waited, and waited. Restarting was sluggish, WiFi kept starting and stopping, After patiently waiting a few minutes, shut down cold and restarted. Worked okay for a while. Later, "Restart Now or Restart Later?" revealed that some of the recent updates STILL were not successfully installed. Restarted. Lather, rinse and repeat the above three times. Attempting to persuade the ever-patient associate not to throw her machine out the window. "That's why they call it Windows," right? Nothing obvious in the error logs. No disk errors. Next step will likely be to attempt to restore from the previous rescue point which, in my limited experience of a dozen or so attempts, never works. Ideas? Suggestions? Mocking? ___ Post Messages to: ProFox@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/c64d7300-4db7-1d83-c2e0-9426d1e4e...@ggisoft.com ** 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.
[NF] Windows updates August problems?
One of our office workstations has been very unhappy since the shutdown Tuesday asked to install updates. Dell Precision M6800 Workstation i7 2.80GHz, 16 Gb RAM, dual 1Gb HDDs Windows 10 Pro Version 1607 (14393.1593) Got the usual "Updating..." when restarting this morning. And waited, and waited. Restarting was sluggish, WiFi kept starting and stopping, After patiently waiting a few minutes, shut down cold and restarted. Worked okay for a while. Later, "Restart Now or Restart Later?" revealed that some of the recent updates STILL were not successfully installed. Restarted. Lather, rinse and repeat the above three times. Attempting to persuade the ever-patient associate not to throw her machine out the window. "That's why they call it Windows," right? Nothing obvious in the error logs. No disk errors. Next step will likely be to attempt to restore from the previous rescue point which, in my limited experience of a dozen or so attempts, never works. Ideas? Suggestions? Mocking? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@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/cacw6n4t9+klkwwmftghxcyhtktnuut-01lhmw7jmzisw3zr...@mail.gmail.com ** 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.
Southwest Fox 2017: Extending Early-bird Deadline
Ooops, we goofed! One of the us went on vacation and completely forgot to schedule the end of July reminder to get registered before the Southwest Fox 2017 Early-bird deadline. So to make up for this colossal mistake, we have decided to extend the Early-bird discount of $50 through August 21st. The conference takes place October 26-29, 2017 in Gilbert, Arizona and we really hope you can be there. Head over to the registration Web site today: https://geekgatherings.com/Registration Check out our list of amazing speakers and dig into our session tracks on our site: http://swfox.net. Follow the news about the conference on our blog. Rick, Doug, and Tamar --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@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/015e01d31131$711927a0$534b76e0$@whitelightcomputing.com ** 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.
Re: SQL Error
Thanks to everyone. Never looked at that help page before. Laurie On 9 August 2017 at 16:11, Richard Kayewrote: > Tamar needs a new pair of shoes. Buy her book - > http://www.hentzenwerke.com/catalog/tamingvfpsql.htm :-) > > -- > > rk > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave > Crozier > Sent: Wednesday, August 09, 2017 11:01 AM > To: profoxt...@leafe.com > Subject: RE: SQL Error > > Like using "in (select .. ) " which is equally poorly documented. > > Dave > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@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/camvtr9e7l_hi-mjzntu-czpzk131gutcdp4bfpshfbf1-1y...@mail.gmail.com ** 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.
RE: SQL Error
Tamar needs a new pair of shoes. Buy her book - http://www.hentzenwerke.com/catalog/tamingvfpsql.htm :-) -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Wednesday, August 09, 2017 11:01 AM To: profoxt...@leafe.com Subject: RE: SQL Error Like using "in (select .. ) " which is equally poorly documented. Dave ___ Post Messages to: ProFox@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/cy4pr10mb176753f61b77eafe8e4cb054d2...@cy4pr10mb1767.namprd10.prod.outlook.com ** 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.
RE: SQL Error
Like using "in (select .. ) " which is equally poorly documented. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 09 August 2017 15:33 To: profoxt...@leafe.com Subject: Re: SQL Error On Wed, 9 Aug 2017, at 03:21 PM, Laurie Alvey wrote: > I've only ever used EXISTS in T-SQL. Didn't know it could be used in VFP. > It doesn't seem to be documented anywhere - what about SOME or ANY? it's on the "Filter Conditions for Queries and Views" help file page. SOME and ANY also. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@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/18725b8cd2d5d247873a2baf401d4ab2b478c...@ex2010-a-fpl.fpl.LOCAL ** 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.
Re: SQL Error
On Wed, 9 Aug 2017, at 03:21 PM, Laurie Alvey wrote: > I've only ever used EXISTS in T-SQL. Didn't know it could be used in VFP. > It doesn't seem to be documented anywhere - what about SOME or ANY? it's on the "Filter Conditions for Queries and Views" help file page. SOME and ANY also. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@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/1502289159.2870383.1068110536.6e5c3...@webmail.messagingengine.com ** 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.
Re: SQL Error
I've only ever used EXISTS in T-SQL. Didn't know it could be used in VFP. It doesn't seem to be documented anywhere - what about SOME or ANY? Laurie On 8 August 2017 at 19:04, Koen Pillerwrote: > I have the same idea, will inform the helpfile autor. Do you have a > proposal ? > Koen > > Op di 8 aug. 2017 om 18:08 schreef Dave Crozier > > > Koe, > > Yes, but the Between() function or SQL Between expression doesn't fit in > > with being a simple expression like X<=Y or X > Y and you have proved > this > > when you split up the code to read cwkt.trndate > cwkt.trndate>validfr which effectively become two "simple expressions". > > > > I guess it must be something to do with how the Between expression is > > parsed, probably because it will create an additional sub query of its > own > > internally. > > > > Dave > > > > -Original Message- > > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Koen Piller > > Sent: 08 August 2017 16:58 > > To: ProFox Email List > > Subject: Re: SQL Error > > > > Hi, > > > > Maybe in Visual Studio Net 2003, > > > > However in VFP this works :) > > select .T. ; > > From ctwc; > > where; > > cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And; > > cwkt.trndatevalidfr ; > > order By funccode, trndate, clcode, wccode, wonbr Into Cursor > > tempselect .T. ; > > From ctwc; > > where; > > cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And; > > cwkt.trndatevalidfr ; > > order By funccode, trndate, clcode, wccode, wonbr Into Cursor temp > > > > > > 2017-08-08 17:54 GMT+02:00 Dave Crozier : > > > > > According to Microsoft Themselves: > > > > > > SQL: Error correlating fields > > > Visual Studio .NET 2003 > > > > > > An outer reference can be used only in syntax similar to the following: > > > > > > X = Y > > > > > > Syntax such as X = Y + 1 or X = 5 will produce this error. > > > > > > Dave > > > > > > -Original Message- > > > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Koen > > > Piller > > > Sent: 08 August 2017 16:40 > > > To: ProFox Email List > > > Subject: Re: SQL Error > > > > > > Hi, > > > > > > Please note: > > > > > > select .T.; > > > FROM cwkt; > > > where; > > > cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And; > > > (cwkt.trndate BETWEEN ctwc.validfr AND ctwc.validto); > > > order By funccode, trndate, clcode, wccode, wonbr Into Cursor temp > > > > > > gives a result > > > > > > and > > > > > > select .T. ; > > > From ctwc; > > > where; > > > cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And; > > > cwkt.trndatevalidfr ; > > > order By funccode, trndate, clcode, wccode, wonbr Into Cursor temp > > > > > > errors: Column funccode is not found. > > > > > > queries are identical however query 1 uses between etc and query 2 > > > uses < etc > > > > > > and query3 with the VFP between function: > > > > > > select .T.; > > > FROM cwkt; > > > where; > > > cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And; > > > BETWEEN(cwkt.trndate, ctwc.validfr, ctwc.validto); > > > order By funccode, trndate, clcode, wccode, wonbr Into Cursor temp > > > > > > also gives a result > > > > > > for you to test yourselve: > > > > > > CREATE CURSOR cwkt ( funccode C(2), trndate d, clcode c(10), wccode > > > c(10), wonbr c(1)) INSERT INTO cwkt( > > > funccode,trndate,clcode,wccode,wonbr) > > > VALUES ("AB", {^2017.01.01}, "DD", "BB", "1") INSERT INTO cwkt( > > > funccode,trndate,clcode,wccode,wonbr) VALUES ("TW", {^2017.08.01}, > > > "DA", "BA", "2") INSERT INTO cwkt( > > > funccode,trndate,clcode,wccode,wonbr) VALUES ("TW", {^2017.03.01}, > > > "DB", "BC", "3") INSERT INTO cwkt( > > > funccode,trndate,clcode,wccode,wonbr) VALUES ("TW", {^2017.04.01}, > > > "DC", "BD", "4") > > > > > > CREATE CURSOR ctwc ( clcode c(10), wccode c(10),validfr d, validto d) > > > INSERT INTO CTWC( clcode, wccode, validfr, validto) VALUES ("AC", > > > "BB", > > > {^2017.01.01},{^2017.01.01}) > > > INSERT INTO CTWC( clcode, wccode, validfr, validto) VALUES ("DA", > > > "BA", > > > {^2017.01.01},{^2017.09.01}) > > > INSERT INTO CTWC( clcode, wccode, validfr, validto) VALUES ("DB", > > > "BC", > > > {^2017.01.01},{^2017.02.01}) > > > INSERT INTO CTWC( clcode, wccode, validfr, validto) VALUES ("DC", > > > "BD", > > > {^2017.01.01},{^2017.05.01}) > > > > > > and the full syntax > > > > > > select *; > > > from cwkt; > > > where; > > > funccode="TW" And trndate>={^2017.07.01} And; > > > exists; > > > (; > > > select .T. From ctwc; > > > where; > > > cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And; > > > BETWEEN(cwkt.trndate, ctwc.validfr, ctwc.validto); > > > ); > > > order By funccode, trndate, clcode, wccode, wonbr Into Cursor temp > > > > > > errors: SQL - error correlating fields. > > > > > > the
Re: Fwd: 2017 News from Hentzenwerke Publishing!
ordered! Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 04/08/2017 à 11:55, mbsoftwaresoluti...@mbsoftwaresolutions.com a écrit : On 2017-08-04 05:21, Michael J. Babcock wrote: Got this from HWP (Whil) today. If you didn't get one, you can probably still use that same link (not sure if that cryptic string is specific to me or not?) to add yourself to his mailing list. The only VFP10 I've heard is some modified Chinese version, which I'm not sure I'd ever use. Still, VFP9SP2, as old as it is, still kicks ass! Here's the Amazon link to the "VFP 10: Hard to Kill" book: https://www.amazon.com/gp/product/1930919131/ref=as_li_qf_sp_asin_il_tl?ie=UTF8=hentzenwerkepubl=1789=9325=as2=1930919131=96d0a966d2a7d0493ee0482962e81830 or http://preview.tinyurl.com/vfp10-hard-to-kill Written by Whil, and edited by our beloved Ted Roche I see! :-) [excessive quoting removed by server] ___ Post Messages to: ProFox@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/ba1c29ab-2a69-b456-88d5-fa02e529e...@foxincloud.com ** 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.
Re: Fwd: 2017 News from Hentzenwerke Publishing!
Hi Ted, IMO, a balanced TOC for a VFP10 book would be (pseudo writing): 1. Keeping your VFP app up and performing for decades without rewrite 2. Expanding your VFP app far beyond 'traditional' desktop 3. Recruiting developers for your VFP app Point 3 is in every manager's head; it has to be addressed and we collectively need to find a way to keep some young people interested in VFP; the only efficient way I know is to deliver an exciting message, not to tell them "you're entering into a carrier dead-end where you'll have to maintain boring legacy code, please enjoy" I wish I could decently write in English, and doubt anyone would be interested in a book written in French, even you as an Editor! ;) Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 08/08/2017 à 21:21, Ted Roche a écrit : On Tue, Aug 8, 2017 at 2:53 PM, Thierry Niveletwrote: Sounds kinda defensive, like "how you can survive with VFP while outdated and clumsy" I think you're looking through the wrong end of the telescope. Whil's book is dealing with supporting existing clients, inheriting the apps of the others, and pointers on maintaining applications into their second and third decades. These are important skills, too. I'd prefer a book mostly showing the exciting things one can do with VFP, and expanding 'legacy' VFP applications. Well, let me know how your book writing goes. If you are looking for an editor, keep me in mind! Third party software take a large part of these exciting opportunities. Absolutely! My most successful applications use a lot of third party software, from web serving to office automation to graphics and GIS! I have always been a big supporter of the philosophy of integrating many tools to make the most powerful application. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@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/17063c7f-e2dc-3632-442d-063cc9fa7...@foxincloud.com ** 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.