hayho
New Member
Posts: 3
|
Post by hayho on May 25, 2021 9:55:18 GMT
HI, I am trying to use transcation to improve the performance. As stated in user manual, I should use: dbManager.BeginTransaction();
But I am using playmaker action instead. So when using the simple SQL-Command, I type dbManager.BeginTransaction() in the input field, but it doesn't work.
Any idea what I might have done wrong?
Great thanks.
|
|
|
Post by echo17 on May 25, 2021 14:19:14 GMT
dbManager.BeginTransaction() is a method call on the SimpleSQLManager component and is not a SQL command. The SQL commands for transactions are: begin transaction rollback commit Typically, you would just call "begin transaction", do your commands, then call "commit". Rollback is only used if you do not want the transaction to make any updates. To use these sql commands, you will need the Playmaker action "Simple SQL_Command". Something like: Here's a link describing transactions in sqlite that might be useful: link
|
|
hayho
New Member
Posts: 3
|
Post by hayho on May 26, 2021 0:27:55 GMT
Thanks a lot.
|
|