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@yahoogroups.com
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]