Questions about capabilities about mysqlite HOT 6 CLOSED

I updated the assembly to version1.0.117.0 last month I have no idea what version supports the feature you are looking for. I don't really know the answers to your other questions. Those would be language or syntax questions I'm not qualified to answer. You'll have to search for answers like this or this on autoincrementing.

from mysqlite.

from mysqlite.

The module is for loading the assemblies and to abstract things like creating databases and tables. Using the database with sqlite queries is up to you.

from mysqlite.

Yep, but the autoincrement for example would be part of that module side for creating the tables, not the writing insert queries bit. But all good for now.
I assume you can't help with "WARNING: Exception calling "ExecuteNonQuery" with "0" argument(s): "SQL logic error
cannot start a transaction within a transaction""
I'm probably not using transactions properly. Will keep researching and close this issue soon

from mysqlite.

I looked for an autoincrement feature when I first started this module, After reading https://www.sqlite.org/autoinc.html I use the native ROWID.

from mysqlite.

Apologies, did you have a small example of using that? As currently, I've set a PK on ID "Int" but it ends up empty if i don't specify it. Fixed

Also any suggestions on handling strings with ' in the name, as that seems to break the string when using '$($FilePath)',
Exception calling "ExecuteNonQuery" with "0" argument(s): "SQL logic error
near "s": syntax error"

• Adding a -replace for every query to replace ' with '' for now until I find a better solution.

from mysqlite.