dbnotify

This forum is for eXpress++ general support.
Post Reply
Message
Author
skiman
Posts: 1199
Joined: Thu Jan 28, 2010 1:22 am
Location: Sijsele, Belgium
Contact:

dbnotify

#1 Post by skiman »

Hi Roger,

Today I discovered your dbnotify sample. This is GREAT! With 3 lines of code I can log changes in a database. This saved me days of work!

Code: Select all

 if lNotify
	oNotify := KLANT->(DC_DbNotify():new())
	oNotify:writeBlock := {|cEvent,cAlias,cDesc,oNotify|WriteData(cEvent,cAlias,cDesc)}
	oNotify:SetNotifications( { DBO_TABLE_UPDATE, DBO_TABLE_APPEND, DBO_TABLE_DELETED }, { 'NAAM', 'BTW_NR', 'BET_DAGEN', 'BET_EINDE', 'PRIJSCAT' , 'FAKT_KLANT' , 'ADRES', 'EMAIL' } )
 endif
With the above code, I just have to change the alias and the fieldnames, and I can log all database modifications for the files I want. :clap:
Best regards,

Chris.
www.aboservice.be

User avatar
rdonnay
Site Admin
Posts: 4813
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: dbnotify

#2 Post by rdonnay »

I'm happy that your'e happy!! :banana-dreads:
The eXpress train is coming - and it has more cars.

Post Reply