Re: Creating a copy of a database -- best practice?
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 generates the code to do so - which includes all the rules, RI, structures, etc. ) Just no data. You could use this to create a destination with no data and then append the source data to the empty backup tables. This would create a very clean, packed, set of data. Of course, it's not that simple if anyone is using it at the time. You probably want to lock the source tables (and related) before appending. Or if you have a last modified record in the tables, use that to check for any changes since the data was copied. Or you might use cursors/views so that changes made by others don't affect you while copying. In fact, if you use a view or have buffering on, once the append is complete, you can check for changes. Anyway, I am sure you will find something that works best for you, Yeah, needs to happen while folks are still in it. I think GENDBC was the utility you were thinking of. This is all a moot point though; I'm gonna recommend Frank Perez and Rick Schummer's CleverFox Backup. It's the bomb. ;-) ___ 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/c0c28941de25379e6f996ed2a0974...@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: MariaDB limitation on memo fields -- caps out at 255
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 rows instead of affected rows 8 = Allow big result sets 16 = Don’t prompt when connecting 32 = Enable dynamic cursors 64 = Ignore schema in column specifications 128 = Disable driver-provided cursor support 256 = Don’t use setlocale() 512 = Pad CHAR to full length with space 1024 = Include table name in SQLDescribeCol() 2048 = Use compression 4096 = Ignore space after function names 8192 = Force use of named pipes 16384 = Treat BIGINT columns as INT columns 32768 = Disable catalog support 65536 = Read options from my.cnf 131072 = Enable safe options (see documentation) 262144 = Disable transaction support 524288 = Log queries to myodbc.sql 1048576 = Don’t cache results of forward-only cursors 2097152 = Force use of forward-only cursors 4194304 = Enable automatic reconnect 8388608 = Enable SQL_AUTO_IS_NULL 67108864 = Allow multiple statements 134217728 = Limit column size to signed 32-bit range 268435456 = Always handle binary function results as character data Your value of 67174427 means: 67108864 = Allow multiple statements + 65536 = Read options from my.cnf + 16 = Don’t prompt when connecting + 8 = Allow big result sets + 2 = Return matched rows instead of affected rows + 1 (I don't know what this means) Not sure what's in your *my.cnf* that might affect the results. Maybe throw a 512 or 64 in there to see what happens? Eric What do you typically use, Eric? ___ 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/a34f24d2985230ff5778c8d1ef1de...@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: Creating a copy of a database -- best practice? - checking email - did not come through before
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 .exe (so
commands like COPY PROCEDURES TO... and APPEND PROCEDURES FROM ...
will not be available)
So...
1) if you know the "data model" of the dbc, you can open it like a
table - then look for the metadata items you want (the stored
procedure code, trigger code, etc). Do a SCATTER MEMO NAME ... Then
open the other DBC as a table and do an APPEND FROM NAME ... After
everything is copied that way I think you will want to do a PACK
DATABASE or maybe VALIDATE DATABASE on the backup. I seem to recall
doing that.
2) after you've copied all the tables, copy the "database files" with
"COPY FILE TO " - copy the dbc, dct, and dcx this way.
Again a PACK or VALIDATE database may be needed afterwards. And of
course, be careful with this, test it out, etc. But I definitely used
this approach before.
3) if you are not worried about the tables being opened at the time of
doing the backup, you could just do the "COPY FILE TO "
- that command allows paths in the from/to. Also, I think it allows
wildcards, so you could do a complete copy in 1 command. Of course,
the downside is the assumption of files being closed.
Hi Charlie,
I've got VFP available so COPY/APPEND PROCEDURES is available. So I
wrote a quick PRG and got the stored procedures just fine with
that...but the part that's missing now is the table-specific data like
default values (important as some call the usual newid('table') function
in the default PK field) and captions (not important).
--Mike
___
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/e6efbd4226dee2145628baff4f262...@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: UCLA & FoxPro...
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 to pay 60K! Although, I hear this is common in Uni's! :-( Well, 60k in California is probably like 30k elsewhere, so sorry to hear that but at least you'll be working with a tool you love! ___ 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/750ce19e4408ffd62633ddc76b6a9...@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: Windows 10 Home and VFP9SP2 apps
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 mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Friday, March 01, 2019 4:55 PM To: profoxt...@leafe.com Subject: Windows 10 Home and VFP9SP2 apps 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 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7bf1f2b96ad68af9bcf6789739e4b...@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: UCLA & FoxPro...
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 Skype interview with 4 people. Was actually kinda fun! They will probably be contacting me for the next phase. In which they also let me know I will be doing a kind of programming test - then a 2nd interview. Best of luck in the new job!!! Yes, best wishes! What would the job title be? A professor teaching "Database Fundamentals 101" or "Database Applications Made Easy with VFP" :-) ___ 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/56454fb049ee9ee6bb6efec757f26...@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.
Windows 10 Home and VFP9SP2 apps
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: 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/f08d9f6eb86613a5e25253434952e...@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: Creating a copy of a database -- best practice?
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 WHISPERING SMITH Ah yes...thanks! ___ 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/551028cdf37d7838feb9ceb2c5c0b...@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: MariaDB limitation on memo fields -- caps out at 255
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 rows instead of affected rows 8 = Allow big result sets 16 = Don’t prompt when connecting 32 = Enable dynamic cursors 64 = Ignore schema in column specifications 128 = Disable driver-provided cursor support 256 = Don’t use setlocale() 512 = Pad CHAR to full length with space 1024 = Include table name in SQLDescribeCol() 2048 = Use compression 4096 = Ignore space after function names 8192 = Force use of named pipes 16384 = Treat BIGINT columns as INT columns 32768 = Disable catalog support 65536 = Read options from my.cnf 131072 = Enable safe options (see documentation) 262144 = Disable transaction support 524288 = Log queries to myodbc.sql 1048576 = Don’t cache results of forward-only cursors 2097152 = Force use of forward-only cursors 4194304 = Enable automatic reconnect 8388608 = Enable SQL_AUTO_IS_NULL 67108864 = Allow multiple statements 134217728 = Limit column size to signed 32-bit range 268435456 = Always handle binary function results as character data Your value of 67174427 means: 67108864 = Allow multiple statements + 65536 = Read options from my.cnf + 16 = Don’t prompt when connecting + 8 = Allow big result sets + 2 = Return matched rows instead of affected rows + 1 (I don't know what this means) Not sure what's in your *my.cnf* that might affect the results. Maybe throw a 512 or 64 in there to see what happens? Eric What do you typically use, Eric? Also, I looked for the my.cnf file and couldn't find it on my or the client systems? ___ 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/1403ab89b53308e535fd76f48d4a8...@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] Learn about Stored Procedures
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 DataObject code; plus, my approach means I'm not stuck with SQL Server in case I want to switch out the backends. There's varying schools of thought on that, and of course, pros and cons to each. I recall somebody (Ted?) saying something years ago about treating that backend as just big dumb iron in the n-tier system approach, which is what I use. ___ 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/647e675038c84fec5a1201b5468ca...@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: Creating a copy of a database -- best practice?
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??? ___ 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/d75f9d1d4ae9647483d5aeb68ad52...@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: Creating a copy of a database -- best practice?
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
lcFile = forceext("C:\BACKUP\" + laTables[ii],'dbf')
use laTables[ii]
copy to (lcFile) database C:\Backup\MyDBC.dbc with cdx
use
endfor
...and that would get me a copy of all of the tables with their
indexes.
Great. But what's the easiest way to get all of the DBC meta-data
into
that new Backup database copy? I can't USE the MyDBC.dbc and do a
COPY
TO as that only makes the result a DBF and FPT.
An easy way to get a copy of the data is to have a copy of all the data
in another folder, then using your loop above, zap each table and
append
from the live data. We use it here as a rough and ready backup during
the day, while people are in the system. Your copy then has all the
same meta data as the original.
Hi Peter,
I see no difference between my COPY TO versus
doing an APPEND FROM from my backup table. ???
Am I mistaken?
tia,
--Mike
___
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/57548c2cb0741015511f60d8bcfd5...@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: false news....
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: 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/a3600e4a845aad4c00b719ad780af...@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: MariaDB limitation on memo fields -- caps out at 255 (SOLVED)
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 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 different (my web) MariaDB database, I'm sure this is a configuration issue. Question is: where do I find/set that? His network OS is Windows 2016 Server. My web database is using a Linux OS iirc. tia, --Mike Here's the weird fix: instead of using a MEDIUMTEXT field, it worked just fine when I changed it to TEXT fields. Now MEDIUMTEXT is supposed to handle LARGER #s of characters, but in this case, just TEXT should suffice. Still...wonder why the ODBC (originally 3.51, then I upgraded to the latest 64-bit MariaDB driver) has a problem with MEDIUMTEXT on this Windows 2016 Server? My other database (where no issues at all) operates on a Debian Linux OS. Thoughts? No takers on this one. Look at the solution above. Thoughts on why TEXT worked and not MEDIUMTEXT (which is larger than TEXT iirc)? tia, --Mike ___ 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/f743075b64adf1083a3e34348960e...@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.
Creating a copy of a database -- best practice?
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 C:\Backup\MyDBC.dbc with cdx
use
endfor
...and that would get me a copy of all of the tables with their indexes.
Great. But what's the easiest way to get all of the DBC meta-data into
that new Backup database copy? I can't USE the MyDBC.dbc and do a COPY
TO as that only makes the result a DBF and FPT.
Trying to think about a good disaster recovery plan (besides using
CleverFox from Rick Schummer and Frank Perez...which is probably the
best option!) for automating backups at the client who just got that
ransomware virus.
tia,
--Mike
___
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/500593bf5f84e661f7648a5121a41...@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: MariaDB limitation on memo fields -- caps out at 255
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 wrote: 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. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fbb6724da613f39736b11588b1c58...@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: MariaDB limitation on memo fields -- caps out at 255 (SOLVED)
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 the memo fields capping at length=255. Given that it works with a different (my web) MariaDB database, I'm sure this is a configuration issue. Question is: where do I find/set that? His network OS is Windows 2016 Server. My web database is using a Linux OS iirc. tia, --Mike Here's the weird fix: instead of using a MEDIUMTEXT field, it worked just fine when I changed it to TEXT fields. Now MEDIUMTEXT is supposed to handle LARGER #s of characters, but in this case, just TEXT should suffice. Still...wonder why the ODBC (originally 3.51, then I upgraded to the latest 64-bit MariaDB driver) has a problem with MEDIUMTEXT on this Windows 2016 Server? My other database (where no issues at all) operates on a Debian Linux OS. Thoughts? ___ 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/8526cee0d3a1d55f364dbe029a95e...@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 application issues on new server
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 ? There was an issue recently with an update to Windows 10 1803 causing weird DBF problems due to SMB caching, which I believe are fixed in Windows 10 1809. Another thing it could be is the Windows Server indexing service which may be on and indexing everything depending on what flavour of Windows Server it is. It could also be online backup software that monitors locations for cloud backup. Hi Chris, What became of this? My client has an old 2003 VFP app (using VFP backend) and was having weird problems too. Never could figure it out. I'd be interested in how you fixed this. Thanks, --Mike ___ 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/229a67c6aefb9cb965b6892936550...@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.
Cryptovirus hit one of my clients
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 (which they said was just hours prior, thankfully). Ouch. Especially when you're website is used all over the nation and Canada. If they had been using MySQL/MariaDB/SQL-Server/PostgreSQL/etc instead of a file-server database, this wouldn't have been possible, right? ___ 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/8378ad2d2d936f54c1b2c51964e57...@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: SFTP
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 that SFTP is not yet supported. Sorry! ___ 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/67806e877fdb0bdcaa52ddad45e75...@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: SFTP
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: 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/45d7151514f0061f5e37e5fe9024c...@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: MariaDB limitation on memo fields -- caps out at 255
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. ___ 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/64a6e2b22c31b10dba7d051fcc6c1...@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.
MariaDB limitation on memo fields -- caps out at 255
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 different (my web) MariaDB database, I'm sure this is a configuration issue. Question is: where do I find/set that? His network OS is Windows 2016 Server. My web database is using a Linux OS iirc. tia, --Mike ___ 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/497fb3eb15f3d608fb2d07fc0e4f1...@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: SFTP
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 up with a SSL error when tracing it through. Should I be looking for another solution that maybe supports newer protocols or am I missing something? Thanks Chris. Hi Chris, I used a simple solution from Dave here. Let me know if you still need something. --Mike ___ 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/aa0810cf0104098004124dbc06e56...@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: ERD with a table with strange keys
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 you can define add, edit, update, delete instructions "WHERE Country=XXX and Category = YYY" which will work all the time. That's proper relational integrity and 4th normal form. The problem happens if you start adding attributes (fields) to the record where a combination of country/category could have more than one record, say, and agerestriction for gender male but no age restriction for gender female where you now have two records with identical primary keys. Which means they're no longer primary keys, since they do not uniquely identify records. So, you'd have to add another field or two to the composite key, or finally break down and add a unique PK field. To avoid this kind of refactoring later in the process, my rule has always been that every table has a unique, non-data-bearing PK which uniquely identifies the record from birth to death. You will never have to deal with all the RI code involved in changing primary keys because the data values (category or country codes) change, and avoid intricate and bothersome code. jomo. Excellent logic, Ted. Purists be damned! 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/a0d763ea24d1860e86ea3b6f343c2...@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] Testing new mail relay
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 the level that the service would be free - around 210 messages / month. And it would be nice to not have to hunt down why various people aren’t getting their messages, which usually ends up being “my ISP is blocking you”. Also - you do this same similar forum for Python - don't you? Which, if so, increases total # of emails, and thus the monthly cost. Or, maybe the cost is Per forum type - not grouped together… I also host the ProLinux and ProPython lists, which were set up to not clog up ProFox with discussions of moving to Linux or programming in Python. While they were busy at first, in 2018 they had 17 and 15 messages for the *entire year*, of which 13 were the monthly/yearly statistics postings. So those don’t really make much of an impact. Well, if ever needed, do a GoFundMe (or better site) campaign and we'll all chip in. I know I'd have no problem throwing a few bucks at this as a "thank you" for such a great resource. ___ 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/4dcef296780e49477701b0d1cb298...@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] Testing new mail relay
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 post gets sent to each subscriber: 475 as of last May, though it’s down to 474 as of Jan1 (https://leafe.com/archives/msg/512459). So that’s where the 133K comes from. Ah, I see this now. Please disregard my last post. ___ 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/c79243280a3e7d7986e6ab48c9ebf...@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: Custom Scrollbar
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 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/80c505ec4c528d0fb9866b729214e...@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] Testing new mail relay
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 (https://www.mailgun.com/). So far it seems to be running well, but if any of you on the receiving end of things notices a problem, please let me know. One other issue is the cost: it’s free if the total # of emails sent is under 100K, but gets expensive above that. Last year the highest number of emails sent in a month was 280 in May, which is about 133,000 total emails, and that would have cost $120 for that month (ouch!). So I’m not sure if I will keep it, but it’s worth a trial at least. First and foremost, thanks again Ed for doing this list!!! Help me out with that math on the above. 280 emails in May...that multiplied by 12 months equates to 3360 emails for the year. Or is multiplied by the number of folks subscribed to arrive at your 133,000 number? ___ 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/bd262f6b3f01016bfc0063288be27...@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: AW: Custom Scrollbar
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, just WHY? Because the VFP grid does not work. Haven't yet found a problem for which I would need a homegrown grid. What can't you do in VFP's native grid, in combination with the excellent container hierarchy which you could add into any / every column of a grid? Full validation of a row. I came close, but it required a lot of kludges and an innocent change in one place could blow it up. Build a set of controls, save them as class, add that class to the Column, change Column.CurrentControl to point to that class, set Column.Sparse to .F. and presto, you can do any complicated setup and stil have the benefits of VFP's native gridspeed. I wish. One of the things that Grid is supposedly not for is data entry. I need a grid that can handle that. Sincerely, Gene Wirchenko ___ 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/0f90af823f1fcb463af85388bd69f...@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: VSS to git conversion
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 have been just working directly in the standard project manager in VFP. Hi Tracy...Happy New Year! Did you mean to say that you ARE or ARE NOT using FoxBin2PRG? I'd think you would have to use it to achieve the non-binary source code control process. ___ 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/640b4e4960c9afd4b1c9a824fbdf5...@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: Fox Team member now MSFT CMO
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 episode 600 (!) of Windows Weekly: https://twit.tv/shows/windows-weekly/episodes/600 "Open source is very important to this Company." Far cry from the Ballmer days. ___ 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/343b5b09b675ae1e7a2ef42fc8438...@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.
[ADMIN] Problem with list archives
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), the site then failed and just said "No results were found. Please try again." (Flashing the big "E" in the sky for Ed Leafe to come save the day with the List management) ___ 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/f611103b06732bbc8dbb7c2a2a194...@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: AW: Visual FoxPro Toolkit for .NET
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: 'profox@leafe.com' Betreff: Visual FoxPro Toolkit for .NET Hi all http://foxcentral.net/microsoft/vfptoolkitnet.htm Does anybody have any experience with this? Is it robust and reliable? Thanks Paul Newton [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/360f56c7bec57b403a07f31243cf1...@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: AW: Reallocating drive space
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 run it: CleanMgr /sagerun:1 Everytime you need a full cleanup, just use the second commandline again. The trick with "sageset" is that you can enable much more cleaning tasks as with the standard interface. Depending on how often you had windows updates, it may well reclaim several Gigabytes of no more necessary Updates etc. Then, also delete all stuff in %temp%, as well as \windows\temp\ (it will choke on some files in use, just skip those) Hi wOOdy, Thanks for the tip. Just tried it. Not much changed, probably because I've already moved my temp environment setting to D:\TEMP instead and recently run this cleanup as well as CCleaner. Was hoping this would get rid of old Windows Updates stuff but I guess that's already been cleaned? ___ 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/b126b94d9e5832ffd92ff4f7a6261...@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: Reallocating drive space
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!!! ___ 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/443cd7cccb329c63c12fc48118bf7...@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: Reallocating drive space
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! ___ 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/73c743b8e0ea646ae283710d1807c...@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: Reallocating drive space
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 ___ 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/2a8aa73de73a67d97999fbd749b92...@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: Reallocating drive space
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 take XX GB from D: and apply to C: drive? You will need to delete D and expand C. The Disk Management tool in Windows can do this. Looks like there is just enough room on C to hold the contents of D. Do a backup first! No no...I don't want to delete D: drive...I want to keep that! I do all my Dev work there; just use C: for Windows system crap. These Windows updates over time are slowly filling up the C: drive. I already moved the TMP folder to D: too. ___ 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/a0f6fce39a4421e75765b84b3bf55...@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: Big Changes & Fox Work in SF Bay Area?
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: 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/9c8c657e678a3eda8867172f565e6...@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.
Reallocating drive space
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 ___ 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/acbe1bcc866d1d81e1ff87238e86c...@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: Big Changes & Fox Work in SF Bay Area?
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 searched for VFP type jobs, I found a few scattered over the east coast and a couple down in LA. Given that I also have grey hair syndrome, I can commiserate with your struggle. If you want, get in touch and I may be able to give you some ideas. The one takeaway I have found is that the top companies (Amazon, Facebook, etc.) all get a huge hit because everyone wants to work there. But that makes it easier to focus on the companies that don't generate the same prestige. Otherwise, have a very happy Thanksgiving! Fletcher Fletcher Johnson fletchersjohn...@yahoo.com LinkedIn.com/in/FletcherJohnson beknown.com/FletcherJohnson twitter.com/fletcherJ twitter.com/svcsug strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt @ Gmail Sent: Wednesday, November 7, 2018 10:16 AM To: profox@leafe.com Subject: Big Changes & Fox Work in SF Bay Area? Hey there folks, Yeah - I've been MIA for a little while now. I struggled to find work in NYC area - and things just went from Bad to Worse! So - towards the end of Sept. I made a big life change. Packed up my car - putting most of my life in Storage - then hit the road and drove West Old Man... About 8 days later I arrived in San Francisco - where I am now living at my sister's place. So, I've been looking for work out here. Even applied to a job at "X" - the special hi-tech lab of Google. They had a job for a 3D Printing specialist. I would have been Perfect for the job - as I had everything they wanted. But, maybe they saw me as too old, working too many years, and probably thought I would need more $$$ than they wanted to pay for the position - and, as such - I never heard back from them. I even had not One but TWO Internal referrals - but, alas, that didn't help... I'm even looking for possible FoxPro work - which is the main reason I am making this posting. Anyone know of any FoxPro work in the Cali area? Preferably in the SF Bay area. Although, I will consider elsewhere in Cali. TIA! -K- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/82283c5f0e33644bbc20998ad2c96...@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.
How can you tell the difference programatically between Windows 8 and Windows 10 (from the desktop, not server versions)?
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 Windows 6.02 OS(5) returns "8102" AND OS(11) returns "1" Windows 8 (Release) Windows 6.02 OS(5) returns "9200" AND OS(11) returns "1" Windows 8.1 Windows 6.02 OS(5) returns "9200" (why not 9600?) AND OS(11) returns "1" Windows 10 Windows 6.02OS(5) returns "9200" AND OS(11) returns "1" ___ 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/2ca9e33382e18d8025738c69f1b1e...@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] Alternatives to Peachtree Accounting software?
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 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/2537041f813bdcfcc7501407fe111...@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: Report with data from 2 unrelated siblings
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 list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/6cc0ec5d4f2ef1abdc5b8d69cbe0b...@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: CDO Email issues all of the sudden? VFP9SP2 app running for years without issue
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 again? I saw John and Fred replied to this saying it works for them. John and Fred -- is yours still working without issue? Koen -- what alternative do you suggest? Thanks, --Michael ___ 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/8f08758742264cb073eab8524066c...@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.
CDO Email issues all of the sudden? VFP9SP2 app running for years without issue
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 gmail account and it's using the LESS SECURE mode so 3rd party apps like mine can send email with it. So I'm not sure if this is a GMail problem, a CDO problem, or Mike's laptop environment problem. No real changes in my environment except for using Avast Secure VPN plug-in now, and Avast Secure browser (but surely that's not in play here). Ideas? tia, --Mike ___ 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/a3b9b35e5c76a22a5ebb943009683...@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] Web Assembly anyone?
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 ___ 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/854752dd59c7cf8c3822d7a8dc685...@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] Tool for editing multiple files for huge search/replace operation
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 change every instance of StringA to StringB across several hundred files all at once? I don't want to manually do that for each file! ___ 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/517e97b200acd291551e53ebd7027...@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: AW: [NF] Tool for editing multiple files for huge search/replace operation
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 had the same experience as you years ago, Ken, with it screwing up files. Never trusted the global replace after that. ___ 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/065549dca211c9c31d6a617f7a42c...@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] Tool for editing multiple files for huge search/replace operation
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 tool to handle large search/replace across several text files in a same folder or even perhaps cascading tree of folders? tia, --Mike ___ 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/90a94ecac0d454084c3394bf68c5d...@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] Broken Windows
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 rewrite it from scratch. It'd take too long to deliver. ___ 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/7c21d1180f1c6930f7bf3f80e3c7a...@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.
.h files included or excluded in your project?
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: 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/f895d8b4c2d4e8d569b20df7a06ae...@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] Broken Windows
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 well in this article - basically they laid off a load of traditional QA and testing professionals in 2014 and are now relying on some sort of crowdsourced bullshit for QA, using people who are on the beta releases, i.e.e fanboys. https://www.theregister.co.uk/2018/10/23/microsoft_windows_10_crisis/ I heard this happening awhile back, when they laid off John Koziol (who worked in Q/A there, didn't he?). No surprise. All that money (more money than any other company perhaps) and they're too cheap to do testing the right way. Ugh. ___ 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/95c422abcd447e807f1cbc7476496...@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.
CleverFox backup tool
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 had a couple issues at the start but that was just my needing to learn how to properly install it. Took less than an hour for sure. It's come in handy too on a couple of occasions when they needed me to restore some data that got tainted/overwritten wrongly. Cheers! --Michael ___ 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/9a0f3713a74e4b0e8fe5fb4a88bbd...@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] Microsoft Dynamics
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+ different operations to take it in status from New to Shipped. It probably has contracts for defining pricing to a customer on set items and how the price can be increased or decreased by the system. Wonder how much that cost them to implement that across the enterprise (which has several hundred franchisee locations)? ___ 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/31175974b7bdae4c402cd68f29ea6...@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] Microsoft Dynamics
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 contracts for defining pricing to a customer on set items and how the price can be increased or decreased by the system. What you wrote is probably super customized for 20-30 different screens. Dynamics has 300+ screens. Dynamics also interacts with CRM which is either a blessing or a curse. Did they look to Salesforce as well? No clue...no communication with dev team for years. When you go from a customized "glass slipper" app to something like what I saw, wow...that's a huge bucket of cold water on you as the end-user. I feel sorry for both end-users and devs. ___ 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/5cd38686eb7d7903b71b57160b259...@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] Microsoft Dynamics
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. ___ 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/ad617b043d87516550cfdb27ce201...@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 & Excel automation -- how to enter this formula into a cell programatically from VFP?
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:
=(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1)
I can't get that entered programatically from VFP.
___
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/bc8e1bbe30e4c73a54ada05bac5a3...@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 & Excel automation -- how to enter this formula into a cell programatically from VFP?
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 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 start and end time and use Excel's native
NetworkDays function to return the length of time between when we
received a ticket and when we responded. So basically I just want to
use Excel's formula/calculation rather than recreate this in the Fox.
Every time I tried to set it manually from the VFP command window, it
failed. See screenshot with my attempts:
https://www.screencast.com/t/BtzVOQLu
My current workaround is to have a simple worksheet with the formula
predefined in a cell and just populate the input datetimes and then
grab the resulting calculation from that NetworkDays(..) cell. I feel
like that's a kludge though, and I'd rather just invoke Excel and
programatically do it raw.
Your thoughts on how to best proceed for this task?
tia,
--Mike
___
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/b2134e2f158208d38eb7ffaaac132...@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 & Excel automation -- how to enter this formula into a cell programatically from VFP?
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 start and end time and use Excel's native NetworkDays function to return the length of time between when we received a ticket and when we responded. So basically I just want to use Excel's formula/calculation rather than recreate this in the Fox. Every time I tried to set it manually from the VFP command window, it failed. See screenshot with my attempts: https://www.screencast.com/t/BtzVOQLu My current workaround is to have a simple worksheet with the formula predefined in a cell and just populate the input datetimes and then grab the resulting calculation from that NetworkDays(..) cell. I feel like that's a kludge though, and I'd rather just invoke Excel and programatically do it raw. Your thoughts on how to best proceed for this task? tia, --Mike ___ 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/8e79d27643c3f13d5b98f025f72f8...@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] Solo Consultant Home Office/Small Office phone recommendations?
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 good quality smartphone would be just as practical, without the need for voice mail at the base station, etc. I'm looking for a really good quality headset (earpieces & microphone) to use with a cell phone to replace my current landline cordless phone and headsets. I have some hearing loss, so high quality is really important. And I'm talking to clients, we're spelling out customer names and part numbers so both sides need to have pin-drop quality sound. Sounding like you're at the far end of a cardboard tube is not acceptable. Current smartphone is a Android Nexus 6P with 35mm audio jack and a USB-3 connector and Bluetooth. I've tried Bluetooth and that was an exercise in frustration, but perhaps they've gotten better. This is a business purchase, not a frugal home purchase, so if you're really convinced the $129.99 Plantronics Bluetooth is worth it, I'll give it a shot. Recommendations? I've had great success with the Plantronics!!! Well worth it, imo. ___ 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/17e4a63a2459a13b878f1adf3a7c7...@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.
Error with Thor's PEMEditor app
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 press ignore and the Prop/Meth is added successfully. Anybody else experience this? tia, --Mike ___ 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/8963c31a4f021fd875e9ff4646e34...@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.
Reading emails from a VFP app and creating "tickets" based on them
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 emails to that web mail account. Currently, it's just manual adding into Excel by help desk staff. Anyone ever do that? (I personally use ZenDesk for my MBSS clients, and I love it, but not sure if that's an option here at the Corporate gig or not. Probably not since it's not a budgeted expense--although it's dirt cheap imo!!!) tia, --Mike ___ 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/5acae1bb0e931e046f0069f447b17...@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: ON KEY usage in your apps
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 F1 key simply called the routine to launch the appropriate help document (PDF) via ShellExecute. ___ 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/e4b154508c64a2d61ef3b021819be...@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: ON KEY usage in your apps
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. ___ 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/99be6fd7d4bdac008646683a7d57c...@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: ON KEY usage in your apps
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 secret spy ship in the beginning of For Your Eyes Only! "Destruct ATAC system!" https://www.youtube.com/watch?v=vsEMeXATt00 ___ 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/97c367cf796be8cba016df3edfadc...@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: ON KEY usage in your apps
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 object (my controls were always thisform.oRecord.cLastName, etc.), then passed that to my data object to add/edit/delete in the backend (MySQL) database via my SPT code. I have allowed editing in grids with no problems for many years using visual max frame. For some reason (probably years before I switched to non-binding VFP cursors instead of local views or direct tables in my earliest VFP days), I favored avoiding data entry in grids. Some here may have helped me form that position too. I would never use an on key label for anything in an application. I would use buttons with hot keys or if that is not possible use the form's key press. I liked the Help manual idea for it! ___ 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/626e7795171ba6c35e29d93d8c8d0...@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: ON KEY usage in your apps
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: 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/de37121c794ed016258589ac52cb2...@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: ON KEY usage in your apps
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 such ability now. I was thinking of using ON KEY to pop up a lookup form to add data records to the grids (instead of that native whatever way of doing an APPEND blank in the native VFP grid). In the past, I've really just used ON KEY to pop up the help file on demand. In what other ways have you used ON KEY in your designs? It's worth noting too that I use disconnected cursors (like Charlie Coleman's approach from the late 1990s!). Backend is MySQL and I basically just use the current app handle (or re-establish if not connected) and perform the add/edit/delete. So it's not like I have to worry about updateable views or anything like that. My own framework is all SPT calls. ___ 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/82e16be6788f6df0874312e4f798e...@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.
ON KEY usage in your apps
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 form to add data records to the grids (instead of that native whatever way of doing an APPEND blank in the native VFP grid). In the past, I've really just used ON KEY to pop up the help file on demand. In what other ways have you used ON KEY in your designs? tia, --Mike ___ 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/c46ca07dbf6c37ebb1c2ea963f3a6...@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: Good old fashioned FTP need from VFP app
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 Downloads page! https://leafe.com/dls/vfp ___ 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/c67882ec236216d65c03303fa0f47...@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: Good old fashioned FTP need from VFP app
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 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/aff0ee34999d9e2e2574e25458d72...@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.
Good old fashioned FTP need from VFP app
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 ___ 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/fe3d9c741ad87269364fb2096cfe8...@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: Problem with VFP's debugger not seeing C# object's properties
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 dropdown will not appear and won't let me see the properties of the lower level objects. See soundless quick demo showing that: https://www.screencast.com/t/nYRe4eXp ___ 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/b3bbc0d5f3b042d73be6892b01dee...@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.
Problem with VFP's debugger not seeing C# object's properties
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 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/dc15919af1352dca2499a0ff00796...@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: 2 Excel questions using automation from VFP9SP2
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 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/49907ffc7c6dde4d7f1aaa844fefd...@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: 2 Excel questions using automation from VFP9SP2
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 says it returns the number of Whole workdays between two dates. Well, ok, I see it as a fraction representing the time but yeah, it's a fraction of the day total using the parameters. We use it to show total time spent on help desk tickets by response, SME time, and total time spent. I guess it depends on your perspective. ___ 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/ebca0ae07e74a58fd11093355c74a...@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: 2 Excel questions using automation from VFP9SP2
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 13:00:00 and 08-01-2018 23:00:00. I didn't monkey around with cell settings to see if it changed. It works fine in Excel; I wanted to incorporate the idea into my framework for when needed later on. Just didn't want to have to fire up Excel just to use this function. ___ 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/5e13bfa26dd8091526a4bffd5fbe5...@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: SOAP
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: 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/1f8cdfa8f2b67a6773a26c1d08f20...@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: 2 Excel questions using automation from VFP9SP2
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 weekend. count rows of cursor. Holidays you are on your own :) On Wed, Sep 5, 2018 at 4:35 PM wrote: 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 highlight) Anybody know how to get this slick NETWORKDAYS formula to work in VFP? Would be neat to have this and I thought perhaps someone already built it. tia, --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0b9e276fe817c836bfed24930f7d1...@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: 2 Excel questions using automation from VFP9SP2
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: 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 highlight) Anybody know how to get this slick NETWORKDAYS formula to work in VFP? Would be neat to have this and I thought perhaps someone already built it. Frank -- it's a slick formula for determining the TIME that's passed within the workday hours set (not just days; that'd be simple). ___ 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/d491dd76de64ba00d6b734f70dd7f...@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.
2 Excel questions using automation from VFP9SP2
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 highlight) Anybody know how to get this slick NETWORKDAYS formula to work in VFP? Would be neat to have this and I thought perhaps someone already built it. tia, --Mike ___ 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/c098c4933dff7f770255511062c0d...@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: Contacting folks on GitHub
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 there are two email addresses. https://github.com/VFPX/FoxCharts Project Manager: Cesar (vfpimag...@hotmail.com) Versions till 1.37 Project Manager: YudinAlexKiev (alex.yudin...@mail.ru) Versions 1.4x HTH, Gianni On Fri, 24 Aug 2018 17:27:42 -0400, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: 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? Ugh...Am I looking at this wrong? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/c5d7e55a11a2c3100a55f7914dbc3...@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.
Contacting folks on GitHub
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? Ugh...Am I looking at this wrong? ___ 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/438a23358341c9cf40b8537c23d2b...@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: MCP ID
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 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/c3aa3cedc78889e6e168e722ab40b...@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: MCP ID
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: https://www.microsoft.com/en-us/learning/certification-overview.aspx ___ 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/a2ec3267328ed04265b3ca3ce2673...@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.
FoxCharts pie question
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 show the labels with #s. (And I'm talking static text, not tooltiptext, as this is for printed reports.) tia, --Mike ___ 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/4c3e8e29cd3debbb5f799ccbc45fb...@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.
MCP ID
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 when (it was 2002 when I got it). ___ 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/3a7ab0e860d395be3f458b2aea9d3...@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: Lianja anyone?
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 takes FOREVER on the client machines at their learning centers Are they on the same LAN as the server with the DBFs? I agree...not huge for VFP but for reasons I can't explain, it's slow. Of course the tech folks at Corporate think it's pulling the entire dbf file etc over the LAN (and maybe they've done analysis to support that with SysInternals...not sure), but I've seen it to be slow. Many lines of legacy code that weren't written for full optimizations, so it is what it is. Yes, I believe the same LAN. Workstations connecting to the inhouse Corporate server box...which then communicates with the MotherShip and sends all their data back there too. I believe the servers are underpowered and not configured correctly but of course that's off-limits to anybody but The Man at Corporate. ___ 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/62c9b6a65b4d76dddfdc6a5178615...@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: Frustrations on anchor=15 resizing not happening until I go off the page and come back to it (SOLVED)
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. See 20-second demo showing my frustration: https://www.screencast.com/t/jmTkdEl2xN Ideas? tia, --Michael Solved it with this kludge in the form.init: this.LockScreen = .T. this.pgf.ActivePage = 2 this.pgf.ActivePage = 1 this.LockScreen = .F. ___ 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/3539eace8df2baa12816446c824f6...@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: Frustrations on anchor=15 resizing not happening until I go off the page and come back to it
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 back to page1 it would shut off). Here's the pickup from page2's tracking: 41830.801, frmhelpdeskcharts.pgf.pag2.Activate() 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.title.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.subtitle.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.xaxis.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.yaxis.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.scalelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.axislegend2.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.shapelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.sidelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.tooltip.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.yaxis2.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.chartcanvas.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.cmdchartoptions.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.title.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.subtitle.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.xaxis.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.yaxis.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.scalelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.axislegend2.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.shapelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.sidelegend.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.tooltip.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.yaxis2.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.chartcanvas.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.cmdchartoptions.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag2.mychart.UIEnable(.T.) 41830.802, frmhelpdeskcharts.pgf.pag1.mychart.Moved() 41830.802, frmhelpdeskcharts.pgf.pag1.mychart.Resize() 41830.802, xfcbitmap.Init(1740, 744, .F., .F., .F.) 41830.804, xfcgraphics.Init() 41830.804, xfcbitmap.Destroy() 41830.805, xfccolor.Init() 41830.809, xfccolor.Destroy() 41830.809, xfcfont(Arial, 16, 1, .F., .F., .F.) 41830.809, 41830.816, frmhelpdeskcharts.LostFocus() 41830.817, frmhelpdeskcharts.Deactivate() 41830.817, frmhelpdeskcharts.Paint() I had tried forcing a thisform.Paint but that didn't make any difference. ___ 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/eb90b65251846fce3feb82eb72a3f...@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: Every day a school day.
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 possible. I only use FOR EACH with arrays on functions like AFIELDS where it automatically creates arrays. The only time I ever use arrays other than those scenarios is where I just use it for a SUM query: select sum(MyValue) FROM MyTable into array laSum return nvl(laSum[1],0) Stuff like that. ___ 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/8320181d8ca33f7b10889591bff37...@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] Recommendations for online PHP course?
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 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/ca736c3bb0e1fa5036795f98c6db7...@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: Lianja anyone?
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 is happening locally on the server. Why doesn't this approach happen more often or why isn't it commonplace? (I get the imnpression it's not.) Is it not professional in its style? And wouldn't this approach be very secure? ___ 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/7a4b9c6cc032e2a2193adbec51c00...@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: Lianja anyone?
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 more often or why isn't it commonplace? (I get the imnpression it's not.) Is it not professional in its style? ___ 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/79bda63a33e0d6ca7f961eff07819...@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: Lianja anyone?
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 that the VFP dbf app I did at Sylvan has the same challenges in its old age. They've got 500MB of data in some centers with 20+ years of data, and for whatever reason, running some reports takes FOREVER on the client machines at their learning centers (where it's just a handful of machines on the local server). Corporate's workaround was to give folks direct server access so they could run it faster on the server. I'm glad I switched to MySQL back in 2004! ___ 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/96e9a3507bf7387b8e8ddfe3c...@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.
Frustrations on anchor=15 resizing not happening until I go off the page and come back to it
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: https://www.screencast.com/t/jmTkdEl2xN Ideas? tia, --Michael ___ 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/b1149dfbff2f560eb4c04cd3b322b...@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: Every day a school day.
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??? Collections I guess? ___ 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/49905257e89f5b9584c70079114f9...@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: Coverage profiler (DISREGARD...I FOUND IT -- MAXCOV.APP) (ED -- PROBLEM WITH FILE UPLOAD TO PROFOX DOWNLOADS PAGE)
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 selected the file via the button so I know it's there. Ed -- problem behind the scenes with the file uploader??? --Mike On 2018-07-05 10:49, Frank Cazabon wrote: The only thing I can think of is CVP. I have version 1.19.18 and it was written by Martina Jindrová. Can't remember where I downloaded it from but maybe Level extreme (formerly Universal Thread) or Foxite. Frank. Frank Cazabon On 05/07/2018 10:24 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 on Win7Pro PC I want to see how long it's taking some code to run. Beyond self-created start/stop variables, I thought "why not use the coverage profiler?" MANY years ago, I recall there was some sort of alternative cool tool to the native Coverage Profiler but I can't recall the specifics. Markus Egger comes to mind. I did a search of the ProFox archives for "coverage profile" but found nothing across the entire archive (https://www.screencast.com/t/FF8gEjeK5DeP). I found this in the ProFox downloads area but I haven't used that before (yet): http://leafe.com/download/cvp_1.18._9_20090211.zip. I found this link when searching for Markus Egger Coverage Profiler (http://www.scrigroup.com/calculatoare/tutorials/434/The-Coverage-Profiler33512.php) but the reference at the end to http://www.eps-software.com/ is a fruitless end as I can't seem to search that site; it just asks you which CoDE site you want to visit. Do any of you have Markus' old CP Analyzer tool or what's your recommendation for analyzing code performance in your VFP code? tia, --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e531be394eb754b205812621c8e4a...@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.
