Hi,
I am introducing myself into local databases and found this cool tool you shared with us. Thank you very much! It is what I need.
I have been playing for a couple of days and it worked very well. But I realized it does not work for multiple sentences queries. I put an example:
CREATE TABLE 'tipos' ( 'index' INTEGER PRIMARY KEY AUTOINCREMENT, 'nombre' VARCHAR(32) UNIQUE, 'cantidad' INTEGER );
INSERT INTO 'tipos' ( 'nombre', 'cantidad' ) VALUES ( 'Tipo 000', 0 );" );
It simply obviates the second sentence.
In the try to build triggers for my database. It works well for single sentences but crashes when trying to add a new sentence to the automation.
CREATE TRIGGER 'contador_tipo' AFTER INSERT ON 'objetos'
BEGIN
UPDATE 'tipos' SET 'cantidad' = 'tipos'.'cantidad' + 1 WHERE 'tipos'.'index' = NEW.'tipo';
UPDATE 'tipos2' SET 'cantidad' = 'tipos2'.'cantidad' + 1 WHERE 'tipos2'.'index' = NEW.'tipo';
END;
I know this addon is getting old but is there any chance to fix it? Thank you anyway. It helps me a lot as it is.
Salud!
PD: tried to create an account on gstools.de forum but the system failed