QSSqlQuery CREATE TRIGGER not working

[ckvsoft]

Hallo

I found some questions about it, but no realy solution.

I try

query.exec("CREATE TRIGGER UpdateCategoriesLastModifiedTime UPDATE OF categories_description, categories_title, categories_status ON categories BEGIN UPDATE categories SET last_modified=CURRENT_TIMESTAMP WHERE categories_id=categories_id END")

query.exec("CREATE TRIGGER UpdateCategoriesLastModifiedTime UPDATE OF categories_description, categories_title, categories_status ON categories BEGIN UPDATE categories SET last_modified=CURRENT_TIMESTAMP WHERE categories_id=categories_id END")

To copy to clipboard, switch view to plain text mode 

and get the Error:

incomplete input Der Befehl konnte nicht ausgeführt werden"
Function Name:  static bool Database::open(bool)   "cannot commit - no transaction is active Der Datensatz konnte nicht abgeholt werden"
Function Name:  static bool Database::open(bool)   "END"
Function Name:  static bool Database::open(bool)   "near \"END\": syntax error Der Befehl konnte nicht ausgeführt werden"

incomplete input Der Befehl konnte nicht ausgeführt werden"
Function Name:  static bool Database::open(bool)   "cannot commit - no transaction is active Der Datensatz konnte nicht abgeholt werden"
Function Name:  static bool Database::open(bool)   "END"
Function Name:  static bool Database::open(bool)   "near \"END\": syntax error Der Befehl konnte nicht ausgeführt werden"

To copy to clipboard, switch view to plain text mode 

Can anyone help me?

lg Chris

[Lesiok]

I think that before END You have to put char ;

query.exec("CREATE TRIGGER UpdateCategoriesLastModifiedTime UPDATE OF categories_description, categories_title, categories_status ON categories "
"BEGIN "
"    UPDATE categories SET last_modified=CURRENT_TIMESTAMP WHERE categories_id=categories_id; "
"END")

query.exec("CREATE TRIGGER UpdateCategoriesLastModifiedTime UPDATE OF categories_description, categories_title, categories_status ON categories "
"BEGIN "
"    UPDATE categories SET last_modified=CURRENT_TIMESTAMP WHERE categories_id=categories_id; "
"END")

To copy to clipboard, switch view to plain text mode