At 08:24 PM 21/01/2006 +0000, you wrote:

>Hi,
> does someone knows how to create a trigger or a procedure by delphi
>db Express ? I've tried by the ExecuteDirect method of the
>TSQLConnection but i found problems with the SET TERM. In fact it
>seems not recognized.
>
>Any suggestion ?

SET TERM is an ISQL statement - it's not available (or needed) outside the
ISQL environment.

Note too that, even if SET TERM were valid DSQL, ExecuteDirect processes
one and only one statement. Your complex CREATE TRIGGER or CREATE
PROCEDURE statement is OK (its embedded statements are valid within the DDL
request) but adding extra statements is not. And if you are trying to use
ExecuteDirect to process an ISQL script, that can't work either.

./heLen