Comments (6)
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.
Related Issues (19)
- Resolve relative paths HOT 1
- Create commands for opening and closing connections HOT 1
- Add Query to ConvertFrom-MySQLiteDB HOT 1
- Module Name Confusion HOT 2
- Error converting get-process result into sqlite HOT 14
- Converting all AD user properties fails HOT 5
- ConvertFrom-MySQLiteDB doesn't restore blobs HOT 2
- Suggestion - Use native clixml methods to avoid need for temp files HOT 5
- Cmdlet checks on ".db" file's extension HOT 3
- Error in Open-MySQLiteDB.ps1 HOT 1
- Rename Convert-MySqliteDB to ConvertFrom-mySqliteDB HOT 1
- Improve handling of empty blobs or those that result in strings HOT 2
- Add help documentation HOT 1
- rename propertymap table to include table name HOT 1
- Add PropertyMap parameter HOT 1
- Need a way to get table details HOT 2
- Add Typename parameter to ConvertTo-MySQLiteDB HOT 1
- create an auto incrementing table HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysqlite.