Re: [sqlite] [EXTERNAL] Determining valid statement placeholders.

No. As the creator of a statement, you are expected to know either the position or the name of any SQL parameters contained therein. Determining which indexes are legal does not help in determining what has been bound, not even if anything has been bound. Please note that sqlite3_reset() does no

Re: [sqlite] Determining valid statement placeholders.

On 21 Jul 2019, at 8:03pm, test user wrote: > For example: "?, ?10" would have two valid indexes: (1, 10). Please don't use numbers as names. That would be extremely confusing to anyone trying to understand your code. > But how can I know that indexes 2-9 are invalid from the API? You have

Re: [sqlite] Determining valid statement placeholders.

On 21 Jul 2019, at 8:03pm, test user wrote: > Is there a `sqlite3` C FFI API that allows me to determine which index values > are valid to bind to? I think you're talking about one of these two: int sqlite3_bind_parameter_index(sqlite3_stmt*, const char *zName); const char *sqlite3_bind_parame

Re: [sqlite] Query Builder Access

On 20 Jul 2019, at 7:33pm, Revere Perkins wrote: > Is the SQL Query Builder only available in the licensed version? Sorry. SQLite is always completely free, and there's no Query Builder included as part of SQLite. You must be asking about a third-party product. And there are lots of SQL Qu

[sqlite] Determining valid statement placeholders.

Is there a `sqlite3` C FFI API that allows me to determine which index values are valid to bind to? The `sqlite3_bind_parameter_*` APIs (count, name, index) do not actually provide the valid indexes. For example: "?, ?10" would have two valid indexes: (1, 10). But how can I know that indexes 2-9

[sqlite] Query Builder Access

Hi, Is the SQL Query Builder only available in the licensed version? If it is available in the free version, how does one access it? The documentation says something like 'go to the Query Builder page' , but I don't find mention of it under any menu or via an icon. Thanks, Revere __

Re: [sqlite] using System.Data.SQLite on Linux / ".Net Core 2"

Yes. Currently, there are binaries that support Windows, Linux, and MacOS in the “System.Data.SQLite.Core” NuGet package: https://www.nuget.org/packages/System.Data.SQLite.Core Sent from my iPhone > On Jul 21, 2019, at 1:27 PM, Larry Brasfield > wrote: > > Is there a build of System.Data.S

[sqlite] using System.Data.SQLite on Linux / ".Net Core 2"

Is there a build of System.Data.SQLite which runs on .Net Core 2.0 when used on a Linux platform? Using Powershell 6 installed on my Ubuntu 16 LTS box, I can do Add-Type -Path ./System.Data.SQLite.dll (which loads the assembly) without issues, (on Linux or Windows), but this $c = New-Objec