Re: Trigger design

2017-10-17 Thread Charlie-gm
On 10/17/2017 5:58 AM, Dave Crozier wrote: ... I decided to add an audit trail feature into a small system here at Flexipol via the DBC Triggers roughly based on the example in MegaFox chapter 7. In order to make things simple and more in line with OOP philosophy I decided to construct an Audi

Re: Sad news...

2017-10-17 Thread mbsoftwaresolutions
On 2017-10-11 14:33, Ed Leafe wrote: On Oct 11, 2017, at 4:32 AM, Dave Crozier wrote: RIP Allen It’s always surprising when you learn of the death of someone you only knew electronically - it feels just as strong as with those for whom you did have the pleasure of meeting in person. I’ll mis

Re: Sad news...

2017-10-17 Thread mbsoftwaresolutions
RIP Allen. You were a good contributor here and will be missed. Pull some strings with the Big Guy upstairs to reinvigorate VFP for us. ;-) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/prof

Re: Trigger design

2017-10-17 Thread Ted Roche
On Tue, Oct 17, 2017 at 5:25 PM, Eric Selje wrote: > Fox Audit was written by Jim Duffy at TakeNote. I see the page for the > product is no longer there, but his website (and contact info) is still up: > takenote.com. Maybe you can contact him directly. And here's what the page looked like: htt

Re: Trigger design

2017-10-17 Thread Eric Selje
Fox Audit was written by Jim Duffy at TakeNote. I see the page for the product is no longer there, but his website (and contact info) is still up: takenote.com. Maybe you can contact him directly. I'm not sure why it wasn't more prevalant. It worked well, with few caveats, for us. Of course the u

RE: Trigger design

2017-10-17 Thread Paul H. Tarver
Did a general search for FoxAudit because I was interested, but all I could find was a foreign company named FoxAudit and a lot of Foxpro tips where people recommended FoxAudit. While doing so I ran across a Microsoft article describing how to build a VFP6 COM application and register and use

RE: Trigger design

2017-10-17 Thread Dave Crozier
I think the object attachment to _SCREEN has sorted out the problem ... so far so good. Will report back after further testing. Dave --- This communication and the information it contains is intended for the person or organisation

Re: Trigger design

2017-10-17 Thread Thierry Nivelet
cristal clear, thanks Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 17/10/2017 à 16:10, Ted Roche a écrit : On Tue, Oct 17, 2017 at 9:33 AM, Thierry Nivelet wrote: Just wondering, in which case would you addProperty(_vfp, …) rather than addP

Re: Trigger design

2017-10-17 Thread Ted Roche
On Tue, Oct 17, 2017 at 9:33 AM, Thierry Nivelet wrote: > > Just wondering, in which case would you addProperty(_vfp, …) rather than > addProperty(_screen, …) > A FoxPro DBC may be opened via ODBC/OLEDB rather than within a running FoxPro development or runtime session. _SCREEN is not available i

RE: Trigger design

2017-10-17 Thread Dave Crozier
Thierry, Will give that a shot... Dave --- This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have

Re: Trigger design

2017-10-17 Thread Thierry Nivelet
Hi Eric, Just wondering, in which case would you addProperty(_vfp, …) rather than addProperty(_screen, …) Could not figure out a sound reason so far… Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 17/10/2017 à 15:28, Eric Selje a écrit : Pe

Re: Trigger design

2017-10-17 Thread Eric Selje
I started down this road once, but ended up purchasing FoxAudit because it did everything I needed in a much more robust fashion. I'm not sure if it's still marketed though. Perhaps you could make oAudit a property of the _VFP object so it will always be available. (_vfp.addobject("oAudit", "class

Re: Trigger design

2017-10-17 Thread Alan Bourke
Try passing oAudit in as a parameter to your trigger. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: htt

Trigger design

2017-10-17 Thread Dave Crozier
Profox People, I decided to add an audit trail feature into a small system here at Flexipol via the DBC Triggers roughly based on the example in MegaFox chapter 7. In order to make things simple and more in line with OOP philosophy I decided to construct an Audit Class with all the logic embedde