ProFox January 2016

profox@leafe.com

46 participants
59 discussions

Re: Alias()
by Sytze de Boer 27 Jan '16

27 Jan '16

Thanks for having a look Gene, but I don't think you've seen my code correctly. Clcode is a field in the Windebs table It is the "currently" selected table (or table which is the controlsource of the grid) The error fires on the line that says "lcclient=clcode" On Thu, Jan 28, 2016 at 11:57 AM, Gene Wirchenko <genew(a)telus.net> wrote: > At 12:22 2016-01-27, Sytze de Boer <sytze.kiss(a)gmail.com> wrote: > >> FRIENDS !! >> Thank you all for your comments. I appreciate it. >> >> I decided to post/ask my query because in the past 3 months I've also had >> some major issues. >> I cannot identify the cause and I'll briefly describe it here. >> >> I have a form with a grid. The controlsource is a free standing table. >> (Clients table called Windebs) >> The form has a command group with several buttons. >> Example, "Show Transactions" >> The click event has code such as >> lcclient=clcode >> select * from winhst where client=lcclient into curs temp >> >> I end up with an error "variable clcode not found" >> > > How do you manage that with no "clcode" in your code? > > It is as though the underlying table is no longer Windebs, which is nuts >> because I did not "select" another table anywhere. >> > > In the example above, you did a select, and the current alias will be > that of the cursor. The cursor will have the structure of winhst, not > windebs. > > Did you open a table and forget to select 0 before doing so? I made > that mistake just this morning, and my code threw an error when I tried to > close the table that got opened over. > > Now, I've seen similar behavior when Anti virus software is locking the >> tables, or extremely slow network connections, but it just started >> happening about 3 months ago, and only with "some" customers. >> At one time I thought it was only on XP pc's but that theory is also >> disproved. >> >> At this stage I'm slowly trawling through my code and changing Click >> events >> to >> >> sele windebs >> lcclient=clcode >> select * from winhst where client=lcclient in to curs temp >> > > Due to the chaoticness of methods being fired, it can be somewhat > unclear what code has just executed. I prefer to be careful and explicitly > specify tables. I do not trust that the alias has stayed the same over > method firing if I have any alias changing. > > [snip] > > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server]

1 0

Re: Alias()
by Gene Wirchenko 27 Jan '16

27 Jan '16

At 12:22 2016-01-27, Sytze de Boer <sytze.kiss(a)gmail.com> wrote: >FRIENDS !! >Thank you all for your comments. I appreciate it. > >I decided to post/ask my query because in the past 3 months I've also had >some major issues. >I cannot identify the cause and I'll briefly describe it here. > >I have a form with a grid. The controlsource is a free standing table. >(Clients table called Windebs) >The form has a command group with several buttons. >Example, "Show Transactions" >The click event has code such as >lcclient=clcode >select * from winhst where client=lcclient into curs temp > >I end up with an error "variable clcode not found" How do you manage that with no "clcode" in your code? >It is as though the underlying table is no longer Windebs, which is nuts >because I did not "select" another table anywhere. In the example above, you did a select, and the current alias will be that of the cursor. The cursor will have the structure of winhst, not windebs. Did you open a table and forget to select 0 before doing so? I made that mistake just this morning, and my code threw an error when I tried to close the table that got opened over. >Now, I've seen similar behavior when Anti virus software is locking the >tables, or extremely slow network connections, but it just started >happening about 3 months ago, and only with "some" customers. >At one time I thought it was only on XP pc's but that theory is also >disproved. > >At this stage I'm slowly trawling through my code and changing Click events >to > >sele windebs >lcclient=clcode >select * from winhst where client=lcclient in to curs temp Due to the chaoticness of methods being fired, it can be somewhat unclear what code has just executed. I prefer to be careful and explicitly specify tables. I do not trust that the alias has stayed the same over method firing if I have any alias changing. [snip] Sincerely, Gene Wirchenko

1 0

Re: Alias()
by Gene Wirchenko 27 Jan '16

27 Jan '16

At 08:54 2016-01-27, Alan Bourke <alanpbourke(a)fastmail.fm> wrote: Someone (attributio lost) wrote: > > I still use Hungarian notation too, despite Microsoft telling us years > > ago that it's no longer acceptable style. Then again, we Foxers have > > always been rebels. lol > >For strongly-typed languages in modern development tools why would you >use it? Because it is much shorter. Suppose I have an array of client data. I might use: sClient size of clients array cClient how many clients xClient index into array >Makes sense for VFP probably. I have never used it much in VFP. I do not have the name collision I do in other languages. Sincerely, Gene Wirchenko

1 0

Alias()
by Sytze de Boer 27 Jan '16

27 Jan '16

I do the following in one of my modules sele 909 use (ltable) alias Junk1 Excl If I issue wait window alias(), it returns Junk1 If I use (ltable) alias "Junk1" Excl, it returns Junk1 as well Is this normal? I ask because I have a client who consistently ends up with an error variable code not found when I know for sure the table has a field called Code, and I am trying to confirm the underlying table is indeed Junk1 -- Kind regards, Sytze de Boer --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 8

Scroll
by Chris Davis 27 Jan '16

27 Jan '16

Hi All Does anyone have a way of creating a horizontal scrolling text which is smooth? Thanks Chris. ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 8

Code Signing VFP exes
by Tracy Pearson 25 Jan '16

25 Jan '16

Today I ran some tests because customers have reported some odd problems. I updated a Windows 10 computer to all the latest updates and finally got to see what the customer reported. https://s3.amazonaws.com/uploads.hipchat.com/15697/60882/WN2lcXUa8zdne6o/cor ruptsignature1.png "Windows protected your PC Windows SmartScreen prevented an unrecognized app from starting. Running this app might put your PC at risk." Clicking on the more info link allows a customer to run the exe anyway. It also appears this only happens with a SHA-1 certificate signed exe, which was signed after 1/1/2016 that was downloaded from the internet. The customer can "Unblock" the file, and this problem goes away. If you support Windows XP, Vista, or Server 2008 (not R2) you won't see this problem. You will see this problem on newer OS's. If you only sign your EXE with the SHA-2 certificate, it will not work on Windows XP SP3, Vista, and Server 2008 (according to Microsoft). I still need to get the SHA-2 certificate. According to this site: http://social.technet.microsoft.com/wiki/contents/articles/32288.windows-enf orcement-of-authenticode-code-signing-and-timestamping.aspx the exe can be dual signed. I don't know if this process will break the VFP executables. If you are looking for code signing, here's a really good deal. http://codesigning.ksoftware.net/

1 0

[NF] The new Trump language
by Stephen Russell 22 Jan '16

22 Jan '16

Instead of True and False, we have fact and lie. http://gizmodo.com/theres-a-donald-trump-programming-language-1754458693 -- 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 ---

2 2

[NF] Win 7 Update messing with network settings?
by Mike Copeland 22 Jan '16

22 Jan '16

Has anyone else run into this in the last few days? (like since last Tuesday) I've had 10 or 12 Windows 7 Pro systems, so far, that have had their NIC IP address settings switched from manually configured to DHCP. At first I thought it was a fluke, but I keep finding more and more systems that this has happened to. And there was a forced reboot update from MSoft last week. I'm not suggesting nefarious activity, just that I have never seen this happen before. All of the systems are locked down with Admin accounts that use a password that is not available to anyone but myself and one other person. Some of the computers are running video display systems (kiosks)...not even touched by users. The one thing they all have in common is Windows 7 pro. Anything happening like that to anyone else? Thanks! Mike Copeland

3 5

[NF] Robohelp HTML
by Allen Pollard 22 Jan '16

22 Jan '16

Hi foxgang FYI A while ago I mentioned that Robohelp's HTML help refused to go on windows 10. Well odd thing is it was the installer that refused to work on Windows 10. I just updated the windows 7 machine with HTML help on and it still works, well other than not being able to load some components which I don't need anyway, but it did that on 7. Good, saves me looking for a new HTML help prog. Al

1 0

[NF] sad story about an app builder and his M$ experience
by Stephen Russell 22 Jan '16

22 Jan '16

http://www.irrlicht3d.org/pivot/entry.php?id=1485 Why you should not develop apps for Windows 10 My point for posting this is are we all expecting more automated messaging to help fix things these days that we lose sight of the real problem? -- 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 ---

9 18

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox January 2016