[PLUGIN] USQLite

Hello All,

New to the plugin and community, so pardon my newbie’ness. I have combed through all that I can find on documentation, YouTube and even the demo project :slight_smile: However, I am running into a few functionality I would like to do and not sure how to do so. Any help is greatly appreciated!

I have a database that has an integer value and that is linked to a variable and working well on run one, it gets a value assigned. I would like to then query the database column and find the max value, return that and increment it by one then run a function and set that.

I thought I could use the [Database] Execute Command: SQL node, use this SQL: “SELECT MAX(TransactionID) from DB_Transactions;” then get back the max value and then add 1 to it. But no such luck.

Any ideas?