--- In IBObjects@y..., "Artur Anjos" <arsoft@n...> wrote:
> Hello
>
> You must tell the trigger where do you want the values from the
select. Something like
>
> SELECT * FROM COSTCATEGORYDEFINITIONS
> WHERE COSTCATEGORYNO = NEW.COSTCATEGORYNO
> INTO :a,:b,:c;
>
> I know this message is not very helpfull.... (TOKEN UNKNOWN - LINE
7, CHAR 44, but it's telling you 'Please don't stop here, tell me
where did you want me to put this values into'
>
> Artur
>
> ----- Original Message -----
> From: slsolutions2002
> To: IBObjects@y...
> Sent: Friday, February 15, 2002 4:41 PM
> Subject: [IBO] Problem with SQL syntax
>
>
> Hello:
>
> Can someone tell me what is wrong with this statement:
> SET TERM !! ;
> CREATE TRIGGER tgPOSTCOSTDETAIL FOR COSTCATEGORYDETAIL
> AFTER UPDATE
> POSITION 1
> AS
> BEGIN
> SELECT * FROM COSTCATEGORYDEFINITIONS
> WHERE COSTCATEGORYNO = NEW.COSTCATEGORYNO;
> END !!
> SET TERM ; !!
> COMMIT;
>
> I get error message:
> ISC ERROR CODE: 335544569
> ICI ERROR MESSAGE
> DYNAMIC SQL ERROR = -104
> TOKEN UNKNOWN - LINE 7, CHAR 44
> ;
>
> I believe I am following the syntax right out of the book but
> whatever SQL statement I put between BEGIN and END !! I get an
error
> If I leave off the trailing semi-colon it get a different error.
>
> Thanks
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
______________________________________________________________________
_____
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
______________________________________________________________________
_____
> http://www.ibobjects.com - your IBO community resource for Tech
Info papers,
> keyword-searchable FAQ, community code contributions and
more !
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]