At 12:07 PM 21-05-02 +0800, Benny Setiawan Tanua wrote:

>i'm sorry i'm beginner in interbase.
>Can you please provide me the detail about sorting and matching ?

Sorting is what happens when you request ORDER BY or GROUP BY in an SQL
statement.

Matching is what happens when you request a JOIN or a WHERE criterion in an
SQL statement.

>or maybe step by step instruction about that.

Look up the Indexes topics in the manuals, along with the documentation for
the SELECT statement. InterBase (beta) manuals are available from
ftp://ftpc.inprise.com/pub/interbase/techpubs/ib_b60_doc.zip
or you can get the Firebird manuals by purchasing the IBPhoenix CD
(http://www.ibphoenix.com).

>for example : i don't understand about BU and BI trigger means ?

Triggers are routines written in IB/FB programming language (PSQL) which
run automatically when data changes are requested through SQL. There are
two phases when triggers can fire: before an operation and after an
operation. There are three operations on which they can fire: insert,
update and delete. So BU is a quick way to refer to a "Before Update"
trigger and BI is "Before Insert".

Please make sure you post your questions to the list, not to my private
email address...thks.

regards,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________