--- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.tonies@...> wrote:

>
>
>
> > Dne 11.3.2011 8:51, thedevguy napsal(a):
> >> Is there a way to sync two columns in the same table using a trigger.
> >> For example I have field1 and field2. On an insert or an update I would
> >> like field2 = field1 if they are different.
> >>
>
>
> What's wrong with ALWAYS setting field2 = field1? If they're different, you
> want them to be the same. Which means that if they're the same, you can copy
> its value anyway.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
>
> >> I tried something like the following but it doesn't work.
> >>
> >> TRIGGER:
> >> if (new.field1<> old.field2) then
> >> new.field2 = new.field1;
> >>
> >> Any help would be greatly appreciated.
> >
> > This kind of triggers works fine for me. I am pretty sure your
> > particular implementation has some bugs, e.g. one of the fields contains
> > a NULL value and the usual "comparison of anything to null is almost
> > always false" GOTCHA kicks in.
> >
> > Pepak
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
> >
>

Hi

better is ask self why you need two fields to be the same in whole table - remove one from database and read always field 1...

Karol Bieniaszewski