Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

2016-04-26 Thread mbsoftwaresolutions
All of the sudden, when I go into VFP and choose something off the main menu, the dropdown area appears but it's all blank. As I scroll down over where the item choices would be, they appear as I scan over them. Same Windows version. Not sure if a recent Windows Update caused it? Very

Re: Using the Windows Event Log from Visual FoxPro

2016-04-26 Thread mbsoftwaresolutions
On 2016-04-25 13:31, Ted Roche wrote: Archive.org (the Internet Wayback Machine) has it cached, too, in case the first link gets broken: https://web.archive.org/web/2013060100*/http://www.craigberntson.com/docs/eventlog.pdf THAT worked. Thanks, Ted!

RE: Using the Windows Event Log from Visual FoxPro

2016-04-26 Thread mbsoftwaresolutions
Did that work for you??? Didn't work when I just tried it!!! On 2016-04-25 12:23, Chris Davis wrote: Didn't think of that did I! Cheers Mike. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Glassman Sent: 25 April 2016 17:16 To:

RE: Swap two variables

2016-04-21 Thread mbsoftwaresolutions
On 2016-04-21 10:54, Michael Glassman wrote: I don't think I've swapped variables since writing bubble sorts 40 years ago. +1 back in the late 80s first learning to program on a TRS-80 (BASIC) and then Apple IIe (Pascal). ___ Post Messages to:

Re: Water/Sewer billing software -- hopefully easy money opportunity

2016-04-21 Thread mbsoftwaresolutions
On 2016-04-21 11:23, Rick Becker wrote: Mike, I would be interested in talking with you about this to see what fit it might be. We have 4 Municipal/County software products used mostly in the state of Ohio. The products are currently written in VFP but we are biting the bullet and

Re: Water/Sewer billing software -- hopefully easy money opportunity

2016-04-20 Thread mbsoftwaresolutions
On 2016-04-20 15:32, Mike Copeland wrote: Comment and question... There are a LOT of very bad utility software packages being sold "out there." My brother is a council member in our small town (35k population) and they have had a continuous stream of really bad "solutions" that have wasted a

Re: Water/Sewer billing software -- hopefully easy money opportunity

2016-04-20 Thread mbsoftwaresolutions
On 2016-04-20 15:07, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I created a water billing software back in 2008. Here's a demo of it: http://mbsoftwaresolutions.com/demos/h2office/rough_overview_viewlet_swf.html (I realize some of those screens go by a bit too quick.) I'd like to

Water/Sewer billing software -- hopefully easy money opportunity

2016-04-20 Thread mbsoftwaresolutions
I created a water billing software back in 2008. Here's a demo of it: http://mbsoftwaresolutions.com/demos/h2office/rough_overview_viewlet_swf.html (I realize some of those screens go by a bit too quick.) I'd like to take this to the open market. If anyone would like to partner this with

Re: [ADMIN]

2016-04-20 Thread mbsoftwaresolutions
On 2016-04-13 13:54, Edward Leafe wrote: As promised, I'm not letting my missing my ride last fall stop me! I'm registered to ride in the 2016 Tour de Cure, which is a cycling event designed to raise money to help research for a cure for diabetes. The ride will take place on Saturday, May 14,

[NF] Digital signatures from NameCheap.com (was RE: Norton will not let me send EXE - Need help fast)

2016-04-19 Thread mbsoftwaresolutions
Got this from a colleague. I believe this was in response to EXEs from our site being flagged improperly, not due to A/V software improperly flagging it as a false-positive for a virus. --- You can get an SSL certificate

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-04-15 Thread mbsoftwaresolutions
On 2016-04-15 15:28, Ted Roche wrote: On Fri, Apr 15, 2016 at 2:57 PM, Gene Wirchenko wrote: Of course, if you were to create GUIDs, the universe would likely end first. GUIDs are not that bad, are they? Oh, indeed they are! The Entropy Heat Death of the Universe

Re: AVFP and Interesting link

2016-04-11 Thread mbsoftwaresolutions
On 2016-04-09 23:34, AndyHC wrote: I was browsing through the AVFP** discussion site and came across this link re. Foxpro speed: http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-for-importing-files ** anyone using it? I've got a test setup running fine locally and on

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-04-08 Thread mbsoftwaresolutions
On 2016-04-08 16:16, Ted Roche wrote: On Wed, Mar 9, 2016 at 6:17 PM, wrote: ...I did NOT want to use auto-increment keys in the tables because I wanted to have more control over them during data-entry, so basically, I can create all kinds of

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-04-05 Thread mbsoftwaresolutions
On 2016-04-05 14:45, Gene Wirchenko wrote: At 20:15 2016-04-04, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: [snip] Fortunately for me, neither Stephen whom I emailed nor I were offended. Sorry it offended you apparently, though. I'll try to not use Saturday Night Live skits in my

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-04-04 Thread mbsoftwaresolutions
On 2016-04-01 13:21, Gene Wirchenko wrote: At 12:15 2016-03-25, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2016-03-24 18:08, Gene Wirchenko wrote: At 13:17 2016-03-24, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2016-03-24 14:17, Stephen Russell wrote: You control freak.

Any Visual Maxframe Professionals here?

2016-04-04 Thread mbsoftwaresolutions
If you know anything about VMP (Visual Maxframe Professional), please shoot me an email at mbabcock at mbsoftwaresolutions dot com. I just have a few questions. Thanks! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: Email using .NET

2016-03-30 Thread mbsoftwaresolutions
On 2016-03-30 07:43, Ted Roche wrote: On Wed, Mar 30, 2016 at 7:02 AM, Laurie Alvey wrote: I currently use CDO to send email from my apps but I'm thinking of using a .NET component to do it. May I ask, "Why?" +1!!! "If it ain't broke, ..."

Used ReFox...CVW files?!??

2016-03-30 Thread mbsoftwaresolutions
On my way out the door now but wanted to start a thread on this. Used ReFox on Jeff's EXE and it seems to have worked for the most part (at least it extracted files and folders). I'll review them later today but noticed a bunch of files with a CVW extension. Binging it shows it to be a

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-28 Thread mbsoftwaresolutions
On 2016-03-28 11:01, Stephen Russell wrote: For me it was moving business that was prepped in test and easily moving it to production. The keys are no longer an issue. The issue with indexes is the free space available in an index page before it has to split into two pages for the same

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-27 Thread mbsoftwaresolutions
On 2016-03-26 11:25, Stephen Russell wrote: Michael please eliminate the steps I think are happening just dealing with the jobs table. 1. insert job row 2. get pkyey back 3. update masterKeyValues table I see 3 separate sql statements involving the first table. Every time you need

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-27 Thread mbsoftwaresolutions
On 2016-03-25 19:56, Ted Roche wrote: Satellite offices. With UUIDs, each app can create *unique* IDs that don't have to be changed when you merge IDs from multiple sources. Solves problems with roaming salesman, remote offices, off-line use, etc. This is why I went with the app-generated

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-27 Thread mbsoftwaresolutions
On 2016-03-25 18:23, Paul McNett wrote: On 3/9/16 3:17 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I created the new incarnation of FabMate a year ago with 16-byte character keys. Works fine, but I wanted to entertain the idea of using integer keys again instead (because I love

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-25 Thread mbsoftwaresolutions
On 2016-03-24 18:08, Gene Wirchenko wrote: At 13:17 2016-03-24, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2016-03-24 14:17, Stephen Russell wrote: You control freak. Let the backend do what it does so well. https://mariadb.com/kb/en/mariadb/auto_increment-faq/ I gave up on that

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-25 Thread mbsoftwaresolutions
Like GWB said, you must be using that "fuzzy math." lol I count many more than 2 tables: Jobs, Items (child to Jobs), Subitems (child to items), Materials (child to Items), Labor (child to Items), Installation (child to Items), etc. depending how many things deep you do. On 2016-03-24

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-24 Thread mbsoftwaresolutions
On 2016-03-24 14:17, Stephen Russell wrote: You control freak. Let the backend do what it does so well. https://mariadb.com/kb/en/mariadb/auto_increment-faq/ I gave up on that single table of last PKs 15 + years ago when I found that the backend already did it for us, all we had to was ask

VFP9SP2 grid display nuisance

2016-03-23 Thread mbsoftwaresolutions
http://screencast.com/t/dTqWXFqmr17W The data in the job name column appears to be top center justified, but as soon as you click in the column's textbox, it centers on the row as it should have displayed from the start. Anybody seen this and know how to resolve? tia, --Mike

RE: An Excel Automation Insert Issue...

2016-03-23 Thread mbsoftwaresolutions
On 2015-12-12 18:50, Richard Kaye wrote: The one I specifically mentioned to Kurt, ASSERT .f., will. I used this quite extensively just recently where I was working on a form that, for better or worse, has a lot of optional configurations and I'm moving or hiding controls. Sometimes I wanted to

Re: ReFox to reverse compile a VFP9 EXE?

2016-03-23 Thread mbsoftwaresolutions
On 2016-03-23 12:53, Wollenhaupt, Christof wrote: Can I use ReFox to somehow get the source code from the distributed EXE (assuming he didn't use ReFox to encrypt it)? Sure. You should be aware of three limitations, though: 1) Comments won't be recovered unless they are in a VCX/SCX file

Re: ReFox to reverse compile a VFP9 EXE?

2016-03-23 Thread mbsoftwaresolutions
On 2016-03-23 11:36, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I'm trying to help one of Jeff Johnson's (RIP) customers and sadly, they don't seem to have the source code. (Good lesson to be learned here.) Can I use ReFox to somehow get the source code from the distributed EXE

ReFox to reverse compile a VFP9 EXE?

2016-03-23 Thread mbsoftwaresolutions
I'm trying to help one of Jeff Johnson's (RIP) customers and sadly, they don't seem to have the source code. (Good lesson to be learned here.) Can I use ReFox to somehow get the source code from the distributed EXE (assuming he didn't use ReFox to encrypt it)? Other suggestions? tia,

Re: MariaDB ODBC Connector 1.0 for Windows in VFP

2016-03-20 Thread mbsoftwaresolutions
Wonder what the advantage is of using something past 3.51? On 2016-03-17 10:57, Fred Taylor wrote: The MySQL ODBC 5.3 ANSI driver works well, too. It does appear like they consider it a serious bug, and hopefully will be dealt with soon. Fred On Wed, Mar 16, 2016 at 6:45 PM, <

Re: MariaDB ODBC Connector 1.0 for Windows in VFP

2016-03-18 Thread mbsoftwaresolutions
On 2016-03-16 11:31, Fred Taylor wrote: I'll do that. I do find it a bit hard to believe that nobody else has run across this issue before. ...because the MySQL ODBC 3.51 driver works great! lol ___ Post Messages to: ProFox@leafe.com

Re: MariaDB ODBC Connector 1.0 for Windows in VFP

2016-03-15 Thread mbsoftwaresolutions
On 2016-03-15 15:48, Fred Taylor wrote: I do have several .INI file in the main folder where MariaDB is installed, but I'm not specifying any of them. Their names are: my-huge.ini my-innodb-heavy-4G.ini my-large.ini my-medium.ini my-small.ini wsrep.ini I would guess there is a default file

Re: MariaDB ODBC Connector 1.0 for Windows in VFP

2016-03-15 Thread mbsoftwaresolutions
On 2016-03-15 15:25, Ted Roche wrote: Sorry, I've got my Linux cap on :) I *think* under Windows the MySQL and MariaDB servers using an .INI file instead. It's been years since I attempted a WAMP install, so they might have moved it to the registry by now. What I was thinking was the server

Re: MariaDB ODBC Connector 1.0 for Windows in VFP

2016-03-15 Thread mbsoftwaresolutions
On 2016-03-15 14:36, Fred Taylor wrote: Anybody familiar with the MariaDB ODBC Connector for Windows? I can't get connected using it as I get an "Connectivity Error: Unknown system variable 'max_allowed_packet_size'". This is the 32 bit driver on a Win7 32bit machine. when using

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-12 Thread mbsoftwaresolutions
On 2016-03-11 17:18, Stephen Russell wrote: Field widths shouldn't make any difference, you do you varchar(50) or nvarchar(50) or (100) already don't you for the data outside of State? In all of my code the UI data is defined by the received data from the backend. I'm not talking about the

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-11 Thread mbsoftwaresolutions
On 2016-03-10 17:53, Stephen Russell wrote: Yes you do that all the time with sprocs. No biggie adding another one at the end. This is the list of params for an insert. ALTER PROCEDURE [dbo].[InvoiceLines_ins] @InvoiceLineID numeric(18,0), @InvoiceID numeric (18,0), @PositionNumber varchar

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
On 2016-03-10 17:22, Stephen Russell wrote: You will always have to change the UI. How many different places are you asking for the same data? If that was in a Sproc it is fixed all over the place now. If you have it as a statement you pas back you have to go to every occurrence in your

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
Now wait a second...you have to change the user interface who's calling that stored procedure, so there's TWO spots right there that need changing...the UI call and the actual SP itself. Or how am I reading that wrong? On 2016-03-10 13:53, Stephen Russell wrote: Change is great because

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
I realize it's done lots of places, but I never wanted explicit stored procedures for inserts/updates as they required update every time you changed a structure. That's too fragile/ridig a system for my liking. I'm thinking it'll be a stored procedure for the purpose of inserting something

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
On 2016-03-10 11:22, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: It's *almost* 15 years, and I always used this function in my framework: FUNCTION GetNewID(tiHandle as Integer) as Integer * Retrieves newly created ID from MYSQL backend. *** mjb 11/09/2011 - added here from Scheduler

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
On 2016-03-10 10:55, Stephen Russell wrote: "until I was absolutely sure I wanted to save the entire dataset." That is exactly what we are talking about. When user clicks save, submit, ok, button they are in save mode. Then you commit header row(s) retaining the fkey(s) necessary for your

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
On 2016-03-10 11:32, Stephen Russell wrote: I think there is confusion here. @@Identity returns the tables identity setting I thought, and in SQL Server it gives you your insert's PKey value. I don't do mySQL but still think that @@Identity gives you how your table is set for PKey

Re: [NF] MySQL InnoDB seems to use more space than MyISAM....why??

2016-03-10 Thread mbsoftwaresolutions
Perfect. Thanks! On 2016-03-10 12:02, Mike Copeland wrote: In general I would say that the designers of the InnoDB data storage file system were more concerned with transactional accuracy and row locking than they were with space efficiency. Here's a good concise (space efficient!) article

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
It's *almost* 15 years, and I always used this function in my framework: FUNCTION GetNewID(tiHandle as Integer) as Integer * Retrieves newly created ID from MYSQL backend. *** mjb 11/09/2011 - added here from Scheduler LOCAL liKey as Integer IF

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
On 2016-03-10 10:51, Stephen Russell wrote: You may get the incorrect value back buy doing this: So I'm thinking "how do I get something like VFP's old NextKey generation" akin to this: * this was pseudo-code, off the top of my head trying to remember my coding from 17+ years ago FUNCTION

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
I think you guys are missing the point of the original post. I just told him I didn't want to commit to disk immediately until I was absolutely sure I wanted to save the entire dataset. The original post title/question was basically "how do I replicate the same key generation we used to do

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
On 2016-03-10 05:12, AndyHC wrote: Use autoinc but wrap your child-parent-grandparent inserts in a transaction - or better still an SP. I don't like the idea of committing until I'm totally sure I want to add those records; hence the disconnected-until-ready-to-save approach.

Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-10 Thread mbsoftwaresolutions
On 2016-03-09 19:55, Stephen Russell wrote: why not this? INSERT INTO table_name (col1, col2,...) VALUES ('val1', 'val2'...);SELECT LAST_INSERT_ID(); Sometimes you have to use the tool as intended. Well that's basically what I'm doing, but it's in a framework so re-use is key. You don't

[NF] MySQL InnoDB seems to use more space than MyISAM....why??

2016-03-09 Thread mbsoftwaresolutions
tech: MySQL/MariaDB backend, version 5+ Anybody know why the same field structures but using the Inno engine type causes a table size to be much larger than if it's a MyISAM table type? I do realize the benefits of using InnoDB for transactions, btw. Just curious why MyISAM smaller, given

[NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

2016-03-09 Thread mbsoftwaresolutions
Tech used: VFP9SP2 against MySQL (MariaDB) backend I created the new incarnation of FabMate a year ago with 16-byte character keys. Works fine, but I wanted to entertain the idea of using integer keys again instead (because I love the idea of 4 bytes instead of 16) and I did NOT want to use

RE: [NF] So SQL Server is coming to Linux.

2016-03-09 Thread mbsoftwaresolutions
+2 On 2016-03-09 07:42, Richard Kaye wrote: +1 -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, March 09, 2016 7:05 AM To: profoxt...@leafe.com Subject: Re: [NF] So SQL Server is coming to Linux. In terms of

Re: [NF] Weird problems with Chrome

2016-03-09 Thread mbsoftwaresolutions
On 2016-03-09 09:36, Ted Roche wrote: https://support.google.com/chrome/troubleshooter/6273575?hl=en and https://productforums.google.com/forum/#!topic/chrome/626aIaLs2Nw solve 90% of the issues. Thanks for the links, Ted! I'll give that a shot. Was a bit hesitant to get rid of

RE: [NF] So SQL Server is coming to Linux.

2016-03-09 Thread mbsoftwaresolutions
On 2016-03-08 10:48, Dave Crozier wrote: Maybe another push is required on VFP now M$ has had a rethink Dave Certainly a better chance since no Ballmer but still, what benefit could there possibly be? What ROI? ___ Post Messages to:

[NF] Weird problems with Chrome

2016-03-08 Thread mbsoftwaresolutions
My Chrome (manually updated to the latest version as of yesterday, but these problems started BEFORE that) is behaving poorly. Pages that normally always worked (Facebook, LogMeIn, BG utility, etc.) are no longer working. They just seem to hang. Was thinking about dropping it and going back

Re: Best way to have multiple projects open simultaneously?

2016-03-04 Thread mbsoftwaresolutions
On 2016-03-04 06:34, Ted Roche wrote: On Fri, Mar 4, 2016 at 6:06 AM, Dave Crozier wrote: Also you can, of course, drag and drop from one project to another with no problems.. Something "obvious" which is often overlooked!! You can, though I generally advise against

RE: Best way to have multiple projects open simultaneously?

2016-03-04 Thread mbsoftwaresolutions
On 2016-03-04 06:06, Dave Crozier wrote: Also you can, of course, drag and drop from one project to another with no problems.. Something "obvious" which is often overlooked!! Dave That's what I was thinking! Wondered why no one else had mentioned that earlier!

Re: Import/Export with CSV

2016-02-28 Thread mbsoftwaresolutions
Sometimes I have to export data with fields that are all digits but are really character fields like PatientID, ClaimNumber, or similar where leadings zeros are necessary. I often prefix the field with an underscore to avoid have Excel screw me over. hth, --Mike On 2016-02-28 19:19, Sytze

RE: [NF] Best format(s) to publish old PPT slides to the web

2016-02-26 Thread mbsoftwaresolutions
No, I went and looked at some examples and at the bottom of one of them was a link back that had the dead link. On 2016-02-26 11:05, Kurt Wendt wrote: Mike - I'm confused! Alan gave the link w/o the 's' in the 'http'. And, it's not the site needs to be Secure - thus why it's not https. Do you

Re: [NF] Best format(s) to publish old PPT slides to the web

2016-02-26 Thread mbsoftwaresolutions
On 2016-02-26 09:28, Alan Bourke wrote: You could just do it in Visme (http://www.visme.co) note .co not .com This looks pretty cool! Someone should tell them that this link of theirs doesn't work though: https://visme.co/ Details: The webpage at https://visme.co/ might be temporarily

Re: Problem with GROUP BY

2016-02-20 Thread mbsoftwaresolutions
On 2016-02-20 15:34, Jean MAURICE wrote: Le 20/02/2016 21:28, mbsoftwaresoluti...@mbsoftwaresolutions.com a écrit : I've often thought: the order of your GROUPING doesn't matterdoes it? Either way, it's the same distinct combination. No if you have'nt an order by clause : by default the

RE: Problem with GROUP BY

2016-02-20 Thread mbsoftwaresolutions
On 2016-02-20 16:06, jerry foote wrote: Thanks for all the feed back on the group by clause. This what I ended up with SELECT service.manifest_n, service.bill_of_la, service.release_no, service.frm_acct, service.source,; service.source_id, sum(service.units) as totat FROM SERVICE WHERE

RE: Problem with GROUP BY

2016-02-20 Thread mbsoftwaresolutions
On 2016-02-20 15:24, Tracy Pearson wrote: When you have an aggregate (the sum), you should group by all the noon-aggregate fields. You could use the numbers for each field. Group by 3,1,2,4,5,6 I've often thought: the order of your GROUPING doesn't matterdoes it? Either way, it's the

RE: Problem with GROUP BY

2016-02-20 Thread mbsoftwaresolutions
Jerry -- you've got to list all non-aggregate fields in your GROUP BY. Example: SELECT Field1, Field2, Field3, Field4, sum(Field5) FROM YourTable GROUP BY Field1, Field2, Field3, Field4 INTO CURSOR Results hth, --Mike On 2016-02-20 14:53, jerry foote wrote: I have adjusted the code as below

RE: [NF][RANT] I need to stop playing 20 questions...

2016-02-19 Thread mbsoftwaresolutions
On 2016-02-19 16:26, Carl Lindner wrote: Good to see you're still here, Carl! I haven't seen any posts from you in a long while (but then again, I've been away at times too). --Mike ___ Post Messages to: ProFox@leafe.com Subscription

Re: [NF][RANT] I need to stop playing 20 questions...

2016-02-19 Thread mbsoftwaresolutions
On 2016-02-19 10:43, Ted Roche wrote: Of course we have, from "PC Load Letter? WTF?" to bad drivers to PCL5/6 incompatibilities to "I forgot to plug it in" to rodent droppings in the paper trays. Love the Office Space (movie) reference!!! LOL

Re: Remote Desktop Options

2016-02-17 Thread mbsoftwaresolutions
On 2016-02-17 17:39, Vince Teachout wrote: On 2/17/2016 4:31 PM, Richard Caruso wrote: Most of our clients use the Remote Desktop App RDP in Windows, but clients have experienced the session screen turning black after some time. We found a Columbus Remote Desktop that seems to work fine, but

Re: [NF] -- 20 years ago yesterday...

2016-02-17 Thread mbsoftwaresolutions
On 2016-02-17 11:12, Ed Leafe wrote: It both seems so long ago, and also so recent. How different these past 20 years would have been with Tom around... Cool thought. Wonder what would've been different with the VFP world? Sorry I never met the guy. Sounded awesome.

RE: DBF Compare

2016-02-16 Thread mbsoftwaresolutions
On 2016-02-12 11:07, Richard Caruso wrote: Stephen, the code is in the label3 click method --> use printcomp exclusive delete all pack append blank replace printcomp with thisform.edit1.value report form printcomp to printer prompt use May I ask why you did DELETE ALL and PACK rather than

Visual FoxPro Lifetime Achievement Awards?

2016-02-11 Thread mbsoftwaresolutions
Do they still do that? There's at least one guy here who definitely deserves that, given his tireless service to the community (and this list) over the years. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-09 Thread mbsoftwaresolutions
The fact that anyone thinks anything in VFP is "newer" tech is absolutely hilarious :D That new tech stuff ("Classes") were introduced I believe back in VFP3 (THREE). Others in the game longer than me can correct as needed. On 2016-02-09 09:49, Kurt Wendt wrote: Hey Mike - thanks

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-09 Thread mbsoftwaresolutions
On 2016-02-09 14:03, Brant E. Layton wrote: Hi Kurt, Sorry I didn't say anything sooner - another trick is to use a cursor containing a logical field. In the Grid, you add a checkbox (an additional control ) to the column assigned to the logical field. Then, the user can just click on the

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-09 Thread mbsoftwaresolutions
On 2016-02-09 15:56, Tracy Pearson wrote: Stephen Russell wrote on 2016-02-09: Have not iterated a vfp object in a decade but can't you go line by line in the object itself instead of mucking with fake data that needs an update from a few different possibilities? Isn't there a selected

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-09 Thread mbsoftwaresolutions
On 2016-02-09 15:40, Kurt Wendt wrote: The whole grid wasn't blank - only the lines that got selected. It was a background/foreground coloring issue. But, its an issue no more - it's been solved. Glad you solved it, Kurt. Did you use the DynamicBack/Fore -Color thingies?

Re: [NF] FTDI disables devices with counterfeit chips

2016-02-05 Thread mbsoftwaresolutions
On 2016-02-05 10:48, Ken Dibble wrote: It's not impossible. People need to be educated to do it. People need to stop buying into, or promoting, the notion of "do it yourself" general purpose computing. It was never appropriate for anyone but computer geeks. It's a failed concept in the larger

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-04 Thread mbsoftwaresolutions
On 2016-02-03 16:45, Kurt Wendt wrote: Wow - didn't realize I was 3 Hotfixes behind! But, I don't control it here. I just spoke to my manager about it - and, no - its not going to happen - no updating with HotFixes. No way to know if the hotfixes actually break something that was working - and

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-03 Thread mbsoftwaresolutions
On 2016-02-03 14:51, Kurt Wendt wrote: Mike - thanks for all your input. FYI - VFPSP2 v 9.00..5815 https://www.berezniker.com/content/pages/visual-foxpro/vfp-90-versions I've been testing of code on this test Form - and on there I have a Regular Grid and the subclassed Grid. So, I've

Why won't the font selection hold in this form I'm editing?

2016-02-03 Thread mbsoftwaresolutions
VFP9SP2+ I've got a form that insists on the Fox default font (Courier 10pt?), regardless of the fact that I've right-clicked in a method, chose Source Code Pro 14pt (btw, thanks Ted Roche for turning me onto that font years ago), and saved it. This usually works (whereby it sticks/saves

Table excluded from EXE (in same folder) versus table INCLUDING in EXE

2016-02-03 Thread mbsoftwaresolutions
I know somebody's got the quick answer based on their experience: if I have a table named Test.dbf which is INCLUDED in the EXE, ship that to the client, and they have a table in the same folder also called Test.dbf.which one gets read and which is ignored? I'm thinking the INCLUDED

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-03 Thread mbsoftwaresolutions
On 2016-02-03 09:07, Kurt Wendt wrote: OK Mike - so, I downloaded your code - grdbase.prg - and was reviewing it. So, the SaveSource and RestoreSource exists in your PRG as Procs. Should I simply take each chunk of code, create New Methods in the Grid Subclass - and insert the code - then call

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-03 Thread mbsoftwaresolutions
On 2016-02-03 11:15, Tracy Pearson wrote: Man-wai, I would suspect the Dymanic properties that fire code to update specific controls within the grid may cause a C5 if the cursor is not carefully handled. The best way to prevent oddities is, either set the RecordSource to an empty string and

RE: Table excluded from EXE (in same folder) versus table INCLUDING in EXE

2016-02-03 Thread mbsoftwaresolutions
On 2016-02-03 12:34, Tracy Pearson wrote: mbsoftwaresoluti...@mbsoftwaresolutions.com wrote on 2016-02-03: I know somebody's got the quick answer based on their experience: if I have a table named Test.dbf which is INCLUDED in the EXE, ship that to the client, and they have a table in the

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-03 Thread mbsoftwaresolutions
On 2016-02-03 12:58, Kurt Wendt wrote: Thanks Tracy - that's a good idea about the Escape key. I will Definitely try this out if I notice this crashing issue happening again - and may just Set Escape on in advance - just in case... You're using VFP9SP2 latest patch, right? Another issue

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-02 Thread mbsoftwaresolutions
On 2016-02-02 10:37, Richard Kaye wrote: Grids are tetchy critters and prone to blowing up with C5 errors, especially if you requery the datasource while its still associated with the object. In general, the tricks have been to temporarily reset it to nothing, rebuild your underlying datasource,

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-02 Thread mbsoftwaresolutions
On 2016-02-02 10:33, Kurt Wendt wrote: Hey Mike - thanks so much for pointing me to your code downloads. I haven't gotten to the point of re-querying the grid - but, I WILL have to do exactly that - and at that point I will look at your code. I'm actually having a Strange problem with this Grid

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-02-02 Thread mbsoftwaresolutions
Honestlywithout subclassing, I think I'd hate programming. It surely would not be as enjoyable. Check out the SaveSource and RestoreSource methods I posted in the ProFox downloads section to add to your grid subclass. Those are MUST HAVEs in my opinion so you never have to rebuild your

Re: Jeff Johnson

2016-01-31 Thread mbsoftwaresolutions
On 2016-01-30 21:27, Kevin Cully wrote: I'm going to miss him on the ProFox list. Certainly a nice contributor. I'll miss his posts too. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

Re: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

2016-01-30 Thread mbsoftwaresolutions
On 2016-01-29 17:20, Kurt Wendt wrote: To be honest - I hadn't sub-classed before, but, I figured it out and made a Grid sub-class. imo, subclassing is the BEST and will allow you to really love the Fox moreso. If I couldn't (or didn't) subclass, I might as well use VB. :-) OOP is

Re: [NF] Ed Yourdon

2016-01-30 Thread mbsoftwaresolutions
On 2016-01-30 16:58, Ken Dibble wrote: The media coverage of the problem was a hoax. The problem was very real. +1 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of

Re: [NF] Ed Yourdon

2016-01-30 Thread mbsoftwaresolutions
On 2016-01-29 08:10, Edward Leafe wrote: On Jan 28, 2016, at 7:53 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Sad news indeed but he did make a big mistake with his predictions about the severity of the Y2K problem despite selling a lot of books about it! He laughed all the way

Re: Jeff Johnson

2016-01-30 Thread mbsoftwaresolutions
I'm so sorry to hear that, Fred. I feared the worst when I didn't hear back from Jeff. He reached out to me earlier this month and was supposed to send me some stuff and when I didn't hear back, I feared the worst. He was a wonderful colleague. I met him (and you) back in 2002 at WhilFest

Re: [NF] VMWare Fusion in the news: team "culled"

2016-01-29 Thread mbsoftwaresolutions
On 2016-01-28 23:42, Michael Oke, II wrote: Makes me think twice about the purchase I was about to make. +1 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this

RE: [NF] Ed Yourdon

2016-01-28 Thread mbsoftwaresolutions
On 2016-01-28 03:38, Dave Crozier wrote: Sad news indeed but he did make a big mistake with his predictions about the severity of the Y2K problem despite selling a lot of books about it! He laughed all the way to the bank I'm sure about the Y2K work.

[NF] VMWare Fusion in the news: team "culled"

2016-01-28 Thread mbsoftwaresolutions
"Hey, let's outsource this. That will surely be a good move." said some failed projects https://www.bing.com/news/search?q=VMWare+Fusion=HDRSC6 Somebody here was talking about VMWare Fusion recently in that thread I had about a testing laptop.

Re: Norton blocking exe's

2016-01-28 Thread mbsoftwaresolutions
On 2016-01-28 06:34, Alan Bourke wrote: Norton should be nailed to a frisbee and flung over a rainbow. ROFLMAO!!! Agreed ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

Re: Alias()

2016-01-27 Thread mbsoftwaresolutions
On 2016-01-27 09:28, Ted Roche wrote: Sytze: "code" is a reserved word, the 4-letter abbreviation for "CODEPAGE" and would likely trip up the compiler in some cases. My favorite reason for using Hungarian notation in Fox ('lccode' and 'tccode' and 'ccode') is not for self-documentation, but to

RE: Norton will not let me send EXE - Need help fast

2016-01-25 Thread mbsoftwaresolutions
On 2016-01-25 10:38, Tracy Pearson wrote: Mike, This might be a little late for you. I just got forwarded an email from the boss asking about SHA-1 and SHA-256. Seems we actually got our certificate through a reseller of Comodo. K Software http://codesigning.ksoftware.net/ Their certificate,

RE: Norton will not let me send EXE - Need help fast

2016-01-25 Thread mbsoftwaresolutions
On 2016-01-25 17:18, Tracy Pearson wrote: Mike, I don't foresee a problem with the 256. It's more trouble than it is worth, and takes longer to crack. Currently From what I picked up from some of the reading I did today. Microsoft made this announcement back in 2014. I suspect we will have

RE: Norton will not let me send EXE - Need help fast

2016-01-23 Thread mbsoftwaresolutions
On 2016-01-22 20:43, Tracy Pearson wrote: I think what you're asking is going to depend on the tool you use to sign the exe. I sign the VFP exe then put it into an INNO installer, and sign that installer. Ah, so you sign BOTH? I thought I just needed to sign the Inno setup executable.

RE: Norton will not let me send EXE - Need help fast

2016-01-22 Thread mbsoftwaresolutions
On 2016-01-21 14:49, Tracy Pearson wrote: mbsoftwaresoluti...@mbsoftwaresolutions.com wrote on 2016-01-21: On 2016-01-21 12:04, Tracy Pearson wrote: Mike, We forked out less than that with a COMODO code signing certificate. Starts at 166.95/year. There might be less expensive providers

<    5   6   7   8   9   10   11   12   13   14   >