Re: [ADMIN] SSL Issues

[Ed Leafe]

On Apr 22, 2019, at 4:19 PM, Ted Roche  wrote:
> 
> My blog is melting down on some leafe.com issues. I suspect you've updated
> your SSL cert recently, and it looks like some of the older http:// links
> aren't working or aren't redirecting.
> 
> http://dabodev.com returns an error, while the https page is working okay.
> 
> I had to update a couple of archive links to https as well.
> 
> You may want to put in a server directive, if you can, to redirect the
> http:// addresses to the matching https://

My Let's Encrypt certs auto-renewed over the weekend, and somehow the https 
redirect was lost. I'll see about getting it corrected.

BTW, I'm almost ready to release an entirely new website. I created the current 
one back in the early 2000s, and it is written in what was the leading Python 
framework of the day. Now that Python 2 is EOL'd, and that framework doesn't 
support Python 3, it's time. It's also given me a chance to play around with 
some of the newer CSS and JS stuff out there, so that's a plus.


-- Ed Leafe






___
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/927e80ed-4b3d-40e4-a63d-29d0ed0b2...@leafe.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.

Fwd: Re: [ADMIN] Replies going right to the user instead of the group

[MB Software Solutions, LLC]

Figured it out.  I was hitting the Reply button instead of Reply List 
button in Thunderbird.  That'll take some getting used to.




 Forwarded Message 
Subject:Re: [ADMIN] Replies going right to the user instead of the group
Date:   Fri, 19 Apr 2019 17:20:52 -0400
From: 	MB Software Solutions, LLC 


To: Ted Roche 



On 4/19/2019 10:49 AM, Ted Roche wrote:
Many mailing lists have this defect, but ProFox does not. You likely 
have a

defective or misconfigured email client, which is replying to the From:
address and not the Reply-To:

Reply-To: profox@leafe.com
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:60.0) Gecko/20100101
Thunderbird/60.6.1



Strange...I'm using the latest Mozilla Thunderbird out of the box 
(nothing special).




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--- StripMime Report -- processed MIME parts ---
multipart/alternative
 text/plain (text body -- kept)
 text/html
---

___
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/23b16676-5b14-26b8-fa28-a6298b146...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

On 4/22/2019 5:06 PM, Eric Selje wrote:

Yes, absolutely appropriate for an ONUPDATE trigger. Insert a new record
into the history table before doing the update.

If you want to do this for every field in every table, FoxAudit is the tool
of choice. (I don't see it on TakeNote.com's website any more but maybe
shoot an email to Jim Duffy)



I recall FoxAudit, but I use MySQL backends for nearly all of my work.  
I avoid DBFs unless I inherit them.


Thanks though!

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/3a657105-07d5-e52c-8ed8-a5f705f45...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

On 4/22/2019 6:13 PM, Frank Cazabon wrote:

Yeah, my succinct point :) was I didn't think it should be a log but a table 
that allows edits. You can then put an audit trail on that if you want or need.



Would it be just another update?  Yeah, kind of a wasted row but still, 
why break process?



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/4976cf33-7c90-a129-4b8b-c49fcd4d8...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

On 4/22/2019 7:19 PM, Johan Nel wrote:
Well I use PostgreSQL and my believe is that updates should be handled 
by the DB itself, e.g. an administrator doing updates directly to the 
DB without using the UI application...  All my tables have 
INSERT/UPDATE columns: usr_ins, usr_upd, dt_ins, dt_upd that are 
trigger populated based on the login details. When rows are 
updated/deleted, the old row is TRIGGER driven to be inserted in a 
_audit with the same columns as the live table plus an 
"audit_no" and  "trg_op"="U|D".


Very easy then to have a view of db changes and even do rollbacks to a 
certain Point in time (which will even be logged in the audit table 
with no software interaction needed).



Hi Johan,

Yeah, I was wondering if I'd do some sort of hardcoded logic in the 
UPDATE/DELETE triggers for this.  I wanted to get the logged-in User's 
ID in the history table so we know who changed it.  Was thinking of 
creating a Session variable upon establishing connection to the MySQL 
(MariaDB) database and then referencing that @Session.MyUserID in the 
UPDATE/DELETE trigger code.  See any problems with that approach?


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/f8f43f46-8e28-f4b9-761b-8ca88d39b...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Johan Nel]

On 2019/04/22 21:33, MB Software Solutions, LLC wrote:

VFP9SP2 app, MariaDB 10 (MySQL) backend.

One of my clients asked about a history of price changes.  Easy enough 
to implement programmatically for the few price fields, but then I got 
to wondering if simply putting code in the ON UPDATE trigger to send 
the old record to a "history" table would be a more complete (and long 
term EASIER) solution, whereby my app would query the "history" table 
for changes.


Your thoughts for tracking price (or other) changes?


Well I use PostgreSQL and my believe is that updates should be handled 
by the DB itself, e.g. an administrator doing updates directly to the DB 
without using the UI application...  All my tables have INSERT/UPDATE 
columns: usr_ins, usr_upd, dt_ins, dt_upd that are trigger populated 
based on the login details. When rows are updated/deleted, the old row 
is TRIGGER driven to be inserted in a _audit with the same 
columns as the live table plus an "audit_no" and  "trg_op"="U|D".


Very easy then to have a view of db changes and even do rollbacks to a 
certain Point in time (which will even be logged in the audit table with 
no software interaction needed).


Johan Nel
George, South Africa

FOX member : Friend(s) of XSharp
X# Website : https://xsharp.info



___
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/2092608e-0e2b-8717-cf2c-da02b7659...@xsinet.co.za
** 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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Frank Cazabon]

Yeah, my succinct point :) was I didn't think it should be a log but a table 
that allows edits. You can then put an audit trail on that if you want or need. 

On 22 April 2019 17:37:45 GMT-04:00, "Paul H. Tarver"  wrote:
>Seems like the reversal would be a logged event as well. 
>
>I've always thought direct edits to any log by a user or even an admin
>corrupts the integrity of the log and invites unlogged edits to be
>made. Asking for trouble depending on the critical nature of the data
>changed. 
>
>Paul H. Tarver
>
>
>
>-Original Message-
>From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>Frank Cazabon
>Sent: Monday, April 22, 2019 4:21 PM
>To: profoxt...@leafe.com
>Subject: Re: How best to do an audit trail of changes (EASILY WITHOUT
>THE NEED FOR A DBA)
>
>If your clients are anything like my clients, make sure you allow them
>access to change the historical dates after they've changed the price.
>Someone is bound to change the price at the wrong time and need to go
>back in and adjust it.
>
>
>
>On 22 April 2019 15:33:48 GMT-04:00, "MB Software Solutions, LLC"
> wrote:
>>VFP9SP2 app, MariaDB 10 (MySQL) backend.
>>
>>One of my clients asked about a history of price changes.  Easy enough
>
>>to implement programmatically for the few price fields, but then I got
>
>>to wondering if simply putting code in the ON UPDATE trigger to send
>>the 
>>old record to a "history" table would be a more complete (and long
>term
>>
>>EASIER) solution, whereby my app would query the "history" table for 
>>changes.
>>
>>Your thoughts for tracking price (or other) changes?
>>
>>tia,
>>--Mike
>>
>>
>>
>>---
>>This email has been checked for viruses by Avast antivirus software.
>>https://www.avast.com/antivirus
>>
>>
[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/3cf4620b-7c5c-4170-a040-88d173c83...@gmail.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Paul H. Tarver]

True, but I felt putting an employee in charge of maintaining logs with no
oversight was asking for trouble long before Sarbanes-Oxley came along. 

Paul H. Tarver


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Charlie-gm
Sent: Monday, April 22, 2019 4:40 PM
To: profoxt...@leafe.com
Subject: Re: How best to do an audit trail of changes (EASILY WITHOUT THE
NEED FOR A DBA)


FYI, if the logs in question belong to a "financial system" (a true 
accounting application), then changing those logs is against the law - 
as far as Sarbanes-Oxley is concerned.

-Charlie

On 4/22/2019 5:37 PM, Paul H. Tarver wrote:
> Seems like the reversal would be a logged event as well.
>
> I've always thought direct edits to any log by a user or even an admin
corrupts the integrity of the log and invites unlogged edits to be made.
Asking for trouble depending on the critical nature of the data changed.
>
> Paul H. Tarver
>
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
> Sent: Monday, April 22, 2019 4:21 PM
> To: profoxt...@leafe.com
> Subject: Re: How best to do an audit trail of changes (EASILY WITHOUT THE
NEED FOR A DBA)
>
> If your clients are anything like my clients, make sure you allow them
access to change the historical dates after they've changed the price.
Someone is bound to change the price at the wrong time and need to go back
in and adjust it.
>
>
>
> On 22 April 2019 15:33:48 GMT-04:00, "MB Software Solutions, LLC"
 wrote:
>> VFP9SP2 app, MariaDB 10 (MySQL) backend.
>>
>> One of my clients asked about a history of price changes.  Easy enough
>> to implement programmatically for the few price fields, but then I got
>> to wondering if simply putting code in the ON UPDATE trigger to send
>> the
>> old record to a "history" table would be a more complete (and long term
>>
>> EASIER) solution, whereby my app would query the "history" table for
>> changes.
>>
>> Your thoughts for tracking price (or other) changes?
>>
>> tia,
>> --Mike
>>
>>
>>
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>>
>>
[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/011b01d4f956$59ca2270$0d5e6750$@tpcqpc.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Charlie-gm]

FYI, if the logs in question belong to a "financial system" (a true 
accounting application), then changing those logs is against the law - 
as far as Sarbanes-Oxley is concerned.


-Charlie

On 4/22/2019 5:37 PM, Paul H. Tarver wrote:

Seems like the reversal would be a logged event as well.

I've always thought direct edits to any log by a user or even an admin corrupts 
the integrity of the log and invites unlogged edits to be made. Asking for 
trouble depending on the critical nature of the data changed.

Paul H. Tarver



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank 
Cazabon
Sent: Monday, April 22, 2019 4:21 PM
To: profoxt...@leafe.com
Subject: Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED 
FOR A DBA)

If your clients are anything like my clients, make sure you allow them access 
to change the historical dates after they've changed the price. Someone is 
bound to change the price at the wrong time and need to go back in and adjust 
it.



On 22 April 2019 15:33:48 GMT-04:00, "MB Software Solutions, LLC" 
 wrote:

VFP9SP2 app, MariaDB 10 (MySQL) backend.

One of my clients asked about a history of price changes.  Easy enough
to implement programmatically for the few price fields, but then I got
to wondering if simply putting code in the ON UPDATE trigger to send
the
old record to a "history" table would be a more complete (and long term

EASIER) solution, whereby my app would query the "history" table for
changes.

Your thoughts for tracking price (or other) changes?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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/d46dcf28-35be-f127-99f0-872bb8a67...@gmail.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Stephen Russell]

Or normalize the price out of the item table.  Now you can combine the item
and the customer to determine that price.  In our industry prices change
monthly based off of an industry standard.

On Mon, Apr 22, 2019 at 2:34 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> VFP9SP2 app, MariaDB 10 (MySQL) backend.
>
> One of my clients asked about a history of price changes.  Easy enough
> to implement programmatically for the few price fields, but then I got
> to wondering if simply putting code in the ON UPDATE trigger to send the
> old record to a "history" table would be a more complete (and long term
> EASIER) solution, whereby my app would query the "history" table for
> changes.
>
> Your thoughts for tracking price (or other) changes?
>
> tia,
> --Mike
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
[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/CAJidMY+48dV+bOqh7ejqNh+pqp8NJJOb=u3kvj-j4vyn5ii...@mail.gmail.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Paul H. Tarver]

Agreed, but at least if there is some code out there for the logging
portion, you wouldn't have to do much on that side. 

Paul H. Tarver

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
Software Solutions, LLC
Sent: Monday, April 22, 2019 3:21 PM
To: profoxt...@leafe.com
Subject: Re: How best to do an audit trail of changes (EASILY WITHOUT THE
NEED FOR A DBA)

Even if somebody's built it for MySQL, I'd still have to code my VFP app 
to query that History table to show the changes made by who and when.


On 4/22/2019 4:05 PM, Paul H. Tarver wrote:
> I did a project many moons ago where we used the INSERT, UPDATE and DELETE
triggers in a Foxpro 6.0 DBC to track field level changes by users by date
and time. It was fairly successful other than making our data very dependent
upon maintaining a valid DBC. Later, we extended program by adding a
connection to a FirebirdSQL database which was then use by a Java-based web
front-end. In the case of Firebird, I found a tools called IBLogManager
which did the same thing at a SQL level using the same sorts of triggers.
>
> I wonder if someone hasn't already created a similar tool for MySQL that
you could take advantage of.
>
> Paul H. Tarver
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
Software Solutions, LLC
> Sent: Monday, April 22, 2019 2:34 PM
> To: profoxt...@leafe.com
> Subject: How best to do an audit trail of changes (EASILY WITHOUT THE NEED
FOR A DBA)
>
> VFP9SP2 app, MariaDB 10 (MySQL) backend.
>
> One of my clients asked about a history of price changes.  Easy enough
> to implement programmatically for the few price fields, but then I got
> to wondering if simply putting code in the ON UPDATE trigger to send the
> old record to a "history" table would be a more complete (and long term
> EASIER) solution, whereby my app would query the "history" table for
> changes.
>
> Your thoughts for tracking price (or other) changes?
>
> tia,
> --Mike
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
[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/011101d4f953$9fda9090$df8fb1b0$@tpcqpc.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Paul H. Tarver]

Seems like the reversal would be a logged event as well. 

I've always thought direct edits to any log by a user or even an admin corrupts 
the integrity of the log and invites unlogged edits to be made. Asking for 
trouble depending on the critical nature of the data changed. 

Paul H. Tarver



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank 
Cazabon
Sent: Monday, April 22, 2019 4:21 PM
To: profoxt...@leafe.com
Subject: Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED 
FOR A DBA)

If your clients are anything like my clients, make sure you allow them access 
to change the historical dates after they've changed the price. Someone is 
bound to change the price at the wrong time and need to go back in and adjust 
it.



On 22 April 2019 15:33:48 GMT-04:00, "MB Software Solutions, LLC" 
 wrote:
>VFP9SP2 app, MariaDB 10 (MySQL) backend.
>
>One of my clients asked about a history of price changes.  Easy enough 
>to implement programmatically for the few price fields, but then I got 
>to wondering if simply putting code in the ON UPDATE trigger to send
>the 
>old record to a "history" table would be a more complete (and long term
>
>EASIER) solution, whereby my app would query the "history" table for 
>changes.
>
>Your thoughts for tracking price (or other) changes?
>
>tia,
>--Mike
>
>
>
>---
>This email has been checked for viruses by Avast antivirus software.
>https://www.avast.com/antivirus
>
>
[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/011001d4f953$9f9a2c30$dece8490$@tpcqpc.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] SSL Issues

[Ted Roche]

Ed:

My blog is melting down on some leafe.com issues. I suspect you've updated
your SSL cert recently, and it looks like some of the older http:// links
aren't working or aren't redirecting.

http://dabodev.com returns an error, while the https page is working okay.

I had to update a couple of archive links to https as well.

You may want to put in a server directive, if you can, to redirect the
http:// addresses to the matching https://

Or not. I'll still re-up my subscription!

-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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/cacw6n4snv1sjyjxb96seszsdwwod2hm3hl3udksbvbad-ci...@mail.gmail.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Eric Selje]

Yes, absolutely appropriate for an ONUPDATE trigger. Insert a new record
into the history table before doing the update.

If you want to do this for every field in every table, FoxAudit is the tool
of choice. (I don't see it on TakeNote.com's website any more but maybe
shoot an email to Jim Duffy)

Eric

On Mon, Apr 22, 2019 at 2:33 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> VFP9SP2 app, MariaDB 10 (MySQL) backend.
>
> One of my clients asked about a history of price changes.  Easy enough
> to implement programmatically for the few price fields, but then I got
> to wondering if simply putting code in the ON UPDATE trigger to send the
> old record to a "history" table would be a more complete (and long term
> EASIER) solution, whereby my app would query the "history" table for
> changes.
>
> Your thoughts for tracking price (or other) changes?
>
> tia,
> --Mike
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
[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/caawxvunl1vkjkhjcule2cynm6dju-epsnt1zfaqftjktdoi...@mail.gmail.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Frank Cazabon]

If your clients are anything like my clients, make sure you allow them access 
to change the historical dates after they've changed the price. Someone is 
bound to change the price at the wrong time and need to go back in and adjust 
it.



On 22 April 2019 15:33:48 GMT-04:00, "MB Software Solutions, LLC" 
 wrote:
>VFP9SP2 app, MariaDB 10 (MySQL) backend.
>
>One of my clients asked about a history of price changes.  Easy enough 
>to implement programmatically for the few price fields, but then I got 
>to wondering if simply putting code in the ON UPDATE trigger to send
>the 
>old record to a "history" table would be a more complete (and long term
>
>EASIER) solution, whereby my app would query the "history" table for 
>changes.
>
>Your thoughts for tracking price (or other) changes?
>
>tia,
>--Mike
>
>
>
>---
>This email has been checked for viruses by Avast antivirus software.
>https://www.avast.com/antivirus
>
>
[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/6383821e-b851-4045-9b90-df2fc31a1...@gmail.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

Even if somebody's built it for MySQL, I'd still have to code my VFP app 
to query that History table to show the changes made by who and when.



On 4/22/2019 4:05 PM, Paul H. Tarver wrote:

I did a project many moons ago where we used the INSERT, UPDATE and DELETE 
triggers in a Foxpro 6.0 DBC to track field level changes by users by date and 
time. It was fairly successful other than making our data very dependent upon 
maintaining a valid DBC. Later, we extended program by adding a connection to a 
FirebirdSQL database which was then use by a Java-based web front-end. In the 
case of Firebird, I found a tools called IBLogManager which did the same thing 
at a SQL level using the same sorts of triggers.

I wonder if someone hasn't already created a similar tool for MySQL that you 
could take advantage of.

Paul H. Tarver


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: Monday, April 22, 2019 2:34 PM
To: profoxt...@leafe.com
Subject: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR 
A DBA)

VFP9SP2 app, MariaDB 10 (MySQL) backend.

One of my clients asked about a history of price changes.  Easy enough
to implement programmatically for the few price fields, but then I got
to wondering if simply putting code in the ON UPDATE trigger to send the
old record to a "history" table would be a more complete (and long term
EASIER) solution, whereby my app would query the "history" table for
changes.

Your thoughts for tracking price (or other) changes?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



[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/f699f2ca-8882-f5f3-cec8-3c7255dfa...@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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Paul H. Tarver]

I did a project many moons ago where we used the INSERT, UPDATE and DELETE 
triggers in a Foxpro 6.0 DBC to track field level changes by users by date and 
time. It was fairly successful other than making our data very dependent upon 
maintaining a valid DBC. Later, we extended program by adding a connection to a 
FirebirdSQL database which was then use by a Java-based web front-end. In the 
case of Firebird, I found a tools called IBLogManager which did the same thing 
at a SQL level using the same sorts of triggers. 

I wonder if someone hasn't already created a similar tool for MySQL that you 
could take advantage of. 

Paul H. Tarver


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: Monday, April 22, 2019 2:34 PM
To: profoxt...@leafe.com
Subject: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR 
A DBA)

VFP9SP2 app, MariaDB 10 (MySQL) backend.

One of my clients asked about a history of price changes.  Easy enough 
to implement programmatically for the few price fields, but then I got 
to wondering if simply putting code in the ON UPDATE trigger to send the 
old record to a "history" table would be a more complete (and long term 
EASIER) solution, whereby my app would query the "history" table for 
changes.

Your thoughts for tracking price (or other) changes?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


[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/00d401d4f946$b1fad620$15f08260$@tpcqpc.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 best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[MB Software Solutions, LLC]

VFP9SP2 app, MariaDB 10 (MySQL) backend.

One of my clients asked about a history of price changes.  Easy enough 
to implement programmatically for the few price fields, but then I got 
to wondering if simply putting code in the ON UPDATE trigger to send the 
old record to a "history" table would be a more complete (and long term 
EASIER) solution, whereby my app would query the "history" table for 
changes.


Your thoughts for tracking price (or other) changes?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/44820f32-921d-b662-45cd-151a705bf...@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] Context Menu

[Charles Hart Enzer, M.D.]

SOLVED with a Context Menu Editor:
https://www.howtogeek.com/howto/windows-vista/how-to-clean-up-your-messy-windows-context-menu/

http://www.nirsoft.net/utils/shell_menu_view.html



*Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP*
*Aliyah : Cincinnati to Jerusalem
's German Colony
 May, 2017*



*Volunteer Associate Professor of PsychiatryUniversity of Cincinnati
Medical CenterWebSite: **EnzerMD.com *
*Publications* 

*Tiny Country, Huge Dreams*
*ארץ זעירה, **חלומות ענקיים*
*עם ישראל חי*


On Sat, Apr 20, 2019 at 9:39 PM Charles Hart Enzer, M.D. 
wrote:

> I am on WIN 10 64bit Pro Version 1803
>
> The popup menu has two [Scan with Windows Defender]s
>
>- One pops up a CMD window
>- One pops up the Defender GUI
>
> I want only the GUI.
>
> Thank you.
>
>
> *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP*
> *Aliyah : Cincinnati to Jerusalem
> 's German Colony
>  May, 2017*
>
>
>
> *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati
> Medical CenterWebSite: **EnzerMD.com *
> *Publications* 
>
> *Tiny Country, Huge Dreams*
> *ארץ זעירה, **חלומות ענקיים*
> *עם ישראל חי*
>


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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/CAFSdja3sDepcqmvJjd04xWnPa++tyHrZoM0n=sgbbkrc3xy...@mail.gmail.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] Context Menu

[Charles Hart Enzer, M.D.]

[HKEY_CLASSES_ROOT\DesktopBackground\Shell\Personalize]
[image: image.png]
[HKEY_CLASSES_ROOT\DesktopBackground\Shell\Personalize]
[image: image.png]



*Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP*
*Aliyah : Cincinnati to Jerusalem
's German Colony
 May, 2017*



*Volunteer Associate Professor of PsychiatryUniversity of Cincinnati
Medical CenterWebSite: **EnzerMD.com *
*Publications* 

*Tiny Country, Huge Dreams*
*ארץ זעירה, **חלומות ענקיים*

*עם ישראל חי*


On Mon, Apr 22, 2019 at 6:49 PM Gérard LOCHON  wrote:

> Do you mean right-clicking on any icon lying on the desktop, or by
> cligking anywhere else on the desktop ?
>
> If it happens with both of it, i suspect an unwanted key to appear in
> the registry (or an unwanted subkey value).
>
> Tell us what you see examining these registry keys/folders :
>
> [HKEY_CLASSES_ROOT\DesktopBackground\Shell\Personalize]
>
> and
>
> [HKEY_CLASSES_ROOT\DesktopBackground\Shell\regedit\command]
>
> Gérard.
>
> On 22/04/2019 17:17, Charles Hart Enzer, M.D. wrote:
> > The CONTEXT MENU pops up when I Right Click on an item on the PC
> >
> > Shai / שי
> > Charles Hart Enzer, MD(Ohio, USA), FAACAP
> > Aliyah: Cincinnati to Jerusalem's German Colony May, 2017
> >
> > Volunteer Associate Professor of Psychiatry
> > University of Cincinnati Medical Center
> > WebSite: http://EnzerMD.com
> >
> > Tiny Country, Huge Dreams
> > מדינה זעירה, חלומות ענקיים
> >
> > עם ישראל חי
> >
> > On Mon, Apr 22, 2019, 14:04 Gérard LOCHON  wrote:
> >
> >> Hello.
> >>
> >> It's not in Settings/Update & Security/Windows Defender ... Where or how
> >> do you see these two options ?
> >>
> >> Gérard.
> >>
> >>
> >> On 20/04/2019 20:39, Charles Hart Enzer, M.D. wrote:
> >>> I am on WIN 10 64bit Pro Version 1803
> >>>
> >>> The popup menu has two [Scan with Windows Defender]s
> >>>
> >>>  - One pops up a CMD window
> >>>  - One pops up the Defender GUI
> >>>
> >>> I want only the GUI.
> >>>
> >>> Thank you.
> >>>
> >>>
> >>> *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP*
> >>> *Aliyah : Cincinnati to
> Jerusalem
> >>> 's German Colony
> >>>  May, 2017*
> >>>
> >>>
> >>
[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/cafsdja2hunvdkq8nj5yuc+iegtetf1-bvh4vn18c_cum1i6...@mail.gmail.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] Context Menu

[Gérard LOCHON]

Do you mean right-clicking on any icon lying on the desktop, or by 
cligking anywhere else on the desktop ?


If it happens with both of it, i suspect an unwanted key to appear in 
the registry (or an unwanted subkey value).


Tell us what you see examining these registry keys/folders :

[HKEY_CLASSES_ROOT\DesktopBackground\Shell\Personalize]

and

[HKEY_CLASSES_ROOT\DesktopBackground\Shell\regedit\command]

Gérard.

On 22/04/2019 17:17, Charles Hart Enzer, M.D. wrote:

The CONTEXT MENU pops up when I Right Click on an item on the PC

Shai / שי
Charles Hart Enzer, MD(Ohio, USA), FAACAP
Aliyah: Cincinnati to Jerusalem's German Colony May, 2017

Volunteer Associate Professor of Psychiatry
University of Cincinnati Medical Center
WebSite: http://EnzerMD.com

Tiny Country, Huge Dreams
מדינה זעירה, חלומות ענקיים

עם ישראל חי

On Mon, Apr 22, 2019, 14:04 Gérard LOCHON  wrote:


Hello.

It's not in Settings/Update & Security/Windows Defender ... Where or how
do you see these two options ?

Gérard.


On 20/04/2019 20:39, Charles Hart Enzer, M.D. wrote:

I am on WIN 10 64bit Pro Version 1803

The popup menu has two [Scan with Windows Defender]s

 - One pops up a CMD window
 - One pops up the Defender GUI

I want only the GUI.

Thank you.


*Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP*
*Aliyah : Cincinnati to Jerusalem
's German Colony
 May, 2017*





[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/61d54f07-fe24-92c3-e594-b80eef706...@wanadoo.fr
** 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] Context Menu

[Charles Hart Enzer, M.D.]

The CONTEXT MENU pops up when I Right Click on an item on the PC

Shai / שי
Charles Hart Enzer, MD(Ohio, USA), FAACAP
Aliyah: Cincinnati to Jerusalem's German Colony May, 2017

Volunteer Associate Professor of Psychiatry
University of Cincinnati Medical Center
WebSite: http://EnzerMD.com

Tiny Country, Huge Dreams
מדינה זעירה, חלומות ענקיים

עם ישראל חי

On Mon, Apr 22, 2019, 14:04 Gérard LOCHON  wrote:

> Hello.
>
> It's not in Settings/Update & Security/Windows Defender ... Where or how
> do you see these two options ?
>
> Gérard.
>
>
> On 20/04/2019 20:39, Charles Hart Enzer, M.D. wrote:
> > I am on WIN 10 64bit Pro Version 1803
> >
> > The popup menu has two [Scan with Windows Defender]s
> >
> > - One pops up a CMD window
> > - One pops up the Defender GUI
> >
> > I want only the GUI.
> >
> > Thank you.
> >
> >
> > *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP*
> > *Aliyah : Cincinnati to Jerusalem
> > 's German Colony
> >  May, 2017*
> >
> >
>
>
[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/cafsdja3r2rajmce80tyrbqdhwlhpd3fzj+n15p5wkpigroq...@mail.gmail.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] Context Menu

[Gérard LOCHON]

Hello.

It's not in Settings/Update & Security/Windows Defender ... Where or how 
do you see these two options ?


Gérard.


On 20/04/2019 20:39, Charles Hart Enzer, M.D. wrote:

I am on WIN 10 64bit Pro Version 1803

The popup menu has two [Scan with Windows Defender]s

- One pops up a CMD window
- One pops up the Defender GUI

I want only the GUI.

Thank you.


*Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP*
*Aliyah : Cincinnati to Jerusalem
's German Colony
 May, 2017*





___
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/517883ac-ca54-c7b8-3a9f-93e2b4674...@wanadoo.fr
** 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.