Re: DISTINCT
From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 6 May 1999 11:27:12 GMT
Message-ID: <01be97b3$620e5840$190114c1_at_sister.grant.UUCP>
Date: 6 May 1999 11:27:12 GMT
Message-ID: <01be97b3$620e5840$190114c1_at_sister.grant.UUCP>
If you don't want to create a permanent view, put (select distinct col1, ..., coln, null from your_table) into Base Table block property.
-- Alexander I.Doroshko, aid_at_grant.kharkov.ua * Bank "Grant", Kharkov, Ukraine Alexander I. Doroshko <aid_at_grant.kharkov.ua> wrote in article <01be97ac$4f2d71e0$190114c1_at_sister.grant.UUCP>...Received on Thu May 06 1999 - 13:27:12 CEST
: Create a view for your
: SELECT DISTINCT.
: If you want to do updates/deletes/inserts in this block,
: your must write ON-LOCK, ON-UPDATE etc. triggers.