Re: [ADMIN] SSL Issues

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

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

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:

Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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

Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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?

Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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

Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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

RE: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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

RE: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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,

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.

Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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>

RE: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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

RE: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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

[ADMIN] SSL Issues

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

Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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)

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

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

RE: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

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

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

Re: [NF] Context Menu

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

Re: [NF] Context Menu

[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

Re: [NF] Context Menu

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 :

Re: [NF] Context Menu

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

Re: [NF] Context Menu

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