Well,

> Thanks for your answer.
>
> > Dialect 3 follows SQL rules for integer/integer division: the
> result is
> > always rounded down to an integer.
>
>
> This seems to me to be a stupid rule, because if I have a non integer
> value as result and assign this to a non integer variable, it should
> not be rounded.
>
> o.k. if I now, I can pay attention to it in my triggers, but
> nevertheless I find it a stupid rule;-)

SQL standard ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com