Re: [NF] This desktop looks like a good deal...your thoughts?
On 11/16/2012 1:13 PM, Mike Copeland wrote: Actually, it's not the product that gives me the heebie jeebies...it's remembering calling the HP tech support when smoke came out of (several) printer(s) under warranty. The last time I spent a few hours conversing with them, the guy told me he was in Mexico. Oh, and then there was that Compaq desktop system I bought back in the early 90's. My son used to live a couple of miles from where Compaq started, just outside Houston. The parents of several of his high-school friends worked at Compaq. I always thought they were spiffykeeno, until I had hardware problems out of warranty and discovered that if it ain't proprietary, it don't go in there. I've never had much respect for hardware companies that bent over backwards to make sure you had to buy replacement parts (out of warranty) from them. Dunno if they still do...wouldn't surprise me. I guess I would trace my hatred of them back to the 90s, and although I think Carly Fiorina should rot in hell, it's not fair to hold her bs comments against HP/Compaq. After all, Walter Hewlett hated her too and wanted her fired (which eventually she was). My dad had a HP desktop back in the 90s iirc and it wasn't so great. But...the reviews I've been reading lately make me think that perhaps the quality has improved. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50a69256.5010...@mbsoftwaresolutions.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] Quickbooks (was Re: [NF] RealBasic and MySQL (was Re: VFP Metro Interface))
On 11/16/2012 1:06 PM, Mike Copeland wrote: Quickbooks = momentum Say what you want about Intuit's products, the marketing was innovative and genius at the time. They practically gave away Quicken...it worked well enough...they were constantly updating (which equated to presence and top of mind market share)...and they developed a nationwide network of local peeps that will hold your hand if you get the jitters and they enlisted accounting firms in the effort to earn credibility. Quicken/Quickbooks was also groundbreaking in not forcing you to post and close accounting periodsI still remember seeing accountants eyes bulge out when they discovered that you actually could go back to a prior, closed accounting period and *gasp!* CHANGE something!!! Oh...mygodit was the end of the world in Bean land. Intuit's technology sucks, but Quickbooks is also a great example of a product completely defining and controlling a software segment. THAT takes skill! Especially the controlling part for any period of time. I don't care for Quickbooks/Quicken either, but I respect what Intuit has accomplished. Peachtree Accounting Software was supposed to be very good and appease the accountants moreso (probably because of that part about closed periods). This is another example of how marketing and its big-$ spend can really take an arguably inferior product and make it #1. History is littered with easy examples of such. Excel over Lotus 1-2-3 comes to mind first. VB6/Access over VFP is another. More? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50a6998c.8090...@mbsoftwaresolutions.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: BETA vs VHS (was Re: [NF] Quickbooks (was Re: [NF] RealBasic and MySQL (was Re: VFP Metro Interface)))
On 11/16/2012 3:35 PM, Kurt @ VR-FX wrote: Tell me about it - the Oxides drop off is TERRIBLE - so, VHS Tapes from 5 t 10 years ago, and those even farther back - are almost Un-viewable! Time to convert them ALL to DVD - before the content degrades to completely unusable. Reminds me of the commentary on the Star Wars remakes for episodes 4-6...the originals were fading fast apparently! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50a6ae06.5040...@mbsoftwaresolutions.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] RealBasic (was Re: VFP Metro Interface)
On 11/13/2012 11:14 AM, Eurico Chagas Filho wrote: I would like an application that would not charge the developer when he is developing. Now if and when I sell the product of my development then I could be charged. I think that way we could try several products till we find the best for us. Some times a project takes months to be sold and 30 days trial is not enough. If I heard right (on LinkedIn iirc), Servoy might be a good choice given your POV on how they charge. No personal experience. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50a55581.5030...@mbsoftwaresolutions.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: The - VFP is Old Tech Complaint...
On 11/12/2012 11:56 AM, M Jarvis wrote: I'd say MySQL or PostgreSQL would sell better than Access as both of those are certainly not going away any time soon...better bet with those over Access for a multitude of reasons! I said Access for the front end, not the DB backend I don't like it because I'm used to and spoiled by VFP all those years, but Access should be fine for user interface work. And they've at prolly heard of it... Gotcha... -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50a13198.2040...@mbsoftwaresolutions.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] Want to help?
I think mine got through this time. Thanks again, Ed! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50a13567.6040...@mbsoftwaresolutions.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: The - VFP is Old Tech Complaint...
On 11/10/2012 4:13 PM, Kurt @ VR-FX wrote: Hey Mike, Thanks for the input. I shall try and consider SQL as a backend for the system. Especially since I know so many people here on this mailing list has done Exactly that - using SQL. However, to be truthful - I have very little experience with doing something like that. Also, I've done the Visual type screen design - where I drop one or more DBF's into the Env. on a Form - which allows me to easily do DragDrop to layout the screen design. I suspect that with an SQL backend - you can't do that at all... I put a demo project on Ed's downloads page long ago. It hits a mySQL website of Paul McNett's. Check that out and see how it's done. It's really easy! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50a04e8d.7020...@mbsoftwaresolutions.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: The - VFP is Old Tech Complaint...
On 11/10/2012 4:33 PM, M Jarvis wrote: On Sat, Nov 10, 2012 at 11:59 AM, MB Software Solutions, LLC Good reasons, but I'd suggest you use a different backend, like MySQL instead of native DBFs. That'll suit you better in the longer run, imo, especially if they live on the web. Well... if you are gonna go w/ a different DB backend, and you wanna get the gig by pitching a dev front end, you might consider giving Access a shot.. IIRC we've been over this before... He can't very well complain about Access going away anytime soon... and it might not hurt given your situation to pick up a new skill I'd say MySQL or PostgreSQL would sell better than Access as both of those are certainly not going away any time soon...better bet with those over Access for a multitude of reasons! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50a04ed8.3060...@mbsoftwaresolutions.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: Memo field repair
On 11/10/2012 4:10 PM, Dan Covill wrote: On 11/10/12 10:33, Ted Roche wrote: What's the current guidance on memo field repair? Doesn't Doug Hennig's Stonefield Toolkit have some Memo field repair functions in it? I think it salvages pointers, but doesn't fix data. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50a0ab25.5060...@mbsoftwaresolutions.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: Memo field repair
On 11/10/2012 1:33 PM, Ted Roche wrote: We grabbed a copy of one client's data today and an attempt to PACK the DBF resulted in Missing or invalid memo error. We downloaded a second copy to confirm it's the data and not a bad copy. What's the current guidance on memo field repair? When I worked at Sylvan, we'd encounter this way too often. But in that situation, most times I could grab a older backup of the file, open the two of them (aliased Current and Backup) and just do a SCAN loop in the old one checking the value of the memo field with a TRY/CATCH wrapped around it. When I'd hit the corruption, I'd seek the record (via PK) in the Backup table and grab the memo value from there. Not perfect, but worked good in that situation. Not a cure-all, and sometime they lost memo field contents, but that's the best that could be done given what they had. There's that old Abri Recover tool too. ?? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509eb182.6020...@mbsoftwaresolutions.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] Want to help?
On 11/10/2012 9:31 AM, Ed Leafe wrote: On Nov 9, 2012, at 10:53 AM, Michael Oke, II oke...@gmail.com wrote: Ed's blown away his total No, I haven't - you guys have! I just checked this morning, and so far the total donated is $675. You all are incredible! Thank you all so much! Some people ask me why I still host this list even though I haven't used VFP in years, and I always tell them it's because Fox isn't just a programming language, it's an entire community. I think that the response to my request demonstrates has demonstrated that very clearly. -- Ed Leafe Ed, When's the deadline? I tried the other day and it rejected my bank card. I just changed my address so I'm told that it should be worked out (the security validation stuff in sync) by next week. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509eb1d5.5050...@mbsoftwaresolutions.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: The - VFP is Old Tech Complaint...
On 11/10/2012 2:13 PM, Thierry Nivelet wrote: 1/ PC/desktop itself is old tech, better pick a simple and cheap one rather than an expensive one 2/ M$ is an ailing giant 3/ no other desktop tech around - all web 4/ when it comes to web, GUI only matters; as HTML/CSS/JS are standard, all techs are alike 5/ VFP license + dev time is cheaper than any other alternative around Good reasons, but I'd suggest you use a different backend, like MySQL instead of native DBFs. That'll suit you better in the longer run, imo, especially if they live on the web. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509eb22a.4020...@mbsoftwaresolutions.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] Undeleting Files...
On 11/9/2012 2:04 PM, Kurt @ VR-FX wrote: Hey folks - looking for a little quick advice. My old computer at my old day job - I had some files on there - which I Deleted - and then Emptied the Trash bin. And, now they are about to re-alloc that PC to another user. I know that in the past I have used special SW to Undelete files - since they aren't truly gone until the OS actually overwrites that space. Do U agree? So - I need to find one of those programs - a free one - and get it to one of my old co-workers - so they can try to retrieve the files - before the PC wiped given to a new user. Was hoping someone here would have a suggestion! Man, this reminds me of the old Norton Utilities! Wonder if that still exists? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509d691e.5090...@mbsoftwaresolutions.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] Observation about UPS
On 11/9/2012 3:26 PM, Mike Copeland wrote: Anyone else use UPS's Worldship software? What a great example of main-frame mentality to address a problem. Bloated, overblown, and unwieldy comes to mind. I realize that they are doing a HUGE task tracking millions (if not billions) of packages around the world minute by minute, but the more I use it, the more of a behemoth it becomes. Just incredible. Sorry, had to vent to the only people I know who would (possibly) commiserate. (The UPS tech support folks didn't...wasn't in their script.) I wrote an app back in 2003 that UPS Worldship hooked into for Order/address information. I can relate. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509d6bb1.8070...@mbsoftwaresolutions.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.
VFP9SP2 apps on Windows 7 boxes
I'm buying a new desktop (yes, desktop) to serve as a new dev machine/code repository in my home office. I'm still designing VFP9SP2 apps on the side. I'm configuring a Dell Vostro 260 mini tower. For the OS, the default is Windows Home Premium. Add $70 to go to Windows 7 Professional. For VFP apps, they should work with the Home version, right? No sense spending the extra $70 if I don't need to. Your thoughts? tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509d7b59.6030...@mbsoftwaresolutions.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: VFP9SP2 apps on Windows 7 boxes
On 11/9/2012 5:01 PM, Tracy Pearson wrote: Mike, What stands out to me that is different between Home Premium and Professional is the ability to connect to a domain. VFP apps run in Home Starter. I've not installed VFP 9 itself into that OS. I wouldn't expect it wouldn't work. Premium has the Areo Glass, where the lower versions don't. Does the Aero Glass come into play for any VFP apps? Slicker UI? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509d815b.2090...@mbsoftwaresolutions.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: VFP9SP2 apps on Windows 7 boxes
On 11/9/2012 5:31 PM, Paul Hill wrote: I'm pretty sure Home Premium has Aero. Unless you need to join a domain go for this. Home (not Premium) only supports 32 bit, not 64bit. Well, seeing how VFP apps are 32-bit, and this is mostly for that (at this time), that's why I was thinking this would be fine. And it's my home office, so no domain needs. Just ODBC out to a MySQL database on the web. FYI my personal laptop has Home Premium. Runs VFP Visual Studio 2010 just fine. It's a cheap dual core, 64bit Celeron. Thanks for the info. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509d86b9.4030...@mbsoftwaresolutions.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 and DBF corruption in SMB2 environments.
On 11/8/2012 9:29 AM, Alan Bourke wrote: I turned up this Microsoft Article a while back: Data corruption when one user on a computer that is running Windows 7 or Windows Server 2008 R2 updates a shared file that is open on multiple computers by using SMB Version 2 Article ID: 2618096 It gives details on obtaining supported hotfixes for Windows 7, Vista and Windows Server 2008 to address this. These hotfixes are not included in any current service packs, nor are they installed via Windows Update, as far as I know. I would imagine the next Service Packs for the OS's in question will include the fix. It *appears* to have largely sorted a persistent index corruption issue on one site for us. Article 2028965 may also be of interest. So glad I don't use DBFs in most of my deployed apps any more. One still does and I'd love to retool/rewrite it to use MySQL instead. Oh to find the time. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509be1af.7060...@mbsoftwaresolutions.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.
VFP9SP2 order of objects issue
I've got a form where some labels should appear in the TOP of the object hierarchy and hence instantiate before some other objects that depend on them to have a custom property. Without the proper order, some other objects encounter an error because the Init of those labels didn't yet happen to create a custom property on them. Is this something I have to hack the SCX to achieve? I tried deleting and re-adding the objects but that didn't help. I'm guessing it has something to do with the timestamp in the SCX? tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509bff82.3010...@mbsoftwaresolutions.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: VFP9SP2 order of objects issue
On 11/8/2012 3:02 PM, Richard Kaye wrote: Isn't that something you can control to a certain extent by setting tab order or zorder? That's what I thought. Although I've never coded in the ZOrder method. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509c17bd.3090...@mbsoftwaresolutions.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: VFP9SP2 order of objects issue
On 11/8/2012 4:32 PM, Richard Kaye wrote: I've manipulated zorder when adding objects to a form at runtime. Depending on the order of instantiation, things can get a little tricky when adding containers to containers. IIRC tab order controls instantiation order which is why even though your labels aren't necessarily something the user TABs through, you should be able to make sure that your dependency between controls by manipulating that. As you could guess, this was a kludgey form. lol -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509c2d0a.4000...@mbsoftwaresolutions.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: [OT] Dow Jones down 240
On 11/7/2012 10:50 AM, Stephen Russell wrote: Not sure why this money should be re-taxed at ordinary rates. It already was through that wringer declaring it as profit. Thus taxed to the company as INCOME. EXACTLY! This money was somebody's after-tax money that was re-invested in a business! Taxing it yet again at ordinary rates sounds completely wrong (unless your goal is socialism)! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/509ab4da.6020...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Windows 8 security measures all defeated say govt funded hackers
http://www.forbes.com/sites/andygreenberg/2012/10/31/government-funded-hackers-say-theyve-already-defeated-all-of-windows-8s-new-security-measures/ -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5093dd97.7010...@mbsoftwaresolutions.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: Silly Form Question: VFP
On 11/1/2012 6:03 PM, Allen wrote: I found the easiest way to be always right is to be single :) I'll never remarry...that's for sure! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5093e403.1010...@mbsoftwaresolutions.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: Interfacing with Google Docs
On 11/2/2012 10:55 AM, Christof Wollenhaupt wrote: Do you want to store a text document or a spreadsheet? Mit freundlichen Grüßen, Christof Wollenhaupt It can be either...it's an informational document (so forward only, not to be updated), telling teachers (tutors) what students they're tutoring at certain days/times of the week. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5093e4c9.20...@mbsoftwaresolutions.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: Interfacing with Google Docs
On 11/2/2012 11:07 AM, Jeff Johnson wrote: Michael: This won't be much help, but I access Google calendar and tasks in my VFP applications. They are coded in Python and I call an exe from VFP. There are tons of Python examples for accessing all things Google. I believe you could use wwipstuff to do the data calls, but I am not sure about handling the data once you get it in VFP. Hi Jeff, This would be a one-way flow, from VFP data query to (created) online doc that field users would review for informational purposes only. No online updates from users. It's just a push of scheduling data for tutors/teachers. Google Docs was suggested so that it can be secured and not able to be read by just anyone. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5093e547.4060...@mbsoftwaresolutions.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: Citrix error
On 11/2/2012 8:21 AM, Tracy Pearson wrote: Switch to INNO. What version of InstallShield are you using? Agreed. Once I switch to Inno, I never looked back to Installshield. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5093e58b.9060...@mbsoftwaresolutions.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: Silly Form Question: VFP
On 11/2/2012 11:18 AM, Jeff Johnson wrote: I made a note of that! ;^) Damn interweb...archiving everything I say! lol -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5093e5b1.8060...@mbsoftwaresolutions.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: Interfacing with Google Docs
On 11/2/2012 12:46 PM, M Jarvis wrote: This would be a one-way flow, from VFP data query to (created) online doc that field users would review for informational purposes only. No online updates from users. It's just a push of scheduling data for tutors/teachers. Google Docs was suggested so that it can be secured and not able to be read by just anyone. Just a thought - if they can get to google docs they can get to email. Why not just email each person their own schedule? I said the same thing...especially since it's a one-way operation! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5093fb31.60...@mbsoftwaresolutions.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: Random subset of records.
On 11/2/2012 12:49 PM, Alan Bourke wrote: Let's say I have a table, and there are a number of candidate records that I could potentially include in a particular process, then flag them as processed so they do not get included again. However, due to constraints I can only take a subset of those candidate records at a time. Using a SQL-Select, how would I retrieve a random subset of the records? I must be misunderstanding.why not just use a WHERE ID NOT IN (SELECT * FROM YOUR_EXCLUSIONS_TABLE) ?? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5093fb89.9070...@mbsoftwaresolutions.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.
DBI-Tech's COM Tools
http://www.dbi-tech.com/ProductPage_COMTools.aspx Was thinking about getting this from DBI. (I had planned to get Studio Controls for COM but COM Tools appears to give me the calendaring that I wanted and it's 1/3 of the price of Studio Controls for COM.) Anybody using this tool from DBI? tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5093fcc5.1010...@mbsoftwaresolutions.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: DBI-Tech's COM Tools
On 11/2/2012 1:58 PM, Mike Copeland wrote: I've used DBI software for years. Some of their components have bugs, but they require that you purchase a support contract before they will even confirm that their product has a bug (which would clarify the need to work around the problem.) They sell you the license, then want to charge you by the year to respond to queries about their own product not working as it should. Halfway decent product, but god forbid you ever need tech support or want to confirm a bug. Thanks for the feedback, Mike. Have you used the calendaring controls specifically? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50940d78.8060...@mbsoftwaresolutions.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: DBI-Tech's COM Tools
On 11/2/2012 2:16 PM, Mike Copeland wrote: If you mean the pop-up calendar, no. If you mean the scheduling control, yes. It was the buggiest. Ugh...that's the one I mean...the scheduling control. :/ -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50941d6f.1060...@mbsoftwaresolutions.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: DBI-Tech's COM Tools
On 11/2/2012 3:58 PM, Tracy Pearson wrote: Mike Copeland wrote on 2012-11-02: Whoa! Excellent pricing! Have they been stable? Thanks Tracy! Mike Mike, I have a really old version of 10.3.1. They are shipping version 15.3.1. The Calendar control is what I've been using. I've not attached data to it. I do not allow it to manage changes. It has been stable for our customers. There was a random C5 in VFP code that I was having trouble tracking down. It only happened when the Calendar control was in use. I haven't heard it being a problem in a couple of years. So yes, I believe it is stable. When I needed some support from them, they were response. I don't know if my request was already being worked on, it was added 3 days after I made it. Like Mike said, the price looks good and the product looks good. (Why DBI's site was so shitty at showing full sized images I have no idea.) Do they have samples in VFP code? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50942c15.7060...@mbsoftwaresolutions.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] Basalmic wire framing app
http://www.balsamiq.com/company Colleague was mocking up a screen with this tool. Looks VERY cool! Anyone use it before? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5092d693.5040...@mbsoftwaresolutions.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] Basalmic wire framing app
On 11/1/2012 4:15 PM, Stephen Russell wrote: On Thu, Nov 1, 2012 at 3:07 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: http://www.balsamiq.com/**company http://www.balsamiq.com/company Colleague was mocking up a screen with this tool. Looks VERY cool! Anyone use it before? --- Would have been nice to see a demo of it working from their site. Looks interesting. They DO have a demo on their site?!? Didn't you see it? Try the home page. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5092dcae.6030...@mbsoftwaresolutions.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: [OT] - Obama Piece in Newsweek
On 10/25/2012 5:20 PM, Stephen Russell wrote: On Thu, Oct 25, 2012 at 4:12 PM, Carl Lindner c...@bdos.com wrote: No, Leland. I was corrected. The article was real, and Snopes says the author - Mat Patterson - may have written for Newsweek previously, but not this piece. No matter where it was published - as she said in My Cousin Vinnie - the article is dead on balls accurate. --- If it wasn't so racist I'd believe it. My Cousin Vinnie was racist? lol ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5092e866.1050...@mbsoftwaresolutions.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] Easiest way to create an .ICO file?
On 9/13/2012 6:00 PM, M Jarvis wrote: On Thu, Sep 13, 2012 at 2:53 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: We've got new logos. I want to create an .ICO file to use as our application's desktop icon (and icon in forms) instead of the good ol' fox icon. They've provided PNG files to me. What's the easiest way to create an icon file from these for my purposes mentioned? MS Paint won't do it. here's something free and quick: http://www.prodraw.net/favicon/generator.php Liked this one...quick and easy...thanks! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50533769.1090...@mbsoftwaresolutions.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] Easiest way to create an .ICO file?
On 9/13/2012 6:00 PM, Fred Taylor wrote: IrfanView should be able to handle it. http://www.irfanview.com/ I've heard of this tool but never used it before. Now I've got a reason to try it! Thanks, Fred! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50533794.30...@mbsoftwaresolutions.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: Speed
On 9/14/2012 7:28 AM, Michael Madigan wrote: My software is too optimized, I have a gazillion index tags, which gives it more moving parts to fail. Throwing hardware at something isn't a bad idea, but sometimes you can't. I worked for this insane woman in Philadelphia (Wyncote to be exact) who indexed nearly every field in a table. ID10T. This was the same woman who would only read the first sentence of my emails and then yell across the office to me asking questions I answered in the email if she'd kept reading. Horrible personal and communication skills. The final straw was when she berated me for using ASSERTS in my code, INSISTING that the end-user would see them in the runtime product. Thank God I found something else. I suffered under her for only 3 months, but it was a LONG 3 months. The company had bought her a brandy new Lexus RX at the time to keep her as I guess she had threatened to leave. What a complete waste of money. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50533926.40...@mbsoftwaresolutions.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: Version control
On 9/14/2012 8:58 AM, Rodney Dixon wrote: @Chrisof, What about TFS do you consider pretty bad? Curious to hear that as well. I haven't used it yet but will be soon when I learn C# and join other projects with our Corporate HQ. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5053395a.8000...@mbsoftwaresolutions.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: Set Textmerge Delimiters To
On 9/13/2012 11:12 AM, Tracy Pearson wrote: Jerry, If I remember correctly , you would need to have and in the TextMerge for the VFP to process it. Therefore, you placing tagData/tag inside the TextMerge is not a problem. I'm fairly certain I use TextMerge to build XML in production code without changing the delimiters. Tracy is right. I used Christof's Excel XML logic and it worked fine with the tags as Tracy suggested. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5051fb8f.6090...@mbsoftwaresolutions.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] all of a sudden pop3 not working, client losing mind
On 9/13/2012 2:26 PM, roger wrote: I had the same problem with Comcast they changed the port from 25 to 993 and 110 to 587. Suddenly no emails went through what a pain So go and check if you are having the same issues That was SUCH a RPITA back when I worked at Sylvan. We had email integration in our app and when COMCAST did that, we took LOTS of support calls. It reminded me that I didn't care so much for that design approach. Live and learn! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/505230ed.60...@mbsoftwaresolutions.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] all of a sudden pop3 not working, client losing mind
On 9/13/2012 4:17 PM, Richard Kaye wrote: I had a client who was complaining about bad ftp performance. I ran pathping from their location to our ftp server. Things moved along nicely and then about 12 hops or so in, ping response times went way up and packet loss was 100%. Now try explaining to someone that a router on some backbone ISP hundreds of miles away from their location was the probable cause... What can you do at that point, since it's outside your area of support/influence? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50524091.4030...@mbsoftwaresolutions.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] Easiest way to create an .ICO file?
We've got new logos. I want to create an .ICO file to use as our application's desktop icon (and icon in forms) instead of the good ol' fox icon. They've provided PNG files to me. What's the easiest way to create an icon file from these for my purposes mentioned? MS Paint won't do it. tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/505255ed.30...@mbsoftwaresolutions.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: Version control
On 9/12/2012 5:56 AM, Dave Crozier wrote: I have had very few occasions to use version control when using VFP but as we are involved in a really large conversion job here I decided 3 months ago to use a formal method of version control and as such decided on the old chesnut Visual Source Safe as we have it under our MSDN agreement and it obviously seems to fit in seamlessly (laugh out loud!!) with VFP. The few occasions I have used it and required it although messy it has worked, however I now find that the VSS database has become totally screwed beyond repair and hence no sensible audit trail etc to go back to as the corruption seems to go back about two months prior to the changes I want to re-instate. I know, bad planning on my behalf but I can go back to disk backups even though it will involve a fair amount file comparing (beyond compare will earn it's corn the next few days!). Never having used alternative software, I think Paul McNett dabbled with subversion using VFP and wonder if anyone has any comments on what to use and why. I know about the format of VFP forms etc. being a pain as they are not simple text. I just don't want to trust VSS any more despite it being the nearest standard VFP offering there is. I recall Ed Leafe telling me about Tortoise SVN I thought many moons ago. ?? At my current day gig, we had been using SourceGear's Vault, which seemed fine to me, but now we're using Team Foundation Server at the corporate HQ (and I suppose I'll be getting on board that any day now too with a new project to check in). -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5050b612.2050...@mbsoftwaresolutions.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: Speed
On 9/11/2012 9:35 PM, Sytze de Boer wrote: I'm losing my mind over this At a client site, they run a report which can take 30 mins to generate, over the network When they run it on a local pc, it takes 5 secs Without boring you with all the details, essentially, the following code makes up the report *trcask4=a date *trcask5=a date Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc, H As SRCE From winhst Where Between(Date,trcask4,trcask5) Union All; Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc, I As SRCE From wininvs Where Between(Date,trcask4,trcask5) Union All ; Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc, J As SRCE From wintime Where Between(Date,trcask4,trcask5) Into Table (myfile) The Winhst file has about 500,000 records The other 2 less than a 1000 combined There seems to be a big difference in time if no-ones else has logged into the app from a different workstation Can anyone suggest a way to make this go quicker? What happens if you use DATE BETWEEN trcask4 and trcask5 instead of using VFP's BETWEEN function? iirc, BETWEEN(field,arg1,arg2) was NOT optimizable but field BETWEEN arg1 and arg2 was optimizable. hth, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5050b7af.1000...@mbsoftwaresolutions.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: Speed
On 9/11/2012 11:22 PM, Sytze de Boer wrote: Fred (Blush) NO S DOH! Dammit Sytze...you owe a round of pints for that one. :-) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5050b8c1.6030...@mbsoftwaresolutions.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: Speed
On 9/12/2012 1:02 PM, Fred Taylor wrote: What happens if you use DATE BETWEEN trcask4 and trcask5 instead of using VFP's BETWEEN function? iirc, BETWEEN(field,arg1,arg2) was NOT optimizable but field BETWEEN arg1 and arg2 was optimizable. Just tried it to prove it to myself. No difference in whichever syntax you choose, optimization uses the TAG on the date field and is fully optimized. Thanks, Fred! I'm in/out of offices today so no time to verify myself. Glad you did to clear that up! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5050c2e8.5030...@mbsoftwaresolutions.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-Sports draw
I don't have such software; I was just clarifying your need. Good luck! --Mike On 9/10/2012 3:11 PM, Sytze de Boer wrote: Yes With facility to edit S On Tue, Sep 11, 2012 at 3:06 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 9/10/2012 2:28 AM, Sytze de Boer wrote: Hi Experts I need to design a system where I need to design a draw involving X number of Teams I can try and redesign a new wheel but I thought I'd check here first Has anyone done this type of work? Do you mean an randomly generated schedule of games? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/504f63ac.4030...@mbsoftwaresolutions.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-Sports draw
On 9/10/2012 2:28 AM, Sytze de Boer wrote: Hi Experts I need to design a system where I need to design a draw involving X number of Teams I can try and redesign a new wheel but I thought I'd check here first Has anyone done this type of work? Do you mean an randomly generated schedule of games? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/504e01d8.1010...@mbsoftwaresolutions.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: Way to get LOCAL desktop to an RDP session?
On 9/6/2012 6:13 PM, Vincent Teachout wrote: Michael Madigan wrote: Why are they saving it to their local desktop? Why not save it to a \\tsclient\foxpro reports or something like that? Convenience. There are 50 plus users, no local network, in 4 cities. So I'd need to create a folder on each users desktop. And it would probably be difficult to train some of these users where to find a fixed folder. Do the cities need to share reports with each other? If so, sounds like a good use for DropBox or such service. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5049f41e.1050...@mbsoftwaresolutions.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] loopy visual studio
On 9/7/2012 3:53 PM, Stephen Russell wrote: On Fri, Sep 7, 2012 at 2:46 PM, Tracy Pearson tr...@powerchurch.com wrote: Allen wrote on 2012-09-07: What I wanted to do was replace a phrase for some text files. Simple. But not in VS Al Allen, NotePad++, PSPad, or if your hard core VI for Windows. grin Really VFP 9 and the Code References could do that for you. -- Agent Ransack to find the files with the text has worked for me. And isn't this what Chet Gardiner's GoFish app was about too? Available on Profox downloads page iirc. hth, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/504a5400.1030...@mbsoftwaresolutions.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] loopy visual studio
On 9/7/2012 4:29 PM, Allen wrote: I use that for VFP. New version is terrific Al Is that in the Thor suite? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/504a6938.3000...@mbsoftwaresolutions.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: SuperMover class
On 9/6/2012 3:53 PM, Michael Savage wrote: I need to create a mover that will move multiple columns. Like the base mover, but it would move 2 columns to another list box with 2 columns. I don't want to concatenate the two fields, as I do not want to show one of them. I've tried working with acopy, etc. but I just can't get it to work. Any ideas? A code sample in the right direction would be great... Supermover reminds me of the FFC classes I saw explained in Markus Egger's Advanced OOP with VFP6 book. Not sure if you have access to that? I would think using the .Selected property and then the column contents you could adjust/write it to fit. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5049080e.2050...@mbsoftwaresolutions.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: Way to get LOCAL desktop to an RDP session?
On 9/6/2012 5:12 PM, Vincent Teachout wrote: I have a vfp app that users run via rdp. It's possible to generate a report, and save it to their local desktop, but it's a slow PITA to do it - they have to browse, select computer, select their local C: drive and not the rdp sessoin (training nightmare), wait until the list of their local folders show up, select users folder, wait until that opens up, select their name, wait, select desktop. Is there a way to get the local desktop name to the remote app? I have code that if run locally will return the local desktop, and if run on the RDP, it returns the rdp desktop, but I need the remote app to somehow get the local desktop. Is that possible? Is there a GETENV(..) of some kind for this? Just a WAG. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50491f1e.4010...@mbsoftwaresolutions.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] Ergonomic Keyboard Recommendation
On 8/27/2012 2:52 PM, Garrett Fitzgerald wrote: I've never been to the diagnosable point, but my wrists were starting to hurt in the 90s, so I decided to teach myself to type in Dvorak. The pain went away, it didn't take me too long to get up to speed on the new layout (month or two?), and I don't even have particular problems with laptop keyboards -- though I do insist on split keyboards on my work computers. Dvorak??? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/503fb021.6080...@mbsoftwaresolutions.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] Ergonomic Keyboard Recommendation
On 8/30/2012 2:31 PM, Paul McNett wrote: Hey Garrett, I tried to convert to Dvorak keyboard layout around 2004 I think, but found that the repositioning of programming symbols like {}:(). and the dread of remapping vim to still have the classic hjkl for movement seemed like a showstopper for me. Any input on that? (pun not intended) I remember you talking about that back then! I was enjoying programming at home while watching the snow come down. I opened MBSS in Jan 2003 due in part to stories like yours about working on your own! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/503fb2b1.5080...@mbsoftwaresolutions.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] Ergonomic Keyboard Recommendation
On 8/30/2012 2:45 PM, Paul McNett wrote: On 8/30/12 11:36 AM, MB Software Solutions, LLC wrote: I remember you talking about that back then! I was enjoying programming at home while watching the snow come down. I opened MBSS in Jan 2003 due in part to stories like yours about working on your own! So how do you like working independently? I'm still loving it! After the divorce I went back to Corporate America for the daytime gig but still do MBSS for long-time clients yet. Corporate America pays a lot better but I do miss my very cheap Wednesday afternoon Therapy sessions on the golf course. That weekly golf league at 2:30pm was just what I needed (along with jettisoning the ex-wife). lol -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/503fb625.2010...@mbsoftwaresolutions.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: Tables left open when form closes
On 8/25/2012 3:39 AM, Allen wrote: What is a good reason to use data sessions. I never do and never have these problems. I prefer control For starters, you can have the same table/cursor names open so you can code consistently moreso rather than having to create bizarre names for your cursors so they don't collide. Think of several forms each with their own datasession. The old Sylvan app (which kicked ass for 16+ yrs and still does so) created bizarre cursor names and kept track of such names in variables. Would have made life much easier if separate data sessions were used. Debugging was many times a nightmare. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/503e3135.6060...@mbsoftwaresolutions.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: Quicker to USE AGAIN instead of SELECT * ?
On 8/10/2012 6:47 PM, Rafael Copquin wrote: What I do in these cases is convert the cursor to xml using the xmladapter and send it back as a variable to the calling form. The calling form then receives it back as xml and using xmladapter turns it back into a cursor What you're describing is fine for a physical n-tier, but mine is a logical n-tier, where the layers can see each other. Besides, your approach is pretty much what Anthony Testi described years ago and it was reported very slow back then. For the purposes of what I needed, this approach would not be quick (enough) compared to the two ways I described. Thanks though! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/503e3326.9070...@mbsoftwaresolutions.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.
Quicker to USE AGAIN instead of SELECT * ?
VFP9SP2 I've got a temporary cursor that I manipulate and then need to return a cursor to the calling routine named what was requested (via parameter). Would it be quicker to do USE MyTempCursor AGAIN IN 0 ALIAS MyDesiredCursorName or do a SELECT * FROM MyTempCursor INTO CURSOR MyDesiredCursorName? tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/502537cd.4070...@mbsoftwaresolutions.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.
Inno Setup INI files section question
For those who use Inno Setup with their Fox apps...If you use the INI section, does that mean you don't include the actual INI file in the Files section? I'm guessing it would automatically create it? tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5023fe76.4040...@mbsoftwaresolutions.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: Update Conflict
On 8/7/2012 1:54 PM, Michael Oke, II wrote: Except the same code, on a different but similar table, does not show the same issue. It is the TableUpdate that throws this error and I'm just trying to narrow down any possible causes. Reserved name? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5022cea4.4030...@mbsoftwaresolutions.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: corrupted table and database issues
On 8/8/2012 7:27 AM, James Harvey wrote: Thanks for the link, this utility looks interesting, and I see that version 2008b includes a DBC testing and repair option. The error number returned when trying to open the corrupted table was 1683. The cdx lost three indexes, and one field name was truncated by one letter (pk_hshealth to pk_hshealt). DBC problems have been the bane of my existence over the years, as they don't happen very often, but when they do it seems like it takes voodoo to get them fixed. ...which is why I love using MySQL or MS-SQL instead of DBFs for years now. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5022d01e.5090...@mbsoftwaresolutions.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: corrupted table and database issues
On 8/8/2012 9:21 AM, James Harvey wrote: The only issue I have with SDT is convincing the powers to be the price is worth it. It's under $300! Good Lord! Count the cost of downtime to show it's value. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5022d1e2.7060...@mbsoftwaresolutions.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: corrupted table and database issues
On 8/8/2012 9:43 AM, James Harvey wrote: In addition to the recreating indexes, would it also return the long field names so the dbc would validate properly? It would put the database to exactly the state you said it should be in the image SDT saves for its structure. One of the must haves when using DBFs with your apps, imo. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5022d27d.6060...@mbsoftwaresolutions.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 has stopped working
On 8/2/2012 3:26 PM, Allen wrote: Thanks Dan In that case the Wiki is wrong as it says at least one requires registering. Al So update it! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/501ae100.4010...@mbsoftwaresolutions.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.
Great article on Microsoft's lost mojo
(Thanks, Russ on Linked In) http://www.vanityfair.com/business/2012/08/microsoft-lost-mojo-steve-ballmer Of course I couldn't help but think of FoxPro when it talked about internal politics and squabbles to shoot themselves in the foot. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/501940c9.1070...@mbsoftwaresolutions.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: Getting the My Documents folder
On 8/1/2012 11:36 AM, Rick Schummer wrote: Is there a better way to determine the current user's My Documents folder? To add one more to the pile from Doug Hennig: http://doughennig.blogspot.com/2007/01/finding-paths-for-special-folders.html or shortened: http://is.gd/3GJph6 Someone else mentioned that one but thanks just the same as this helps those who may have missed it and increases chances of a better match when searching the archives! :-) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50195009.3030...@mbsoftwaresolutions.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: Can click() method code be deleted?
On 7/31/2012 11:33 AM, Tracy Pearson wrote: Vincent Teachout wrote on 2012-07-31: Tracy Pearson wrote: Vincent, You could probably get away with adding code similar to this in the Activate event. IF select(GrdCursor) 0 Select GrdCursor Append From SelectResults Else Select * from SelectResults into cursor GrdCursor ReadWrite endif USE IN SELECT(SelectResults) Also a minor change to the Select into cursor above the new code, changing the original result cursor name. Similar to what I was planning, but I failed to remember to check for the existence of the cursor. Thanks, Tracy - consider this stolen! :-) Vincent, I noticed that I didn't include to ZAP the existing grid cursor. Just make sure you use disconnected cursors and NOT UPDATABLE VIEWS. (Been there, done that, had some support calls!) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5017fb62.9080...@mbsoftwaresolutions.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.
Getting the My Documents folder
VFP9SP2 I had this code in an older program: *** mjb 03/03/2010 - changed for Vista and beyond IF VAL(SUBSTR(OS(),9,1)) = 6 THEN Vista doesn't use My lcDir = lcDrive + ADDBS(GETENV(HOMEPATH)) + Documents\MyApp2009\ ELSE XP and below use My lcDir = lcDrive + ADDBS(GETENV(HOMEPATH)) + My Documents\MyAppt2009\ ENDIF Is there a better way to determine the current user's My Documents folder? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5017fca8.6000...@mbsoftwaresolutions.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: PEM Code Editor version 7.11 bug
On 7/31/2012 1:43 PM, Richard Kaye wrote: Maybe. There are GGs for Thor GoFish that I tend to monitor more than the VFPX forums. Does that mean you use Thor and GoFish? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50182129.2080...@mbsoftwaresolutions.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: Any one put an app in a cloud?
On 7/31/2012 4:50 PM, Fred Taylor wrote: Really depends on the number of users. We moved several VFP apps to the cloud with about 125-150 users. Not quite sure how many servers that's spread across on the cloud, but I think it's at least 6 servers (4 for user logins and 2 for data). Everything accessed from RDP (remote desktop). So each user RDP's into a location and runs the app that way? It's using VFP tables for it's backend? Any performance lag with the RDP approach? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50184b87.1040...@mbsoftwaresolutions.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: Any one put an app in a cloud?
On 7/31/2012 5:37 PM, Lew Schwartz wrote: So, to be clear, has anyone simply mounted the drive ( or used the vendor's mounting routine) and run both app and data as though it were a local drive letter? Lew, Do you mean the Foxpro tables (is that what you're using on the backend?) are on that cloud drive? I'm betting that'd suck for performance. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5018515a.3090...@mbsoftwaresolutions.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: Any one put an app in a cloud?
On 7/31/2012 5:38 PM, Fred Taylor wrote: Not so that it's noticeable. We had a sever problem with generating/printing large reports early on (10-1 slower) but I'm pretty sure that's not as big a problem as it used to be. At least I don't hear the complaints as often, anyways. ;) The printing was local, and what was a 3 minute report generation time, was around 30 minutes. I think it's 3-5 minutes now. Generating emails (via Outlook) had a similar problem that's since been resolved, too. (And just for Ed, RackSpace hosts our email Exchange server). So the users all dial into the same computer address, but I'm guessing it's some sort of Citrix like setup (as opposed to them each having a computer remotely--which of course makes NO sense)? Are they using VM for this stuff? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/501851e1.2030...@mbsoftwaresolutions.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: Any one put an app in a cloud?
On 7/31/2012 5:49 PM, M Jarvis wrote: Like MB said, I suspect performance will be lacking... perhaps the EXE running local w/ data on the cloud would be acceptable, especially if it's just a single user app like you described... I can hear Steve Russell now. Dot Net Cloud Service! g -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50185371.9080...@mbsoftwaresolutions.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 data and VPN
On 7/30/2012 7:27 AM, Christof Wollenhaupt wrote: Easier than I though. Speed is not really an issue as its only a tidy job Should speed become an issue, you could temporarily copy VFP9.EXE and VFP9ENU.DLL onto the remote machine. That's sufficient to run VFP 9 in most cases if you don't mind lacking any of the developer tools, IntelliSense, and so forth. Copying VFP to the remote machine is perfectly in line with the EULA if you remove the files afterwards, as VFP is licensed per developer not per machine. Don't forget Ed Leafe's vRunFox in the Profox archives! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5016a2aa.9020...@mbsoftwaresolutions.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 data and VPN
On 7/30/2012 11:36 AM, Alan Bourke wrote: IMO you would be better running an RDP session through the VPN and use vrunfox.exe on the remote PC. I would agree with this approach to avoid potential issues from the lag otherwise. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5016ab42.9000...@mbsoftwaresolutions.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] Fox Tshirt
On 7/27/2012 8:47 PM, Jeff Johnson wrote: OMG! Those guys are hip! It really does say that! I don't see that on the shirt?!?!??? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5013e05e.6030...@mbsoftwaresolutions.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] Fox Tshirt
On 7/28/2012 12:48 PM, Fred Taylor wrote: I think you'll find that was more in reference to FireFox vs IE than VFP judging from the other comments there. I'd bet moreso on this. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50143ef7.6040...@mbsoftwaresolutions.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: Logo
On 7/26/2012 11:24 AM, Jeff Johnson wrote: The picture control on the report has a fixed control source .\images\logo.jpg Prior to running the report I replace logo.jpg with the file I want to use from the memo field based on the customer. logo.jpg is excluded from the project. Actually, I load the logos in .jpgs when I open the application. HTH Jeff Neat tip! Did you ever accidentally load the wrong logo? g -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/501161ae.1020...@mbsoftwaresolutions.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: SYS(3054)
On 7/25/2012 8:25 AM, Jean MAURICE wrote: Have a look at SYS(3092, myquery.txt) Solved it with SET CONSOLE OFF (thought it was but apparently not!) but this looks like what I wanted too. Thanks! --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/500ffd10.9030...@mbsoftwaresolutions.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: VFP9 windows 8
On 7/25/2012 9:46 AM, Alan Bourke wrote: I installed our product on it and it worked fine. I would hope the windows\system32 thing is a permissions issue, and DBF files shouldn't be in there anyway. I'm glad I don't use DBFs anymore! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/500ffe40.2070...@mbsoftwaresolutions.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.
Easiest way to count months in range?
Input is 2 dates...I need to count the number of months between (and including) them. example: 2012-02-27 to 2013-01-31 would be 13. Thought this might yield some interesting approaches. :-) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50105961.4030...@mbsoftwaresolutions.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: Easiest way to count months in range?
On 7/25/2012 4:45 PM, Fred Taylor wrote: What constitutes a month? Is 2012-06-30 to 2012-07-01 one month or two? And how would your example be 13? Hi Fred, Sorry...forgot to say disregard the day in the month. Here's what I came up with. It's a bit verbose but it's for clarity's sake: FUNCTION CountMonths(tdStart as Date, tdEnd as Date) as Integer LOCAL liNumMonths as Integer, liStartYear as Integer, liEndYear as Integer, liStartMonth as Integer, liEndMonth as Integer IF tdEnd = tdStart THEN liStartYear = YEAR(tdStart) liEndYear = YEAR(tdEnd) liStartMonth = MONTH(tdStart) liEndMonth = MONTH(tdEnd) IF liStartMonth = liEndMonth THEN take 12 months from year for date math liEndYear = liEndYear - 1 liEndMonth = liEndMonth + 12 ENDIF liNumMonths = ((liEndYear - liStartYear) * 12) + (liEndMonth - liStartMonth) + 1 last +1 is to include the month you're in ELSE invalid entry...start shouldn't be later than end liNumMonths = -1 ENDIF tdEnd = tdStart RETURN liNumMonths ENDFUNC CountMonths(tdStart as Date, tdEnd as Date) as Integer -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50105db2.8040...@mbsoftwaresolutions.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: Easiest way to count months in range?
On 7/25/2012 4:45 PM, Fred Taylor wrote: What constitutes a month? Is 2012-06-30 to 2012-07-01 one month or two? And how would your example be 13? Fred On Wed, Jul 25, 2012 at 1:38 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Input is 2 dates...I need to count the number of months between (and including) them. example: 2012-02-27 to 2013-01-31 would be 13. And I was wrong...my example would be 12. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50105dff.1040...@mbsoftwaresolutions.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: Easiest way to count months in range?
On 7/25/2012 5:31 PM, Paul Hill wrote: On 25 July 2012 22:26, Sytze de Boer sytze.k...@gmail.com wrote: I never reply to this kind of email because I leave it to you gurus However, I was just working with a live system where I use this formula today=date() m1=(year(trans.date)*12)+month(trans.date) m2=(year(today)*12)+month(today) lvMonths=m2-m1 That's the idea same as my version :-) Yep...you both win the prize! Nice and neat. Thanks! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5010680a.4050...@mbsoftwaresolutions.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.
SYS(3054)
VFP9SP2 I'm using SYS(3054,11,lcRush) to analyze the optimization in my queries, but I don't want the echos to the screen---I only want them in the variable. I don't see a way to suppress this. Ideas? tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/500f15f2.1040...@mbsoftwaresolutions.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: Restarting VFP app
On 7/20/2012 7:23 PM, Ted Roche wrote: Search for VFP loader and you'll likely find the code in Ed's downloads, on the Fox Wiki or VFOX. The authoritative article was FoxPro Advisor in '94, IIRC. Ted, What that FPA article the one written by Stephen Settimi? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/500c49cb.7030...@mbsoftwaresolutions.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.
What was that old trick for getting Intellisense to work in a PRG class with THIS. references?
VFP9SP2 I've got a PRG based class that I'm writing and I want Intellisense to kick in for THIS. when I'm writing procedure code. I can't recall the trick. Was it with a #DEFINE or something? Remember -- this is not the instantiated object I'm talking about...rather, I'm writing the class code itself. Thanks, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/500710c7.1010...@mbsoftwaresolutions.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: What was that old trick for getting Intellisense to work in a PRG class with THIS. references?
But that doesn't work when I'm writing/creating code and using THIS. For example, if in a method in my class I want to write IF THIS.SystemName = ABC THEN messagebox(Rock on, man!) ENDIF ...and I want Intellisense to kick in right after I type THIS. See what I mean? I want to use THIS. Thanks, --Mike On 7/18/2012 3:47 PM, Richard Kaye wrote: LOCAL myvar AS [myclass.myobject] You have to have set classlib to myclass in scope. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, July 18, 2012 3:39 PM To: profoxt...@leafe.com Subject: What was that old trick for getting Intellisense to work in a PRG class with THIS. references? VFP9SP2 I've got a PRG based class that I'm writing and I want Intellisense to kick in for THIS. when I'm writing procedure code. I can't recall the trick. Was it with a #DEFINE or something? Remember -- this is not the instantiated object I'm talking about...rather, I'm writing the class code itself. Thanks, --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5007152a.5080...@mbsoftwaresolutions.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: What was that old trick for getting Intellisense to work in a PRG class with THIS. references?
On 7/18/2012 4:11 PM, Tracy Pearson wrote: Mike, #IF .F. LOCAL THIS as ObjectClass #ENDIF Sometimes the syntax might be #IF .F. LOCAL THIS as ObjectClass OF WONTOP() #ENDIF That did it...THANKS Saved this one in the Keep folder! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50071e32.90...@mbsoftwaresolutions.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: upsizing wizard
On 7/16/2012 9:18 AM, Kevin Cully wrote: E, Take a look at the VFP2MySQL set of programs on the downloads page. http://leafe.com/dls/vfp There are others for PostgreSQL as well. Looks like I did that one, although I thought you did, Kevin? (Guess yours was the routine that actually created the tables whereas mine just moved the data.) The MakeUpdatable routine is Paul McNett's, also found in that same download area. If you have any troubles, just let me know. Thanks, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50058c30.7020...@mbsoftwaresolutions.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: upsizing wizard
On 7/16/2012 9:26 AM, Stephen Russell wrote: snippedEither use powershell where you can bring in 10 mill rows into a SQL Server table in about 25 + seconds Really? WOW! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50058ca9.6000...@mbsoftwaresolutions.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] Network Question
On 7/17/2012 5:54 PM, Kurt Wendt wrote: Jeff - and I'm no network expert - so YMMV - but, if I am not mistaken - you could simply use a Hub - and connect both PC's to the hub via the extra network card you are looking to put into each of the PC's. At least, I think that's what I did some time in the past... I'm no hardware/network expert either, but I thought hubs were outdated and to be avoided; instead, use a router. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5005e180.40...@mbsoftwaresolutions.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 2008 column constraint question
On 7/13/2012 12:18 AM, Dan Covill wrote: On 07/12/12 20:13, MB Software Solutions General Account wrote: I've seen how to create a rule for data in a column using direct values (http://www.databasejournal.com/features/mssql/article.php/3811831/Using-Check-Constraints-to-Validate-Data-in-SQL-Server.htm). But I want to basically say Only allow values in this FK field that exist as PKs in that other table. How do I do that? If you're doing lots and lots of them, SELECT UNIQUE pk-field FROM othertable INTO ARRAY OKFields keep the array around, then IF ASCAN(OKFields, FKvalue 0 -- it's good -- If this is a rare thing, SELECT pk-field INTO ARRAY Dummy FROM OTHERTABLE ; WHERE pk-field = FKvalue if alen(Dummy) 0 -- it's good -- Dan, This is not Foxpro. It's SQL Server 2008 R2. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/50001af1.4060...@mbsoftwaresolutions.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] SQL Server constraints getting in the way of truncate table command
SQL Server 2008 R2 I'm trying to create a simple sql script to create sample data. I want to keep it lean, just simple INSERT INTOs. I attempt a TRUNCATE TABLE ahead but it balks on the constraints. Suggestions/Ideas? I guess DELETE FROM instead? Haven't tried that yet. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5000411d.7070...@mbsoftwaresolutions.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] Small fixed dialogue box in MS SQL Server Mgmt Studio (2008 R2)
I'm creating my indexes/keys in SQL Server Mgmt Studio (2008 R2) and it's such a small dialogue box, fixed in size, not resizable. C'mon, M$...it's 2012...why the hell must I work within such a small box? Steve Russell or anyone working with a newer version -- please tell me this is only in the 2008 R2 version?!?!?!??? Gr.. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ffedbb1.20...@mbsoftwaresolutions.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] Small fixed dialogue box in MS SQL Server Mgmt Studio (2008 R2)
On 7/12/2012 10:30 AM, Stephen Russell wrote: On Thu, Jul 12, 2012 at 9:14 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I'm creating my indexes/keys in SQL Server Mgmt Studio (2008 R2) and it's such a small dialogue box, fixed in size, not resizable. C'mon, M$...it's 2012...why the hell must I work within such a small box? Steve Russell or anyone working with a newer version -- please tell me this is only in the 2008 R2 version?!?!?!??? --- It has been that way for ever. ver 4.5 didn't have it but 6.0 did. snipped technical stuff Steve, I was talking about the ability to increase the screen size to make it easier to work with...nothing to do with technical stuff! :-) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ffee1a1.3070...@mbsoftwaresolutions.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.