Performing multi-line SQL statement

[Cigma]

hi guys, I am running MySQL QB 1.1.19. I am wondering why every other SQL Query program can perform a multi-line SQL statement but MySQL QB can not? What is needed to do to make it work?
I am unable to execute this statement in QB in the SCRIPT window:

CREATE TRIGGER Inventory_BeforeDelete BEFORE DELETE ON Inventory
FOR EACH ROW
BEGIN
DELETE FROM InventoryProperty WHERE InventoryProperty.InventoryKey=OLD.InventoryKey;
END;

QB want's the entire thing on one line. Please help me in some way!
Thank you! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Thalian]

MySQL QB has two SQL editors: the query area and the script editor. The first one is for single queries only and the other one is for multiple statements and can be used to step through the script. You are using the same delimiter for both, the command itself and the trigger text. So there must be at least a "delimiter xxx" command.
Open a script tab and put this code in:

delimiter $
CREATE TRIGGER Country_BeforeDelete BEFORE DELETE ON Country
FOR EACH ROW
BEGIN
DELETE FROM City WHERE City.ID = OLD.Capital;
END $ -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --