Re: Creating a copy of a database -- best practice?

2019-03-06 Thread mbsoftwaresolutions
On 2019-03-04 17:52, Fletcher Johnson wrote: Mike, I am assuming that the backup has to happen while the tables are in use (or you would just copy over the data folder via windows.) \ Creating the DBC programmatically should be easy (I seem to remember there is an option in VFP that

Re: MariaDB limitation on memo fields -- caps out at 255

2019-03-03 Thread mbsoftwaresolutions
On 2019-02-27 19:50, Eric Selje wrote: Well it's happened again where I discover a blog post I made that helps me towards a current problem. Looking here: http://saltydogllc.com/on-vfp-and-mysql-connectionstrings/ Here are the options (at the time, I doubt they've changed): 2 = Return matched

Re: Creating a copy of a database -- best practice? - checking email - did not come through before

2019-03-03 Thread mbsoftwaresolutions
On 2019-03-02 08:14, Charlie-gm wrote: Ok, I haven't done this in a while, but I think I have done this a few ways. First, by "metadata" of the database, I assume you mean stored procedures, maybe table triggers, database comment field? I'll also assume you are trying to run from within an

Re: UCLA & FoxPro...

2019-03-03 Thread mbsoftwaresolutions
On 2019-03-02 16:19, Kurt @ Gmail wrote: HA ha - Nice one Mike! Nope - its mainly FoxPro dev. in a logistics type dept. w/in UCLA. Downside - pay is TERRIBLE!!! Its a tad more than 1/2 my last salary! Ugh... I can't believe they want someone with Exp. - serious VFP/FoxPro exp. - yet, only want

Re: Windows 10 Home and VFP9SP2 apps

2019-03-01 Thread mbsoftwaresolutions
Thanks Tracey and John! On 2019-03-01 17:06, Tracy Pearson wrote: Yes. VFP 9 installs on HOME, and I have several customers that I've seen using HOME with our product. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of

Re: UCLA & FoxPro...

2019-03-01 Thread mbsoftwaresolutions
On 2019-03-01 15:53, Vince Teachout wrote: On 03/01/19 2:33 PM, Kurt @ Gmail wrote: Yup - if you can believe (which I am sure you folks can - since Uni's at time tend to be a bit behind in Tech.) - they actually have a job opening with FoxPro being the core of the job. Just finished doing a

Windows 10 Home and VFP9SP2 apps

2019-03-01 Thread mbsoftwaresolutions
VFP9SP2 apps work fine on Windows 10 HOME, right? I know they work fine on Win10 Professional but am double-checking the HOME version. tia, --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Creating a copy of a database -- best practice?

2019-03-01 Thread mbsoftwaresolutions
On 2019-03-01 05:08, Peter Cushing wrote: Hi Mike, Your COPY TO won't give you all the meta data, which is what you wanted in the first place.  When you already have a copy of the system the meta data is already there, you are just updating the data. HTH Peter Cushing IT Department

Re: MariaDB limitation on memo fields -- caps out at 255

2019-03-01 Thread mbsoftwaresolutions
On 2019-02-27 19:50, Eric Selje wrote: Well it's happened again where I discover a blog post I made that helps me towards a current problem. Looking here: http://saltydogllc.com/on-vfp-and-mysql-connectionstrings/ Here are the options (at the time, I doubt they've changed): 2 = Return matched

Re: [NF] Learn about Stored Procedures

2019-02-28 Thread mbsoftwaresolutions
On 2019-02-28 09:45, Stephen Russell wrote: I have some long stored procedures that are in the 3000 lines long arena Jesus...that makes my head hurt just thinking about that. I get the efficiency angle but I really enjoy breaking work up into much more manageable/readable units in the

Re: Creating a copy of a database -- best practice?

2019-02-28 Thread mbsoftwaresolutions
On 2019-02-28 07:08, Stephen Russell wrote: Why not make a compressed file of the entire folder where the data lies? After file is created move it to a different machine off the network. Because I think open DBFs would present a problem with that approach???

Re: Creating a copy of a database -- best practice?

2019-02-28 Thread mbsoftwaresolutions
On 2019-02-28 04:43, Peter Cushing wrote: On 27/02/2019 17:22, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I can easily do something like this: CREATE DATABASE C:\Backup\MyDBC.dbc OPEN DATABASE C:\Production\MyDBC.dbc liNumTables = adbobjects(laTables,'TABLE') for ii = 1 to liNumTables

Re: false news....

2019-02-27 Thread mbsoftwaresolutions
On 2019-02-22 14:50, Kevin Cully wrote: There are a ton of VFP developers and they've never reached out to their community to improve their skills and it shows in their code. So true! Together, we're better. ___ Post Messages to:

Re: MariaDB limitation on memo fields -- caps out at 255 (SOLVED)

2019-02-27 Thread mbsoftwaresolutions
On 2019-02-23 01:23, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2019-02-18 15:50, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: My VFP9SP2 app connects to my web database with no issue. My client wanted to host the database on his network there so I installed MariaDB there and

Creating a copy of a database -- best practice?

2019-02-27 Thread mbsoftwaresolutions
I can easily do something like this: CREATE DATABASE C:\Backup\MyDBC.dbc OPEN DATABASE C:\Production\MyDBC.dbc liNumTables = adbobjects(laTables,'TABLE') for ii = 1 to liNumTables lcFile = forceext("C:\BACKUP\" + laTables[ii],'dbf') use laTables[ii] copy to (lcFile) database

Re: MariaDB limitation on memo fields -- caps out at 255

2019-02-27 Thread mbsoftwaresolutions
I'd appreciate that, Eric. I'm using 67174427. On 2019-02-25 14:42, Eric Selje wrote: Yes I'd check your ConnectionString Options. Whil Hentzen's book about devloping with Fox and MySQL (Maria) goes over all of those. I can check it if you'd like. Eric On Mon, Feb 18, 2019 at 7:36 PM

Re: MariaDB limitation on memo fields -- caps out at 255 (SOLVED)

2019-02-22 Thread mbsoftwaresolutions
On 2019-02-18 15:50, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: My VFP9SP2 app connects to my web database with no issue. My client wanted to host the database on his network there so I installed MariaDB there and everything seemed to fire up just fine. HOWEVER, there's a problem with

Re: VFP application issues on new server

2019-02-22 Thread mbsoftwaresolutions
On 2019-02-05 05:50, Chris Davis wrote: It's all server 2016 -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: Tuesday, 05 February 2019 10:29 To: profoxt...@leafe.com Subject: Re: VFP application issues on new server What are the operating systems in question ?

Cryptovirus hit one of my clients

2019-02-22 Thread mbsoftwaresolutions
Got a call from a client today who was having some sort of error with the program/website (WestWind WebConnection). I remoted in to see that EVERY file had been renamed to something like filename.ext.decrypt12...@qq.com. Told them their IT vendor would have to restore from their last backup

Re: SFTP

2019-02-19 Thread mbsoftwaresolutions
On 2019-02-19 13:18, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2019-02-19 08:45, Chris Davis wrote: Yes please! https://leafe.com/dls/vfp It's the top of the list from ProFox's very own Dave Crozier. ;-) Oh Chris...I'm sorryre-reading Dave's comments in that listing says

Re: SFTP

2019-02-19 Thread mbsoftwaresolutions
On 2019-02-19 08:45, Chris Davis wrote: Yes please! https://leafe.com/dls/vfp It's the top of the list from ProFox's very own Dave Crozier. ;-) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: MariaDB limitation on memo fields -- caps out at 255

2019-02-18 Thread mbsoftwaresolutions
On 2019-02-18 18:07, Fred Taylor wrote: Mike, Are you sure it's not a TINYTEXT field? TINYTEXT is 0 to 255 chars. TEXT is 65,535 And MEDIUMTEXT is 16,777,215. Fred I'll double-check but I'm thinking it's my connection string OPTIONS value.

MariaDB limitation on memo fields -- caps out at 255

2019-02-18 Thread mbsoftwaresolutions
My VFP9SP2 app connects to my web database with no issue. My client wanted to host the database on his network there so I installed MariaDB there and everything seemed to fire up just fine. HOWEVER, there's a problem with the memo fields capping at length=255. Given that it works with a

Re: SFTP

2019-02-18 Thread mbsoftwaresolutions
On 2019-02-08 06:09, Chris Davis wrote: Me again, sorry! I have been using vfpconnection for sometime now, very useful! However I have now got a ftp server that I wont connect to. The url I have been given starts SFTP, vfpconnection only seems to support FTPS. When I use FTPS I just send

Re: ERD with a table with strange keys

2019-01-26 Thread mbsoftwaresolutions
On 2019-01-26 12:22, Ted Roche wrote: Adam: Not a UML expert, but it seems like the restrictions tables has a "Many-To-Many" relationship with Country and Category. By having no unique PK of it's own, it's implied that there is only one record for each combination of country and category. So

Re: [ADMIN] Testing new mail relay

2019-01-09 Thread mbsoftwaresolutions
On 2019-01-09 16:02, Ed Leafe wrote: On Jan 9, 2019, at 2:54 PM, Kurt @ Gmail wrote: Ed - I really do NOT think you should use this service - since its Pricey - and there's NO Reason why you should pay for the service when these forums don't even Net you ANY $$$! Most months were below

Re: [ADMIN] Testing new mail relay

2019-01-09 Thread mbsoftwaresolutions
On 2019-01-09 14:13, Ed Leafe wrote: On Jan 9, 2019, at 12:58 PM, Gene Wirchenko wrote: The numbers do not make sense. Does that "100K" mean 100,000 messages or 100 kilobytes? How does 280 relate to 133,000? It’s a monthly limit on the number of messages. And as Ted pointed out, each

Re: Custom Scrollbar

2019-01-09 Thread mbsoftwaresolutions
At 08:18 2019-01-06, Jean Laeremans wrote: If memory serves me right he must be at it for at least 15 years. lol...we've been hanging around this barber shop for quite a long time ;-) ___ Post Messages to: ProFox@leafe.com Subscription

Re: [ADMIN] Testing new mail relay

2019-01-09 Thread mbsoftwaresolutions
On 2019-01-09 13:51, Ed Leafe wrote: Many of you have had problems receiving mail from the list, as my domain is hosted on a server in the cloud, and many ISPs have blanket blocks on any IP addresses from cloud providers like mine (Digital Ocean). I’m testing out a new relay service, Mailgun

Re: AW: Custom Scrollbar

2019-01-09 Thread mbsoftwaresolutions
Gene, correct me if I'm wrong, but as far back as this list goes, I remember you talking about your own VFP grid replacement, honestly as far back as 15+ years ago. Am I right? On 2019-01-07 00:20, Gene Wirchenko wrote: At 08:13 2019-01-06, wrote: >> I want to create my own grid WHY,

Re: VSS to git conversion

2019-01-04 Thread mbsoftwaresolutions
On 2019-01-03 11:29, Tracy Pearson wrote: We are looking at changing things over from VSS to git. There are about 20 projects that we want to transfer the history of the files in to git. However, we do not want to transfer the binary files over. We haven't been using the FoxBin2PRG since we

Re: Fox Team member now MSFT CMO

2018-12-20 Thread mbsoftwaresolutions
On 2018-12-20 09:34, Ted Roche wrote: Some of you may remember Chris Capposella from the 1993 DevCon Orlando "Challenge Me!" skits.: https://flic.kr/s/aHsjDMvYaF (pictures by the late Geary Rachel, used with permission) Amazingly, Chris is STILL with MSFT, his title now: CMO. Featured on

[ADMIN] Problem with list archives

2018-11-27 Thread mbsoftwaresolutions
I wanted to review past posts for protecting your distributed EXEs. I recall I asked about this a couple years ago. I found this in my 'armadillo' search: https://leafe.com/archives/msg/506233 However, when clicking the "View entire thread" (https://leafe.com/archives/full_thread/506233),

Re: AW: Visual FoxPro Toolkit for .NET

2018-11-21 Thread mbsoftwaresolutions
Yeah, I was gonna ask the Freshness Date of this. On 2018-11-21 16:21, juer...@wondzinski.de wrote: What do you expect from a NET Class-library from 2002 ? -Ursprüngliche Nachricht- Von: ProFox Im Auftrag von Paul Newton Gesendet: Mittwoch, 21. November 2018 15:07 An:

Re: AW: Reallocating drive space

2018-11-20 Thread mbsoftwaresolutions
On 2018-11-20 04:40, juer...@wondzinski.de wrote: Maybe you should first clean up your C drive: Open a CMD window with administrative Rights. Start "CleanMgr /sageset:1" In that dialogue select all entries, beside of "User Shadow Copies" Close it. That selection is now saved as "set 1" Now

Re: Reallocating drive space

2018-11-19 Thread mbsoftwaresolutions
On 2018-11-19 13:51, Fernando D. Bozzo wrote: Without any doubt, you shoul try SpaceSniffer, the best freeware program I'd use to know what is eating the disks: http://www.uderzo.it/main_products/space_sniffer/ Wow...cool tool! https://www.screencast.com/t/6cAL9mi6 Thanks!!!

Re: Reallocating drive space

2018-11-19 Thread mbsoftwaresolutions
On 2018-11-19 13:50, Michael Oke, II wrote: You will want to check your Windows Temp folder. It can eat up gigabytes of disc space with nothing relevant to keeping your system operating. Already had moved that to D: drive in the config setup. Good tip, though...thx!

Re: Reallocating drive space

2018-11-19 Thread mbsoftwaresolutions
On 2018-11-19 13:47, Stephen Russell wrote: This utility may allow you to find the log file that is eating you your space? https://jam-software.com/treesize_free/ Been using this for 5 years now I believe. That link is not working for me, Stephen: https://www.screencast.com/t/flnEFeb1l

Re: Reallocating drive space

2018-11-19 Thread mbsoftwaresolutions
On 2018-11-19 13:39, Paul Hill wrote: On Mon, 19 Nov 2018 at 18:17, wrote: See screenshot showing my C: drive near full and plenty of space on my D: drive allocation: https://www.screencast.com/t/eaW92AgbXXF. It's the same 512 GB SSD drive. What's the easiest way to reallocate space, to

Re: Big Changes & Fox Work in SF Bay Area?

2018-11-19 Thread mbsoftwaresolutions
On 2018-11-17 21:12, Kurt at VR-FX wrote: Very funny Mike!!! Well - am in Cali since my sister lives here in SF. Definitely cheaper to live with somebody! :D ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Reallocating drive space

2018-11-19 Thread mbsoftwaresolutions
See screenshot showing my C: drive near full and plenty of space on my D: drive allocation: https://www.screencast.com/t/eaW92AgbXXF. It's the same 512 GB SSD drive. What's the easiest way to reallocate space, to take XX GB from D: and apply to C: drive? tia, --Mike

Re: Big Changes & Fox Work in SF Bay Area?

2018-11-17 Thread mbsoftwaresolutions
Best of luck, Kurt! I recall you were in NYC, and now I see you're in Cali. Wow...you love the high rent states, eh? lol On 2018-11-15 19:30, Fletcher Johnson wrote: Kurt, Welcome to CA! Nice to know another VFP/FP guy in the area (there aren't that many left) The last time I

How can you tell the difference programatically between Windows 8 and Windows 10 (from the desktop, not server versions)?

2018-11-14 Thread mbsoftwaresolutions
VFP9SP2 According to http://fox.wikis.com/wc.dll?Wiki~VFPFunctionOS, it looks like 8 and 10 return the same values? Windows 7 Windows 6.01OS(5) returns "7600" AND OS(11) returns "1" Windows 7 SP1 Windows 6.01OS(5) returns "7601" AND OS(11) returns "1" Windows 8 Dev Preview

[NF] Alternatives to Peachtree Accounting software?

2018-11-13 Thread mbsoftwaresolutions
I have a potential client who desires to replace his Peachtree accounting software for their company. Will find out more but wondered if anyone here has replaced PeachTree with something else? ___ Post Messages to: ProFox@leafe.com Subscription

Re: Report with data from 2 unrelated siblings

2018-11-09 Thread mbsoftwaresolutions
This was my attempt to build the data, but I get doubling up: Will putting a DISTINCT in your SELECT fix that? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this

Re: CDO Email issues all of the sudden? VFP9SP2 app running for years without issue

2018-11-09 Thread mbsoftwaresolutions
On 2018-11-09 02:51, Koen Piller wrote: Gmail has changed its policy. Advise you to switch to an other mailprovider Koen Hi Koen, I know GMail had changed policy awhile back (2 yrs ago?) whereby I had to set it to use "Less secure apps" option to enable this emailing. Has it changed yet

CDO Email issues all of the sudden? VFP9SP2 app running for years without issue

2018-11-08 Thread mbsoftwaresolutions
VFP9SP2 Strange...code that has been working for years using my mbss.b...@gmail.com as the sender now doesn't want to work. Good ol' Error 1429. See screenshot: https://www.screencast.com/t/Bxe0x4CX I know some of you here use CDO. Did you notice any problems this year? I checked that

Re: [NF] Web Assembly anyone?

2018-11-05 Thread mbsoftwaresolutions
On 2018-11-05 03:43, Alan Bourke wrote: Yes please! Anything that hastens the demise of Javascript is absolutely fine by me. LOL! You mean that "old" technology that suddenly became all the rage again? Maybe there's hope for VFP yet. LOL ___

Re: [NF] Tool for editing multiple files for huge search/replace operation

2018-10-29 Thread mbsoftwaresolutions
On 2018-10-29 18:25, Richard Kaye wrote: GoFish has replace functionality.  Pretty much any decent text editor will have a find and replace in files function. For example, I still use TextPad from Helios Software as my primary text editor and it does that sort of thing. ...to manually

Re: AW: [NF] Tool for editing multiple files for huge search/replace operation

2018-10-29 Thread mbsoftwaresolutions
On 2018-10-29 20:27, Ken McGinnis wrote: Yes it does. I use the "Code References" tool from FoxPro a lot. I stopped using the global search and replace because it can destroy the files. There may be a way to make it work, but I manually go through the list of files now and it works well. I

[NF] Tool for editing multiple files for huge search/replace operation

2018-10-29 Thread mbsoftwaresolutions
Literally about 10 years ago, I'm pretty sure this list suggested a tool that I used to update several text files in a common folder; it was a big "replace text 123 with 456" kind of thing. But alas, my memory is failing me and I can't recall what the tool was called. Anybody know of such a

Re: [NF] Broken Windows

2018-10-25 Thread mbsoftwaresolutions
On 2018-10-25 10:34, Ted Roche wrote: Perhaps they should rewrite it. Third time's the charm, or so they mythology goes within MS. Highly recommended: https://en.wikipedia.org/wiki/Microsoft_Windows for a refresher on the history. Good overview. I'm pretty safe in saying they will NEVER

.h files included or excluded in your project?

2018-10-24 Thread mbsoftwaresolutions
VFP9SP2 Since .h #INCLUDE files are only utilized at build time, is there any reason you'd want to include the .h files in the EXE? I'm thinking "no." ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] Broken Windows

2018-10-24 Thread mbsoftwaresolutions
On 2018-10-24 04:51, Alan Bourke wrote: I think Windows has gotten too complex for MS to understand. Shadow directories and fake redirections and everything dependent not on the OS or the File System, but the Registry, may just be a step too far. What's actually happened is described pretty

CleverFox backup tool

2018-10-24 Thread mbsoftwaresolutions
Hey ProFox Community, Just wanted to give an endorsement to Rick Schummer's and Frank Perez' automatic VFP backup product, CleverFox: https://cleverfoxbackup.com/ I use it for some of the Sylvan franchisees I support and it's been great. Not only is it affordable but it's super easy too. I

Re: [NF] Microsoft Dynamics

2018-10-23 Thread mbsoftwaresolutions
On 2018-10-23 14:53, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2018-10-23 14:12, Stephen Russell wrote: Dynamics is an ERP that has a tremendous amount of set up that identifies how things play out in all the different processes that are happening. An Order my now take 10+

Re: [NF] Microsoft Dynamics

2018-10-23 Thread mbsoftwaresolutions
On 2018-10-23 14:12, Stephen Russell wrote: Dynamics is an ERP that has a tremendous amount of set up that identifies how things play out in all the different processes that are happening. An Order my now take 10+ different operations to take it in status from New to Shipped. It probably has

[NF] Microsoft Dynamics

2018-10-23 Thread mbsoftwaresolutions
Anyone here have a GOOD experience with Microsoft Dynamics? I just saw a former company of mine using it to replace an app I solidified years ago...and I gotta say, this replacement looks very rough...not user-friendly and klunky. Interested in your experience with it.

Re: VFP9SP2 & Excel automation -- how to enter this formula into a cell programatically from VFP?

2018-10-16 Thread mbsoftwaresolutions
Thanks, Fred. I was so close! On 2018-10-15 17:18, Fred Taylor wrote: ox.Cells(yourrow,yourcolumn).Formula = [=(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1)] Fred On Mon, Oct 15, 2018 at 2:06 PM wrote: I forgot to post the formula in text here:

Re: VFP9SP2 & Excel automation -- how to enter this formula into a cell programatically from VFP?

2018-10-15 Thread mbsoftwaresolutions
I forgot to post the formula in text here: =(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1) I can't get that entered programatically from VFP. On 2018-10-15 17:05, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: See screenshot: https://www.screencast.com/t/wzLweduy General

VFP9SP2 & Excel automation -- how to enter this formula into a cell programatically from VFP?

2018-10-15 Thread mbsoftwaresolutions
See screenshot: https://www.screencast.com/t/wzLweduy General scenario: 2 input datetime values, with output being the native Excel command NetworkDays result on those 2 cells using 9 a.m. to 5:30 p.m. bounds, giving me the time elapsed between DateTime1 and DateTime2. I want to supply a

Re: [NF] Solo Consultant Home Office/Small Office phone recommendations?

2018-10-15 Thread mbsoftwaresolutions
On 2018-10-09 10:55, Ted Roche wrote: Thinking of cord-cutting the landline. My office phone is running close to $70 a month, as long as I don't use any "long distance" and the office is just me now, and there are rarely more than two hours of phone a month. For $850 a year, I'm thinking a

Error with Thor's PEMEditor app

2018-09-24 Thread mbsoftwaresolutions
VFP9SP2, latest version of PEMEditor, It's weird. On my home dev machine, I have no problems at all, but on my corporate gig laptop, whenever I add a property or method using PEMEditor, I get this error every time (https://www.screencast.com/t/jGjInCmNtCk) although it continues after I

Reading emails from a VFP app and creating "tickets" based on them

2018-09-20 Thread mbsoftwaresolutions
VFP9SP2, Network Solutions web email account We've got a clunky manual process here at the Corporate gig whereby we have an Excel file we track customer interactions, and several of those interactions come from incoming email. Boss wants solution that auto-creates tickets based on incoming

Re: ON KEY usage in your apps

2018-09-19 Thread mbsoftwaresolutions
On 2018-09-19 11:19, Frank Cazabon wrote: I thought set help on and set help to automatically make the F1 key work without having to use on key label. At least I have never had to set on key label f1 to get my help to work in my applications. I never used the integrated help like that. My

Re: ON KEY usage in your apps

2018-09-19 Thread mbsoftwaresolutions
On 2018-09-19 04:51, Alan Bourke wrote: We use ON KEY LABEL F1 for throwing up the application help file. Aside from that we almost exclusively use form KeyPreview() methods I think. I think I used the form.KeyPreview method maybe once or twice in 20 years. H.

Re: ON KEY usage in your apps

2018-09-19 Thread mbsoftwaresolutions
On 2018-09-19 09:36, Stephen Russell wrote: I wrote software for the used car business and one early customer paid me big money to put an ON KEY command to format the hard disk. This was either in 89 or 1990 time frame. LOL!!! Sounds like the "self-destruct button" on the St. Georges

Re: ON KEY usage in your apps

2018-09-18 Thread mbsoftwaresolutions
On 2018-09-18 19:29, Frank Cazabon wrote: Not sure I'm understanding. Do you want to allow editing in the grid or do you want a popup form to edit the records from the grid? I've always used a separate form for single record add/edit. Then took that object and validated it in the business

Re: ON KEY usage in your apps

2018-09-18 Thread mbsoftwaresolutions
On 2018-09-18 21:18, Gene Wirchenko wrote: I use on key label "ctrl+0" * so .null. can not be entered into controls. Clever ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: ON KEY usage in your apps

2018-09-18 Thread mbsoftwaresolutions
On 2018-09-18 17:03, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 on Win7/8/10 pcs I really never fully took advantage of this gem in VFP. In my apps, I haven't allowed editing in grids in probably 14 years. Some of my users seem to want that though so I'm thinking of allowing

ON KEY usage in your apps

2018-09-18 Thread mbsoftwaresolutions
VFP9SP2 on Win7/8/10 pcs I really never fully took advantage of this gem in VFP. In my apps, I haven't allowed editing in grids in probably 14 years. Some of my users seem to want that though so I'm thinking of allowing such ability now. I was thinking of using ON KEY to pop up a lookup

Re: Good old fashioned FTP need from VFP app

2018-09-10 Thread mbsoftwaresolutions
On 2018-09-10 10:59, Dave Crozier wrote: I have a full VFP FTP Client class (Passive and non Passive) I could post on the archives if anyone is interested. Dave Crozier Software Development Manager Flexipol Packaging Ltd. Absolutely, Dave! It's always good to contribute to the VFP

Re: Good old fashioned FTP need from VFP app

2018-09-08 Thread mbsoftwaresolutions
On 2018-09-08 18:20, Koen Piller wrote: Use dropbox From VFP? I'm designing an automated solution that will fire every day. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

Good old fashioned FTP need from VFP app

2018-09-08 Thread mbsoftwaresolutions
Got a client need for me to FTP some data of theirs to a 3rd party vendor. Nothing fancy, just regular FTP (not SFTP, not FTP-S). Many moons ago I interacted with Robert Abrams VFP class (wow...I think that was VFP5 days?!?!?). What do folks use nowadays for FTP from a VFP app? tia, --Mike

Re: Problem with VFP's debugger not seeing C# object's properties

2018-09-08 Thread mbsoftwaresolutions
On 2018-09-08 10:29, Koen Piller wrote: Mike, VFP debugger will show you the properties of those objects only when you select the object selve, not the parent of the object, which you have done in this picture Rgds, Koen Hi Koen, Even if I select the object via single or double click, a

Problem with VFP's debugger not seeing C# object's properties

2018-09-08 Thread mbsoftwaresolutions
VFPSP2 consuming C# (maybe version 3.5 or later?) See screenshot: https://www.screencast.com/t/bb0Xfu2KuMpC Is there a way I can have the C# guy somehow expose the properties somehow? tia, --Mike ___ Post Messages to: ProFox@leafe.com

Re: 2 Excel questions using automation from VFP9SP2

2018-09-07 Thread mbsoftwaresolutions
On 2018-09-05 17:45, Richard Kaye wrote: 1 - set the saved property to .t. before you get rid of the Excel object. m.loExcel.ActiveWorkbook.Saved=.t. That worked greatThanks, Richard! ___ Post Messages to: ProFox@leafe.com Subscription

Re: 2 Excel questions using automation from VFP9SP2

2018-09-06 Thread mbsoftwaresolutions
On 2018-09-06 20:31, Frank Cazabon wrote: On 06/09/2018 04:38 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: it's a slick formula for determining the TIME that's passed within the workday hours set (not just days; that'd be simple). Are you sure about that? Everywhere I've looked it

Re: 2 Excel questions using automation from VFP9SP2

2018-09-06 Thread mbsoftwaresolutions
On 2018-09-06 17:41, Stephen Russell wrote: Do you have a table for Holidays? We use it in our system but it also identifies the country you are in for work. We are USA, CA, UK for now. I too tried the formula in base format in excel and it returns days when my two cells were 7-30-2018

Re: SOAP

2018-09-06 Thread mbsoftwaresolutions
On 2018-09-06 09:30, Stephen Russell wrote: Today the industry is changing the name from Web Service to API but in general it works in much the same way. But I get the impression that it's easier to work with the APIs? ___ Post Messages to:

Re: 2 Excel questions using automation from VFP9SP2

2018-09-06 Thread mbsoftwaresolutions
No no...despite the name, it's not a count of days; it's a count of the TIME (hours/minutes) within the workday parameters set. Counting days would be easy. On 2018-09-05 18:22, Stephen Russell wrote: Idea on network days for loop between the days insert to a cursor if the DOW if not a

Re: 2 Excel questions using automation from VFP9SP2

2018-09-06 Thread mbsoftwaresolutions
On 2018-09-05 17:54, Frank Cazabon wrote: I use a calendar table (albeit in SQL server but that shouldn't matter). Then it's just a matter of some simple queries. On 5 September 2018 16:47:27 GMT-04:00, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: See screenshot for case matter:

2 Excel questions using automation from VFP9SP2

2018-09-05 Thread mbsoftwaresolutions
See screenshot for case matter: https://www.screencast.com/t/VNdRiSd1D 1) (rose highlight) I've forgotten how to get Excel to close without asking me this every time. Currently, I'm just calling the .Quit() method of my Excel object. I tried passing a .T. parm but that failed. 2) (yellow

Re: Contacting folks on GitHub

2018-08-24 Thread mbsoftwaresolutions
Hi Gianni, Thanks for those email links. I'll try those. (As for the screenshots, I always post a link...you can't attach screenshots to profox emails!) On 2018-08-24 19:31, Gianni Turri wrote: Hi Mike, please post a link whenever is possible instead of screenshots. At the project link

Contacting folks on GitHub

2018-08-24 Thread mbsoftwaresolutions
Screenshot: https://www.screencast.com/t/O6mkbvxNL7jU I see this guy was the last to work on FoxCharts so I wanted to email him or contact him somehow, but I don't see how this page allows me to do that? Wouldn't you think you could click on the name and send some sort of communication?

Re: MCP ID

2018-08-24 Thread mbsoftwaresolutions
On 2018-08-24 16:20, Garrett Fitzgerald wrote: Did you click on Your Dashboard? That takes me to a page where I can see my transcript, certificates, wallet cards, etc. Ah there it is. THANK YOU! ___ Post Messages to: ProFox@leafe.com

Re: MCP ID

2018-08-24 Thread mbsoftwaresolutions
On 2018-08-24 13:57, Garrett Fitzgerald wrote: You should be able to log in and look it up at https://www.microsoft.com/en-us/learning/certification-overview.aspx. I logged into my account but don't see anything about my MCP status. It's just advertising for their latest tracks:

FoxCharts pie question

2018-08-24 Thread mbsoftwaresolutions
Here's a screenshot of what I've manually done in Excel: https://www.screencast.com/t/iTHjVOSd2mD I want to create the labels of the pie to have the name too (not just the total number or percentage for that section). Anyone done that before? The demos in the Foxcharts sample app don't

MCP ID

2018-08-24 Thread mbsoftwaresolutions
Current Corporate gig is asking for anyone with MCP status to provide their MCP ID, regardless of its status. I got my MCP for both desktop and distributed systems years ago, but I can't recall what the ID was. Do other MCPs here know their ID? I'm wondering if they even had IDs way back

Re: Lianja anyone?

2018-08-23 Thread mbsoftwaresolutions
On 2018-08-22 12:27, Alan Bourke wrote: On Wed, 22 Aug 2018, at 3:51 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2018-08-17 10:08, Dave Crozier wrote: They've got 500MB of data in some centers with 20+ years of data Not *that* big in Fox terms ... running some reports

Re: Frustrations on anchor=15 resizing not happening until I go off the page and come back to it (SOLVED)

2018-08-22 Thread mbsoftwaresolutions
On 2018-08-22 10:43, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 using FoxCharts (1.37 and 1.46beta) I've got FoxCharts working somewhat in my testing so far, but I can't get the first showing page to fully resize automatically and some trickery I've tried is driving me nuts.

Re: Frustrations on anchor=15 resizing not happening until I go off the page and come back to it

2018-08-22 Thread mbsoftwaresolutions
On 2018-08-22 11:21, Richard Kaye wrote: Is the chart container magically zooming when you activate the 2nd page? If so, what code is executing at that time? I used EVENTTRACKING to tell me. I set ET on in the pag1.Deactivate and turned it back off in the pag1.Activate (so when I navigated

Re: Every day a school day.

2018-08-22 Thread mbsoftwaresolutions
On 2018-07-31 05:49, Alan Bourke wrote: On Tue, 31 Jul 2018, at 5:57 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I pretty much only use it with arrays. What else would you use it for??? Collections I guess? I only use it for collections, due to the fact that I avoid arrays if

Re: [NF] Recommendations for online PHP course?

2018-08-22 Thread mbsoftwaresolutions
On 2018-08-08 06:29, Dave Crozier wrote: Udemy.com run some great courses and every few weeks run special offers where courses are discounted to your equivalent of a few dollars. I've used PluralSight for some learning. Some good, some eh. ___ Post

Re: Lianja anyone?

2018-08-22 Thread mbsoftwaresolutions
On 2018-08-22 10:54, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2018-08-20 07:41, Alan Bourke wrote: You might find that putting the existing solution on a Windows server in the cloud and allowing the users RDP access is a path of less resistance - in that scenario all the DBF access

Re: Lianja anyone?

2018-08-22 Thread mbsoftwaresolutions
On 2018-08-20 07:41, Alan Bourke wrote: You might find that putting the existing solution on a Windows server in the cloud and allowing the users RDP access is a path of less resistance - in that scenario all the DBF access is happening locally on the server. Why doesn't this approach happen

Re: Lianja anyone?

2018-08-22 Thread mbsoftwaresolutions
On 2018-08-17 10:08, Dave Crozier wrote: Looking at it as a basis for some web development that at the moment converting from strict VFP desktop onto a browser based solution as the desktop solution ships so much data when opening DBF's with their associated indexes. Just a quick comment

Frustrations on anchor=15 resizing not happening until I go off the page and come back to it

2018-08-22 Thread mbsoftwaresolutions
VFP9SP2 using FoxCharts (1.37 and 1.46beta) I've got FoxCharts working somewhat in my testing so far, but I can't get the first showing page to fully resize automatically and some trickery I've tried is driving me nuts. See 20-second demo showing my frustration:

Re: Every day a school day.

2018-07-30 Thread mbsoftwaresolutions
On 2018-07-27 04:43, Alan Bourke wrote: No matter how long you've been hacking VFP and how good you think you are, there's always something you didn't realise. Such as the fact that FOR ... EACH works with arrays. I pretty much only use it with arrays. What else would you use it for???

Re: Coverage profiler (DISREGARD...I FOUND IT -- MAXCOV.APP) (ED -- PROBLEM WITH FILE UPLOAD TO PROFOX DOWNLOADS PAGE)

2018-07-05 Thread mbsoftwaresolutions
I found Markus' add-in in an old dev folder. It's called MaxCov.app. I tried uploading it to the ProFox downloads site but got the following error: 400 Bad Request The server could not comply with the request since it is either malformed or otherwise incorrect. No file specified I

  1   2   3   4   5   6   7   8   9   10   >