Re: Textbox in grid column.... When is cursor updated?

2017-09-27 Thread mbsoftwaresolutions
On 2017-09-25 10:55, Matt Slay wrote: Textbox in grid column question When is the value entered in a textbox in a grid column applied to the underlying bound cursor relative to the firing of the grid.AfterRowColChange() when user hits tab to move to the next column? Here is the situation I

RE: [NF]Debugging Pain Survey

2017-09-27 Thread mbsoftwaresolutions
On 2017-09-26 10:59, Dave Crozier wrote: The one that bites everyone: The difference between what you see . and what you THINK you see! "Well it works fine on my machine." ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Create PDF from FoxPro report with selectable text...

2017-09-27 Thread mbsoftwaresolutions
On 2017-09-27 19:45, Matt Slay wrote: I'm printing a FoxPro FRX to a PDF file using Adobe PDF printer driver from Adobe Acrobat (VFP9 SP2, Windows 10). Printing to the PDF works fine, but the text inside the generated PDF is not selectable text. It seems more like a rendered raster image. My

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-09-19 Thread mbsoftwaresolutions
On 2017-09-19 08:45, Roger Tremblay wrote: You can try TEAMVIEWER its free for casual use and it's easy to install, you can remote in from anywhere. This is for connecting to her business machine, though, so not really personal use (depending on your interpretation).

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-09-19 Thread mbsoftwaresolutions
On 2017-09-19 07:35, Richard Kaye wrote: Several of my clients have settled on Splashtop as an LMI replacement - Yep...my colleague uses Splashtop for his clients too. ___ Post Messages to: ProFox@leafe.com Subscription

Re: [NF] Suggestions: job boards, listings, contacts? for Senior Technical Writer

2017-09-19 Thread mbsoftwaresolutions
On 2017-09-19 15:42, Ted Roche wrote: Slightly off-topic, your indulgence please. A friend of a friend finds themselves at the end of 30+ year career in a need of a new position. Highly skilled technical writer, worked in several of the well known high-tech firms. Needs a new placement,

[NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-09-18 Thread mbsoftwaresolutions
Customer is a small business and NOT tech savvy at all (so don't suggest "UltraVNC configured oh so cool!"). I warned her you get what you pay for many times, but said I'd research it. I use TeamViewer and it's great for me but overkill for her. TV has a free license but the wording appears

Re: [OT] Spent the past 4 days in London...and loved it!!!!

2017-09-13 Thread mbsoftwaresolutions
On 2017-09-13 06:52, Jean Laeremans wrote: Nah that's just an alternative truth. https://www.youtube.com/watch?v=_SuhRiO1_bg LOL ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

RE: [OT] Spent the past 4 days in London...and loved it!!!!

2017-09-12 Thread mbsoftwaresolutions
On 2017-09-11 05:08, Dave Crozier wrote: 200 miles away from London here in Manchester Mike. Sorry about the rain ... but at least it hasn't been as bad as what they are getting in Florida etc. Dave Actually, for the time we were there, it only rained a short while, and usually

Re: Janis Booth, RIP

2017-09-12 Thread mbsoftwaresolutions
On 2017-09-12 09:00, Ted Roche wrote: I'm sad to pass on news that Janis Booth has passed away. Janis may be more familiar to you as "Jim" during her active FoxPro career. She was 66. Janis was a 2013 winner of the FoxPro Lifetime Achievement Award [1], a Microsoft MVP 1993-2003, a key member

[OT] Spent the past 4 days in London...and loved it!!!!

2017-09-11 Thread mbsoftwaresolutions
First visit for my wife and me. Loved it! Went on several tours and visited with some cousins of hers from Norwich. Would definitely come back for another visit...we'd even more over here. We were impressed...and the prices weren't too bad. Any ProFoxers from the Norwich or surrounding

Re: [NF] Re: [FW] Programming language life expectancy

2017-09-01 Thread mbsoftwaresolutions
On 2017-09-01 13:04, Laurie Alvey wrote: Didn't everyone at least dabble with BASIC? I started out with a Commodore VIC20 which (I believe), had 3.2 kB of RAM. Oh yes. My first was GW-BASIC on our AT home computer. 10 PRINT "Hello" 20 GOTO 10 :-)

RE: [NF] Re: [FW] Programming language life expectancy

2017-09-01 Thread mbsoftwaresolutions
On 2017-09-01 03:31, Dave Crozier wrote: Brilliant ingenuity! I started on Fortran, Algol 60 and COBOL but only liked Algol and went on to love Pascal obviously. Loved loved loved Pascal way back in the late 80s/early 90s. I think somebody said that Delphi is today's Pascal?

Re: [NF] do you ever reboot all your servers?

2017-09-01 Thread mbsoftwaresolutions
On 2017-08-31 15:36, Stephen Russell wrote: We are rebooting all of our ERP virtual and IRON db servers a second time today. Who knows what went on but the messenger service to the ERP is not doing what is should. Let us kill another 30 min! First thing to try when it doesn't work: "Did

Re: Office (Excel) automation with Office365

2017-08-27 Thread mbsoftwaresolutions
On 2017-08-27 11:15, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 Anybody doing VFP/Excel automation coding with Office365? Looks like you get Office 2016 with that subscription. I don't see why it WOULDN'T work but I wanted to check with the forum first before purchasing a

Office (Excel) automation with Office365

2017-08-27 Thread mbsoftwaresolutions
VFP9SP2 Anybody doing VFP/Excel automation coding with Office365? Looks like you get Office 2016 with that subscription. I don't see why it WOULDN'T work but I wanted to check with the forum first before purchasing a subscription. tia, --Mike

RE: Curved monitors

2017-08-24 Thread mbsoftwaresolutions
On 2017-08-24 09:42, Kevin J Cully wrote: Our plan review people just got some big, high resolution monitors when looking at these incredibly detailed plans. I think these are the ones: http://www.dell.com/en-us/shop/accessories/apd/210-aiyz?c=us=19=en=210-AIYZ Impressive!!! I think the

Re: VFP Icon issue

2017-08-24 Thread mbsoftwaresolutions
On 2017-08-24 09:35, Man-wai Chang wrote: https://www.google.com.hk/search?q=clear+icon+cache=utf-8=utf-8_rd=cr=B9aeWc2QO4T38QXZoprgCQ By jove I think you've got it, Mr. Changthe only thing I changed (environment-wise) was running my latest CCleaner after updating to the latest. That

Re: VFP Icon issue

2017-08-24 Thread mbsoftwaresolutions
On 2017-08-24 08:47, Alan Bourke wrote: Try changing Windows to 16-bit colour and back to 32-bit, this forces an icon cache rebuild. So weird...somehow it's now back...and I didn't try that or anything else (beyond re-selecting the icon which didn't work earlier).

Re: Curved monitors

2017-08-24 Thread mbsoftwaresolutions
On 2017-08-24 08:48, Alan Bourke wrote: I don't even see the point of curved TV's beyond "shit, nobody's interested in 3D TV, what other nonsense can we invent to sell them ..." +1! I thought they were marketing it from the perspective of "hey, I can watch this TV from the wide angle way

Computer monitors (was Re: Curved monitors)

2017-08-24 Thread mbsoftwaresolutions
https://www.amazon.com/s/ref=sr_st_price-asc-rank?keywords=computer+monitor=as%3Aoff=n%3A172282%2Cn%3A541966%2Ck%3Acomputer+monitor%2Cp_n_size_browse-bin%3A3547806011=1503572736=price-asc-rank Those Sceptre ones are under $100 and the reviews show them to be reputable. Anybody using that brand

Curved monitors

2017-08-24 Thread mbsoftwaresolutions
Was looking for new computer monitors at BestBuy yesterday and noticed some curved ones. I knew they had curved TVs but this was the first monitor I saw. I don't know if I'd like dual curved monitors or not. Anybody using them? ___ Post Messages

Re: VFP Icon issue

2017-08-24 Thread mbsoftwaresolutions
On 2017-08-24 05:19, Jean MAURICE wrote: you can try : right clic on the icon (the one on the desktop), properties, select icon (in french : changer d'icône). The first suggestion should be the good one. HTH the Foxil That's what I tried...no change. :(

VFP Icon issue

2017-08-24 Thread mbsoftwaresolutions
Win7Pro I had VFP9SP2 pinned to my Taskbar but before creating a customer demo, I unpinned it. Now, when I repinned it or even located it in the Programs list, the icon is "unknown". See here: https://www.screencast.com/t/h482eEgGFlm I've tried resetting the icon by selecting the program

RE: [NF] Python: 2.x vs 3.x

2017-08-22 Thread mbsoftwaresolutions
On 2017-08-21 13:47, Ivan Martinez (imvh.g.c) wrote: VFP is the best but it´s obsolete. We must look the future. Ivan Martinez Ivan, When is VFP going to stop running? If it runs on Windows 10 today, and M$ is just patching Windows 10 from here out, my wager is that our VFP9 apps will

Re: [NF] Python: 2.x vs 3.x

2017-08-22 Thread mbsoftwaresolutions
On 2017-08-21 15:53, Alan Bourke wrote: Nothing, but I wouldn't use DBF files. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Mon, 21 Aug 2017, at 06:00 PM, Laurie Alvey wrote: If you're building Windows database apps, what's wrong with VFP? Laurie Exactly. I've been using

Re: [NF] Python: 2.x vs 3.x

2017-08-20 Thread mbsoftwaresolutions
On 2017-08-20 12:49, Paul H. Tarver wrote: Gotta say, right now it is all very confusing. From all the different frameworks and ide's and modules and platforms and licensing and versions I'm making myself crazy trying to figure out how to proceed. All I want to do is find a language and/or

Re: [NF] Amazon Web Services/Azure/Google Cloud Computing

2017-08-16 Thread mbsoftwaresolutions
On 2017-08-15 10:15, Ed Leafe wrote: On Aug 15, 2017, at 8:55 AM, Malcolm Greene wrote: our value-add is your application and customer support - not haphazardly configuring and maintaining infrastructure in your spare(?) time. This. If all you’re doing is moving your

Re: [NF] Trigger question

2017-08-15 Thread mbsoftwaresolutions
On 2017-08-15 23:06, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: MariaDB backend (but could be SQL Server too) Given this trigger: UPDATE MyTable SET cItemID = new.cID WHERE cItemID = old.cID My question: will this trigger fire even if the old.cID = new.cID? Or do I need to add to the

[NF] Trigger question

2017-08-15 Thread mbsoftwaresolutions
MariaDB backend (but could be SQL Server too) Given this trigger: UPDATE MyTable SET cItemID = new.cID WHERE cItemID = old.cID My question: will this trigger fire even if the old.cID = new.cID? Or do I need to add to the WHERE clause something like "and old.cID <> new.cID" ???

RE: VFP9SP2 apps on Citrix

2017-08-14 Thread mbsoftwaresolutions
On 2017-08-14 13:49, John Weller wrote: I have a similar system except that the .exe resides on the workstation and the server. When the app is started it actually runs the loader first which checks the version number of the local exe and the server exe. If the server exe is newer then it

Loader logic

2017-08-14 Thread mbsoftwaresolutions
I've uploaded this to the ProFox downloads page in a text file, pending approval. I think I've got all the components included in that text file. Works well for me. Original Message Subject: RE: VFP9SP2 apps on Citrix Date: 2017-08-14 13:30 From:

RE: VFP9SP2 apps on Citrix

2017-08-14 Thread mbsoftwaresolutions
On 2017-08-14 11:04, Richard Kaye wrote: Sounds great. I'm pretty sure Michael B posted one here a while back, too. I did, but that one's dated, and although it probably still works, I redid it years ago with the code I just posted. I'll also post that update to the ProFox downloads page;

RE: VFP9SP2 apps on Citrix

2017-08-14 Thread mbsoftwaresolutions
On 2017-08-14 10:59, Richard Kaye wrote: Having a great deal of respect for your VFP chops, is your loader something you can share, Dave? I'm always curious about the mechanics of these types of things. -- rk Here's a copy/paste from FabNet, called from my Main.prg: PROCEDURE

RE: VFP9SP2 apps on Citrix

2017-08-14 Thread mbsoftwaresolutions
On 2017-08-14 10:46, Dave Crozier wrote: I have a general purpose "Loader" app that loads the .exe from the server onto the local workstation in a pre-defined folder and runs it. This means that updating the .exe on the server is simple as you are sure that it is never open by anyone. In

RE: VFP9SP2 apps on Citrix

2017-08-11 Thread mbsoftwaresolutions
On 2017-08-11 14:55, Kevin J Cully wrote: We used Citrix at a healthcare company I worked at around 2005. Basically everyone came in to an office, just to telecommute into our hosted servers that was in a city 30 minutes north of our office. It was a valid approach to better securing

Re: VFP9SP2 apps on Citrix

2017-08-11 Thread mbsoftwaresolutions
On 2017-08-11 16:32, Bill Anderson wrote: Mike I think SYS(602) exists because of these types of applications...just make a note of it. Interesting. My Win7Pro 64-bit laptop returns 256 for OS(10). Didn't think this would be considered having a Terminal Server present? Thanks for the

VFP9SP2 apps on Citrix

2017-08-11 Thread mbsoftwaresolutions
Anyone have VFP apps running on Citrix? Any special configurations that have to be done? Any gotchas? A potential client of mine uses Citrix and is very happy with it. He said they basically wipe/replace the image daily. I guess that way they don't have to worry about viruses? If I were

Re: [NF] Windows updates August problems?

2017-08-11 Thread mbsoftwaresolutions
On 2017-08-11 09:21, Ted Roche wrote: That's what's great about Windows. Make America Reboot Again! LOL!!! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: [NF] Windows updates August problems?

2017-08-11 Thread mbsoftwaresolutions
On 2017-08-11 09:16, Malcolm Greene wrote: You guys are making me jealous. I've been supporting my company's five (all different models) MacBooks since Jan 2014 without a single hiccup across 4 OS upgrades. No unexpected reboots ... everything pretty much just works. Very boring :) Malcolm

Re: [NF] Windows updates August problems?

2017-08-11 Thread mbsoftwaresolutions
A potential client of mine uses Citrix and is very happy with it. He said they basically wipe/replace the image daily. I guess that way they don't have to worry about viruses? If I were to develop a desktop app for them, I'd have to consider how to upgrade it easily. He said

Re: Fwd: 2017 News from Hentzenwerke Publishing!

2017-08-07 Thread mbsoftwaresolutions
My book arrived yesterday via Amazon! Read the first few pages so far. Glad to see Ted Roche got a VFP Lifetime Achievement Award back in 2013. For some reason, I thought he hadn't yet received it (but definitely should have!!!). ___ Post

RE: Report Anomaly

2017-08-07 Thread mbsoftwaresolutions
On 2017-08-07 17:36, Tracy Pearson wrote: John, What I mean by "copy it out". You can FILETOSTR(STRTOFILE()) to copy a known Included file out of the currently running EXE to the physical drive. Otherwise, you can just distribute the external files. Tracy Tracy, Don't you have that

Re: [NF] Freelance Achievement Stickers

2017-08-07 Thread mbsoftwaresolutions
On 2017-08-07 14:07, Malcolm Greene wrote: For any of you on this list who are freelancers, the following may have special meaning.https://www.newyorker.com/humor/daily-shouts/freelance-achievement-stickers Marking this NF vs OT because its tied to the business side of development. Malcolm

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-08-04 Thread mbsoftwaresolutions
On 2017-08-04 15:17, Ted Roche wrote: On Fri, Aug 4, 2017 at 2:09 PM, wrote: Next step I guess is to use the "Trusted Adapter" tip that Dave gave. I'm just waiting for the user to call me back. Apparently there's no internet connection on that

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-08-04 Thread mbsoftwaresolutions
On 2017-08-01 15:58, Ted Roche wrote: On Tue, Aug 1, 2017 at 2:45 PM, wrote: I also get that error OUTSIDE of the application trying to email. I created a test.txt file on the desktop, right-click and say "Send to Mail Recipient" and I get this

Re: Fwd: 2017 News from Hentzenwerke Publishing!

2017-08-04 Thread mbsoftwaresolutions
On 2017-08-04 05:21, Michael J. Babcock wrote: Got this from HWP (Whil) today. If you didn't get one, you can probably still use that same link (not sure if that cryptic string is specific to me or not?) to add yourself to his mailing list. The only VFP10 I've heard is some modified Chinese

Performance with qualifier/scope (was RE: GETFILE() Returns Empty String in Some Cases)

2017-08-04 Thread mbsoftwaresolutions
On 2017-08-03 18:23, Darren wrote: Personally I use this approach ... STORE m.variable|obj.property|table.fieldname to variable. Fully qualify everything / always. Easier to debug as well. Additional to results below ... STORE/ = | with/without m. | with/ without table open. No Table

RE: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-08-02 Thread mbsoftwaresolutions
On 2017-08-02 03:44, Dave Crozier wrote: The workstation IP address... it becomes trusted by Exchange. Dave Great..thanks, Dave. Now I just have to get access to her Exchange server (although she isn't savvy about computers at all and is half-way across the US from me).

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-08-01 Thread mbsoftwaresolutions
On 2017-08-01 15:58, Ted Roche wrote: On Tue, Aug 1, 2017 at 2:45 PM, wrote: I also get that error OUTSIDE of the application trying to email. I created a test.txt file on the desktop, right-click and say "Send to Mail Recipient" and I get this

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-08-01 Thread mbsoftwaresolutions
On 2017-08-01 15:42, Alan Bourke wrote: CCleaner to me is the nuclear option with any problem. It's more likely Win 10 trying to pimp it's crappy Windows Store apps. Is it 32-bit Outlook? Have you tried

RE: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-08-01 Thread mbsoftwaresolutions
On 2017-07-26 04:27, Dave Crozier wrote: In Exchange you can set up a trusted adapter (IP address) that will accept SMTP directly into the mailserver either authenticated or unauthenticated. Dave Dave -- this is out of my normal zone. Is that IP address the workstation's IP address, or

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-08-01 Thread mbsoftwaresolutions
On 2017-07-26 11:06, Alan Bourke wrote: It offered SMTP, MAPI, and Extended MAPI. If you can make it use Extended MAPI then you shouldn't have an issue sending with Outlook. computer specs: Windows 10 Professional, 64-bit I tried using Simple OR Extended MAPI but I get this error:

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-08-01 Thread mbsoftwaresolutions
On 2017-07-25 13:35, Alan Bourke wrote: You may be confusing this with when the Outlook security model started throwing up an 'allow/deny' confirmation when an external programme attempts to create a message using Simple MAPI. A kludgy way around that is to install a utility called ClickYes

RE: GETFILE() Returns Empty String in Some Cases

2017-08-01 Thread mbsoftwaresolutions
On 2017-08-01 10:00, Ken Dibble wrote: A member of the VFP Team (I can't remember his name; he was the guy who "took out the slow parts" from various subsystems for VFP 8 and 9) wrote a blog article explaining that without the M. prefix, the system MUST compare every variable referenced to every

Re: [NF] back to naming conventions

2017-08-01 Thread mbsoftwaresolutions
On 2017-08-01 09:21, Stephen Russell wrote: I just got a custom Access application that our product development team contracted out. Every table in the damn mdf file starts with tbl Just letting you know that fox doesn't own the idea that type has to be baked into everything. Yeah I

RE: GETFILE() Returns Empty String in Some Cases

2017-08-01 Thread mbsoftwaresolutions
On 2017-08-01 03:44, Dave Crozier wrote: Mike, I agree with reasoning, but I have a slightly different methodology in that all table/database variables AREN'T designated with a type prefix but all programming variables are. This way there is never any confusion as I reckon that the name in a

Re: [NF] FileMaker Pro

2017-08-01 Thread mbsoftwaresolutions
On 2017-08-01 06:36, Ted Roche wrote: On Tue, Aug 1, 2017 at 5:06 AM, Dave Crozier wrote: Used it a lot but there are runtime charges as it is definitely NOT a royalty free product like VFP. The language itself is very quirky and lots of things are done in weird and

RE: [NF] FileMaker Pro

2017-08-01 Thread mbsoftwaresolutions
On 2017-08-01 05:06, Dave Crozier wrote: Mike, Used it a lot but there are runtime charges as it is definitely NOT a royalty free product like VFP. The language itself is very quirky and lots of things are done in weird and wonderful ways. As for the multi platform then yes it does work but

[NF] FileMaker Pro

2017-07-31 Thread mbsoftwaresolutions
A colleague of mine was telling me about how FileMaker Pro can create apps for multiple platforms. From their website (http://www.filemaker.com/products/starter-solutions.html): "Manage tasks on iPad, iPhone, desktop, and the web" Just wanted to poll the ProFox community on their thoughts

Re: [NF] are you considering Python?

2017-07-31 Thread mbsoftwaresolutions
On 2017-07-31 16:29, Ed Leafe wrote: On Jul 31, 2017, at 12:12 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: So a static set of data, then? Like USPS zip codes? Well, not exactly. It could be anything that only makes sense as a complete set. Like parameters to a function, or small

Re: GETFILE() Returns Empty String in Some Cases

2017-07-31 Thread mbsoftwaresolutions
On 2017-07-31 16:04, Ken Dibble wrote: GAHHH!!! That's it!! Not a PRIVATE declaration, the variable is declared LOCAL. But in application mode there is a field in an open table with the same name as the variable. I applied the "essential m-dot" to the variable, and that fixed it. That

Re: [NF] are you considering Python?

2017-07-31 Thread mbsoftwaresolutions
On 2017-07-29 16:12, Ed Leafe wrote: On Jul 29, 2017, at 8:10 AM, Alan Bourke wrote: Sort of like an immutable collection of objects or primitive types then? Sort of, but there is also the concept that it makes no sense to add or remove an item from that

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-07-31 Thread mbsoftwaresolutions
On 2017-07-31 10:41, Philip Borkholder wrote: Hi Mike, Is the application you're referring to Sage PRO ERP (Accpac Pro Series, SBT Pro Series?) If so, we ran into this same problem here with some installations of Outlook 2016. i simply changed the automatically send SMTP commands to prompt

3+month onsite VFP gig in West Mifflin, PA

2017-07-28 Thread mbsoftwaresolutions
From Ellen at EPS: Seeking VFP Contractor One of our clients is seeking a VFP Developer for an on-site only 3+ month contract in West Mifflin, PA. Development is for an existing custom ERP App written in VFP9 with DBF backend. If you are interested, please email your resume to

Re: "Source not available" -- seems to happen in the history of the list!

2017-07-28 Thread mbsoftwaresolutions
On 2017-07-28 04:44, Alan Bourke wrote: It's at times like this I fire up Process Explorer from Sysinternals, find the EXE (or VFP9.EXE if you're running from within the IDE), highlight it and see exactly what damn files it has handles on. But would that show handles on those files that are

Re: "Source not available" -- seems to happen in the history of the list! (workaround found)

2017-07-27 Thread mbsoftwaresolutions
I found a workaround. I had a copy of the PJX/PJT from a year ago from a source code backup. Works now. Bottom line -- I think something wonky with the Project file. Wonder if that weird quirk could lead to this wonky "ghosting" behavior they're seeing? It's not consistent either. Oh

Re: "Source not available" -- seems to happen in the history of the list!

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-27 13:15, Ted Roche wrote: What's SET('Development')? Confirm your CurDir() is where you think you are. Turn off VFP and try it again cold. Compiling often leaves things in memory. SET DEVELOPMENT is ON. CurDir() confirms it's in the app/project folder. I've restarted VFP

Re: "Source not available" -- seems to happen in the history of the list!

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-27 11:38, Alan Bourke wrote: I get similar issues sometimes. It's always paths or old FXP files without debug info in them. What's weird is I've deleted the FXPs and recompiled though. DebugInfo is checked in the Project setup too. Are the PRG files built into the EXE via the

RE: Determining VFP field to be AutoInc or not

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-27 11:17, Paul H. Tarver wrote: Would there ever be a case where element[x,18] > 0 and element[x,2] <> 'I'? Or is the test on element[x,2] a "safety check"? Actually, I'm sorry...I didn't tell the list I'm looking a few lines up from that for the "IID" field, which is consistent

"Source not available" -- seems to happen in the history of the list!

2017-07-27 Thread mbsoftwaresolutions
VFP9SP2 Frustrated!!! All of the sudden my 2003 project code wants to rebel. I'm trying to debug some things and when I try to step into the code--code which has worked since 2003, mind you--it now says "Source not available" DESPITE THE FACT that I'm in the Project's home folder, where

Re: Determining VFP field to be AutoInc or not

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-27 10:04, Alan Bourke wrote: As I understand it you need to check if a field is autoinc or not. You could use afields(), and in the resulting array if element [x, 2] is "I" and element [x, 18] > 0 then you can safely say that field is autoinc. Rightthat's what I'm doing.

Re: Determining VFP field to be AutoInc or not

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-27 09:43, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2017-07-27 09:29, Stephen Russell wrote: can you add a row to the table to see which one auto populates? The VFP Help file states that 17 is the NextValue for autoincrementing and 18 is the Step for autoincrementing.

Re: Determining VFP field to be AutoInc or not

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-27 09:29, Stephen Russell wrote: can you add a row to the table to see which one auto populates? The VFP Help file states that 17 is the NextValue for autoincrementing and 18 is the Step for autoincrementing. ___ Post Messages to:

Determining VFP field to be AutoInc or not

2017-07-27 Thread mbsoftwaresolutions
VFP9SP2 I'm retrofitting old code and need to identify if the field's IID field in AutoInc or not. Looks like AFIELDS() is my friend here for array elements 17 and 18. Just wondered if anyone else had a better way? Thanks. --Mike ___ Post

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-26 19:07, Alan Bourke wrote: What Stephen was getting at was that whether you're using SQL Server as the database or not you can call a stored procedure in it to send emails. thx! ___ Post Messages to: ProFox@leafe.com Subscription

Re: Variable/Procedure Naming Conventions

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-27 04:35, Alan Bourke wrote: I think at the end of the day, as with indenting and brackets in the C-derived languages, you should pick your own style and be consistent, and if you're in a team with a published house style then you should use that. +1

Re: Variable/Procedure Naming Conventions

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-26 19:13, Ted Roche wrote: On Wed, Jul 26, 2017 at 2:55 PM, wrote: What is the YAG naming convention? lcName, ldDue, or is it more CamelCase like DateDue? http://fox.wikis.com/wc.dll?Wiki~NamingConventionsVariables

Re: Variable/Procedure Naming Conventions

2017-07-27 Thread mbsoftwaresolutions
On 2017-07-26 16:45, Alan Bourke wrote: In Fox I do scope, type, name in camel case. So lcTaxCode lnTaxRate llFlag gcApplicationName goLogger ...and so forth. +1 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-07-26 Thread mbsoftwaresolutions
On 2017-07-26 11:06, Alan Bourke wrote: It offered SMTP, MAPI, and Extended MAPI. If you can make it use Extended MAPI then you shouldn't have an issue sending with Outlook. Hi Alan, Good to know. Her config screen says she's using Simple MAPI. --Mike

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-07-26 Thread mbsoftwaresolutions
On 2017-07-26 11:07, Stephen Russell wrote: If they were using SQL Server you could enable SQL Mail and from VFP hit a sproc in SQL Server that sends everything you need. We use it internally for SPAM to ourselves about all the stuff that should be happening and isn't. As well as an email

RE: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-07-26 Thread mbsoftwaresolutions
Ok I'll look into that. Thanks. My Plan A was to simply use something like Thunderbird and integrate her application with that, as I know that worked as some point in time. --Mike On 2017-07-26 11:02, Dave Crozier wrote: Mike, Trusted adapters are for sending OUT so yes, I think you

Re: Variable/Procedure Naming Conventions

2017-07-26 Thread mbsoftwaresolutions
On 2017-07-26 13:37, Paul H. Tarver wrote: I was reading a chapter on 'Meaningful Names' in the book "Clean Code" by Robert C. Martin last night and right after he made a big point of using "Intention-Revealing Names" ie: make the name of a variable, procedure or function reflect its use, he

Re: Variable/Procedure Naming Conventions

2017-07-26 Thread mbsoftwaresolutions
On 2017-07-26 14:00, Ed Leafe wrote: "Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.” LMAO!! This has to be one of the funniest things I've ever read on ProFox. :D ___ Post

RE: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-07-26 Thread mbsoftwaresolutions
On 2017-07-26 04:27, Dave Crozier wrote: In Exchange you can set up a trusted adapter (IP address) that will accept SMTP directly into the mailserver either authenticated or unauthenticated. ...but this is for SENDING email OUT, Dave. What you're saying above sounds like something for

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-07-25 Thread mbsoftwaresolutions
On 2017-07-25 13:56, Ted Roche wrote: On Tue, Jul 25, 2017 at 1:12 PM, wrote: My client has Outlook 2016. At some point in the past, the Outlook version they had prior worked with the application that uses SMTP to send emails from it. I thought

Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

2017-07-25 Thread mbsoftwaresolutions
My client has Outlook 2016. At some point in the past, the Outlook version they had prior worked with the application that uses SMTP to send emails from it. I thought I recalled Microsoft tightening security over the years but that there was some (3rd party?) utility to get around the

Re: Array Declaration

2017-07-24 Thread mbsoftwaresolutions
On 2017-07-24 06:20, Ted Roche wrote: I almost always use LOCAL myArray[] to scope the array locally. DECLARE/DIMENSION creates an array with a private scope. PUBLIC myArray[] is global, of course. Years ago I switched to LOCAL ARRAY MyArray[1] (...with the ARRAY keyword) Great tip on the

Re: [FIC] Problems with Adapted code

2017-07-24 Thread mbsoftwaresolutions
Should I use the WWWC forum instead? On 2017-07-24 06:27, Thierry Nivelet wrote: Mike, another point: if you don't mind, make sure to follow up on the hint and solutions we provide here and/or by PM: it helps us sort out what is pending or not, and what needs more work. Thanks, Thierry

Re: [FIC] Problems with Adapted code

2017-07-22 Thread mbsoftwaresolutions
On 2017-07-22 09:04, Richard Kaye wrote: As much as I love Profox, I'd definitely move the discussion over to the FiC forum on the Westwind message boards. https://support.west-wind.com/ West Wind Message Board support.west-wind.com Support Web site for West

Re: [FIC] Problems with Adapted code

2017-07-21 Thread mbsoftwaresolutions
Hi Thierry, Finally getting back to this. After running Step 2 in FAA, I reviewed the changes it said I had to make. Made nearly all of them. (Some didn't seem applicable...for example, no need to flag my pathing in my variable declarations MyVar as MyClass of

Re: Validating email addresses

2017-07-17 Thread mbsoftwaresolutions
On 2017-07-17 04:19, Alan Bourke wrote: To my mind the easiest way would be not to re-invent the wheel and just leverage an existing email list verification service like https://neverbounce.com/ Validating 250,000 email addresses with that would cost you $100 Thanks...this looks to be

RE: Scrollbar ghost effect

2017-07-14 Thread mbsoftwaresolutions
On 2017-07-14 17:52, Tracy Pearson wrote: Mike, Yes, it does prevent the artifact from appearing. Reading what REFRESH does, makes me cringe a little to use it in this way. Every control will refresh its data, not just a redraw of the screen area. Tracy Well you don't change any data in

RE: Validating email addresses

2017-07-14 Thread mbsoftwaresolutions
On 2017-07-14 16:29, Kevin J Cully wrote: If you want to check if an email address is in a valid format, there are many RegEx expressions that you can use. Easy and free. It's not a "valid format" she's talking about. She's talking about undeliverables. Things that are properly assembled

Re: "An IF | ELSE | ENDIF statement is missing"

2017-07-14 Thread mbsoftwaresolutions
On 2017-07-14 08:59, Ted Roche wrote: On Thu, Jul 13, 2017 at 9:40 AM, wrote: Don't you hate it when you have a super long one-time conversion program, This is another good justification for printouts. Every few months, we print out long listings,

RE: Scrollbar ghost effect

2017-07-14 Thread mbsoftwaresolutions
Just a WAG -- In the thisform.Resize event, does adding a this.refresh fix it? --Mike On 2017-07-14 10:33, Dave Crozier wrote: With your anchor settings still no problems seen. However my video card Is a high spec Nvidea with 11Gb on board it. I'll certainly try it on a lower spec machine

Validating email addresses

2017-07-14 Thread mbsoftwaresolutions
My client wants to weed out the bad emails she has in her database. I'm guessing however she's sending them out, she's either not getting the bounce backs or it's too manual a process. When I googled, I found this: https://www.emailhippo.com/en-us/verify-email-address/api/a I thought I'd

Re: "An IF | ELSE | ENDIF statement is missing"

2017-07-14 Thread mbsoftwaresolutions
On 2017-07-14 07:39, Laurie Alvey wrote: I was wondering if Intellisense would help (IFELSE). No. Intellisense doesn't prevent you from writing sloppy way-too-long code. lol ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: Disappearing (and later reappearing) data on Windows Server 2016 (WORKAROUND FOUND)

2017-07-14 Thread mbsoftwaresolutions
On 2017-07-11 15:13, Tracy Pearson wrote: mbsoftwaresoluti...@mbsoftwaresolutions.com wrote on 2017-07-11: On 2017-06-08 13:57, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: UPDATE FROM CLIENT: "[Local IT guy] suggested trying to run the program in Windows 7 Compatibility mode. We

Re: "An IF | ELSE | ENDIF statement is missing"

2017-07-14 Thread mbsoftwaresolutions
On 2017-07-13 16:34, Ted Roche wrote: On Thu, Jul 13, 2017 at 9:40 AM, wrote: It pays to take the time and do good modular design instead of this way-too-long PRG run on crap. hahaha So, wait, you're saying that if you create

<    1   2   3   4   5   6   7   8   9   10   >