AW: VFP9SP2 DBC -- update trigger

2019-10-03 Thread juergen
end me a PM. wOOdy -Ursprüngliche Nachricht- Von: ProFox Im Auftrag von Eric Selje Gesendet: Donnerstag, 3. Oktober 2019 22:46 An: ProFox Email List Betreff: Re: VFP9SP2 DBC -- update trigger I'd get FoxAudit (if you can find it) for this. Well worth the price and takes minutes t

Re: VFP9SP2 DBC -- update trigger

2019-10-03 Thread Eric Selje
I'd get FoxAudit (if you can find it) for this. Well worth the price and takes minutes to set up to get very very robust change management. Eric On Wed, Oct 2, 2019 at 6:33 AM Charlie Coleman wrote: > Yes, with VFP it is that simple. > > I would suggest adding a timestamp to your logging table.

Re: VFP9SP2 DBC -- update trigger

2019-10-02 Thread Charlie Coleman
Yes, with VFP it is that simple. I would suggest adding a timestamp to your logging table. Technically, since your just doing inserts you could assume sequence - but seeing the time of day of events might help track this down. That means your log table structure would be slightly different of cour

Re: VFP9SP2 DBC -- update trigger

2019-10-01 Thread Koen Piller
Hi, You can also apply the Field Validation. Set in the Rule box !Empty(this.Value) and users are not able to save the record with that field empty. You can also write an information message in the Mesage box of the field. These fields can be found by modify your table. Regards, Koen Op wo 2 okt

VFP9SP2 DBC -- update trigger

2019-10-01 Thread MB Software Solutions, LLC
I've got a client with a wonky situation where the data (for some unknown reason) gets "blanked out" (not deleted, mind you...just some fields set to blanks).  I wanted to add an UPDATE trigger so that I could get some sort of historical update accounting to help me hone in on where the problem