Comments (4)
@slashd I have tried this on both linux and windows with PowerShell 7 and have been unable to replicate this issue.
I believe I fixed this in core by reimplementing the [DBNullScrubber] under this commit:
095b701
I do not have a mac available to test in case the issue was on that platform.
If you are still having this issue, please provide details on your PS version, OS and PSSqlite module version.
@RamblingCookieMonster May want to consider closing this if there is no follow up?
My test:
PSSQLite> $d = { datasource = "./test.db" }
PSSQLite> Invoke-SqliteQuery @d -Query "create table customer (name)"
PSSQLite> Invoke-SqliteQuery @d -Query "insert into customer (name) values ('bob')"
PSSQLite> Invoke-SqliteQuery @d -Query "select * from customer"
name
----
bob
from pssqlite.
Works for Invoke-SqlCmd2 as well. Thank you, fffnite for taking the time to troubleshoot this for the community.
from pssqlite.
Hi!
Yes, the default of As PSObject
will not work outside of Windows PowerShell.
Don't have time to fix this (e.g. change default for *nix), but as a workaround, switch -As
to something else:
[ValidateSet("DataSet", "DataTable", "DataRow","PSObject","SingleValue")]
[string]
$As="PSObject"
Presumably -as DataRow
Thanks!
from pssqlite.
Hm, I'm sure I fixed this originally when adding core support... Though I changed a lot since then. I will try take another look at this some time this week if I can.
@slashd can you confirm what OS you are running pwsh 7 on? If it is windows, I have a feeling I know what the problem is...
Thanks
from pssqlite.
Related Issues (20)
- Bulk insert performance could be improved HOT 1
- $InputFile parameter can be tested without it having been set. HOT 2
- Unable to bulk insert with single column HOT 12
- Select alias in PSSQLite.psm1 HOT 2
- Newer versions of .NET dlls HOT 1
- Using the module with PowerShell Core on Linux HOT 12
- Validate Compatible Column Type on BulkCopy
- Invoke-SQLiteBulkCopy w/ -SQLiteConnection doesn't commit.
- Pb when dealing with string that include a ' in bulk insert HOT 3
- Query throwing errors in Powershell Core HOT 1
- Invoke-SqliteQuery : Exception calling "Fill" with "1" argument(s): "String was not recognized as a valid DateTime." HOT 2
- Invoke-SqliteQuery Fails when there is Rank() used in views HOT 4
- Unable to find type [DBNullScrubber]. HOT 3
- PSSQLite no Support for armhf Platform?
- Conflicting commandlet in PSSQLite with powershellget
- PSSQLite.psm1 loading the wrong .DLL on Linux!
- doesn't retrieve added fields in vscode, unless using admin mode
- Invoke-SQLiteBulkCopy fails when object contains properties with non-alphanumeric characters HOT 1
- Add-Type : Could not load file or assembly HOT 4
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 pssqlite.