On Sunday, September 4, 2005, 1:42:02 PM, Dmitry Yemanov wrote:

> "Bambang P" <bpranoto@...> wrote:
>>
>> CREATE VIEW VIEW_DUR ( ID,DUR_HOUR,DUR_MIN)
>> as SELECT ID,
>> cast( DURATION_MINUTES/60 as INTEGER),
>> cast( DURATION_MINUTES - ((DURATION_MINUTES/60)*60) as integer)
>> from DURATION;

> Try this:

> from DURATION join RDB$DATABASE on 1=1

> In your case, the engine updates the table two times - directly (because a

That works! Thanks!

--
Bambang P.


Age is a very high price to pay for maturity.