Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 10 of 10 total

Fri, Oct 9 2009 4:02 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Is there any way of forcing a trigger to execute across the whole table? The reason I want to do this is I'm adding a trigger to format phone numbers and I want to get the whole database into the same format plus if I ever change the way they're formatted I'll need to persuade it to run again. Roy Lambert
Fri, Oct 9 2009 5:47 AM	Permanent Link
Uli Becker	Roy, > Is there any way of forcing a trigger to execute across the whole table? How about calling a procedure from within the trigger? Uli
Fri, Oct 9 2009 6:15 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Uli >> Is there any way of forcing a trigger to execute across the whole table? > >How about calling a procedure from within the trigger? OK, but how do I get the trigger to execute to start with? Roy Lambert
Fri, Oct 9 2009 10:24 AM	Permanent Link
"John Hay"	Roy > Is there any way of forcing a trigger to execute across the whole table? > > The reason I want to do this is I'm adding a trigger to format phone numbers and I want to get the whole database into the same format plus if I ever change the way they're formatted I'll need to persuade it to run again. Maybe the bit that does the formatting should be a function. This could then be called by a trigger, a simple sql statement or procedure. John
Fri, Oct 9 2009 1:02 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	John I'm thinking of going down the external function (written in delphi) route, especially with the ability to switch off triggers. Roy Lambert
Sun, Oct 11 2009 8:35 PM	Permanent Link
Richard Harding	Roy, >> OK, but how do I get the trigger to execute to start with? How about something like UPDATE Table1 SET Column1 = Column1 Richard Harding
Mon, Oct 12 2009 2:40 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Richard I don't know why but I thought ElevateDB was smarter than that. I'll give it a go. Roy Lambert
Mon, Oct 12 2009 2:04 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << I don't know why but I thought ElevateDB was smarter than that. >> ElevateDB defers to the developer on certain things, expecting them to be smarter than the software. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Oct 12 2009 2:12 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim >ElevateDB defers to the developer on certain things, expecting them to be >smarter than the software. Oh shiiiit
Mon, Oct 12 2009 4:45 PM	Permanent Link
"Daniel Kram"	LOL "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:4AF76CF6-5A7B-41CB-8C84-B1E0AC7F4F60@news.elevatesoft.com... > Tim > >>ElevateDB defers to the developer on certain things, expecting them to be >>smarter than the software. > > Oh shiiiit > >