RE: Outlook Automation Help Needed
They said the same thing about FoxPro. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, August 13, 2024 8:31 AM To: profoxt...@leafe.com Subject: Re: Outlook Automation Help Needed The thing about Outlook automation is that its days are probably numbered in the medium to long term. Once the 'new' Outlook client is the default and the current native application is unsupported none of the MAPI or Object Model stuff will apply anymore. Using the Outlook Graph API is probably the future for this sort of requirement. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/079801daed88$fc3dba90$f4b92fb0$@tpcqpc.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: Outlook Automation Help Needed
Hmmm...now that I can scan through Outlook emails in VFP efficiently, perhaps I should change my program to detect base64 and auto-translate Richard's emails... Now that I think about it, that is a rabbit hole for another day as I spent most of today in one already! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Monday, August 12, 2024 5:30 PM To: profoxt...@leafe.com Subject: RE: Outlook Automation Help Needed Really? Y'all can't read base64? 😉 I always have to remember to tell Lookout to use plain text for Profox replies and in this case I clearly neglected to do that. Since Ed already translated on my behalf all I can say is mea culpa and I'll do better next time. Or you can come to SWFox and yell at me in person. There are still a few in-person slots left... -- rk From: ProfoxTech On Behalf Of Ed Leafe Sent: Monday, August 12, 2024 6:03 PM To: profoxt...@leafe.com Subject: Re: Outlook Automation Help Needed On Aug 12, 2024, at 16:50, Kurt Wendt <mailto:kurthwe...@gmail.com> wrote: > > Hey there Richard - I'm having a problem understanding your > Question/Problem - when you talk in Alien Speak!!! > > I'm sure I'm not the only one... First, some outlook emails are sent base64 encoded - I have no idea why. You can copy the gibberish text and paste in an online tool like https://url.us.m.mimecastprotect.com/s/gHgbCM8E2JuqRA33I1uMu2G7wY?domain=toolbox.googleapps.com and it will decode it for you. So I did just that, and the email had the following line: Refactor time. 😊 You should be able to swap out those SEEK function + !FOUND() calls with a single INDEXSEEK call. followed by the complete text of Paul's message, including the full program text. IOW, there were 115 characters of actual new message out of 7792 characters total, which is less that 1.5% of the message. Nothing personal against Richard, but rather Microsoft, and their idiotic default of top quoting and including the full text of the message being replied to. Sorry, but wasteful practices piss me off, and I just wanted to vent. -- Ed Leafe [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/06af01daed08$1aac9450$5005bcf0$@tpcqpc.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: Outlook Automation Help Needed
You get 'em Ed! PS: Sorry to waste more bits on this, but it seemed appropriate at the time. :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe Sent: Monday, August 12, 2024 5:03 PM To: profoxt...@leafe.com Subject: Re: Outlook Automation Help Needed On Aug 12, 2024, at 16:50, Kurt Wendt wrote: > > Hey there Richard - I'm having a problem understanding your > Question/Problem - when you talk in Alien Speak!!! > > I'm sure I'm not the only one... First, some outlook emails are sent base64 encoded - I have no idea why. You can copy the gibberish text and paste in an online tool like https://toolbox.googleapps.com/apps/encode_decode/ and it will decode it for you. So I did just that, and the email had the following line: Refactor time. 😊 You should be able to swap out those SEEK function + !FOUND() calls with a single INDEXSEEK call. followed by the complete text of Paul's message, including the full program text. IOW, there were 115 characters of actual new message out of 7792 characters total, which is less that 1.5% of the message. Nothing personal against Richard, but rather Microsoft, and their idiotic default of top quoting and including the full text of the message being replied to. Sorry, but wasteful practices piss me off, and I just wanted to vent. -- Ed Leafe [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/06ae01daed07$92fb07d0$b8f11770$@tpcqpc.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: Outlook Automation Help Needed
.Address, m.loM.ReceivedTime, m.loM.ReceivedTime) ELSE IF m.loM.ReceivedTime > EmailSenders.lastcontact REPLACE EmailSenders.lastcontact WITH m.loM.ReceivedTime IN EmailSenders ENDIF ENDIF ENDIF ENDFOR IF m.toFolders.ITEM(m.lnCounter).Folders.COUNT > 0 GetChildren(m.toFolders.ITEM(m.lnCounter).Folders, m.tnLevel + 1) ENDIF ENDIF ENDFOR ENDPROC Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gianni Turri Sent: Sunday, August 11, 2024 7:06 AM To: profoxt...@leafe.com Subject: Re: Outlook Automation Help Needed Hi Paul, did you find these posts during your Internet searches? Enumerating Outlook Folders into Treeview https://www.tek-tips.com/viewthread.cfm?qid=913176 Copying Emails into a VFP table from Outlook https://www.tek-tips.com/viewthread.cfm?qid=1784442 Probably you need to open and connect to your Outlook instance your variuos .PST files before running any code that searches for folders and emails. HTH, Gianni On Fri, 9 Aug 2024 12:17:51 -0500, "Paul H. Tarver" wrote: Ok, before I ask my question, I want to confirm that I've looked at the Microsoft Office Automation with Visual FoxPro book, searched for Outlook related messages on this list and spent more than I wanted to on the Internet and still haven't found a solution that I can use or modify to accomplish my goal. So, it's up to ProFox now. Here's what I need to do: I have a system with Outlook 2010 running on it. I need to access the individual emails stored in multiple pst files with multiple sub-folders and extract the unique email addresses found on those emails. Ideally, I'd like to select the .PST file and have a program loop through all of the folders/subfolders, touch each email and extract any email addresses that contain a search string. I can get an Outlook object active in VFP, but things get muddy after that. Any ideas? Or is this even doable? I feel like the Fox is capable, but at the moment I'm not. J Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/069801daecf6$730d1c80$59275580$@tpcqpc.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.
Outlook Automation Help Needed
Ok, before I ask my question, I want to confirm that I've looked at the Microsoft Office Automation with Visual FoxPro book, searched for Outlook related messages on this list and spent more than I wanted to on the Internet and still haven't found a solution that I can use or modify to accomplish my goal. So, it's up to ProFox now. Here's what I need to do: I have a system with Outlook 2010 running on it. I need to access the individual emails stored in multiple pst files with multiple sub-folders and extract the unique email addresses found on those emails. Ideally, I'd like to select the .PST file and have a program loop through all of the folders/subfolders, touch each email and extract any email addresses that contain a search string. I can get an Outlook object active in VFP, but things get muddy after that. Any ideas? Or is this even doable? I feel like the Fox is capable, but at the moment I'm not. J Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/008201daea80$1080c940$31825bc0$@tpcqpc.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: [NF] Make Software Simple Again (like the Fox)
I think the concept of making software simple again and moving back into the desktop with applications is a central topic for VFP and I wouldn't make this an [NF] post. I've been working to keep our software and our sales process as simple as possible and my business model from day one has been to sell our applications once, stand behind them forever and hopefully build a long term relationship with clients via OPTIONAL annual support priced as low as possible to encourage clients to purchase the annual support. However, if they choose NOT to renew their support, we will still support our software at our published hourly rate. This makes sense to me and never creates a situation like I think SaaS and high-priced support does where the client feels like a tenant rather than an owner. Or where there is a feeling of winners or losers in the relationship, rather it should feel like a partnership. Are there situations where SaaS makes sense, absolutely, but there are many more situations where desktop applications or intranet applications are more appropriate. I think there is a herd-mentality of sorts created by hype where SaaS (and now AI) are being promoted as the end all - be all and customers are being directed to solutions which are not necessarily the best solution and they unknowing follow along and do what all their peers are doing. I think there are more people like DHH who followed the herd only to find out cloud-based isn't necessarily a panacea and it definitely isn't cheap. This is not the first time in the past six to eight months when I've heard of major organizations coming to the conclusion the costs of scaling cloud services is prohibitive and can be done cheaper internally PLUS the company can control exactly where their key data is stored and who has access to it. Just my two-cents. PS: I've grown increasingly tired of all the websites I've visited recently with pop-ups from their "AI chatbot" wanting to be helpful. If a chatbot was really intelligent, it would know to stay out of my way until I want to ask a question. (FYI, this is the electronic equivalent of me standing at my front door yelling "Get Off My Lawn!") Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, July 31, 2024 10:07 AM To: profoxt...@leafe.com Subject: [NF] Make Software Simple Again (like the Fox) https://shiftmag.dev/dhh-make-software-simple-again-3829/ -- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/003001dae41c$a58428d0$f08c7a70$@tpcqpc.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: It's been a long time...
Congratulations!!! So glad this resource exists and happy to be a part of it! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe Sent: Monday, July 22, 2024 8:32 AM To: profoxt...@leafe.com Subject: It's been a long time... ...since the first message posted to ProFox: exactly 25 years ago today! https://leafe.com/archives/msg/1 It's amazing that something started as a temporary solution to a problem has proven to be so long-lived! And while only a handful of people post regularly, there are still 306 subscribers to the profox list, and 184 to the profoxtech list. So while the Fox might be dead, ProFox is still very much alive! -- Ed Leafe [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/053b01dadc41$8dea2bd0$a9be8370$@tpcqpc.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: VFP 8, ODBC connection to Azure SQL Server Pausing
Just scatter shooting here, but I'm wondering if you could attempt to
connect and then re-attempt to connect if you get an error.
Not sure if this would help but here's some code I use to make DSN-less
connections:
* Set SQL TimeOut Wait
=SQLSETPROP(0,"ConnectTimeOut",3)
* Suppress ODBC error dialog
=SQLSETPROP(0,"DispWarnings",.f.)
* Suppress login dialog
=SQLSETPROP(0,"DispLogin",3)
CLEAR ERROR
lnConnection = SQLSTRINGCONNECT(lcDSNLess,.T.)
lnErrorRows = AERROR(laError)
IF lnConnection < 0
lcErrMsg = ''
FOR lnLoopCnt = 1 TO 7 && Display all elements of the array
lcErrMsg = lcErrMsg + TRANSFORM(laError(lnLoopCnt))
+ CHR(13)
ENDFOR
= MESSAGEBOX('Cannot make connection' + CHR(13) + lcErrMsg +
CHR(13) + lcDSNLess, 16, 'SQL Connect Error')
lnConnection = -1
ELSE
= SQLSETPROP(lnConnection, "PacketSize", 4096 )
ENDIF
Hope this helps!
Paul H. Tarver
Tarver Program Consultants, Inc.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Philip
Borkholder
Sent: Tuesday, June 18, 2024 8:34 AM
To: profoxt...@leafe.com
Subject: VFP 8, ODBC connection to Azure SQL Server Pausing
Hello,
I have been having issues with MS Azure SQL Server going to a "pause state"
at night after no activity.
Then when I try to connect with :
lnConnection = SQLSTRINGCONNECT(lcConnString,.T.)
Because the Azure SQL Server is paused, the SQLSTRINGCONNECT() times out and
prompts with the ODBC failed to connect and SQL Server login prompt.
This is annoying when I don't want that to pop up because the end user will
not know what to do.
All the help online just says an Azure SQL Server resumes once an attempt to
connect is made...
Does anyone have any experience with this?
Is it a timeout issue that we can set in our connection string?
Is there a setting on the Azure SQL server we need to set to not allow it to
pause?
Thanks for any guidance,
Philip Borkholder
Bison Tech Plus
Vicksburg, MI
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/06c301dac1b5$0f2f7260$2d8e5720$@tpcqpc.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: [ADMIN] Email issue
Microsoft is co-opting your emails to push false information! Bet Apple and Facebook are in on it too! :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Wednesday, April 24, 2024 9:26 AM To: profoxt...@leafe.com Subject: Re: [ADMIN] Email issue Yeah - GMail has been tossing a BUNCH of the recent ProFox emails into my SPAM. I have keep trying to say it's not Spam - as I've done it a lot in the past year, but, it keeps trying to push ProFox into Spam! Maybe its cause it Knows that the Fox is Dead! Yikes! OK - that just meant to be humorous - don't Stone me... -K On Tue, Apr 23, 2024 at 10:12 AM Ed Leafe wrote: > On Apr 23, 2024, at 11:22, Joe Yoder wrote: > > > > I no longer get any of the list emails. The only way for me to get > answers > > to my questions is by going to the archive. Does anyone know how to > > restore delivery? > > I checked the list status, and your account is still active. So I checked > the logs on the server, and they show mail going out normally via google: > > 91011:Apr 23 10:31:35 mail postfix/smtp[268230]: 9BDC5120630: to=< > j...@wheypower.com>, relay=aspmx.l.google.com[142.251.163.26]:25, > delay=0.96, delays=0.14/0.31/0.15/0.37, dsn=2.0.0, status=sent (250 2.0.0 > OK 1713886295 s15-20020a0562140caf00b006992314d921si13547765qvs.223 - > gsmtp) > > So if you're not getting emails from the list, check your spam folder, and > if they aren't there, contact your email provider. > > > -- Ed Leafe > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/092e01da965a$00d31ef0$02795cd0$@tpcqpc.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: Splitting PDF Files with Ghostscript
Thanks for the suggestion! I tried the product and I liked it so much, I bought the company...er..At least the Pro version... :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Graham Brown Sent: Thursday, March 28, 2024 4:24 AM To: profoxt...@leafe.com Subject: RE: Splitting PDF Files with Ghostscript Hi Alternative approach is to use the free PDFTK utility. This is command line and from memory you give it a command line argument of "CAT". Regards] Graham -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul H. Tarver Sent: 27 March 2024 21:25 To: ProFox@leafe.com Subject: Splitting PDF Files with Ghostscript Ok, does anyone have some sample VFP code they are willing to share to help me split a PDF file with 50 pages or so into separate PDF files with one page in each file? I've tried to convert several things I've seen on multiple sites with various languages, but I've had no luck converting those to run using the WScript.Shell. Any help would be appreciated! Thanks! Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/03c301da811a$41c31e10$c5495a30$@tpcqpc.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.
Splitting PDF Files with Ghostscript
Ok, does anyone have some sample VFP code they are willing to share to help me split a PDF file with 50 pages or so into separate PDF files with one page in each file? I've tried to convert several things I've seen on multiple sites with various languages, but I've had no luck converting those to run using the WScript.Shell. Any help would be appreciated! Thanks! Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/023f01da808d$28f17db0$7ad47910$@tpcqpc.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: VFPAdvanced - My Problem, My Tests & Some Results
<> This is why you are my hero, Alan! With just a casual reply, you gave me information about a command I didn't know existed, and when I threw in a sys(1104) my memory issue disappeared! After replacing my FLUSH command with a sys(1104), I ran a new test and the memory usage never exceeded 50Mb total! Plus while I expected some improvement in performance, I never dreamed I could possibly achieve a 93% reduction in the time it takes to import 250 million records over my initial tests. HOLY CRAP! My process involves opening a table, opening two IDX files for that table, importing text from a 3GB file, parsing the text into area code 3byte character values and converting 7 digit text telephone number into an integer value, posting 145,000 rows at time to my table which automatically updates the IDX files, while summarizing a count of records in each area code AND providing a progress bar update for the user. AND on my first full test it completed the process in only 36.18 minutes which is down from the 531.08 minutes it took when I started this experiment. Un-freaking-believable! Never bet against the Fox! Never doubt the power of ProFoxTech! And, never, ever doubt Alan Bourke!!! Thank you, Thank You, THANK YOU! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, March 06, 2024 2:50 AM To: profoxt...@leafe.com Subject: Re: VFPAdvanced - My Problem, My Tests & Some Results WRT large memory allocation, try throwing a sys(1104) in maybe. "Purges memory cached by programs and data, and clears and refreshes buffers for open tables. You can improve performance by calling SYS(1104) after executing commands that make extensive use of memory buffers. This function also clears internal buffers for open tables, forcing the tables to be refreshed, which is useful with large tables and in multiuser environments." -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/012801da7095$7eeed3f0$7ccc7bd0$@tpcqpc.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: VFPAdvanced - My Problem, My Tests & Some Results
I think that is still why I'm programming in VFP. It is fun to still be learning new stuff about this language and what I can do with it after all these years! :) Enjoy your new role but don't leave VFP too far behind! PS: I understand your comments about set and forget with no updates and if this were an in-house project that I was doing and not a retail product, I'd probably take your advice! But paying customers demand, so we try to achieve. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Tuesday, March 05, 2024 10:20 PM To: profoxt...@leafe.com Subject: Re: VFPAdvanced - My Problem, My Tests & Some Results Thank you Paul for your kind words. One suggestion - why not suggest that the Import process is run at the End of the Day - and have the User start it up and just walk away for the night. Then - NO NEED to have any kind of Status updates on the screen - as nobody is watching it! Also, an alternate option - suggest client run this on a machine not in use - and it can run unattended. The idea behind both suggestions is simply then you need not truly worry about screen updating and a status. Anyway - its just a thought... Yeah - my new job is truly my Dream job - its FUN - and I enjoy going to work every day - and I get to run printers, and even get to do 3D Design work! When work is FUN -- Then LIFE is GOOD!!! My Motto - Trademark Pending... -K On Mon, Mar 4, 2024 at 12:35 PM Paul H. Tarver wrote: > There is a status line that displays the indexing progress, but that > doesn't show up in my compiled app where I rely on progress bars to give > the user feedback. I tried building the IDX without the COMPACT option and > while the indexes are huge, there was no improvement on the speed of > building them, so I'm probably going to go back to using the COMPACT option > as I think Rushmore likes that better. Since there is no time benefit > either way, I'll go with the smaller indexes. > > I also had a chance to test building the indexes after the import. The > import took less than 30 minutes, but the index process is the definitely > the slow part. But this also proved that the Indexes were NOT the cause of > the large allocation of memory used during the import. I'm not sure what is > causing that since I'm releasing the memory variable and the array I'm > importing the text into after writing the data to the DBF, but the process > ends up allocating between 3-4Gb of RAM before it finishes and it only > released when I shut VFP down. It works, but is weird since I'm not using > that much to process each batch and that is with the Indexes closed so I'm > sure they aren't the problem. > > Working in this environment with such large chunks of data has been an > experience for sure! > > Glad you are back at work albeit in something exciting like 3DP! :) > > Paul H. Tarver > Tarver Program Consultants, Inc. > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt > Wendt > Sent: Monday, March 04, 2024 9:55 AM > To: profoxt...@leafe.com > Subject: Re: VFPAdvanced - My Problem, My Tests & Some Results > > Hey there Paul, > > Interesting write-up, and it was a good read this morning. > > Will admit - I have NOT Touched VFP in a while. AS I've had my head down in > the 3DP world for a while now. In fact, life kinda went to hell again for > me - as I lost my job last July - co. imploded - letting almost EVERYONE go > from the Essentium site in Irvine, CA - whilst only letting a couple folks > go from HQ in TX. And, it was miserable - a little over 6 months > unemployed. But, luckily I got a new gig - also in Irvine - and I am > actually doing 3D Design work for the job, as well as heavily working with > 3D Printers. In fact, I had thrown the idea around about doing a small > database application for them. But, so far, I have not really dived into > that... > > Yeah, I suspect that every time you import a record - it has to do a > Re-org of that IDX file - and the building of it would probably be Much > faster after importing all data. > > I'm curious... > > Doesn't VFP normally give some kinda of a screen updating when building an > IDX file? And, if so - maybe you could use THAT as a way to show the user > what is happening! > > It's just a thought - and mostly a WAG. > > Goodluck! > > -Kurt > > On Fri, Mar 1, 2024 at 10:52 AM Paul H. Tarver wrote: > > > Just got the Stats for February, 2024 and when the ProFox List Statistics > > for January is one of the top posts for the month of February, I realized > > I've been busy to
RE: VFPAdvanced - My Problem, My Tests & Some Results
There is a status line that displays the indexing progress, but that doesn't show up in my compiled app where I rely on progress bars to give the user feedback. I tried building the IDX without the COMPACT option and while the indexes are huge, there was no improvement on the speed of building them, so I'm probably going to go back to using the COMPACT option as I think Rushmore likes that better. Since there is no time benefit either way, I'll go with the smaller indexes. I also had a chance to test building the indexes after the import. The import took less than 30 minutes, but the index process is the definitely the slow part. But this also proved that the Indexes were NOT the cause of the large allocation of memory used during the import. I'm not sure what is causing that since I'm releasing the memory variable and the array I'm importing the text into after writing the data to the DBF, but the process ends up allocating between 3-4Gb of RAM before it finishes and it only released when I shut VFP down. It works, but is weird since I'm not using that much to process each batch and that is with the Indexes closed so I'm sure they aren't the problem. Working in this environment with such large chunks of data has been an experience for sure! Glad you are back at work albeit in something exciting like 3DP! :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Monday, March 04, 2024 9:55 AM To: profoxt...@leafe.com Subject: Re: VFPAdvanced - My Problem, My Tests & Some Results Hey there Paul, Interesting write-up, and it was a good read this morning. Will admit - I have NOT Touched VFP in a while. AS I've had my head down in the 3DP world for a while now. In fact, life kinda went to hell again for me - as I lost my job last July - co. imploded - letting almost EVERYONE go from the Essentium site in Irvine, CA - whilst only letting a couple folks go from HQ in TX. And, it was miserable - a little over 6 months unemployed. But, luckily I got a new gig - also in Irvine - and I am actually doing 3D Design work for the job, as well as heavily working with 3D Printers. In fact, I had thrown the idea around about doing a small database application for them. But, so far, I have not really dived into that... Yeah, I suspect that every time you import a record - it has to do a Re-org of that IDX file - and the building of it would probably be Much faster after importing all data. I'm curious... Doesn't VFP normally give some kinda of a screen updating when building an IDX file? And, if so - maybe you could use THAT as a way to show the user what is happening! It's just a thought - and mostly a WAG. Goodluck! -Kurt On Fri, Mar 1, 2024 at 10:52 AM Paul H. Tarver wrote: > Just got the Stats for February, 2024 and when the ProFox List Statistics > for January is one of the top posts for the month of February, I realized > I've been busy to comment and I assume everyone else has been busy too, so > consider this a kick-off post for March to help improve or at least > stimulate some conversation in here! > > > > So, last month, I took the plunge and purchased a copy of VFPA 10.2. I have > a software app I wrote a long time ago to help telemarketers comply with > the > Telemarketing Sales Rule by scrubbing their call lists against the National > Do Not Call List sold by the Federal Trade Commission. The program (which I > creatively named Call List Scrubber) was originally written in VFP6 and > just > like VFP, it is a mature and stable product requiring little maintenance, > is > easy to use and is easy to support. > > > > That having been said, the full National Do Not Call List has grown to > almost 3Gb in size and while we changed several years ago from using FREADs > to using the Scripting.FileSystemObject, up until now we could import and > store the information in a DBF and didn't exceed 2Gb by using several > tricks > not the least of which was storing the area codes as a 3 byte text field > and > the 7 digit number as an 4byte integer. Oh, and I built the original > program > to use IDX files instead of compound NDX files so that was another trick > that helped us over the years as we dealt with the unceasing growth in the > National Do Not Call List. > > > > While most of our users only purchase individual area code DNC lists from > the FTC, in January we had a new client who did purchase the full national > list and you guessed it, Call List Scrubber could no longer import the full > National DNC list and function. So, I helped the client split the file into > two roughly equal portions, set up two installs for them and they are able > to function and use the pro
VFPAdvanced - My Problem, My Tests & Some Results
ode and I suspect I won't find any major differences in VFP9 code because I'm using both VFP6 and VFP9 class libraries in my tests and everything works as expected. Chen has been responsive to my questions and released an update even as I was writing this. I'm not sure I'm ready to cut over to VFPA for my primary development work, but this is looking like a great option in this particular situation. Finally, there is one issue that concerns me at this point and that is with memory usage. During an import test like the ones I've described here, I see memory usage by VFP and the Large Memory module that Chen provides grow from the 500Mb I usually see when running one of my VFP applications to 2 to 2.5 GB. I have a suspicion this is caused by the two IDX files I have open while doing the import. I'm opening the IDX files with the DBF file so that they are updated as the data is inserted into the DBF. This may not be the best way to do things because perhaps recreating the indexes after the import is complete may be faster, BUT, I'm not sure how to provide user feedback on the progress of the indexing process and maybe I just need someone to guide me on this point. I'll have to test doing the import without the IDX files open to confirm my thoughts about the memory usage during the import, but the most important issue is that the memory that gets allocated during the import process isn't released when I close the table and the indexes. In fact, it isn't released at all until I close VFPA and restart it. Does anyone have an insight into this memory usage weirdness I'm seeing? Ok, I know this is a long email, but I'm trying to start some conversation and there are several points I think y'all can help me with so have at it. Any feedback is helpful for this situation let me know what you know! Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/045a01da6c09$6ec1a1a0$4c44e4e0$@tpcqpc.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: Run under WIN 11
I'm with wOOdy on this one. I feel cramped and very limited when I try to work on VFP6 instead of VFP9 and I still have a bunch of clients using apps I wrote in VFP6. Slowly migrating them when I can, but man, I miss VFP9 when I can't use it. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of juer...@wondzinski.de Sent: Monday, January 29, 2024 8:17 AM To: profoxt...@leafe.com Subject: AW: Run under WIN 11 Hi Charles, VFP3 would run, but only if you have less than 728 Mb of RAM. On today's usual boxes with at least 2Gb it errors out with "Insufficient Memory". Everything else from VFP5 upwards is still working ok. I tested all versions. But why would anyone use something even older than VFP9, which is now already 20 years old? (First release was on 2004-12-13) wOOdy -Ursprüngliche Nachricht- Von: ProFox Im Auftrag von Charles Hart Enzer, M.D. Gesendet: Sonntag, 28. Januar 2024 09:09 An: Profox Betreff: Run under WIN 11 What is the oldest version that can run under WIN 11 Thank you -- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/021e01da52ce$100514c0$300f3e40$@tpcqpc.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: [NF] T'was the Night Before Crisis
Merry Christmas, Y’all! Paul H. Tarver Sent from my iPhone > On Dec 22, 2023, at 4:41 PM, Ted Roche wrote: > > 'Twas the night before crisis, and all through the house, > Not a program was working, not even a browse. > The programmers were wrung out, too mindless to care, > Knowing chances of shipping hadn't a prayer. > > The users were nestled all snug in their beds, > While visions of inquiries danced in their heads. > When out in the lobby there arose such a clatter, > That I sprang from my cube to see what was the matter. > And what to my wondering eyes should appear, > But a SUPER PROGRAMMER, oblivious to fear. > > More rapid than eagles, his programs they came, > And he whistled and shouted and called them by name: > On Update! On Add! On Inquiry! On Delete! > On Batch Jobs! On Closing! On Functions Complete! > His eyes were glazed over, his fingers were lean, >> From weekends and nights in front of the screen. > > A wink of his eye, and a twist of his head, > Soon gave me to know I had nothing to dread. > He spoke not a word, but went straight to his work, > Turning specs into code, then he turned with a jerk. > And laying his finger on the ENTER key, > The system came up, and worked perfectly. > > The updates, updated; the deletes, they deleted; > The inquiries, inquired; and the closing completed. > He tested each whistle, he tested each bell, > With nary an abend, and all had gone well. > The system was finished, the tests were concluded, > The client's last changes were even included! > > And the client exclaimed with a snarl and a taunt, > "It's just what I asked for, but NOT what I want" > > (attributed variously, my copy came from here[1]) > > [1] http://www.mdarwin.ca/humour/night-before-xmas/night-before-crisis.phtml > > https://web.archive.org/web/20070923102738/http://www.mdarwin.ca/humour/night-before-xmas/night-before-crisis.phtml > > Merry Christmas, Chag Hanukkah sameach, happy Qwanza, merry Solstice, > happy Saturnalia and so forth to all! > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/63cc4f2c-18fb-4ab3-931c-bb44ab767...@tpcqpc.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: Index & Seek Question
Let me explain in more detail what I'm doing. I have a Windows webserver I'm
working with and I've built a program to import IIS log data from about 50
websites for a specific range of dates and then doing some analysis SQL queries
on the log detail specifically focusing on activity which takes place across
the multiple sites/logs on the server. Ultimately, I'm searching for bad actors
attempting to do bad things on this server. I have a look up table with URL
requests we consider to be bad and I'm doing a look up on the Client IP
addresses to determine whether in the world the activity is coming from. To
that end, I look up each unique IP address in the IP2LOCATION-LITE-DB3 list and
then update the temporary log table table with the source locations. Once we
identify a bad actor, I have a blocking system I use to completely block
blacklisted IP's from even getting a response from the server, so we don't
waste a lot of time generating 403 or 404 errors.
But it just dawned on me while writing this that one way to squeeze a little
more speed out of the process, is to just update a separate table of the unique
IP addresses and then join the results in my analysis queries rather than
physically updating the working log tables.
This is really an exercise in optimizing my programming as much as possible,
although we are already seeing some significant results from our efforts so
far. I cut my server memory usages in half the first day I started this
strategy and shaved 35% off the number of active processes running at any one
time. It's been like getting a new server. But more importantly, I'm having
loads of fun testing what I can do with this little program and how fast I can
make it go. :)
Thanks!
Paul H. Tarver
Tarver Program Consultants, Inc.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Saturday, December 16, 2023 3:42 PM
To: profoxt...@leafe.com
Subject: Re: Index & Seek Question
IPv4 addresses are 32-bit numbers expressed for human convenience as 4
numbers between 0 and 255 separated by dots, but they can really be
handled more easily as a single 32-bit integer.
So, have you added a column to your table that stores the integer
value of the IP address?
ALTER TABLE YourTable ADD COLUMN dIPADDR INT(16)
UPDATE YourTable SET dIPADDR = ipsegment[1]*256^3 +ipsegment[2]*256*2
+ ipsegment[3]*256 + ipsegment[4]
Then add an index on that column.
Convert your search value using the same algorithm.
An answer on a 50,000 row table should be returned in less than one second.
On Fri, Dec 15, 2023 at 6:08 PM Paul H. Tarver wrote:
>
> Been quiet in here for a while, so I thought I'd toss out something I'm
> tinkering with and ask for your advice. Besides, I want to keep my name on
> the monthly top 10! J
>
>
>
> I have a large table populated with the IP2LOCATION-LITE-DB3 list. I'm
> running a process to convert an IPV4 address into a decimal number and then
> locate the first record in my table where the value I'm looking up is
> between the From_IP numeric value and the To_IP numeric value in the table
>
>
>
> Here's the code snippet I have working now:
>
> --
>
> LPARAMETERS toParams
>
> LOCAL lcBase2IP, lnElements, lnIpNumber
>
>
>
> IF USED("ip_locs")
>
>
>
> lcCurrSel = ALIAS()
>
>
>
> lnElements = ALINES(ipsegment, toParams.ocClientIp, 1, ".")
>
>
>
> IF lnElements = 4
>
>
>
> lcBase2IP =
> PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[1])), 2), 8, "0") + ;
>
>
> PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[2])), 2), 8, "0") + ;
>
>
> PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[3])), 2), 8, "0") + ;
>
>
> PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[4])), 2), 8, "0")
>
>
>
> lnIpNumber = THISFORM.utilities.bin2dec(lcBase2IP)
>
>
>
> SELECT ip_locs
>
> LOCATE FOR lnIpNumber => ip_locs.ip_from AND lnIpNumber <=
> ip_locs.ip_to
>
>
>
> IF FOUND('ip_locs')
>
>
>
> toParams.ocCountry_Code = ip_locs.Country_Code
>
> toParams.ocCountry_Name = ip_locs.Country_Name
>
> toParams.ocRegion_Name = ip_locs.Region_Name
>
> toParams.ocCity_Name = ip_locs.City_Name
>
>
>
> ENDIF
>
>
>
> ENDIF
>
>
>
> SELECT (lcCurrSel)
>
>
>
> ENDIF
>
>
>
> RETURN
>
> ---
>
&
Index & Seek Question
Been quiet in here for a while, so I thought I'd toss out something I'm
tinkering with and ask for your advice. Besides, I want to keep my name on
the monthly top 10! J
I have a large table populated with the IP2LOCATION-LITE-DB3 list. I'm
running a process to convert an IPV4 address into a decimal number and then
locate the first record in my table where the value I'm looking up is
between the From_IP numeric value and the To_IP numeric value in the table
Here's the code snippet I have working now:
--
LPARAMETERS toParams
LOCAL lcBase2IP, lnElements, lnIpNumber
IF USED("ip_locs")
lcCurrSel = ALIAS()
lnElements = ALINES(ipsegment, toParams.ocClientIp, 1, ".")
IF lnElements = 4
lcBase2IP =
PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[1])), 2), 8, "0") + ;
PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[2])), 2), 8, "0") + ;
PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[3])), 2), 8, "0") + ;
PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[4])), 2), 8, "0")
lnIpNumber = THISFORM.utilities.bin2dec(lcBase2IP)
SELECT ip_locs
LOCATE FOR lnIpNumber => ip_locs.ip_from AND lnIpNumber <=
ip_locs.ip_to
IF FOUND('ip_locs')
toParams.ocCountry_Code = ip_locs.Country_Code
toParams.ocCountry_Name = ip_locs.Country_Name
toParams.ocRegion_Name = ip_locs.Region_Name
toParams.ocCity_Name = ip_locs.City_Name
ENDIF
ENDIF
SELECT (lcCurrSel)
ENDIF
RETURN
---
This works fine and it really isn't that slow. It takes about 30 - 60
seconds to do the location look up on a list of 50,000+ ip address records.
I'm pretty sure I'm getting Rushmore optimization on the LOCATE FOR line,
but I've been wondering if there is a way to use SEEK with an index to find
a value between the numeric IP_FROM field and the numeric IP_TO field. But I
cannot figure out how I can create an index that would give me Rushmore
optimization and let me use the SEEK command for a value between those to
numerics.
FYI, I tried doing a simple SQL query to a temporary cursor, but
surprisingly, the LOCATE FOR command is actually faster. Hey, I know I'm
being greedy, but I'm wondering if it is possible to squeeze any more speed
out of this process. I may be using the best method, but I figured if y'all
had a minute you might give me a little feedback.
Thanks in advance!
Paul H. Tarver
Tarver Program Consultants, Inc.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/182b01da2fab$905abdf0$b11039d0$@tpcqpc.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: ZPL
Woohoo! I love it when the bug belongs to someone else! :)
Paul H. Tarver
Tarver Program Consultants, Inc.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris
Davis
Sent: Wednesday, November 15, 2023 8:14 AM
To: profoxt...@leafe.com
Subject: RE: ZPL
After a lot of testing it turns out this was a bug at the other end, I have
obtained a patch for it and now VFP sends the data fine.
-Original Message-
From: ProfoxTech On Behalf Of Chris Davis
Sent: Tuesday, November 14, 2023 9:41 AM
To: profoxt...@leafe.com
Subject: RE: ZPL
Thanks Woody
The image is already converted to hex and the { symbol doesn't appear in it
... if I don't get any further today I will create an actual example to
demonstrate it better. Although I am just considering going the Chilkat
route and sending the data via the socket and making a networked label
printer a minimum requirement for our customers.
Appreciate your input so far.
Regards
Chris.
-Original Message-
From: ProfoxTech On Behalf Of
juer...@wondzinski.de
Sent: Tuesday, November 14, 2023 8:27 AM
To: profoxt...@leafe.com
Subject: RE: ZPL
Hi Chris,
I suspect that you have a "misbehaving char" in your hex data, something
like Ctrl-Z, which terminates the standard DOS copy process.
If you need to transfer binary data to your printer, you could use this
routine here:
??? ChrTran(File2Str("yourPicture.jpg"), "{", "{{}")
wOOdy
-Original Message-
From: ProFox On Behalf Of Chris Davis
Sent: Monday, November 13, 2023 3:13 PM
To: profox@leafe.com
Subject: RE: ZPL
Done a bit more testing and capture the print job it looks like it only
sends upto 16535 kB to the printer before it's then captured as a job? Make
any sense?
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/084e01da17ec$417b95f0$c472c1d0$@tpcqpc.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: ProFox List Statistics for October 2023
I'm back on the charts! Woohoo! :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of List Administrator Account Sent: Wednesday, November 01, 2023 7:03 AM To: profoxt...@leafe.com Subject: ProFox List Statistics for October 2023 == ProFox List Statistics October 2023 == Subscriber Count at End of Month: ProFox: 305 ProFoxTech: 184 == Total Posts: 37 (Up 164.29% from September 2023) Total [OT] Posts: 0 (Unchanged from September 2023) Total [NF] Posts: 0 (Unchanged from September 2023) Daily Message Counts for October 2023 DOW Date Count --- - S 1 - 1 T 3 - 4 W 4 - 2 T 5 - 7 F 6 - 6 S 8 - 1 F13 - 1 T24 - 2 S29 - 1 M30 - 12 Message Counts By Day of Week for October 2023 DOW Count --- - Sun -3 Mon - 12 Tue -6 Wed -2 Thu -7 Fri -7 Distinct Posters to the List (changes relative to September 2023) Non-OT messages: 13 (Up 18.18%) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 13 (Up 18.18%) Top 14 Contributors by Number of Non-OT Posts |Posts Contributor | 1.8Virgil Bierschwale 2.6Kurt Wendt 3.5Graham Brown 4.4Eric Selje 5.3Joe Yoder 6.2Frank Cazabon 7.2 Paul H. Tarver 8.1List Administrator Account 9.1Bill Anderson 10.1Eric Selje 11.1Ted Roche 12.1Tracy Pearson 13.1 14.1Alan Bourke Top 0 Contributors by Number of OT Posts |Posts OT% Contributor | Top 0 Contributors by Number of NF Posts |Posts Contributor | Top 14 Contributors by Total Number of Posts |Posts Contributor | 1.8Virgil Bierschwale 2.6Kurt Wendt 3.5Graham Brown 4.4Eric Selje 5.3Joe Yoder 6.2Frank Cazabon 7.2 Paul H. Tarver 8.1List Administrator Account 9.1Bill Anderson 10.1Eric Selje 11.1Ted Roche 12.1Tracy Pearson 13.1 14.1Alan Bourke Top 6 Contributors by Number of New Threads Started |Posts Contributor | 1.3Joe Yoder 2.2Graham Brown 3.1List Administrator Account 4.1Eric Selje 5.1Kurt Wendt 6.1Bill Anderson Top 9 Non-OT Threads by Total Number of Posts -- |Posts Subject | -- 1. 10FW: SQL Upsize 2.8Unemployed Destitute FoxPro Guy 3.4ProFox List Statistics for September 2023 4.4Programatically placing text boxes on a form - continued 5.4Log4VFP or Log4Fox 6.3Programatically placing text boxes on a form 7.2Classlib setting in VFP 8.1ChilkatVFP 1.24 released 9.1SQL Upsize Top 0 OT Threads by Total Number of Posts -- |Posts Subject | -- Top 9 Threads by Total Number of Posts -- |Posts Subject | -- 1. 10FW: SQL Upsize 2.8Unemployed Destitute FoxPro Guy 3.4ProFox List Statistics for September 2023 4.4Programatically placing text boxes on a form - continued 5.4Log4VFP or Log4Fox 6.3Programatically placing text boxes on a form 7.2Classlib setting in VFP 8.1ChilkatVFP 1.24 released 9.1SQL Upsize [excessive quoting removed by server] ___ Post Mes
RE: FW: SQL Upsize
I wondered the same thing, but when I checked it out, I found that is a slightly pricier version of the SQL management tool I use which is from EMS Software Management. I think both Navicat and the EMS solutions occupy the same space and appear to offer the same features but I've been using EMS SQL Manager for a many years and it works pretty well for me. I don't recall trying to upsize any VFP database with it, but I know you can run .SQL scripts to create tables and populate them pretty easily. It's also very easy to export data to Excel or other data tools (which is what I use most of the time). You can purchase everything ala carte which appears similar to the pricing model that Navicat uses but it looks like the support renewal is a little cheaper with EMS. I think I pay about $150 per year for support on the SQL Manager tool. Anyway, not trying to hijack the thread with a discussion about different SQL Manager tools, but perhaps that would be a good NF topic to ask what external database tools everyone is using and why. Just a thought. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Graham Brown Sent: Friday, October 06, 2023 3:11 AM To: profoxt...@leafe.com Subject: RE: FW: SQL Upsize Thanks What is Navicat? -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale Sent: 05 October 2023 20:04 To: ProFox Email List Subject: Re: FW: SQL Upsize I use navicat. copy the dbf to csv or txt. use navicat to connect to sql server. and then do a import. I've added about 10GB data to mysql that way and it works pretty good. they have a version for sql server as well. On Thu, Oct 5, 2023 at 11:36 AM Graham Brown wrote: > Hi > Thanks > > Yes, the database and tables all get created via the upsizing wizard so > definitely something to do with the data itself > The upsizing wizard has worked in the past probably 2000 to 2005 but won't > work in 2008r2. Havent done one of these in a long time. > > In the upsizing wizard I uncheck indices, integrity etc etc but made no > difference > > I have created a simple prg to create a cursor adapter on the local data > and another on the server data. This does scatter and gather between the > two but on a table with 500k records it takes two days to run so too slow. > > The next thing I am going to try is manually creating the insert sql > commands and run these in EM, just a pita if I am missing something obvious. > > Interesting one. > > Graham > > > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt Wendt > Sent: 05 October 2023 17:21 > To: ProFox Email List > Subject: Re: FW: SQL Upsize > > Hey there Graham, > > Now, I know this is going to be more of a WAG or a total Shot-in-the-Dark, > Butt... > > Also, I will admit - I am not familiar with the exact process you're > attempting to do. I did try something similar MANY Years ago, admittedly - > back in like 2012. Anyway... > > So, my question is this - did your Process at least create the Database > files in SQL - and SOME of the records did make it into the Database? If > so, why not push the records into SQL Databases from FoxPro after the SQL > databases were already created? > > Now, I know - it's Not Addressing your original problem. But, I figured I > would throw some suggestions out there... > > -Kurt > > > On Thu, Oct 5, 2023 at 8:44 AM Graham Brown wrote: > > > Hi all > > > > > > > > I am upsizing a Foxpro DBC to SQL 2008 r2. This worked fine with earlier > > versions of SQL but gives errors to newer versions of SQL. I am using > ODBC > > rather than Native client although it doesn't make any difference to the > > errors. > > > > > > > > For one specific table the upsize says 988 rows failed. Only a few > records > > show an error in the report (6) and this is connectivity error failed to > > convert numeric to float. The destination fields do not show float so not > > sure what it is complaining about. > > > > > > > > Has anyone seen the same please. > > > > > > > > Regards > > > > Graham > > > > > > > > Ps Sent the last one to owner@, sorry Ed. > > > > > > > > > > > > --- StripMime Report -- processed MIME parts --- > > multipart/alternative > > text/plain (text body -- kept) > > text/html > > --- > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https:/
RE: ProFox List Statistics for September 2023
I was feeling the same thing when I saw the stats. But sometimes life gets in the way of our fun. I hate I've not been more active, but if you know about elderly parents, then you know. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Tuesday, October 03, 2023 4:01 PM To: profoxt...@leafe.com Subject: Re: ProFox List Statistics for September 2023 Wow - I agree - that IS a Slow month! Maybe I'm going to have to do a Post as well. Thanks for the prompt Eric! -Kurt On Tue, Oct 3, 2023 at 1:56 PM Eric Selje wrote: > Slow month! Let's pick it up (see new thread). > > Eric > > On Sun, Oct 1, 2023 at 7:03 AM List Administrator Account < > list...@leafe.com> > wrote: > > > == > > ProFox List Statistics > > September 2023 > > == > > Subscriber Count at End of Month: > > ProFox: 305 > > ProFoxTech: 184 > > == > > > > Total Posts: 14 > > (Down 50.0% from August 2023) > > > > Total [OT] Posts: 0 > > (Unchanged from August 2023) > > > > Total [NF] Posts: 0 > > (Down 100.0% from August 2023) > > > > > > Daily Message Counts for September 2023 > > > > DOW Date Count > > --- - > > F 1 - 8 > > T 5 - 2 > > W 6 - 4 > > > > > > Message Counts By Day of Week for September 2023 > > > > DOW Count > > --- - > > Tue -2 > > Wed -4 > > Fri -8 > > > > > > Distinct Posters to the List > > (changes relative to August 2023) > > > > Non-OT messages: 11 (Down 21.43%) > > OT messages: 0 (Unchanged) > > NF messages: 0 (Down 100.0%) > > Total number: 11 (Down 21.43%) > > > > > > Top 11 Contributors by Number of Non-OT Posts > > -------- > > |Posts Contributor | > > > > 1.2MB Software Solutions, LLC > > 2.2Eric Selje > > 3.2Vincent Teachout > > 4.1Ted Roche > > 5.1Kurt Wendt > > 6.1Paul H. Tarver > > 7.1Richard Kaye > > 8.1Ed Leafe > > 9.1List Administrator Account > > 10.1Stephen Russell > > 11.1Rick Schummer > > > > > > Top 0 Contributors by Number of OT Posts > > > > |Posts OT% Contributor | > > > > > > > > Top 0 Contributors by Number of NF Posts > > > > |Posts Contributor | > > > > > > > > Top 11 Contributors by Total Number of Posts > > > > |Posts Contributor | > > > > 1.2MB Software Solutions, LLC > > 2.2Eric Selje > > 3.2Vincent Teachout > > 4.1Ted Roche > > 5.1Kurt Wendt > > 6.1Paul H. Tarver > > 7.1Richard Kaye > > 8.1Ed Leafe > > 9.1List Administrator Account > > 10.1Stephen Russell > > 11.1Rick Schummer > > > > > > Top 3 Contributors by Number of New Threads Started > > > > |Posts Contributor | > > > > 1.1Rick Schummer > > 2.1List Administrator Account > > 3.1Vincent Teachout > > > > > > Top 4 Non-OT Threads by Total Number of Posts > > -- > > |Posts Subject | > > -- > > 1. 10Just call me Master, for short > > 2.2Southwest Fox 2023: URGENT - Now or never, register today > > 3.1Sou
RE: Just call me Master, for short
Awesome! Well done! I feel safer already! :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Vincent Teachout Sent: Friday, September 01, 2023 12:18 PM To: profoxt...@leafe.com Subject: Just call me Master, for short And... Done! Master of Science in Information Security. https://www.parchment.com/u/award/f75a554cf48fd78bb2a872629841f08d If you have any Science or Information Security that needs mastering, just let me know. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/007401d9dd09$f2949c10$d7bdd430$@tpcqpc.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: Logging
I have written two products in VFP for the Timber Industry to help with them with logging. https://cruisecalc.com/ https://loadcalcpro.com/ Does that count? :) PS: Yes, I'm sorry that was terrible but Bill started it! :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Bill Anderson Sent: Tuesday, August 01, 2023 3:16 PM To: profoxt...@leafe.com Subject: Re: Logging Well, the effects of deforestation and biodiversity come to mind... Did you have something else in mind? ;) Bill On Tue, Aug 1, 2023 at 6:13 AM Eric Selje wrote: > I'm doing a session on logging at SW Fox. > > Just based on that information, what would you hope to see the session > cover? > > Thanks, > > Eric > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/065401d9c4bb$295adf50$7c109df0$@tpcqpc.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: [NF] SQL ALL, but not quite
Have you considered using UNION? Still four queries, but at least not four joins. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Garrett Fitzgerald Sent: Thursday, June 22, 2023 6:23 AM To: profoxt...@leafe.com Subject: [NF] SQL ALL, but not quite Is there an idiomatic way to get parent records that have all of the child records a, b, c, and d, short of joining the child table 4 times? Oracle 19, if it's relevant. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/044a01d9a50a$554e4870$ffead950$@tpcqpc.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: Using OpenAI like ChatGPT?
I count this as good news. The overlords still need VFP programmers. :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Roberts Sent: Friday, February 03, 2023 9:18 PM To: profoxt...@leafe.com Subject: Re: Using OpenAI like ChatGPT? If you ask ChatGPT to write FoxPro code you get an odd mix of FoxPro and DotNet that won't run on either platform. On Fri, Feb 3, 2023, 9:09 PM Man-wai Chang wrote: > I am just wondering whether Visual Foxpro could make use of OpenAI > like ChatGPT :) > > I don't have any purpose nor objective in mind. > > -- > .~. Might, Courage, Vision. SINCERITY! > / v \ 64-bit Fedora 35 Server Spin > /( _ )\ http://sites.google.com/site/changmw > ^ ^ May the Force and farces be with you! > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/0f3501d93a80$064880a0$12d981e0$@tpcqpc.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: Howdy Folks
I did something similar back in VFP6 where I added a VFP timer object to the main page and then we set the interval to 3-5 minutes (I can't really remember exactly how long) and the timer method would fire and check to see if a "SHUTDOWN" file was found and if so, it would display a message to the user with a 90 second countdown to give them time to close the application. If they didn't respond, the shutdown message form would request a Save method on the parent form to save whatever was open at the time and then it would close the application. I also checked for the existence of the "SHUTDOWN" file when starting the application and if found, it would provide a user message and then shut down. The coding for that is old and antiquated so I'll not embarrass myself by posting. But the logic was pretty much as stated. I guess my point is I just used the native VFP timer object to trigger the automated shutdown everything. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Virgil Bierschwale Sent: Tuesday, November 15, 2022 2:26 PM To: profoxt...@leafe.com Subject: Howdy Folks Been a long time. I'm back maintaining a foxpro system Back in the 90's I used a utility that would allow me to put a text file named shutdown.txt in the root folder and it would force all users out. Been googling and can't find it anymore. Any of you remember it? Looking for a way to kick users out so I can reindex when necessary. Thanks, Virgil --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/037f01d8f948$e387d0c0$aa977240$@tpcqpc.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: Matt Slay
Prayers for his family during this terrible time. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rick Schummer Sent: Monday, October 11, 2021 5:18 PM To: profoxt...@leafe.com Subject: Matt Slay It is with great sadness and a heavy heart to share the news that Matt Slay has passed away from COVID-19 earlier today. You may recognize Matt for his many contributions to the Fox Community on VFPX with the next generation of GoFish, DynamicForms, assisting Jim Nelson and Doug Hennig with the development and testing of Thor, inspiring the Go To Definition feature in Thor, and the VFP language template for VS Code, just to name a few of his contributions. Matt also inspired other developers to create things for our community when he was not tackling them himself. He was very good at twisting arms of fellow Visual FoxPro developers to get other things contributed. Matt leaves behind his wife Sharon and two teenage sons. This is an absolute gut punch and is a terrible way to extinguish a shining star in our community. Rick Schummer Rick White Light Computing, Inc. www.whitelightcomputing.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/001801d7bf6d$fea92f40$fbfb8dc0$@tpcqpc.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: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday
Thank you Dave and everyone else here.
My father is getting some better but still in the hospital. Thanks for your
positive thoughts and prayers!
I'm looking forward to that "next time!"
Paul H. Tarver
Tarver Program Consultants, Inc.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Monday, October 04, 2021 3:04 AM
To: profoxt...@leafe.com
Subject: RE: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday
Best wishes to your father Paul, I will miss touching base with you again but
there will be a next time soon.
Regards
Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.
Mob: 07967 671080
﴾⚆ᨎ⚆﴿
Flexipol® Packaging Ltd
T 01706 222 792
E dcroz...@flexipol.co.uk
W https://www.flexipol.co.uk/
Follow us:
Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH
​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.
-
​​
​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
-Original Message-
From: ProFox On Behalf Of Tracy Pearson
Sent: 01 October 2021 20:40
To: profox@leafe.com
Subject: RE: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday
It's saddens me to hear about your dad Paul.
May you and your family have a positive experience and blessings.
Tracy
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Friday, October 01, 2021 3:25 PM
To: profoxt...@leafe.com
Subject: RE: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday
Sorry to hear about your dad, Paul. I hope things move in a positive direction
for you and your family.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Paul H. Tarver
Sent: Friday, October 1, 2021 3:10 PM
To: profoxt...@leafe.com
Subject: RE: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday
I hate I won't be able to attend this year as I was very much looking forward
to it. However, my father is currently in the hospital and we are not sure if
his next step is to rehab or what, so I can't commit to being able to
participate in this year's event.
Have fun y'all!
Paul H. Tarver
Tarver Program Consultants, Inc.
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/003401d7b92d$9242d7c0$b6c88740$@tpcqpc.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: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday
I hate I won't be able to attend this year as I was very much looking forward to it. However, my father is currently in the hospital and we are not sure if his next step is to rehab or what, so I can't commit to being able to participate in this year's event. Have fun y'all! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rick Schummer Sent: Wednesday, September 29, 2021 8:38 PM To: profoxt...@leafe.com Subject: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday Last call! (we want to make sure we have your attention) The Early-Bird discount ends midnight (North American Eastern time) on Thursday, which is tomorrow night. Here is the direct link to get registered: http://geekgatherings.com/registration Virtual Fox Fest is October 14, 20, and 26, 2021! Rick Schummer --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00bd01d7b6f7$fe29d250$fa7d76f0$@tpcqpc.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: [NF] - Is Bigger Always Better When It Comes To Your Monitors? :)
Desktop, not laptop. I'm just curious whether anyone had used DP ports and what was the general size monitor and number of monitors in use by the Foxpro community. I'm really starting to like this 27" monitor I have in place. But, I'm not sure I want two large monitors of the same size. I'm working quite nicely with the 27" as my primary and a 22" as my secondary right now. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, August 25, 2021 11:08 AM To: profoxt...@leafe.com Subject: Re: [NF] - Is Bigger Always Better When It Comes To Your Monitors? :) Your docking station should take care of any port issues...assuming you're using a laptop? On 8/24/2021 3:04 PM, John Weller wrote: > I'd say go for it - you can't have too much screen real estate! Don't know > about Display Ports, no experience. > > John > > John Weller > 07976 393631 > >> -Original Message- >> From: ProfoxTech On Behalf Of Paul H. >> Tarver >> Sent: 24 August 2021 19:59 >> To: profoxt...@leafe.com >> Subject: [NF] - Is Bigger Always Better When It Comes To Your Monitors? :) >> >> I've been using dual monitors for many years now, but I've been working > with >> monitors with two different layouts. Both monitors were 22" wide but the >> primary monitor was more square format whereas my secondary monitor has >> more of a wide screen format. >> >> >> >> Apparently, after I started talking about upgrading my gear, the main > monitor >> heard me, got mad and decided to give up the ghost yesterday. >> >> >> >> Fortunately, I had a used 27" monitor on hand which I stuck in place >> temporarily and the size and brightness and contrast have been a huge >> improvement. In fact, this used monitor is making my secondary monitor > look >> like crap. >> >> >> >> So, my question is this: What size monitors are you using for development > and >> how many? The new computer I've purchased has 2 Display Ports, 1 HDMI and >> 1 VGA. So I'm considering getting two matching monitors which support > Display >> Ports. Any comments, thoughts or suggestions about Display Ports? >> >> >> > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/007401d799d2$5b198520$114c8f60$@tpcqpc.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] - Is Bigger Always Better When It Comes To Your Monitors? :)
I've been using dual monitors for many years now, but I've been working with monitors with two different layouts. Both monitors were 22" wide but the primary monitor was more square format whereas my secondary monitor has more of a wide screen format. Apparently, after I started talking about upgrading my gear, the main monitor heard me, got mad and decided to give up the ghost yesterday. Fortunately, I had a used 27" monitor on hand which I stuck in place temporarily and the size and brightness and contrast have been a huge improvement. In fact, this used monitor is making my secondary monitor look like crap. So, my question is this: What size monitors are you using for development and how many? The new computer I've purchased has 2 Display Ports, 1 HDMI and 1 VGA. So I'm considering getting two matching monitors which support Display Ports. Any comments, thoughts or suggestions about Display Ports? Thanks in advance! Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/011a01d7991a$141a5b30$3c4f1190$@tpcqpc.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: Retire the CSV?
So Alex is complaining about the "simplicity and ubiquity [which] make[s] CSV an extremely popular way for organizations to exchange data both internally and externally"? And my question is: If it is going to take all of this work and effort to change to something else, what's the point? Did this guy ever work for Microsoft? Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Monday, August 23, 2021 8:25 AM To: profoxt...@leafe.com Subject: Retire the CSV? https://www.bitsondisk.com/writing/2021/retire-the-csv/ It's so simple they say. -- 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 --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/006c01d798f9$a4962160$edc26420$@tpcqpc.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: [NF] New Job & The Silence is Killing Me...
HAHAHAHAHAHAH! I WISH I was on a beach somewhere. Been too busy to even read messages here much less comment! Hopefully, the payroll tax changes coming down from D.C. will slow down at some point and I can participate more often. Missing y'all! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe Sent: Wednesday, July 21, 2021 8:34 AM To: profoxt...@leafe.com Subject: Re: [NF] New Job & The Silence is Killing Me... On Jul 20, 2021, at 21:33, Kurt at VR-FX wrote: > Wow - seems like in the past month or so - its gotten VERY Quiet around here!!! Well, it *is* summer. The more frequent posters are probably relaxing on a beach somewhere. :) > And - for those that follow my Meanderings thru this thing we call life - I was last working Tech support at Northrop-Grumman in Redondo Beach, CA - and was there for like 1 year and 2 months. Well - I know moved onto a New Gig - which may be my true DREAM JOB - as its a 3D Printing co. in Irvine - building Big and Hi-Tech and FAST 3D Printers! So - its VERY Cool indeed!!! Sounds great! What sort of work are you doing there? > P.S. OK - my bad - after I started to write this I realized I should probably tag this as NF - although I DID start with a Q re: Quiet ProFox list... No worries - took care of it for you for subsequent discussion! -- Ed Leafe [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00d201d78fc0$74e4e650$5eaeb2f0$@tpcqpc.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: Printing PDF's
FoxIt removed the PDF Printer Driver from the free version when they updated to Version 10. I remember being angry about it when it happened on an automatic update and reverting to version 9.x to get it back. I have been refusing all updates since then. There were a lot of people unhappy when that happened, but I didn't keep up with it after that. Did they put the PDF Printer driver back into the free version? Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jan Bucek Sent: Thursday, June 03, 2021 8:13 AM To: profoxt...@leafe.com Subject: Re: Printing PDF's Free Foxit PDF reader installs a PDFprinter by default. PDFprinter has a couple of properties than can be set in Settings > Printers. Dne 03.06.2021 v 13:20 Chris Davis napsal(a): > I've found ... > > http://www.columbia.edu/~em36/pdftoprinter.html > > seems to achieve what I needed > > Thanks for the heads up on 2printer though Matt. > > Regards > > Chris. > > -Original Message- > From: ProfoxTech On Behalf Of Chris Davis > Sent: Wednesday, 02 June 2021 13:37 > To: profoxt...@leafe.com > Subject: RE: Printing PDF's > > Thanks Matt, looks good, I am hoping to find a free solution but will keep that option open if I don't. > > Regards > > Chris. > > -Original Message- > From: ProfoxTech On Behalf Of Matt Slay > Sent: 02 June 2021 12:26 > To: profoxt...@leafe.com > Subject: Re: Printing PDF's > > Check out 2Printer. I've used the trial version recently to test it. > It's got a powerful command line syntax with options to set the paper size. > > https://www.cmd2printer.com/ <https://www.cmd2printer.com/> > > > Here is the very complete documentation on the syntax. I was able to get a list of available printers, then I was able to get a list of defined paper sizes for my desired printer, the I was able to print a PDF tabloid (ledger, 11" X 17") from the command line. > > https://www.cmd2printer.com/overview/syntax > <https://www.cmd2printer.com/overview/syntax> > > > *- Matt Slay* > > > > On 6/2/2021 3:01 AM, Chris Davis wrote: >> Hi All >> >> We are currently printing some PDF content using the shell print function that just triggers the default application for opening PDF's to do its stuff. We have a lot of A5 content which needs to printed to fit A4 paper, is there another method I could use that would give us this control. >> >> We have tried setting defaults in Acrobat Reader but the fit to page option isn't one it retains, we are also thinking there might be a more efficient way of getting the PDF to the printer other than using the default app. >> >> TIA >> >> Chris. >> >> >> --- StripMime Report -- processed MIME parts --- multipart/alternative >> text/plain (text body -- kept) >> text/html >> --- >> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000301d75ba0$b4fe5220$1efaf660$@tpcqpc.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 server connection
In our case, we require that our clients provide us with secure VPN access to their network. All of our development and support is done across this vpn connection and NOT to port open to the internet. Once our application is installed within their network access to their self-hosted SQL is already available. We never ask them to expose their SQL server directly to the internet. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Friday, February 12, 2021 3:19 AM To: profoxt...@leafe.com Subject: Re: sql server connection Have you considered the firewall port requirements involved for your clients in the generally inadvisable process of exposing a SQL Server directly to the internet? -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/002d01d70155$6473d640$2d5b82c0$@tpcqpc.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 server connection
I've not been able to make Windows Authentication work in the past, but I'll keep that in mind and try it again sometime. So far, my clients have been accommodating in terms of creating SQL Credentials. I also only need Read/Only rights for the work I do, so that helps with their security concerns as well. Thanks! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Thursday, February 11, 2021 12:05 PM To: profoxt...@leafe.com Subject: RE: sql server connection Really? All you have to do is set trusted=yes in the conn string, afaik. But I could be wrong. We only use SQL security accounts in our environment. I'm sure it's been mentioned before but this is a good resource for connection strings - https://www.connectionstrings.com/sql-server/ -- rk -Original Message- From: ProfoxTech On Behalf Of Paul H. Tarver Sent: Thursday, February 11, 2021 12:49 PM To: profoxt...@leafe.com Subject: RE: sql server connection I do this with multiple applications and we handle it using a DSN-less connection. The only requirement for the pc is a 32-bit MS SQL ODBC driver must be installed, but no DSN needs to be created on the computer. Also, you must have SQL Credentials configured on the SQL Server as you cannot use Windows Authentication over ODBC. Here's a short clip of the important parts of the SQLConnect.prg I use: lcDSNLess = 'Driver=' + ALLTRIM(lcDriver) + ';' + ; 'Server=' + ALLTRIM(lcServer) + ';' + ; 'Uid=' + ALLTRIM(lcUid) + ';' + ; 'Pwd=' + ALLTRIM(lcPWD) + ';' + ; 'Database=' + ALLTRIM(lcDbName) * Set SQL TimeOut Wait =SQLSETPROP(0,"ConnectTimeOut",3) * Suppress ODBC error dialog =SQLSETPROP(0,"DispWarnings",.f.) * Suppress login dialog =SQLSETPROP(0,"DispLogin",3) CLEAR ERROR lnConnection = SQLSTRINGCONNECT(lcDSNLess,.T.) lnErrorRows = AERROR(laError) Then check to see if lnErrorRows is greater than 0 to catch any errors. If the lnConnection value is greater than 1, then you can start sending pass through commands and getting results. Hope that helps! Paul H. Tarver Tarver Program Consultants, Inc. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/01f601d700af$bc3dc300$34b94900$@tpcqpc.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 server connection
I do this with multiple applications and we handle it using a DSN-less connection. The only requirement for the pc is a 32-bit MS SQL ODBC driver must be installed, but no DSN needs to be created on the computer. Also, you must have SQL Credentials configured on the SQL Server as you cannot use Windows Authentication over ODBC. Here's a short clip of the important parts of the SQLConnect.prg I use: lcDSNLess = 'Driver=' + ALLTRIM(lcDriver) + ';' + ; 'Server=' + ALLTRIM(lcServer) + ';' + ; 'Uid=' + ALLTRIM(lcUid) + ';' + ; 'Pwd=' + ALLTRIM(lcPWD) + ';' + ; 'Database=' + ALLTRIM(lcDbName) * Set SQL TimeOut Wait =SQLSETPROP(0,"ConnectTimeOut",3) * Suppress ODBC error dialog =SQLSETPROP(0,"DispWarnings",.f.) * Suppress login dialog =SQLSETPROP(0,"DispLogin",3) CLEAR ERROR lnConnection = SQLSTRINGCONNECT(lcDSNLess,.T.) lnErrorRows = AERROR(laError) Then check to see if lnErrorRows is greater than 0 to catch any errors. If the lnConnection value is greater than 1, then you can start sending pass through commands and getting results. Hope that helps! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Thursday, February 11, 2021 6:50 AM To: profoxt...@leafe.com Subject: sql server connection I have a VFP) app that uses MS sqlserver as backend. The SQL Server is located in a web provider The connection is achieved by creating a DSN throught the ODBC driver in my PC I need to deploy this app to several clients. But none of them should use their ODBC driver to create the connection, or install the applicable SQL Server Native Client in their PC. The idea is that I would send them my VFP application exe and they would simply connect to the cloud SQL Server and run the app without any further operations to install the exe. I tried SQLConnect and SQLStringConnect, but they always refer to an existing DSN Is there a way to accomplish this without my clients intervention other than lodging the exe in the applicable directory in their PC's ?? Please advise and if possible, provide an example on how to do this TIA Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/01aa01d7009e$2a9b69e0$7fd23da0$@tpcqpc.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: Facebook - FoxPro (LOL)
!LOL! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Sunday, January 31, 2021 7:39 PM To: profoxt...@leafe.com Subject: Facebook - FoxPro (LOL) Screenshot: https://www.screencast.com/t/rfxtn8NOjxd lol -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/004c01d6f8b9$410d57c0$c3280740$@tpcqpc.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: [NF] Back to the job search boards!
Sorry to learn of your family's loss and your corporate gig loss. Prayers for you and your family! Hopefully, February will get better quickly. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Monday, February 01, 2021 10:34 AM To: profoxt...@leafe.com Subject: [NF] Back to the job search boards! Well, I got notice today that I'm done with my current Corporate gig as of 3/1. And I learned my Uncle Bob passed away last night just before midnight. (I wasn't close to him but he's still family.) Not a great start to February! Since losing my VFP job in early 2017, I've been playing the "Business Analyst" role since then. You know how it is with regards to VFP dev work (it's non-existent!). "This too shall pass." --Mom's famous words of encouragement many decades ago. ;-) One thing never changes though...our love for the Fox and our virtual water-cooler here! Glad I can't lose this group! :D --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/004b01d6f8b9$4103e1e0$c30ba5a0$@tpcqpc.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: ProFox List Statistics for 2020
Sorry for the delayed response to the Annual Stats listing! As a developer primarily supporting payroll departments, you might imagine 2020 would not go out quietly due to all the 2020 payroll tax law changes, COVID tax credits and payroll departments working from home which have not been quite as productive as normal in terms of early testing for W2 printing! So, it has been a really busy couple of months for us, so much so, I've not been able to take the time to post to this group as much as I would have liked. That having been said, it's a proud moment when I can count myself in the top 20 of such a renowned group of Foxpro developers (and characters)! Thanks for letting me join in when I can and thanks for all the support and great answers this group has provided me over the years! Oh, and thanks in advance for all the great technical responses, snarky comments and down-right funny posts that keep me smiling even when I may not be able to respond in kind. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of List Administrator Account Sent: Sunday, January 03, 2021 4:18 PM To: profoxt...@leafe.com Subject: ProFox List Statistics for 2020 == ProFox List Statistics 2020 == Subscriber Count at End of Year: ProFox: 296 ProFoxTech: 182 == Total Posts: 1105 (Down 44.56% from 2019) Total [OT] Posts: 0 (Down 100.0% from 2019) Total [NF] Posts: 279 (Down 43.75% from 2019) Daily Message Counts for 2020 Date Count - 1 - 33 2 - 35 3 - 39 4 - 28 5 - 30 6 - 23 7 - 34 8 - 50 9 - 30 10 - 46 11 - 19 12 - 9 13 - 20 14 - 15 15 - 22 16 - 37 17 - 45 18 - 24 19 - 2 20 - 40 21 - 67 22 - 38 23 - 76 24 - 73 25 - 37 26 - 50 27 - 31 28 - 46 29 - 33 30 - 53 31 - 20 Message Counts By Day of Week for 2020 DOW Count --- - Sun - 35 Mon - 181 Tue - 213 Wed - 232 Thu - 199 Fri - 182 Sat - 63 Distinct Posters to the List (changes relative to 2019) Non-OT messages: 71 (Down 18.39%) OT messages: 0 (Down 100.0%) NF messages: 42 (Down 30.0%) Total number: 71 (Down 21.11%) Top 20 Contributors by Number of Non-OT Posts |Posts Contributor | 1. 155MB Software Solutions, LLC 2. 87Alan Bourke 3. 76Richard Kaye 4. 60Tracy Pearson 5. 55Eric Selje 6. 55Stephen Russell 7. 50Paul Newton 8. 50Ted Roche 9. 38Ed Leafe 10. 36JChttps://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00a501d6e69e$fe74ff70$fb5efe50$@tpcqpc.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: SCX form included in EXE is not found on DO FORM line
FYI, the movie was better than the book. :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, December 08, 2020 8:22 AM To: profoxt...@leafe.com Subject: RE: SCX form included in EXE is not found on DO FORM line A fine question. 😊 I didn't watch the movie. Are you putting a path in on your DO FORM call? Do you have a back door where you can see the runtime environment settings? I would think if you want VFP to walk its path to find the form in the EXE, then your DO FORM call should not include a fully qualified path or even a partial one. -- rk -Original Message- From: ProfoxTech On Behalf Of MB Software Solutions, LLC Sent: Monday, December 7, 2020 10:07 PM To: profoxt...@leafe.com Subject: Re: SCX form included in EXE is not found on DO FORM line Agreed, but why should it matter since the form was INCLUDED in the EXE? I figured "all definitions are in memory" so it should be able to find it no matter what. On 12/7/2020 2:34 PM, Richard Kaye wrote: > Smells like a PATH issue in your dev environment to me. > > -- > > rk > > -Original Message- > From: ProfoxTech On Behalf Of MB > Software Solutions, LLC > Sent: Monday, December 7, 2020 2:01 PM > To: profoxt...@leafe.com > Subject: Re: SCX form included in EXE is not found on DO FORM line > > Hi Tracy, > > Those wouldn't apply to me here because this is all done on my Dev machine > (dev and testing). Legacy core project files are on c:\wsapps\bwd but my > MBSS additions come from e:\dev\client\ > > Again, the strange thing is that this works AT THE CLIENT SITE where my > e:\dev folder doesn't exist at all. > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00c601d6cd8a$97aac360$c7004a20$@tpcqpc.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: SCX form included in EXE is not found on DO FORM line
Mike, I have run into this error only once and it happened for a client using an existing utility app which I wrote years ago and has been working ever since. The only difference was she went home when the COVID shutdowns started and began running the application across a VPN connection. I don't normally recommend doing that any way, but because it a conversion process which picks up files and converts them and then writes the output to a local folder and it creates all temp files locally, I didn't have too much concern about it. However, it turned out she was also connecting to her VPN via her WIFI connection at home and at some point after the application loaded, but before she clicked on a button to start a process, either her WIFI or VPN dropped out for a split second and it returned the Form Not Found message. Shutting down the VFP app and restarting the app solved the problem and everything worked fine the second time. As far as I know if it happens again, she just restarts once her VPN/WIFI signal stabilizes, and it works fine for her. I know that is not a permanent fix for most applications but it works for this little utility she runs once every two weeks. I don't know if that provides any additional clues or not but I thought I would at least document what we saw earlier this year. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Saturday, December 05, 2020 9:32 PM To: profoxt...@leafe.com Subject: SCX form included in EXE is not found on DO FORM line VFP9SP2 - Win 7 Pro 43 second demo showing the problem: https://www.screencast.com/t/ZjyWYqFI The SCX form is included in the EXE. I'm running the EXE. DO FORM errors saying that the form is not found. Makes no sense to me. Now the app (a legacy app that I inherited which is very dirty) changes the path but stillif the SCX form is included in the EXE, why in the world would it not be found on DO FORM frmMyForm??? tia, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/01db01d6cce8$77860880$66921980$@tpcqpc.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: Virtual Fox Fest 2020: Follow-up
Just another opportunity for me to heap praise on everyone involved in putting this event on! It was amazing and educational and fun! Thank you, thank you, thank you! Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rick Schummer Sent: Friday, November 06, 2020 4:06 PM To: profoxt...@leafe.com Subject: Virtual Fox Fest 2020: Follow-up Here are some follow-up notes about Virtual Fox Fest 2020 (https://virtualfoxfest.com/), the first but likely not the last online event hosted by Geek Gatherings: Videos for all presentations are now available on YouTube (https://www.youtube.com/channel/UCsLb2rL3ALQW9g5r-qqf_jA/videos) for free to everyone, as our contribution to the VFP community. Be sure to subscribe to our channel. If you want materials (white papers and sample code) for the presentations, go to https://geekgatherings.com/Registration and "register" for the conference. You're not really registering since it's over, but in the Registration Fees section of the registration page, you'll see "Virtual Fox Fest 2020 Session Materials (download)". The cost of the materials is $49. There's also an opportunity to sponsor Virtual Fox Fest, which means your name will be listed on our Sponsors page (https://virtualfoxfest.com/sponsors.aspx). We're planning on doing a survey soon. It'll be sent to all attendees but if you want to participate so you can help shape future events, email i...@geekgatherings.com and ask to be included. We have tentative dates for an in-person Southwest Fox (http://www.swfox.net/) conference next year: October 14-17, 2021, at the same location as previous years: the SanTan Conference Center in Gilbert, Arizona. At this point, we don't know whether we'll be able to have an in-person event, but hope springs eternal! If you didn't attend Virtual Fox Fest, check out our Facebook page (https://www.facebook.com/fox.geekgatherings.5) and see what you missed, then plan to attend a future one so you can join in the fun. Rick White Light Computing, Inc. www.whitelightcomputing.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/005401d6b6b4$339c2d10$9ad48730$@tpcqpc.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: Tomorrow is the last day of Virutal Fox Fest
+1 Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Monday, October 26, 2020 12:42 PM To: profoxt...@leafe.com Subject: Tomorrow is the last day of Virutal Fox Fest Hello Everyone! I have been enjoying chatting with people and getting to see some faces of people for the first time. The sessions have been worth the time to watch live. There is a lot of chatter in the chat window as well. I haven't been paying attention to the chat much. Maybe I'll get a chance to put some more faces to the names I see here. Have a good one! Tracy [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/011801d6abe2$d6dfad30$849f0790$@tpcqpc.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: Day one Virtual FoxFest has begun
i...@geekgatherings.com
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Friday, October 16, 2020 5:55 AM
To: profoxt...@leafe.com
Subject: RE: Day one Virtual FoxFest has begun
Hey Dave,
I think Tamar said everything will be available on their you tube channel but
only after the last day. Maybe message geek gatherings directly to get the
unedited version :)
On 16 October 2020 06:43:00 GMT-04:00, Dave Crozier
wrote:
>Guys,
>I have registered for the conference but unfortunately missed yesterday
>as my mum took a bad fall. I hadn't registered for the day via Hopin
>and it now tells me that the sessions are obviously ended. Is there any
>way we can currently access the finished sessions so I can catch up
>before the next session?
>
>Dave Crozier
>Software Development Manager
>Flexipol Packaging Ltd.
>
>Mob: 07967 671080
>
>﴾⚆ᨎ⚆﴿
>
>
>
>Flexipol® Packaging Ltd
>T 01706 222 792
>E dcroz...@flexipol.co.uk
>W https://www.flexipol.co.uk/
>Follow us:
>Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire,
>BB4 5HH
>
>​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.
>
>-
>​​
>​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
>-Original Message-
>From: ProFox On Behalf Of Richard Kaye
>Sent: 15 October 2020 19:50
>To: profox@leafe.com
>Subject: Day one Virtual FoxFest has begun
>
>As far as I know it's not too late to register. 2 good sessions so far
>on SQL security and a graphics library that can be used in VFP.
>
>And cheers to Ted Roche for being a sponsor!
>
>--
>
>rk
>
>
>
>--- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
>---
>
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/005d01d6a3be$0603bbb0$120b3310$@tpcqpc.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: [NF] SQL Server access via ODBC won't work from one workstation
+1 Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, October 07, 2020 2:42 PM To: profoxt...@leafe.com Subject: RE: [NF] SQL Server access via ODBC won't work from one workstation Hosts file? -- rk -Original Message- From: ProfoxTech On Behalf Of Ted Roche Sent: Wednesday, October 7, 2020 2:53 PM To: profoxt...@leafe.com Subject: Re: [NF] SQL Server access via ODBC won't work from one workstation On Wed, Oct 7, 2020 at 4:49 AM Alan Bourke wrote: > When creating the System DSN, does it work with an IP address as > opposed to the hostname, i.e. > > xxx.xxx.xxx.xxx\SQLEXPRESS > Well. Maybe I should have asked a week ago. It does! [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/015b01d69ce6$74f14b70$5ed3e250$@tpcqpc.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: VFP Apps/DBFs with AMD Processor
Reading and then retaining all that knowledge until you need said information is as big a challenge sometimes. :) Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Monday, September 21, 2020 12:13 PM To: profoxt...@leafe.com Subject: AW: VFP Apps/DBFs with AMD Processor >> I still notice commands in the help file I've never seen before :) It couldn't harm to finally READ the revised helpfile from VFPX.org. After 15 years of stable existence, it shouldn't change anymore. Maybe it would be a good time to start discovering shocking new details of VFP9? :) wOOdy -Ursprüngliche Nachricht- Von: ProFox Im Auftrag von Alan Bourke Gesendet: Montag, 21. September 2020 16:21 An: profoxt...@leafe.com Betreff: Re: VFP Apps/DBFs with AMD Processor > Today, I'm still trying to wring the most out of VFP9 and I often feel > like I'm still only scratching the surface. I still notice commands in the help file I've never seen before :) -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/014f01d69062$f936a0f0$eba3e2d0$@tpcqpc.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: VFP Apps/DBFs with AMD Processor
I think we all had a bit of a transition to the Windows UI. I didn't succeed at it until VFP 6.0. I started with FoxBase, then moved to FoxproLan then for several years, I used a DOS language called MagicPC (btrieve based) before switching back to VFP 6.0. it was a challenge, but one well worth the effort. Today, I'm still trying to wring the most out of VFP9 and I often feel like I'm still only scratching the surface. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Monday, September 21, 2020 3:44 AM To: profoxt...@leafe.com Subject: Re: VFP Apps/DBFs with AMD Processor On Mon, 21 Sep 2020, at 9:34 AM, Jean Laeremans wrote: > And what a joy that was Allen. ;) VFP 3.0? The hardest part for me as I remember it was getting my head around how to bind UI controls, handle buffering and transactions, and that whole paradigm. I had never been a VB programmer or anything - I was a C guy back then with some FoxPro for DOS experience. So Windows UI was new to me. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/001d01d6901f$02bc2940$08347bc0$@tpcqpc.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: Virtual Fox Fest
+1 - Very much looking forward to this and several other sessions at Virtual Fox Fest! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Eric Selje Sent: Friday, September 11, 2020 4:13 PM To: profoxt...@leafe.com Subject: Re: Virtual Fox Fest I'm excited to see what John has to say about VFPA and especially the C++ compiler. When I was preparing my session last year and was reading about that I thought "Well this is an entire session unto itself" so I didn't get too far into it but it looks very very interesting. It actually takes your VFP apps and compiles them using the c++ compiler for extra speed and security, if I'm not mistaken. Chan is some sort of genius. Eric On Wed, Sep 9, 2020 at 4:59 PM Rick Schummer wrote: > We're pleased to announce GeekWear by Geek Gatherings ( > https://virtualfoxfest.com/geekwear.aspx). Order your Virtual Fox > Fest gear from the options shown or create your own unique VFFwear. > > Unfortunately, because of family matters, Cathy Pountney had to withdraw > from presenting this year. Fortunately, John > Ryan offered to present "Visual FoxPro Advanced and VFP C++ Compiler: A > New Lease of Life for VFP" > ( > https://virtualfoxfest.com/Sessions.aspx#Visual_FoxPro_Advanced_and_VFP_C_Co mpiler > ). > > Registrations are still open: http://geekgatherings.com/Registration > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/005801d68cff$0f536100$2dfa2300$@tpcqpc.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: [NF] I will .....
I have created variables on the fly without declaring them at the beginning of my procedures. I've been attending THOR BeautifyX meetings regularly and I've been able to avoid that particular sin for at least six months now. But the guilt remains... Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Friday, July 17, 2020 11:06 AM To: profoxt...@leafe.com Subject: [NF] I will . Alright, I'm not a priest, but I am a programmer. Confess to me your programming sins, and I shall absolve you. -- 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 --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/009901d65c5e$786478e0$692d6aa0$@tpcqpc.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: [NF] Less Filling or Tastes Great?
Gotta say, all of these comments were WAY funnier, once I went back and watched the video. Funnier than the video for sure! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Eric Selje Sent: Monday, July 13, 2020 1:30 PM To: profoxt...@leafe.com Subject: Re: [NF] Less Filling or Tastes Great? That server should have carded Gates. He looks 14. On Mon, Jul 13, 2020 at 11:01 AM Ted Roche wrote: > I think they were both full of it. > > On Fri, Jul 10, 2020 at 3:27 PM Stephen Russell > wrote: > > > https://www.youtube.com/watch?v=5ycx9hFGHog > > > > -- > > 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 > > --- > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/01ca01d65947$d4657fa0$7d307ee0$@tpcqpc.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: SQLite
I think you'll find SQLite interesting, fast and efficient. There are some caveats particularly when it comes to multi-user functionality, but the book (edited by none other than Ted Roche!) covers all of that material in an easy to understand way. I think I only had to ask Ted for help once! :) Have fun! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 10:06 AM To: profoxt...@leafe.com Subject: RE: SQLite Thanks Paul. I'll investigate. I'm only playing as I've retired but it's something to do in lockdown 😊 John John Weller 01380 723235 07976 393631 -Original Message- From: ProfoxTech On Behalf Of Paul H. Tarver Sent: 23 June 2020 15:57 To: profoxt...@leafe.com Subject: RE: SQLite I have and it works great. I'm using it to import a table much wider than 250 columns and then querying that table for specific results and using them to create an upload file for a third party service. I recommend the following book as your starting point: https://www.hentzenwerke.com/catalog/sqlite2gb.htm Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 9:19 AM To: profoxt...@leafe.com Subject: SQLite Has anyone used SQLite with VFP? I have always used DBFs as it seemed over-kill to use SQL Server for the small membership databases I've been using (2000 records) however I was introduced to SQLite as part of a Python course so thought I'd give it a try with VFP. John John Weller 01380 723235 07976 393631 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00cb01d64973$ede17210$c9a45630$@tpcqpc.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: SQLite
I have and it works great. I'm using it to import a table much wider than 250 columns and then querying that table for specific results and using them to create an upload file for a third party service. I recommend the following book as your starting point: https://www.hentzenwerke.com/catalog/sqlite2gb.htm Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 9:19 AM To: profoxt...@leafe.com Subject: SQLite Has anyone used SQLite with VFP? I have always used DBFs as it seemed over-kill to use SQL Server for the small membership databases I've been using (2000 records) however I was introduced to SQLite as part of a Python course so thought I'd give it a try with VFP. John John Weller 01380 723235 07976 393631 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/008a01d6496e$8662f230$9328d690$@tpcqpc.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: [NF} Thanks For This Group!
At least I'm in good company!
Have a great weekend everyone!
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Friday, May 29, 2020 3:27 PM
To: profoxt...@leafe.com
Subject: Re: [NF} Thanks For This Group!
On Wed, May 20, 2020 at 3:08 PM Richard Kaye wrote:
> Been there, done that so many times, Paul. Quite often the act of
> formulating a properly worded question that even Ted would accept leads to
> the answer. 😉
>
>
:)
Exactly the reason for "How to Ask a Good Question." Much as I enjoy
annoying fellow forum members, stating the basics, especially when you know
"that couldn't be the problem" and justifying the steps you took along the
way troubleshooting ("No, wait, did I try to do it this way and that way?")
very often solve the problem. I delete a number of questions ready to send
to the list for exactly this reason.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/017a01d6360a$52bab930$f8302b90$@tpcqpc.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: Virtual Fox Fest 2020: All new virtual Fox conference in October, Southwest Fox hiatus until 2021
+1 Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, May 27, 2020 9:17 AM To: profoxt...@leafe.com Subject: RE: Virtual Fox Fest 2020: All new virtual Fox conference in October, Southwest Fox hiatus until 2021 Thanks for reminding me. I just registered as well. -- rk -Original Message- From: ProfoxTech On Behalf Of Vince Teachout Sent: Wednesday, May 27, 2020 9:35 AM To: profoxt...@leafe.com Subject: Re: Virtual Fox Fest 2020: All new virtual Fox conference in October, Southwest Fox hiatus until 2021 On 05/14/20 10:52 AM, Rick Schummer wrote: > Registration opens up in July, but I'd hate to temper your enthusiasm > so you are welcome to figure it out via our normal conference > registration page: https://geekgatherings.com I'm registered! This is the first time ever I'll get to "go" to one of these! -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/018701d6345f$4efd9f30$ecf8dd90$@tpcqpc.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} Thanks For This Group!
This morning I was pulling out what little hair I have left trying to make an programmatic ADODB connection to a Pervasive (btrieve) database from VFP with no success. I started to write up the problem to submit it to this group to see if I could get an assist in figuring out my problem and in the process of trying to explain it in an email, I realized what I had done wrong, make a change in my code and voila! Problem solved! Sometimes just knowing there is a group of like-minded individuals I can turn to is enough to solve even the toughest problem. You guys have always been there for me when I needed it, occasionally even before I submit a question like today, and I just wanted stop for a moment and say thank you. Thanks to Ed for keeping this whole thing going. Thanks to everyone who contributes questions and answers. I learn more from your questions and answers than you will ever know. This resource is one of my favorites and I refer back to past emails almost daily. Y'all have made me a better programmer and I appreciate it. Just wanted you to know it. Paul H. Tarver --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/008e01d62ec4$c35ae4f0$4a10aed0$@tpcqpc.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: Virtual Fox Fest 2020: All new virtual Fox conference in October, Southwest Fox hiatus until 2021
What he said! Plus, I'm all in! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, May 13, 2020 9:50 AM To: profoxt...@leafe.com Subject: Re: Virtual Fox Fest 2020: All new virtual Fox conference in October, Southwest Fox hiatus until 2021 Sounds great! At $49, that's a no-brainer, even for me. So where do I pay? https://imgflip.com/i/41a3wr On 5/13/2020 10:42 AM, Rick Schummer wrote: > We're disappointed to announce that due to COVID-19, the annual Southwest Fox > Conference is on hiatus in 2020. However, > we're excited to offer you Virtual Fox Fest, an online conference presenting > the latest in Microsoft Visual FoxPro > development techniques and interoperability with other technologies. This > conference provides a venue for VFP experts to > come together virtually to learn more about how our fellow programmers are > using and extending VFP. For details about > Virtual Fox Fest, please see https://virtualfoxfest.com. > > We've issued the Call for Speakers > (https://virtualfoxfest.com/CallForSpeakers.aspx) for Virtual Fox Fest. If > you are > interested in presenting, please read the document referenced in that page > and consider submitting sessions. If you > previously submitted sessions for Southwest Fox 2020, you don't need to > resubmit for Virtual Fox Fest (but feel free to > delete or revise your prior submissions or submit new sessions). > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/02f301d6294d$3ac0e8f0$b042bad0$@tpcqpc.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: Test
Coming through loud and clear, Dave!
Well, maybe not loud, but clear! :)
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Thursday, April 30, 2020 5:05 AM
To: profoxt...@leafe.com
Subject: Test
Hi guys,
Just sending an email for Ed’s benefit so he can hopefully sort out my issues
posting to Profox. Hence my absence for nearly 12 months.
Missing the interaction with you all and hoping you are all well.
If some of you could reply to this message to confirm that I can see your
responses even though I can’t see my posts to the group
Thanks
Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.
﴾⚆ᨎ⚆﴿
Flexipol® Packaging Ltd
T 01706 222 792
E dcroz...@flexipol.co.uk
W https://www.flexipol.co.uk/
Follow us:
Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH
​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.
-
​​
​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
Disclaimer
The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and others
authorized to receive it. If you are not the recipient, you are hereby notified
that any disclosure, copying, distribution or taking action in relation of the
contents of this information is strictly prohibited and may be unlawful.
This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast Ltd, an innovator in Software as a Service
(SaaS) for business. Providing a safer and more useful place for your human
generated data. Specializing in; Security, archiving and compliance. To find
out more visit the Mimecast website.
--- StripMime Report -- processed MIME parts ---
multipart/related
multipart/alternative
text/plain (text body -- kept)
text/html
image/jpeg
image/jpeg
image/png
image/png
image/png
image/png
---
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/000b01d61ef5$420912c0$c61b3840$@tpcqpc.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: GoFish problem
Matt, it looks like with your tip, I got it going. I knew MSCOMCTL.ocx was on the computer I was testing on (Win7 64bit), but I decided to try to ty to re-register it manually just to make sure. Ran CMD as Admin and it dropped me into C:\Windows\System and without thinking I ran REGSVR32 MSCOMCTL.ocx and it failed. Re-reading your message I switched to C:\Windows\SysWow32, ran REGSVR32 again and this time the command worked. When back into VFP and ran the GOFISH.APP and it worked perfectly. I don't know why the reinstallation of the VB6 Common tools didn't also re-register the .ocx, but manually doing it from the SysWow32 folder took care of the problem. Thanks for the tip as I didn't know what OLE library I was supposed to focus on! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Matt Slay Sent: Tuesday, April 28, 2020 4:18 PM To: profoxt...@leafe.com Subject: Re: GoFish problem Here is what GoFish uses: OLEObject = C:\Windows\SysWOW64\MSCOMCTL.OCX - Matt Slay On 4/28/2020 3:43 PM, Tracy Pearson wrote: > We had enough problems with the Common controls we removed them from our > product. > Try to open a screen in our software and Windows attempting to run an > installer. The file was there, and registered, but the installer insisted it > was the wrong one. > You are looking for one these files. I don't know which version was attached > to the form: > Microsoft Windows Common Controls 5.0 (SP2) > File: c:\windows\syswow64\comctl32.ocx > Microsoft Windows Common Controls 6.0 (SP6) > File: c:\windows\syswow64\mscomctl.ocx > > If you are on a Windows 10 64-bit OS, that is where they live. > I don't use GF personally. > > HTH, > Tracy > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H. > Tarver > Sent: Tuesday, April 28, 2020 4:09 PM > To: profoxt...@leafe.com > Subject: RE: GoFish problem > > It looks like the Microsoft Visual Basic 6.0 Common Controls download only > updated my existing MSComCt files and didn't appear to install anything else > and my OLE error remains. > > So I'm guessing it's something in a different distribution. > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard > Kaye > Sent: Tuesday, April 28, 2020 12:38 PM > To: profoxt...@leafe.com > Subject: RE: GoFish problem > > IIRC it uses MS common controls circa VB6 so you might need to hunt down > something like that. > > -- > > rk > > -Original Message- > From: ProfoxTech On Behalf Of Paul H. Tarver > Sent: Tuesday, April 28, 2020 11:05 AM > To: profoxt...@leafe.com > Subject: RE: GoFish problem > > After you brought up GoFish, I found a video on it and thought I'd try to > use it, but I can't get v5 to run. I keep getting an OLE error code that a > class is not registered. If I click ok on the error the source stops on a > reference to 'otree'. I cannot find any instructions to setup it up or any > pre-requisites as far as .ocx files that I need to have for it run. I'd like > to try it, but so far no go. (Also, I couldn't find a download for the 4.3 > version, so got stuck there too.) > > Any ideas? > > Paul H. Tarver > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul > Newton > Sent: Tuesday, April 28, 2020 8:26 AM > To: profoxt...@leafe.com > Subject: GoFish problem > > Hi all > > I have been happily using GoFish (4.3) for years but today when I tried to > run it (in VFP9 SP2) the cursor changes to that circular one which appears > when Fox is busy and GoFish refuses to load. Fox also displays eventually > as Not Responding. Any ideas/suggestions? Many thanks > > Paul Newton > > > --- StripMime Report -- processed MIME parts --- multipart/alternative >text/plain (text body -- kept) >text/html > --- > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000601d61e29$0cba0ba0$262e22e0$@tpcqpc.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: GoFish problem
Been there, done that. No joy in Mudville so far. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, April 28, 2020 2:08 PM To: profoxt...@leafe.com Subject: RE: GoFish problem There is/was a Google group for GF. I'd try searching that for clues. -- rk -Original Message- From: ProfoxTech On Behalf Of Richard Kaye Sent: Tuesday, April 28, 2020 1:38 PM To: profoxt...@leafe.com Subject: RE: GoFish problem IIRC it uses MS common controls circa VB6 so you might need to hunt down something like that. -- rk -Original Message- From: ProfoxTech On Behalf Of Paul H. Tarver Sent: Tuesday, April 28, 2020 11:05 AM To: profoxt...@leafe.com Subject: RE: GoFish problem After you brought up GoFish, I found a video on it and thought I'd try to use it, but I can't get v5 to run. I keep getting an OLE error code that a class is not registered. If I click ok on the error the source stops on a reference to 'otree'. I cannot find any instructions to setup it up or any pre-requisites as far as .ocx files that I need to have for it run. I'd like to try it, but so far no go. (Also, I couldn't find a download for the 4.3 version, so got stuck there too.) Any ideas? Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Tuesday, April 28, 2020 8:26 AM To: profoxt...@leafe.com Subject: GoFish problem Hi all I have been happily using GoFish (4.3) for years but today when I tried to run it (in VFP9 SP2) the cursor changes to that circular one which appears when Fox is busy and GoFish refuses to load. Fox also displays eventually as Not Responding. Any ideas/suggestions? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00af01d61d98$ecdeb0a0$c69c11e0$@tpcqpc.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: GoFish problem
It looks like the Microsoft Visual Basic 6.0 Common Controls download only updated my existing MSComCt files and didn't appear to install anything else and my OLE error remains. So I'm guessing it's something in a different distribution. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, April 28, 2020 12:38 PM To: profoxt...@leafe.com Subject: RE: GoFish problem IIRC it uses MS common controls circa VB6 so you might need to hunt down something like that. -- rk -Original Message- From: ProfoxTech On Behalf Of Paul H. Tarver Sent: Tuesday, April 28, 2020 11:05 AM To: profoxt...@leafe.com Subject: RE: GoFish problem After you brought up GoFish, I found a video on it and thought I'd try to use it, but I can't get v5 to run. I keep getting an OLE error code that a class is not registered. If I click ok on the error the source stops on a reference to 'otree'. I cannot find any instructions to setup it up or any pre-requisites as far as .ocx files that I need to have for it run. I'd like to try it, but so far no go. (Also, I couldn't find a download for the 4.3 version, so got stuck there too.) Any ideas? Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Tuesday, April 28, 2020 8:26 AM To: profoxt...@leafe.com Subject: GoFish problem Hi all I have been happily using GoFish (4.3) for years but today when I tried to run it (in VFP9 SP2) the cursor changes to that circular one which appears when Fox is busy and GoFish refuses to load. Fox also displays eventually as Not Responding. Any ideas/suggestions? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00ae01d61d98$ecd784b0$c6868e10$@tpcqpc.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: GoFish problem
After you brought up GoFish, I found a video on it and thought I'd try to use it, but I can't get v5 to run. I keep getting an OLE error code that a class is not registered. If I click ok on the error the source stops on a reference to 'otree'. I cannot find any instructions to setup it up or any pre-requisites as far as .ocx files that I need to have for it run. I'd like to try it, but so far no go. (Also, I couldn't find a download for the 4.3 version, so got stuck there too.) Any ideas? Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Tuesday, April 28, 2020 8:26 AM To: profoxt...@leafe.com Subject: GoFish problem Hi all I have been happily using GoFish (4.3) for years but today when I tried to run it (in VFP9 SP2) the cursor changes to that circular one which appears when Fox is busy and GoFish refuses to load. Fox also displays eventually as Not Responding. Any ideas/suggestions? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/003b01d61d6e$5726d8a0$057489e0$@tpcqpc.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: AddObject/BindEvent Question
Antonio, I responded previously but I didn't see the reply come through and it didn't show up in the archive. However, I'm very happy it didn't because in my reply I confirmed I had set the checkbox visibility to true. And, I knew it was true because I could clearly see the checkbox in the grid when it was displayed. But as you well know, when you "assume" ANYTHING, it will bite you in the end. After toying some more this morning with the BINDEVENT command for the checkbox, I noticed for all other field types in my code, the Visibility of the control was set to .t.. Your reply clicked when I realized I hadn't explicitly included that setting for the checkbox. What I was seeing on the screen was the underlying column display value NOT the actual checkbox control itself. I could have clicked until I was blue in the face and nothing would ever happen because the actual control was hidden. Long story short, I set the Visibility = .T. and all of the default functionality I wanted, started working perfectly. Thanks for the help on this issue. Once again, my problem is caused more by me than by Foxpro. :) Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of António Tavares Lopes Sent: Sunday, April 26, 2020 6:14 AM To: profoxt...@leafe.com Subject: Re: AddObject/BindEvent Question Paul, since you're adding the control at run time, did you set the checkbox visibility to .T.? On Sat, Apr 25, 2020 at 8:31 PM Paul H. Tarver wrote: > I'm probably missing something obvious here or being thickheaded about > this, > but here's my situation: > > > > I have a standard lookup button class I use all the time that I drop onto a > form, set several properties, do a simple query to create a picklist and > then it uses CREATEOBJECT to create a simple form from my class library, > then it uses ADDOBJECT to add a Grid from the class library and > Select/Cancel buttons to the form. After creating the grid, I loop through > the fields in the picklist and setup the columns in the grid. I use > BINDEVENT to provide the functionality to the click event of each button > and > the dblclick event of the grid columns. This class has worked perfectly > for > many years and is easy to use and include whenever I want a simple look up > for a single selection from the picklist by the user. > > > > However, today I was trying to add some functionality to the class by > adding > a checkbox in the first column of the grid to allow users to make multiple > selections from the picklist. Adding a 'Sel' field to the query and setting > the resulting cursor to READWRITE was easy enough. Displaying the checkbox > in the generated grid was also easy. I set the readonly propery for the > grid, the column and the checkbox to .f. and everything displays correctly > but no matter what I do, when I click on the checkbox, nothing happens. > > > > I've confirmed the cursor is readwrite at runtime. I've monitored readonly > properties all the way to the moment the .show() method is called to > display > the picklist form and they all are .f. until after the .show() method > executes. I've traced the code for all the parent elements and can find no > other place where any readonly properties are being set to .t. > > > > My question is this: If I'm using ADDOBJECTS and BINDEVENT commands to > create this picklist form, do I need to create a procedure specifically for > the CLICK event of the checkbox to issue a DODEFAULT() command and then > bind > that to the Click Event manually or will the checkbox just automatically > use > the base CLICK event code from the parent class? > > > > I haven't worked with ADDOBJECTS and BINDEVENT commands often (the last > time > was probably when I wrote the original code for the picklist class I'm > trying to modify) and I'm not sure this makes sense, but after a couple of > hours failure, I decided to give up and ask for help. > > > > Thanks in advance! > > > > Paul H. Tarver > > > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/014c01d61ce4$8983dd50$9c8b97f0$@tpcqpc.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.
AddObject/BindEvent Question
I'm probably missing something obvious here or being thickheaded about this, but here's my situation: I have a standard lookup button class I use all the time that I drop onto a form, set several properties, do a simple query to create a picklist and then it uses CREATEOBJECT to create a simple form from my class library, then it uses ADDOBJECT to add a Grid from the class library and Select/Cancel buttons to the form. After creating the grid, I loop through the fields in the picklist and setup the columns in the grid. I use BINDEVENT to provide the functionality to the click event of each button and the dblclick event of the grid columns. This class has worked perfectly for many years and is easy to use and include whenever I want a simple look up for a single selection from the picklist by the user. However, today I was trying to add some functionality to the class by adding a checkbox in the first column of the grid to allow users to make multiple selections from the picklist. Adding a 'Sel' field to the query and setting the resulting cursor to READWRITE was easy enough. Displaying the checkbox in the generated grid was also easy. I set the readonly propery for the grid, the column and the checkbox to .f. and everything displays correctly but no matter what I do, when I click on the checkbox, nothing happens. I've confirmed the cursor is readwrite at runtime. I've monitored readonly properties all the way to the moment the .show() method is called to display the picklist form and they all are .f. until after the .show() method executes. I've traced the code for all the parent elements and can find no other place where any readonly properties are being set to .t. My question is this: If I'm using ADDOBJECTS and BINDEVENT commands to create this picklist form, do I need to create a procedure specifically for the CLICK event of the checkbox to issue a DODEFAULT() command and then bind that to the Click Event manually or will the checkbox just automatically use the base CLICK event code from the parent class? I haven't worked with ADDOBJECTS and BINDEVENT commands often (the last time was probably when I wrote the original code for the picklist class I'm trying to modify) and I'm not sure this makes sense, but after a couple of hours failure, I decided to give up and ask for help. Thanks in advance! Paul H. Tarver --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000601d61b38$08435fc0$18ca1f40$@tpcqpc.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: File sharing services
I use both Send-Anywhere and Dropbox regularly, but occasionally I fall back on my self-hosted FileZilla server for really big stuff in one-off scenarios. Not sure about API's. Wouldn't that require programming on the client side to grab data, unless you are building some kind of automated transfer process? For regular scheduled transfers via Backblaze Cloud space, I use Syncovery to handle the automated uploads and downloads on each end. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Glassman Sent: Thursday, April 23, 2020 4:07 PM To: profoxt...@leafe.com Subject: RE: File sharing services I use Send Anywhere (https://send-anywhere.com/), a free service for files up to 10gb. Alas, no API. Mike -Original Message- From: Richard Kaye [mailto:rk...@invaluable.com] Sent: Thursday, April 23, 2020 2:52 PM To: profoxt...@leafe.com Subject: File sharing services Calling on the collective wisdom. What are people using th4eses days to share files with customers beside Dropbox? Preferably something that can be accessed via APIs. TIA -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/010601d619bb$d349dba0$79dd92e0$@tpcqpc.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: [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April
+1 Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Thursday, April 23, 2020 10:53 AM To: profoxt...@leafe.com Subject: Re: [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April On Thu, 23 Apr 2020, at 11:42 AM, Johan Nel wrote: > Hope this is of interest to some. > > Today we have released a new installer for XSharp Bandol 2.4 to our FOX > subscribers. I think what would really help drive interest in this from the VFP community is a thorough start-to-finish example, like a To Do List or something, using VFP syntax and demonstrating how to work with DBF files. It's extremely hard to figure out what you're supposed to be doing in XSharp if you're not from a Visual Objects or similar background. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00ac01d619a5$4df0c010$e9d24030$@tpcqpc.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: Looking for a "side by side" editor for PRGs
Notepad++ has a plugin for comparing two text files. I've used it for this kind of comparison. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Friday, January 24, 2020 11:52 AM To: profoxt...@leafe.com Subject: Looking for a "side by side" editor for PRGs Hi all (Happy New Year) I have two PRGs with about 60 differences between them. I am looking for an editor that will allow me to view and edit them side by side. I have CodeCompare but I can't seem to get on with it and I don't have time to get to grips with it. Basically I want a one way copy-and-paste facility (copy from one file, paste into the other). If it highlighted differences that would be a bonus but not absolutely essential. All suggestions most welcome. Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/006501d5d2ec$b914f190$2b3ed4b0$@tpcqpc.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: Nostalgia -- updating an app written 15+ years ago
Another active VFP programmer here with a high comfort level. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Tuesday, January 14, 2020 4:24 AM To: profoxt...@leafe.com Subject: AW: Nostalgia -- updating an app written 15+ years ago Oh you whiners... I'm still actively coding in VFP. And currently I have to maintain an app which was originally coded in 1998, then continuously updated up to VFP9, but lots of code fragments are from earlier versions. The original programmer died last year because of a heartattack, thus no clean handover was possible. That's why I work somewhat as a firefighter now; enhancing it to new requirements as well as refactoring old parts. That software controls multi-million-Euro Metallurgy Furnaces, with over 60 installations scattered over whole Europe. Multi-lingual with several codepages is really funstuff without Unicode :) wOOdy -Ursprüngliche Nachricht- Von: ProFox Im Auftrag von MB Software Solutions, LLC Gesendet: Montag, 13. Januar 2020 16:20 An: ProFox Email List Betreff: Nostalgia -- updating an app written 15+ years ago Offered one of my clients 20 free dev hours in 2020 hoping to spur more business moving their suite of apps I've provided since 2003 forward. Modifying one app now that I can a comment dated 2004-12-28. Gives a nice warm feeling to be working on this app again. It was redesigned some time ago to use MySQL as the backend instead of DBFs and uses the 3-tier (UI/BizObj/DataObj) design, so I'm confident it'll be easy to work on. (Knock on wood!) I'm sure some of you have gone back into your archives and felt good about some apps you've designed long ago. Just wanted to share the moment/feeling. ;-) [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/007101d5caf5$037f2480$0a7d6d80$@tpcqpc.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: Hacker's Guide, Section 4, now live on github.io!
+1 I prefer to spend my time on the concept of "craftsmanship" and get better at the languages I already know instead of learning new languages. Probably not the way to stay current, but crafting better code gives me great pleasure and satisfaction. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Monday, December 30, 2019 3:15 PM To: profoxt...@leafe.com Subject: Re: Hacker's Guide, Section 4, now live on github.io! On 12/30/2019 4:01 PM, Ted Roche wrote: > Not from me, I'm afraid. While I dabble in Python, making lights blink > with one of the Raspberry Pi's, I've never gotten beyond duffer stage. Admittedly, I think one of the negatives of getting older is that my attitude towards learning all kinds of new stuff is becoming tired and less enthused. My current Corporate gig is that of a Business Analyst and I'm good with that. Our Java developers here are all younger than me. They're learning Angular now for a new project we're undertaking. I just don't seem to have that same energetic "zeal" that I used to have years ago for learning new stuff. I would suspect I'm not the only one in this group feeling that way as the years go on. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/059a01d5c195$becc5e10$3c651a30$@tpcqpc.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: T'was the Night Before Crisis...
And to you as well! Merry Christmas, Y'all! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Monday, December 23, 2019 6:06 AM To: profoxt...@leafe.com Subject: T'was the Night Before Crisis... 'Twas the night before crisis, and all through the house, Not a program was working, not even a browse. The programmers were wrung out, too mindless to care, Knowing chances of shipping hadn't a prayer. The users were nestled all snug in their beds, While visions of inquiries danced in their heads. When out in the lobby there arose such a clatter, That I sprang from my cube to see what was the matter. And what to my wondering eyes should appear, But a SUPER PROGRAMMER, oblivious to fear. More rapid than eagles, his programs they came, And he whistled and shouted and called them by name: On Update! On Add! On Inquiry! On Delete! On Batch Jobs! On Closing! On Functions Complete! His eyes were glazed over, his fingers were lean, >From weekends and nights in front of the screen. A wink of his eye, and a twist of his head, Soon gave me to know I had nothing to dread. He spoke not a word, but went straight to his work, Turning specs into code, then he turned with a jerk. And laying his finger on the ENTER key, The system came up, and worked perfectly. The updates, updated; the deletes, they deleted; The inquiries, inquired; and the closing completed. He tested each whistle, he tested each bell, With nary an abend, and all had gone well. The system was finished, the tests were concluded, The client's last changes were even included! And the client exclaimed with a snarl and a taunt, "It's just what I asked for, but NOT what I want" (attributed variously, my copy came from here[1]) [1] http://www.mdarwin.ca/humour/night-before-xmas/night-before-crisis.phtml Merry Christmas, happy Hanukkah, happy Kwanzaa, festive Festivius, salubrious Solstice, happy Saturnalia and so forth to all!-- - - Ted --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/006501d5bad5$c3b001f0$4b1005d0$@tpcqpc.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: [NF] TeamViewer alternatives
I did some minimal testing with BitWarden when LogMeIn increased the LastPass annual subscription. Honestly, I did not really give it a complete and fair test because I didn't want to uninstall LastPass on my main computer and depend solely on BitWarden for the time it would take for me to properly review it. It seemed to work in a similar fashion but for some reason, I remember thinking it wasn't quite as user friendly as LastPass, but for the life of me I can't remember anything specific which made me think that. However, the ability to easily transfer all your existing logins from LastPass to BitWarden was very cool and definitely made me consider it as a possible alternative to LastPass. If the new owners do something crazy, I'll be going back to BitWarden first to do a more detailed review. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Thursday, December 19, 2019 1:41 PM To: profoxt...@leafe.com Subject: Re: [NF] TeamViewer alternatives On Thu, Dec 19, 2019 at 10:39 AM Eric Selje wrote: > I'm holding off until LastPass' new owners deem it worth moving, but we're > eyeballing https://bitwarden.com/ as an alternative. > > Added to the list. I'll check it out. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/015101d5b6ae$fd599950$f80ccbf0$@tpcqpc.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: [NF] TeamViewer alternatives
HmmmI thought that was what I said... > Actually, the company buying LassPass, Francisco Partners, is an investor in Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Christof Wollenhaupt Sent: Thursday, December 19, 2019 9:04 AM To: profoxt...@leafe.com Subject: Re: [NF] TeamViewer alternatives > Actually, the company buying LassPass, Francisco Partners, is an investor in > or owner of the following companies: Bomgar, Legal Zoom, Comodo, LogMeIn, > SonicWall, WatchGuard and many more. Francisco Partners is buying LogMeIn. LastPass already had been sold to LogMeIn four years ago. -- Christof --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00a101d5b681$1de65b50$59b311f0$@tpcqpc.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: [NF] TeamViewer alternatives
Actually, the company buying LassPass, Francisco Partners, is an investor in or owner of the following companies: Bomgar, Legal Zoom, Comodo, LogMeIn, SonicWall, WatchGuard and many more. I think I'm going to wait and see what they do with LassPass before jumping. I almost jumped when LogMeIn bought the company and doubled the subscription, but the service was still good for the price. It's up to Francisco Partners next move right now. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Thursday, December 19, 2019 8:41 AM To: profoxt...@leafe.com Subject: Re: [NF] TeamViewer alternatives On Thu, Dec 19, 2019 at 5:33 AM AndyHC wrote: > https://www.theregister.co.uk/2019/12/18/log_me_in_acquired/ Headline: Log us out: Private equity snaffles Lastpass owner LogMeIn subhead: World+dog hunts for new password manager Love their headline editor. LastPass! Darn! Just when I have successfully integrated hundreds of passwords, secret account numbers, etc, and got it working on Ubuntu, Chromebook, Fedora, Windows and Android. 2-Factor Authentication and all. Time to start shopping for a new one. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/007901d5b67d$0506da00$0f148e00$@tpcqpc.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: [NF] TeamViewer alternatives
Steve, I switched from GoToMyPC (price doubled after the company was sold) to Splashtop for remote access to my office computers and I couldn't be happier. I haven't used their remote support tools as I'm still using GoToAssist, but if the cost of my license for this jumps as well I'll be looking. Are you using the Splashtop SOS tools? Do you have a lot of unattended computers setup? Thanks! PS: For emergencies there is always AnyDesk.com Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of CCTbySteveGraves Sent: Tuesday, December 17, 2019 10:18 AM To: profoxt...@leafe.com Subject: Re: [NF] TeamViewer alternatives I'm pretty pleased with Splashtop ( Which I learned about on this list) .. Steve in central Florida On Tue, Dec 17, 2019, 10:38 AM Jürgen Wondzinski wrote: > Hi Mike, > > Same problems with TeamViewer at my side. Nozt only got it very expensive, > the product grew to a moloch with lots of useless features (at least for > me). > > I'm now using www.AnyDesk.com, which is much less expensive, less > cluttered and just works. > > wOOdy > > > -Ursprüngliche Nachricht- > Von: ProFox Im Auftrag von MB Software > Solutions, LLC > Gesendet: Dienstag, 17. Dezember 2019 15:52 > An: ProFox Email List > Betreff: [NF] TeamViewer alternatives > > I bought a TeamViewer (TV) license a few years back and it's the purchased > one-and-done lifetime license. TeamViewer's business model has changed and > they've been pushing annual licenses now for over a year. I like my TV > license and it works great for me; I don't see the need to upgrade to the > latest. That said, I wondered if others are using another tool they enjoy > and isn't expensive. Prior to TV, I used to use LogMeIn (LMI) but then > their licensing prices went up too. > > What's your current remote support tool of choice (other than UltraVNC > etc. I wasn't a fan of VNC as YES, IT WORKED, but it wasn't as easy and > user-friendly as TV or LMI. My clients on the other end of the support > connection are NOT tech folks. I needed it to be super simple and that's > what TV/LMI gave me. > > tia, > --Mike > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00be01d5b503$df031c30$9d095490$@tpcqpc.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: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)
Dang it! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Thursday, November 21, 2019 7:24 PM To: profoxt...@leafe.com Subject: RE: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command) Hi Paul, You missed Eric's SWFox presentation. You can have VFP 9 SP 2, VFP Advanced, and VFP Advanced 64bit running on the same machine. Eric didn't say you needed to change anything. Here did have both VFP 9 and Advanced running at the same time. Tracy On November 21, 2019 5:09:27 PM EST, "Paul H. Tarver" wrote: >This is going to seem like a stupid question I'm sure but is there a >way to >run VFPA (either 32 or 64 bit) in parallel with VFP9? > >I'd like to test, but I don't want to mess up my existing development >environment. Some of the readme files seem to indicate the answer is >no. > >Paul H. Tarver > > >-Original Message- >From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Eric >Selje >Sent: Thursday, November 21, 2019 3:35 PM >To: profoxt...@leafe.com >Subject: Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE >command) > >The Microsoft of 20 years ago probably would have complained, but >they're a >different company now. Their take is basically "If you want to modify >the >copy of VFP that you paid for, go for it." > >VERSION() either returns 10, or not. Almost all of the changes he >implemented can be turned off with settings for maximum backwards >compatibility. > >On Thu, Nov 21, 2019 at 2:07 PM MB Software Solutions, LLC < >mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > >> On 11/21/2019 2:54 PM, Eric Selje wrote: >> > VFP 10 (or VFP Advanced) is a copy of your licensed copy of VFP9, >with >> some >> > binary patches to fix bugs and add features. There's *also* a >64-bit >> > version. >> > >> > Yes, I use it every day, along with 1000's of others. My opinion is >that >> > there's no reason every VFP developer should not. >> > >> > Eric >> >> >> I was surprised that M$ didn't send out a "cease and desist" or some >> such action for it. Morally and ethically, there's nothing wrong >with >> it from what I can tell, but you recall the HUGE STINK they put up >when >> Whil Hentzen was going to show VFP running on WINE. I can't see the >> harm in that either, for that matter. If that increases M$'s VFP >sales, >> GREAT! (Yes, that's laughable to say...cue the quote by BG about >every >> time VFP was sold, they lost $20,000 or something on SQL Server >sales.) >> >> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/008101d5a15a$80f33a10$82d9ae30$@tpcqpc.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: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)
Actually, I have a virtual machine I could do that on, I was just thinking it would be easier to do side-by-side comparisons. One thing is certain, doing the first install on a virtual machine is definitely probably the way to start as the instructions are a bit vague. :) Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Thursday, November 21, 2019 5:05 PM To: profoxt...@leafe.com Subject: Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command) On 11/21/2019 5:09 PM, Paul H. Tarver wrote: > This is going to seem like a stupid question I'm sure but is there a way to > run VFPA (either 32 or 64 bit) in parallel with VFP9? > > I'd like to test, but I don't want to mess up my existing development > environment. Some of the readme files seem to indicate the answer is no. > > Paul H. Tarver Time for that 2nd laptop (Or Virtual Machine), Paul. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/008201d5a15a$810402f0$830c08d0$@tpcqpc.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: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command)
This is going to seem like a stupid question I'm sure but is there a way to run VFPA (either 32 or 64 bit) in parallel with VFP9? I'd like to test, but I don't want to mess up my existing development environment. Some of the readme files seem to indicate the answer is no. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Eric Selje Sent: Thursday, November 21, 2019 3:35 PM To: profoxt...@leafe.com Subject: Re: VFP Advanced (was Fwd: RE: Fatal error issuing CALCULATE command) The Microsoft of 20 years ago probably would have complained, but they're a different company now. Their take is basically "If you want to modify the copy of VFP that you paid for, go for it." VERSION() either returns 10, or not. Almost all of the changes he implemented can be turned off with settings for maximum backwards compatibility. On Thu, Nov 21, 2019 at 2:07 PM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 11/21/2019 2:54 PM, Eric Selje wrote: > > VFP 10 (or VFP Advanced) is a copy of your licensed copy of VFP9, with > some > > binary patches to fix bugs and add features. There's *also* a 64-bit > > version. > > > > Yes, I use it every day, along with 1000's of others. My opinion is that > > there's no reason every VFP developer should not. > > > > Eric > > > I was surprised that M$ didn't send out a "cease and desist" or some > such action for it. Morally and ethically, there's nothing wrong with > it from what I can tell, but you recall the HUGE STINK they put up when > Whil Hentzen was going to show VFP running on WINE. I can't see the > harm in that either, for that matter. If that increases M$'s VFP sales, > GREAT! (Yes, that's laughable to say...cue the quote by BG about every > time VFP was sold, they lost $20,000 or something on SQL Server sales.) > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/012201d5a0b8$57a49c50$06edd4f0$@tpcqpc.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: File Sync
I still use SyncToy: https://www.microsoft.com/en-us/download/details.aspx?id=15155 Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis Sent: Wednesday, November 20, 2019 9:39 AM To: profoxt...@leafe.com Subject: File Sync Can anyone recommend a free and simple file syncing program to mirror a folder on a server to a local folder (files and subfolders). I had been using freefilesync / robocopy but struggling with both of these on one particular computer and want to try another such utility to see if it gives me a better idea of what the issue is. Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/002601d59fbc$2b464070$81d2c150$@tpcqpc.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: Will Visual FoxPro run on Windows 10's successor?
I think I saw on the internet where Abraham Lincoln said that too. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Sunday, October 20, 2019 10:38 AM To: profoxt...@leafe.com Subject: Re: Will Visual FoxPro run on Windows 10's successor? On Sun, Oct 20, 2019 at 7:12 AM wes.wil...@yahoo.com wrote: > >From the internet: > I've heard that you can't believe everything you read on the internet. I don't know, but some people are saying. We'll see. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/004201d58815$96ab09e0$c4011da0$@tpcqpc.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 server connection
Peter, Personally, I like SPT because I can build valid and safe pass-through commands in my code based on user selections, generate the string, hand it off to the server with an ASYNCH connection and easily provide users with progress feedback while data is returned. For some reason, I've never been able to wrap my head around cursor adapters completely. Maybe it’s a control issue! :) I think SPT just made more sense to me upfront. Thankfully, Foxpro gives you plenty of different ways to accomplish the same things and you can pick the one that works the way you do! I use it to query data for reporting purposes and it gives me a lot of control over how I construct the query string since I can use all of the string functions within Foxpro to build exactly the query I want based upon users' selections. Another advantage is I able to dump the query string to my audit files just before the SQLEXEC() command fires, so if something goes wrong, I can just copy the query to my SQL management tool and see if I can manually figure out what is going on. So far, I've used SPT successfully to backend Foxpro with SQL, MySQL, Oracle, Access, PostgreSQL, SQLite, etc. I just tweak queries to customize for the database and the rest of my code remains the same. It works for me, but I'm sure, someone else here will provide you with the benefits of cursor adapters. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter Cushing Sent: Tuesday, August 20, 2019 4:40 AM To: profoxt...@leafe.com Subject: SQL server connection Hi, After running my app (VFP 9) on our local network (with a DBC) for many years, we are upgrading it (in stages) to a visual studio app with SQL server back end. I have read many people here talking about using SQL as a back end. At the beginning I will just be accessing the SQL data for reporting purposes but may need to write to it at some point. Looking through the archives some people mentioned SPT and others cursor adapters. Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, -- Peter Cushing IT Department WHISPERING SMITH This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. 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. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 [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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/006501d55761$2dfc4790$89f4d6b0$@tpcqpc.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: So how many classes in a VCX is *too* many ...
Holy cow! That makes mine look positively paltry by comparison! I gotta get to work! LOL! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, August 20, 2019 4:35 AM To: profoxt...@leafe.com Subject: So how many classes in a VCX is *too* many ... https://ibb.co/QPfg68f -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/005b01d5575e$66f2fb00$34d8f100$@tpcqpc.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: Happy Anniversary!
The Who also sang: "And pray We don't get fooled again Don't get fooled again No, no! Yeah! Meet the new boss Same as the old boss" Maybe they seeing the future with Microsoft or Google or Amazon or a boss we haven't met yet? (he said with his tongue firmly in cheek...) Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Malcolm Greene Sent: Monday, August 19, 2019 11:03 AM To: profoxt...@leafe.com Subject: Re: Happy Anniversary! I came for the language and stayed for the community. To paraphrase the Who: FoxPro is dead, long live Profox! Thank you Ed! Malcolm [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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/001a01d556c1$e0e29440$a2a7bcc0$@tpcqpc.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: Happy Anniversary!
So glad we have this resource! Thank you! Thank You! THANK YOU! We appreciate all you do! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe Sent: Saturday, August 17, 2019 9:36 AM To: profoxt...@leafe.com Subject: Happy Anniversary! OK, it's a bit late, but it just occurred to me that we just passed the 20th anniversary of the ProFox list! I posted the first message on July 22, 1999. So break out the bubbly! https://leafe.com/archives/msg/1 -- Ed Leafe [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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00fc01d556a3$96e5acb0$c4b10610$@tpcqpc.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.
Using Chilkat Tools with VFP
All, I have a project in the prelim stages which will require automating a process to pull various files from API's using SOAP and then storing the results via ODBC to a SQL database. I'm looking at purchasing the Chilkat toolkit to help me with some of the XML and web connectivity that will be required. I know Tracy Pearson has posted positive comments about Chilkat and I reviewed prior messages posted here on the ProFox list and I'm feeling fairly confident it will provide what I need. However, I'd like some folks to provide their thoughts about the ease of implementation, distribution and maintenance of the library at the client level. I saw a couple of comments about unlock codes not working, etc and I just thought some additional information about the practical aspects of using Chilkat would be helpful. Thanks in advance! Paul H. Tarver --- 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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/004001d54c68$dd508890$97f199b0$@tpcqpc.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: Figured out how I was getting around that Page.Init "bug" not working as expected in my subclass
The older I get, the more disciplined I become at commenting. I cannot tell you how many times I have cursed my younger self for not doing more of that when he wrote the original code! My younger self was a pretty good programmer but alas he was lazy and stupid. :) Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Thursday, July 11, 2019 11:18 AM To: profoxt...@leafe.com Subject: Re: Figured out how I was getting around that Page.Init "bug" not working as expected in my subclass At 08:43 2019-07-10, "MB Software Solutions, LLC" wrote: >2 things: 1. thankfully I had source code backups 2. I'm very glad I >documented (commented) it well with my datestamp too. I always code >to help me later down the road when I lose my mind. I try to comment appropriately, but sometimes, I miss putting down what ends up being a critically missing detail years later. If my code were less reliable, then maybe, I would have looked at it sooner and would be more familiar with it for when I finally have to change it. The "Set it and forget it." mentality does have the problem of "forget it". [snip] Sincerely, Gene Wirchenko [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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/010c01d53805$69267e60$3b737b20$@tpcqpc.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: LOCATE Backwards?
If you are using VFP9, why won't a SELECT statement work? Something like: SELECT TOP 1 * FROM table WHERE condition ORDER BY key DESC INTO CURSOR tmp Just make sure you create index(es) on the condition field(s) so Rushmore will kick in and it should give you a reverse order cursor with all the matching values in a flash. Is there a reason you want to use LOCATE instead? Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Wednesday, July 03, 2019 11:47 AM To: profoxt...@leafe.com Subject: LOCATE Backwards? Hello: I have a situation in my app where I am having to pick up what will presumably be the last row in a table. Mind you, the general situation is that it might not be if in a multiuser situation. With the current situation, I can use an index to find that row really fast. BUT ... What if an index is not appropriate? Is there any way to do a LOCATE backwards (or something equivalent)? (The table has 186,574 rows currently so searching backwards would definitely be worth it.) I do not think there is such a critter, but maybe, you know better? Sincerely, Gene Wirchenko [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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00d401d531d2$a24ee3f0$e6ecabd0$@tpcqpc.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: Remote FoxPro Work???
+1 I am still developing and supporting VFP6.0 and VFP9.0 apps daily for my very narrow market. After having done extensive testing on multiple development tools over the last six years, I can definitively say there is nothing I can't do for my clients in my particular market and do it faster with shorter development times. Just look at the issue today that Ricardo and Ted helped to solve for me today. Even when I cannot describe what I'm trying to do to Google or Bing, I describe it here and lo and behold, Ricardo tosses out the perfect command that has been there all along but I've never needed it before. I guess what I'm saying is don't give up on finding the perfect job to fit your knowledge. You may have to settle in the short term, but don't quit looking! I'm sure that everyone on this group will keep you top of mind and let you know if we hear of anything! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Koen Piller Sent: Tuesday, July 02, 2019 8:40 PM To: profoxt...@leafe.com Subject: Re: Remote FoxPro Work??? Kurt, I donot agree with you on this. When I say 'a modern Win10 appilication' I just mean an application built with VFP9SP2 with some modern UI - like FoxyRibbon, FoxyPreviewer etc. This is for the endusers already an immazing improvement when you have worked with a FoX2.2 built application. Sure if you can manage to learn quickly, and realy it is not so difficult, to manage FoxInTheCLoud you can also built a more modern app which runs on your Smartphone. But tht should be step 2. Think about it, Koen Op di 2 jul. 2019 om 21:20 schreef Kurt at VR-FX : > Hey Koen - I TOTALLY Appreciate the input. Problem is - I can't convert > a VFP app to a Modern Win10 app - since, I don't have any experience > w/tech that would allow me to do exactly that. Sure - I know FoxInCloud > has a kind of conversion utility to do something like that, but, alas - > I don't have any experience with that either! > > Since we're on the topic... > > I have a buddy of mine who has been DEMANDING that I get onto the > SalesForce bandwagon. Seems there is a HUGE Demand out there it. And, > supposedly - its Stupid easy to learn. Am curious if any folks here work > with it!?!? > > Of course, might be best NOT to bury that Q in this thread - and post it > as a New thread. Hmmm... > > -K- > > On 7/2/2019 4:47 PM, Koen Piller wrote: > > Kurt > > My advise: throw a website together in which you advertise your skills. > > Donot prompte Foxpro but do promote you can convert old fashioned DOS > apps > > (VFP 2.2, Clipper and the like ) to a Win10 app. > > Lots lots of these old programs still running around seeking for a modern > > upgrade > > Koen > > > > Op di 2 jul. 2019 om 17:56 schreef Kurt at VR-FX > > > >> Yeah - I know - these days - that's a pretty crazy request. > >> > >> I know some of you have followed me a bit - and know I lost my job in > >> Nov 2017 - where I was working down on Wall Street. Then, moved to Cali > >> to look for a job - could NOT find work in San Francisco. Even applied > >> to UCLA for a programming job - did 2 rounds of interviews - and the > >> people there saying they were impressed with me - during both > >> interviews. Only to NOT get the job. Then, finally, getting a "job" down > >> here in San Diego. Actually getting to do 3D Design work for clients, as > >> well as running 3D Printing jobs. But, sadly - its SUCKING! Its not a > >> regular job - not salaried - not even part time pay. Its contractor pay > >> - per job - and it does NOT pay well enough. Been here for over 9 weeks > >> now - and its again put me in a BAD financial situation... > >> > >> So - as a total "shot in the dark" - I figured I would post here again > >> and see if there is any possible remote FoxPro work. > >> > >> And, I know - almost no companies these days are still working w/VFP. > >> And, sure, I know it would be better to work in some other newer more > >> modern tech. - but, I don't have any of those tools in my tool belt. So > >> - all I really have is VFP & MS SQL. > >> > >> Anyway - just figured I would take a stab and post here... > >> > >> Regards -Kurt > >> > >> [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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/013b01d5314a$59ca51b0$0d5ef510$@tpcqpc.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: Reverse Wildcard String Comparison
I've made the comment to this group before: Almost day I learn something new
that Foxpro can do that changes the way I work. I use this tool everyday and
I kid you not, the joke in my office is when I yell out, "I learned my new
Foxpro trick for the day!"
Thank you Ricardo! Your tip put me exactly where I wanted to be and with a
few modifications, I have a SQL Select statement that not only solves my
problem, but it is screaming fast and will work going forward.
My final query looks like this:
SELECT dz.* ;
FROM Xref_deptzips dz ;
WHERE LIKE(dz.dept, NVL(tmpEmpWork.deptcode,SPACE(20))) ;
INTO CURSOR tmpWork
The NVL is necessary because I'm scanning through a sub-query and the
space(20) simply ensures that the NVL failure value is exactly the same
length as the dz.dept field. Once I got all the fields to the same length it
started working perfectly.
Thanks so much for giving me the clue I needed to get out of the corner I
was in! I appreciate it!
Love this group!
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ricardo
Molina
Sent: Tuesday, July 02, 2019 5:12 PM
To: profoxt...@leafe.com
Subject: Re: Reverse Wildcard String Comparison
There's no need for a UDF, VFP has a built-in function LIKE().
Create Cursor depts ( deptnum c(3), Descript c(10), Value i)
Insert Into depts ( deptnum, Descript, Value) Values ( "1??", "Dept 1",
99930)
Insert Into depts ( deptnum, Descript, Value) Values ( "2??", "Dept 2",
92382)
Insert Into depts ( deptnum, Descript, Value) Values ( "3??", "Dept 3",
83728)
Insert Into depts ( deptnum, Descript, Value) Values ( "?4?", "Dept 4",
27377)
Create Cursor employees ( empref c(10), empname c(20), deptnum c(3))
Insert Into employees (empref, empname, deptnum) Values ("001", "Jack",
"141")
Select employees.*, depts.Value From employees Left Join depts On
Like(depts.deptnum, employees.deptnum)
Ricardo
On Tue, 2 Jul 2019 at 18:29, Ted Roche wrote:
> Requisite snarky comment: if a join depends on only _part_ of the value of
> another field, the data is not normalized.
>
> Are the DeptNum fields really literally question marks and digits, as if
> they were wildcards?
>
> If so, you could write some UDF to convert DOS wildcards of * and? to SQL
> wildcards of % and _
>
> It's a bit unholy but it ought to get the job done:
>
> SELECT Employee.*, Dept.* from Employee JOIN Dept ON Employee.Dept LIKE
> MyUDF(Dept.DeptNum)
>
>
>
> On Tue, Jul 2, 2019 at 12:57 PM Paul H. Tarver wrote:
>
> > Ok, I need a little help and here's the scenario:
> >
> >
> >
> > I have an x-ref table that looks like this:
> >
> >
> >
> > DeptNum, Description, Value
> >
> > 1??, Dept 1, 99930
> >
> > 2??, Dept 2, 92382
> >
> > 3??, Dept 3, 83728
> >
> > ?4?, Dept 4, 27377
> >
> >
> >
> > Next, I have a data table with thousands of employees with department
> > numbers I want to scan through. If the employee's dept # is 101, then in
> > the
> > fastest way possible, I want to compare 101 to the DeptNum in the x-ref
> > table and return the value 99930. If the employee's dept # is 141, then
> the
> > search should return both 99930 and 27377 and I'll perform some logic to
> > determine which value is most important.
> >
> >
> >
> > I know I can do SELECT queries using the LIKE statement such as Select *
> > from x-ref where x-ref.DeptNum LIKE "1%", but in this case, I know the
> > explicit value and I need to compare it to the masked values in the
x-ref
> > table. So I really need to the reverse which would be Select * from
x-ref
> > where "1%" LIKE x-ref.DeptNum (which doesn' t work, I know.). FYI, The
> > DeptNum field can be up to 20 characters long and I am guessing the
> masked
> > values could be as well.
> >
> >
> >
> > Unfortunately, I think I'm stuck mentally on doing this with a SQL Query
> > and
> > I'm not able to think outside of this box right now, so any suggestions
> > will
> > help. Hell, at this point, I'll take snarky comments, but only if they
> > contain clues to how I need to proceed. LOL
> >
> >
> >
> > Thanks in advance
> >
> >
> >
> > Paul H. Tarver
> >
> >
> >
> >
> >
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> > text/plain (text body -- kept)
> > text/html
> > ---
> >
[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: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/013a01d53149$732c3bb0$5984b310$@tpcqpc.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: Reverse Wildcard String Comparison
No snark implied or taken! The reason for this isn't about the source data as much about the destination data. We are pulling the data for use in another system and we are trying to populate a new field with content based upon similar source data. It will be normalized in the destination system. Problem is that we'll be pushing data to the new system on an on-going basis. Therefore, I'm trying to build a process that will work in all of the situations that might come up. I also was intrigued by the prospect of playing around with some "fuzzy logic." This process does not have to use a Select statement, I just thought that might be the fastest way rather than scanning through the x-ref table on every employee record. I did something similar with another client where they could enter a range of values into a field and then we expanded the range to an array to include every value in the range and did an ascan to test, but I was thinking there might be a better way. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, July 02, 2019 12:30 PM To: profoxt...@leafe.com Cc: profoxt...@leafe.com Subject: Re: Reverse Wildcard String Comparison Requisite snarky comment: if a join depends on only _part_ of the value of another field, the data is not normalized. Are the DeptNum fields really literally question marks and digits, as if they were wildcards? If so, you could write some UDF to convert DOS wildcards of * and? to SQL wildcards of % and _ It's a bit unholy but it ought to get the job done: SELECT Employee.*, Dept.* from Employee JOIN Dept ON Employee.Dept LIKE MyUDF(Dept.DeptNum) On Tue, Jul 2, 2019 at 12:57 PM Paul H. Tarver wrote: > Ok, I need a little help and here's the scenario: > > > > I have an x-ref table that looks like this: > > > > DeptNum, Description, Value > > 1??, Dept 1, 99930 > > 2??, Dept 2, 92382 > > 3??, Dept 3, 83728 > > ?4?, Dept 4, 27377 > > > > Next, I have a data table with thousands of employees with department > numbers I want to scan through. If the employee's dept # is 101, then in > the > fastest way possible, I want to compare 101 to the DeptNum in the x-ref > table and return the value 99930. If the employee's dept # is 141, then the > search should return both 99930 and 27377 and I'll perform some logic to > determine which value is most important. > > > > I know I can do SELECT queries using the LIKE statement such as Select * > from x-ref where x-ref.DeptNum LIKE "1%", but in this case, I know the > explicit value and I need to compare it to the masked values in the x-ref > table. So I really need to the reverse which would be Select * from x-ref > where "1%" LIKE x-ref.DeptNum (which doesn' t work, I know.). FYI, The > DeptNum field can be up to 20 characters long and I am guessing the masked > values could be as well. > > > > Unfortunately, I think I'm stuck mentally on doing this with a SQL Query > and > I'm not able to think outside of this box right now, so any suggestions > will > help. Hell, at this point, I'll take snarky comments, but only if they > contain clues to how I need to proceed. LOL > > > > Thanks in advance > > > > Paul H. Tarver > > > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/011101d53125$b3e44450$1bacccf0$@tpcqpc.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.
Reverse Wildcard String Comparison
Ok, I need a little help and here's the scenario: I have an x-ref table that looks like this: DeptNum, Description, Value 1??, Dept 1, 99930 2??, Dept 2, 92382 3??, Dept 3, 83728 ?4?, Dept 4, 27377 Next, I have a data table with thousands of employees with department numbers I want to scan through. If the employee's dept # is 101, then in the fastest way possible, I want to compare 101 to the DeptNum in the x-ref table and return the value 99930. If the employee's dept # is 141, then the search should return both 99930 and 27377 and I'll perform some logic to determine which value is most important. I know I can do SELECT queries using the LIKE statement such as Select * from x-ref where x-ref.DeptNum LIKE "1%", but in this case, I know the explicit value and I need to compare it to the masked values in the x-ref table. So I really need to the reverse which would be Select * from x-ref where "1%" LIKE x-ref.DeptNum (which doesn' t work, I know.). FYI, The DeptNum field can be up to 20 characters long and I am guessing the masked values could be as well. Unfortunately, I think I'm stuck mentally on doing this with a SQL Query and I'm not able to think outside of this box right now, so any suggestions will help. Hell, at this point, I'll take snarky comments, but only if they contain clues to how I need to proceed. LOL Thanks in advance Paul H. Tarver --- 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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/007901d530f7$27ca6a90$775f3fb0$@tpcqpc.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: [NF] What would you miss from VFP, when migrating
Thanks for the heads up, Frank. In this case, I do multiple validations and tests on the Thisform.CoCode.value which end processing on failures before it ever reaches the WHERE clause. One of the first tests we do is validate the user's selection of the CoCode against a table before we ever let processing begin. Then we do other validations before building the SQL command. My example was admittedly over-simplified. Thanks again! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Friday, June 28, 2019 12:13 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating To make your code safer, ensure you use parameters: m.CompanyID = ALLTRIM(thisform.CoCode.value) m.lcWhereClause = "WHERE emp.CpnyID = ?m.CompanyID" Frank. Frank Cazabon On 28/06/2019 11:14 AM, Paul H. Tarver wrote: > I've never doubted the benefits of stored procedures and if I were an > in-house programmer for a company with full admin rights and/or console > access to the SQL Servers, I would be tempted to always use stored > procedures myself. However, that is NOT the world I work in. My job is to > build interfaces to move data between different systems. I am usually > provided with READ-ONLY SQL credentials so I can then issue SELECT queries > to extract data and then use the results of those queries to create data > feeds into other systems. > > Our systems pull data in one direction only and when I describe dynamic SQL > statements I'm referring to something little like this (although most are > far more complicated queries with lots of moving parts): > > lcWhereClause = "WHERE emp.CpnyID = '" + > ALLTRIM(thisform.CoCode.value) > > TEXT TO lcSQLCmd TEXTMERGE NOSHOW > SELECT > CAST(emp.CpnyID AS CHAR(20)) AS compid, > CAST(emp.EmpId AS CHAR(20)) AS emplid, > emp.NameFirst as fname, > emp.NameMiddle as mname, > emp.NameLast as lname, > emp.StrtDate as hire_date > FROM dbo.Employee emp > <> > ENDTEXT > > lnStatus = SQLEXEC(lnSQLHandle, lcSQLCmd, "EmpList") > > We accept and validate the selection of the CoCode by the user and then we > construct the "dynamic query." I suspect your perception of a Dynamic Query > is greatly different than mine. The point of my original comment was to > praise the ease with which I can construct SQL statements in a TEXT/ENDTEXT > construct and I think this example shows that > > Thanks! > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen > Russell > Sent: Friday, June 28, 2019 9:27 AM > To: profoxt...@leafe.com > Subject: Re: [NF] What would you miss from VFP, when migrating > > I am backing off of licenses for SQL Enterprise down to Standard for 2/3 of > all my SQL Server usage in my new deployments. Use to have a total of 96 > cores running Ent. and now seeing if we can only use 30. Having virtual > guests instead of a single bad ass box makes this a lot easier to do. > > Dynamic SQL can burn you. > > https://www.cnet.com/news/sony-playstation-site-victim-of-sql-injection-atta > ck/ > > > Making a stored procedure is common sense. Why you cannot see the beauty > of it for long term source code is lost on me. Say you make a change to a > table. You can easily find every sproc that referenced that table with > this statement and miss all that you have fixed: > declare @text varchar(50) > , @stringtosearch varchar(100) > , @comment varchar(150) > > > set @text = 'Warehouse' > set @comment ='%WarehouseChange fixed%' > > SET @stringtosearch = '%' +@text + '%' > > SELECT Distinct SO.Name > FROM sysobjects SO (NOLOCK) > INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID > AND SO.Type = 'P' > AND SC.Text LIKE @stringtosearch > and SO.id not in > (select distinct SO1.ID > FROM sysobjects SO1 (NOLOCK) > INNER JOIN syscomments SC1 (NOLOCK) on SO1.Id = SC1.ID > AND SO1.Type = 'P' > AND SC1.Text LIKE @comment) > > ORDER BY SO.Name > > You can then cross reference every place that the table was used and see if > you need to tweak the data access to include the change you just made to > the column. > > We just got handed an oh by the way that hits a major focus on how we track > sales. We use to give all sales to the plant that made them, which makes > sense. Over time we have created warehouses in areas of the country to hold > product for delivery to a customer rich area. Su
RE: [NF] What would you miss from VFP, when migrating
I've never doubted the benefits of stored procedures and if I were an in-house programmer for a company with full admin rights and/or console access to the SQL Servers, I would be tempted to always use stored procedures myself. However, that is NOT the world I work in. My job is to build interfaces to move data between different systems. I am usually provided with READ-ONLY SQL credentials so I can then issue SELECT queries to extract data and then use the results of those queries to create data feeds into other systems. Our systems pull data in one direction only and when I describe dynamic SQL statements I'm referring to something little like this (although most are far more complicated queries with lots of moving parts): lcWhereClause = "WHERE emp.CpnyID = '" + ALLTRIM(thisform.CoCode.value) TEXT TO lcSQLCmd TEXTMERGE NOSHOW SELECT CAST(emp.CpnyID AS CHAR(20)) AS compid, CAST(emp.EmpId AS CHAR(20)) AS emplid, emp.NameFirst as fname, emp.NameMiddle as mname, emp.NameLast as lname, emp.StrtDate as hire_date FROM dbo.Employee emp <> ENDTEXT lnStatus = SQLEXEC(lnSQLHandle, lcSQLCmd, "EmpList") We accept and validate the selection of the CoCode by the user and then we construct the "dynamic query." I suspect your perception of a Dynamic Query is greatly different than mine. The point of my original comment was to praise the ease with which I can construct SQL statements in a TEXT/ENDTEXT construct and I think this example shows that Thanks! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Friday, June 28, 2019 9:27 AM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating I am backing off of licenses for SQL Enterprise down to Standard for 2/3 of all my SQL Server usage in my new deployments. Use to have a total of 96 cores running Ent. and now seeing if we can only use 30. Having virtual guests instead of a single bad ass box makes this a lot easier to do. Dynamic SQL can burn you. https://www.cnet.com/news/sony-playstation-site-victim-of-sql-injection-atta ck/ Making a stored procedure is common sense. Why you cannot see the beauty of it for long term source code is lost on me. Say you make a change to a table. You can easily find every sproc that referenced that table with this statement and miss all that you have fixed: declare @text varchar(50) , @stringtosearch varchar(100) , @comment varchar(150) set @text = 'Warehouse' set @comment ='%WarehouseChange fixed%' SET @stringtosearch = '%' +@text + '%' SELECT Distinct SO.Name FROM sysobjects SO (NOLOCK) INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID AND SO.Type = 'P' AND SC.Text LIKE @stringtosearch and SO.id not in (select distinct SO1.ID FROM sysobjects SO1 (NOLOCK) INNER JOIN syscomments SC1 (NOLOCK) on SO1.Id = SC1.ID AND SO1.Type = 'P' AND SC1.Text LIKE @comment) ORDER BY SO.Name You can then cross reference every place that the table was used and see if you need to tweak the data access to include the change you just made to the column. We just got handed an oh by the way that hits a major focus on how we track sales. We use to give all sales to the plant that made them, which makes sense. Over time we have created warehouses in areas of the country to hold product for delivery to a customer rich area. Sure the ERP already did this but the early reporting team never saw that value. All of these changes are only in our BI/reporting system or our customer portal. We have to identify over 1000 sprocs to validate that nothing needs to be done here and only 150 really need to be altered. How would you find that in your prgs? I use the power of the db engine to do a lot of things like this for me. On Thu, Jun 27, 2019 at 6:16 PM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 6/27/2019 6:39 PM, Paul H. Tarver wrote: > > Give me a little credit for being a better programmer than that. > > > C'mon, Paul -- it's mega-million$ $teve we're talking about here. Mr. > Deep Pockets with SQL Server blinders on usually with only Stored > Procedures being the only viable safe option. > > lol > > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [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: https://leafe.com/archives T
RE: [NF] What would you miss from VFP, when migrating
Only if I were trying to destroy my clients and my livelihood. Give me a little credit for being a better programmer than that. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, June 27, 2019 5:02 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating just put this into your textbox that gets passed back: 1=1 ; Drop table customers go On Thu, Jun 27, 2019 at 3:54 PM Paul H. Tarver wrote: > I meant "dynamic" in the sense of controlling variables in SELECT WHERE > statements. Didn't intent to scare anyone. > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Stephen > Russell > Sent: Thursday, June 27, 2019 3:17 PM > To: profoxt...@leafe.com > Subject: Re: [NF] What would you miss from VFP, when migrating > > As a dba that scares the shit out of me. Just being honest about dynamic > statements and hackers who might know how to mess with you. > > This fear is real. > > https://codecurmudgeon.com/wp/sql-injection-hall-of-shame/ > > > > On Thu, Jun 27, 2019 at 3:10 PM Paul H. Tarver wrote: > > > I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text > and > > dynamic variables, then pass the resulting string to SQLEXECUTE. Very > > convenient when creating large query strings. > > > > Paul H. Tarver > > > > > > -Original Message- > > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > > Stephen > > Russell > > Sent: Thursday, June 27, 2019 2:43 PM > > To: profoxt...@leafe.com > > Subject: Re: [NF] What would you miss from VFP, when migrating > > > > Am I missing something about TEXT/ENDTEXT where it just mashes up a > string > > for you for whatever transpires within the loop? > > > > What do you do with that output or the textmerge when you are done with > > it? > > > > On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < > > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > > > > > Steve Ellenoff and I were talking the other day about the beauty of > > > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet > (or > > > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > > > > > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > > > Hi VFPers > > > > > > > > I have asked this question on foxite too with very little feedback, > so > > > > I am asking it here too. > > > > > > > > If you have to summarize the 1 or 2 features of VFP that you will > feel > > > > is a step backwards when migrating to .NET or any other platform as a > > > > move forwards. > > > > > > > > Looking forward to your replies. > > > > > > > > Two things that was highlighted on Foxite: > > > > > > > > 1. Macro-compilation > > > > 2. Evaluate(
RE: [NF] What would you miss from VFP, when migrating
I meant "dynamic" in the sense of controlling variables in SELECT WHERE statements. Didn't intent to scare anyone. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, June 27, 2019 3:17 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating As a dba that scares the shit out of me. Just being honest about dynamic statements and hackers who might know how to mess with you. This fear is real. https://codecurmudgeon.com/wp/sql-injection-hall-of-shame/ On Thu, Jun 27, 2019 at 3:10 PM Paul H. Tarver wrote: > I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and > dynamic variables, then pass the resulting string to SQLEXECUTE. Very > convenient when creating large query strings. > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Stephen > Russell > Sent: Thursday, June 27, 2019 2:43 PM > To: profoxt...@leafe.com > Subject: Re: [NF] What would you miss from VFP, when migrating > > Am I missing something about TEXT/ENDTEXT where it just mashes up a string > for you for whatever transpires within the loop? > > What do you do with that output or the textmerge when you are done with > it? > > On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > > > Steve Ellenoff and I were talking the other day about the beauty of > > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or > > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > > Hi VFPers > > > > > > I have asked this question on foxite too with very little feedback, so > > > I am asking it here too. > > > > > > If you have to summarize the 1 or 2 features of VFP that you will feel > > > is a step backwards when migrating to .NET or any other platform as a > > > move forwards. > > > > > > Looking forward to your replies. > > > > > > Two things that was highlighted on Foxite: > > > > > > 1. Macro-compilation > > > 2. Evaluate(
RE: [NF] What would you miss from VFP, when migrating
I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and dynamic variables, then pass the resulting string to SQLEXECUTE. Very convenient when creating large query strings. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, June 27, 2019 2:43 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating Am I missing something about TEXT/ENDTEXT where it just mashes up a string for you for whatever transpires within the loop? What do you do with that output or the textmerge when you are done with it? On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Steve Ellenoff and I were talking the other day about the beauty of > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > Hi VFPers > > > > I have asked this question on foxite too with very little feedback, so > > I am asking it here too. > > > > If you have to summarize the 1 or 2 features of VFP that you will feel > > is a step backwards when migrating to .NET or any other platform as a > > move forwards. > > > > Looking forward to your replies. > > > > Two things that was highlighted on Foxite: > > > > 1. Macro-compilation > > 2. Evaluate(
RE: [NF] What would you miss from VFP, when migrating
+1 Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin Cully Sent: Thursday, June 27, 2019 12:25 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating The VFP Report Writer is amazing compared to other development tools I've seen, including my beloved Xojo. I've had to create my own report writer that spits out HTML based reports just to get me close to what VFP offered. Another language command is the SCATTER NAME and GATHER NAME. The ability to create an object with properties that corresponds to each field of a record is incredibly useful. Especially when combined with the TEXTMERGE command already stated earlier. -Kevin On 06/27/2019 08:51 AM, Johan Nel wrote: > Hi VFPers > > I have asked this question on foxite too with very little feedback, so > I am asking it here too. > > If you have to summarize the 1 or 2 features of VFP that you will feel > is a step backwards when migrating to .NET or any other platform as a > move forwards. > > Looking forward to your replies. > > Two things that was highlighted on Foxite: > > 1. Macro-compilation > 2. Evaluate(
RE: [NF] What would you miss from VFP, when migrating
I would greatly miss the speedy import capabilities of Foxpro and the CREATE CURSOR to build temporary files to temporarily hold imported data. I also make extensive use of Class Libraries. More and more I'm using of creating Empty Objects and adding properties to store and manage lots of variables including making it possible to pass a single reference to the object as a parameter and making all of the properties available to other modules. And I agree 100% with wanting to keep the TEXTMERGE feature. I think I could do this all day and because it seems I'm still learning new ways to use VFP commands and features, I think I fear losing any of them! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Johan Nel Sent: Thursday, June 27, 2019 7:52 AM To: profoxt...@leafe.com Subject: [NF] What would you miss from VFP, when migrating Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
RE: Using FoxPro & ODBC to connect to Progress Database
UPDATE! Since I didn't get any responses to my original post, I thought I'd at least provide an update on this project. At the end of last week, I was able to establish an ODBC DNS-less connection to a self-hosted Progress Database across a VPN from within Foxpro, issue queries and obtain and process the results. Woohoo! Turns out the biggest difference on Progress will be the syntax of the SQL which seems to be pretty rigid T-SQL. And, the only type of connection I can made to the database is via ODBC. Because the Progress ODBC drivers are 32bit, I was unable to use Microsoft SQL Studio 64bit software to create a linked database connection to query the database, so I downloaded an free-ware tool called ODBC Query Tool (https://sourceforge.net/projects/odbc-query-tool/) which has a 32bit and a 64bit bit version software package designed to connect to any database via ODBC. It provides a browse table feature and a simple pass-through query feature to allow users to build queries. Once I got a VPN connection and could ping the database from an ODBC System DSN, I then was able to issue a simple query through the ODBC Query Tool. Next, I set about putting together the connection string for the DSN-less connection from VFP. The Progress DSN-less connection string is constructed like this: DRIVER=;HOST=;PORT=;DB=;UID=;PWD=;DIL= All of the settings are self-explanatory except DIL which supports the has following values: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE However if you want more information you can find it here: https://knowledgebase.progress.com/articles/Article/P97292 If you want to learn more about the architecture of the Progress Database system, you should check out this manual: https://waterfund.go.ke/watersource/Downloads/Progress%20Database%20Administ ration.pdf Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H. Tarver Sent: Monday, June 10, 2019 4:12 PM To: profoxt...@leafe.com Subject: Using FoxPro & ODBC to connect to Progress Database Finally, I have something new and maybe interesting to throw at y'all! Got a potential client I'm doing some prelim work for to determine if we can establish an ODBC connection to a Progress Database. I'm just now trying to install all the ODBC drivers and extras the Progress client requires. However, I wondered if anyone on this group had ever connected Foxpro to Progress and if so, what pitfalls can you help me avoid? I'm told by the client that they use SQL Management Studio and then connect to the Progress database via Linked Databases which forces the use of an ODBC DSN. My goal would be to use this to browse the tables and build my test queries and then use SQL Pass-Through via a DSN-Less ODBC connection to query data in production. I've accomplished similar processes by connecting Foxpro to SQL, MySQL, PostgreSQL, FirebirdSQL, Oracle, Sybase, SQLite and Access. I've ODBC'd my way into a bunch of databases, but I've never worked with Progress. Any tips, suggestions or recommendations? Thanks in advance! Paul H. Tarver --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/008701d52b69$32ac49d0$9804dd70$@tpcqpc.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.
