ProFox

profox@leafe.com

2704 discussions

[NF] No Internet Connect
by Charles Hart Enzer, M.D. 06 May '18

06 May '18

I ran Network Troubleshooter: No DNS server is responding I then ran DIAGNOSE *Shai / שי Charles Hart Enzer, M.D., FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May, 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html> *"* *“To announce that there must be no criticism of the President, or that we are to stand by the President, right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public.”* *-- Theodore Roosevelt, May 1918* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

[NF] How to block the Windows 10 April 2018 Update, version 1803, from installing
by Ted Roche 04 May '18

04 May '18

How to block the Windows 10 April 2018 Update, version 1803, from installing Woody Leonhard to the rescue once again. https://www.computerworld.com/article/3232632/microsoft-windows/how-to-bloc… Enterprise and WSUS users, yea, blah-blah-blah, you know what to do already. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

6 10

RE: AGETFILEVERSION Fail - SOLVED!
by Gene Wirchenko 03 May '18

03 May '18

At 10:18 2018-05-02, "Paul H. Tarver" <paul(a)tpcqpc.com> wrote: [snip] >So I've updated my class method to include the explicit full path which will >be backwardly compatible with all my previous code and I learned a valuable >lesson: > > "When in doubt, get explicit!" Just like both we and drug pushers have users, the above advice is also useful for the porn industry. >Thanks for everyone's help on this! It was definitely appreciated! Nasty glitches and bugs are nasty. I have a low-priority project to create a grid that works for me. Too much working around trying to get Grid to work. I gave up. [snip] Sincerely, Gene Wirchenko

2 1

[NF] Network Request timed out
by Frank Cazabon 02 May '18

02 May '18

I am having some problems when running code that synchronises data between 2 SQL Servers using SM Sync Framework. This code runs fine at about 50 other sites. I am getting time out errors reported: TCP Provider, error: 0 - The semaphore timeout period has expired Google has suggested this site https://sqlserverscribbles.com/2013/02/15/tcp-provider-the-semaphore-timeou… as possible solutions but I wanted to make sure there is actually a problem before I try to fix it as I am not a network guy. My client doesn't have anyone who manages their network for them either. I found a suggestion to run this command: ping -t hostname > out.txt so I did that and left it running for about 4 and a half hours. In that period I got 38 Request timed out messages (out of 18,685 total messages, so 18,643 were successful, the majority in 3 or 4 ms but pretty regularly going up to 22 or 23ms). Is this normal, or do you think they have a problem? -- Frank. Frank Cazabon

4 5

AGETFILEVERSION Fail
by Paul H. Tarver 02 May '18

02 May '18

Has anyone ever had any problem with AGETFILEVERSION() failing to return values after an ODBC connection is made? I'm using the Oracle ODBC Driver and until the SQLCONNECT() command is issued AGETFILEVERSION() works perfectly. After I issue the SQLCONNECT() command and get a valid handle, AGETFILEVERSION() will not return any values. I have to exit VFP and restart it, then, AGETFILEVERSION() works again until I make another connection to Oracle via ODBC. I've used the Oracle's ODBC driver previously with no ill affect. But now.Grrrrrr! Paul --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 15

RE: AGETFILEVERSION Fail - SOLVED!
by Paul H. Tarver 02 May '18

02 May '18

Thanks to Gianni for giving me the idea which led to the solution. Gianni had written this: > that at the return from "report form ..." the curdir() was changed to > something like C:\Windows\System32. That got me to thinking perhaps the default folder was changing for some unknown reason. It was not. The path remained the same. However, in testing, I wondered what would happen if I explicitly defined the path & filename in the AGETFILEVERSION() command. As the code was written, I got the filename from the ADIR() command but the array of filenames returned does not include the full path. I decided to try re-writing the line for AGETFILEVERSION() like this: lnElements = AGETFILEVERSION(laVersInfo, ADDBS(SYS(5) + SYS(2003)) + laPrograms[m.lnLoopCnt,1]) And it worked perfectly even after getting a connection handle to the Oracle database! I exited my form multiple times and it continued to work as expected. However, when I issue the AGETFILEVERSION() without the full path included, it starts to fail again. So I've updated my class method to include the explicit full path which will be backwardly compatible with all my previous code and I learned a valuable lesson: "When in doubt, get explicit!" Thanks for everyone's help on this! It was definitely appreciated! Paul H. Tarver -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Paul H. Tarver Sent: Wednesday, May 02, 2018 11:41 AM To: profoxtech(a)leafe.com Subject: RE: AGETFILEVERSION Fail After some further testing, I determined that mis-spoke when I said that AGETFILEVERSION() was returning an empty string and not an array. What it is actually doing is returning NOTHING. If I remove the LOCAL ARRAY line from the routine, I found that the once the connection is made, AGETFILEVERSION() does not even create the array once a connection handle to the Oracle ODBC driver is obtained, AGETFILEVERSION() simply fails without error, without creating an array, but it does return a 0 as the number of elements. Paul H. Tarver -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Paul H. Tarver Sent: Wednesday, May 02, 2018 11:28 AM To: profoxtech(a)leafe.com Subject: RE: AGETFILEVERSION Fail I checked the array generated from ADIR() in my code and it is returning the proper list of EXE files found in the folder. But I'm thinking I want to do some more testing with your idea about the directory or path changing after we get a connection to the ODBC driver or something like that. I'll post more once I chase that rabbit. As I mentioned in another response the weird thing is AGETFILEVERSION() is supposed to always return an Array, but once we make a connection to the Oracle ODBC driver, AGETFILEVERSION() simply returns an empty string. Not an empty array, an empty string. On top of that, I cannot for the life of me figure out what would AGETFILEVERSION() have in common with and ODBC connection. I'm sure that where they overlap will be where the problem lies, but I can't figure out where those two functions would overlap. Thanks for the idea though! Paul H. Tarver -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Gianni Turri Sent: Wednesday, May 02, 2018 10:51 AM To: profoxtech(a)leafe.com Subject: Re: AGETFILEVERSION Fail Hi Paul! If the current directory ( curdir() ) changes to something like C:\Windows\System32 your array gets populated by many exe's but not the exe's you expect from your application directory, because in you code you load adir() with exe's from the "current" directory. > lnExeNumber = ADIR(laPrograms, '*.EXE') Gianni -----Original Message----- On Wed, 02 May 2018 02:47:00 +0200, Gianni Turri <giannit62(a)gmail.com> wrote: Hi Paul! I remember many years ago when printing to pdf using the Adobe Acrobat printer driver that at the return from "report form ..." the curdir() was changed to something like C:\Windows\System32. Are you sure it is not happening something similar? Gianni -----Original Message----- On Tue, 1 May 2018 15:23:55 -0500, "Paul H. Tarver" <paul(a)tpcqpc.com> wrote: Thanks Ted. The code I'm using now is how I determine the name of the compiled application and once it returns the correct .EXE name, we then look for an .INI file with the same JUSTSTEM() where our settings are. The code works whether compiled or in the IDE and the only requirement is that I have at least one copy of the compiled .exe file in the development folder. I know I can hard code that easily enough, but because I have so many projects and they often have different compiled names, so the logic of looking in the app folder for an .EXE with 'MAIN PROGRAM' in the file version information makes the method to retrieve the JUSTSTEM('exe name') a simple prospect and has worked since version 6. First time I've ever had a problem with it and that's only after the second time I get a handle to the Oracle database via the Oracle ODBC driver. Weird stuff. Thanks for the suggestions though. I may end up refactoring this whole process anyway because of this weirdness. Paul H. Tarver -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, May 01, 2018 2:38 PM To: profoxtech(a)leafe.com Subject: Re: AGETFILEVERSION Fail On Tue, May 1, 2018 at 3:23 PM, Paul H. Tarver <paul(a)tpcqpc.com> wrote: > > The reason for this code is to identify the application .EXE. Perhaps there > is a better way to identify the application name that will eliminate the > need to use AGETFILEVERSION() to identify the main .exe file for the > application. > You might consider PROGRAM(), the venerable SYS(16) or the (new to VFP7) AStackInfo(). https://www.tedroche.com/hackfox7/s4g120.html [excessive quoting removed by server]

1 0

Re: AGETFILEVERSION Fail
by Gene Wirchenko 02 May '18

02 May '18

At 06:31 2018-05-02, Charlie-gm <ccbibleman(a)gmail.com> wrote: >Maybe take a look at "_VFP.servername". That returns a character >string of the .exe (including path) that is being executed. > >Example: >my_exe_file = _vfp.servername > >I don't think this will work if you are running ".app" files - in >that case it may always return the path to the VFP9.exe executable. >But if you run that line of code within a compiled VFP .exe, you >should always get the path/name of the .exe (assuming that is what >you're after here). I need the name for using Adobe's print to PDF printer driver. My code: * What is the name of executable that CBS2 is running under? * This is needed by the PDF reporting code. local sys16name, apptype, underruntime, vfpexename sys16name=sys(16,1) apptype=upper(right(sys16name,4)) underruntime=version(2)=0 vfpexename=_vfp.fullname do case case apptype=".FXP" && .FXP under VFP development this.appexename=vfpexename case apptype=".EXE" and !underruntime && .EXE under VFP development this.appexename=vfpexename case apptype=".EXE" and underruntime && .EXE under VFP runtime this.appexename=sys16name otherwise && unknown this.appexename=vfpexename endcase [snip] Sincerely, Gene Wirchenko

1 0

Report Writer - New Discovery
by Dave Crozier 02 May '18

02 May '18

Gentlemen, Having spent time on many occasions hacking reports in their “VFP Table” state I came across an interesting discovery earlier. If you have the properties dialogue open for any item on the report and right click on it you are prompted with a quick sub menu with the following options: Event Inspector Object Memberdata -> Browse FRX Options Most useful… I never knew of its existence until today as I had never felt it necessary to right click on the form I wonder what other “hidden features” are available deep in VFP!. Dave Crozier Software Development Manager Flexipol Packaging Ltd. --------------------------------------------------------------- This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --------------------------------------------------------------- Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time

2 1

Class Definition Not Found
by Chris Davis 02 May '18

02 May '18

Bit of a vague question but is anyone aware of any mis match of run time DLL's that might result in the error message in the subject. Maybe the VFP runtimes or the VC ones. Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 13

Southwest Fox 2018: Speakers and Sessions announced!
by Rick Schummer 02 May '18

02 May '18

Speakers (http://www.swfox.net/Speakers.aspx) and sessions (http://www.swfox.net/SessionsSWFox.aspx) have been announced. Registration opens soon; send an email to info(a)geekgatherings.com if you want us to email you when it's ready. Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox