Re: [sqlite] After column add, what should be done to update the schema?

I just tried it in v5.3.5.470 and v5.3.5.472 and it worked fine. From: sqlite-users On Behalf Of Andy KU7T Sent: Thursday, February 27, 2020 6:03 PM To: SQLite mailing list Subject: [sqlite] After column add, what should be done to update the schema? Hi, I use a simple ALTER TABLE ADD COLUMN

Re: [sqlite] SQLite Application Server Concurrency

Depending on your level of expertise with C#, you could create a .NET Windows service to run on machine X that contains a WCF service which controls the database access. The Y and Z clients would be WCF clients that talk to the WCF service on X. They could communicate via http or TCP. From:

Re: [sqlite] SQLite.Interop.dll

re is no .csproj or .vbproj file). Inside that folder are additional folders -> eventually drills down to bin\Debug. "Right-click your solution" ... do you mean inside VS (Visual Studio 2013)? When I right-click inside VS, my only choice is "new solution explorer view". On

Re: [sqlite] SQLite.Interop.dll

.dll as a Reference -> error message "SQLite.Interop.dll could not be added " Lee, What is the procedure to reference a "Solution-level Library folder"? Also, would it be referenced by my genealogy WPF or my Custom Control Library dll? On Fri, Feb 24, 2017 at 9:27 AM, Lee Gray <le

Re: [sqlite] SQLite.Interop.dll

I never could get the NuGet package to cooperate with the interop dlls, so here's what I've done. I create a Solution-level Library folder (and matching physical folder) with this layout: \Library System.Data.SQLite.dll \x64 SQLite.Interop.dll \x86

[sqlite] Using |DataDirectory| in connection string (.NET with System.Data.SQLite)

|DataDirectory| in connection string (.NET with System.Data.SQLite) Lee Gray wrote: > > How do they make use of the connection string |DataDirectory| macro? > It is expanded when the connection is opened. It will either be replaced with the per-AppDomain "DataDirectory"

[sqlite] Using |DataDirectory| in connection string (.NET with System.Data.SQLite)

Hello, I'm just starting to experiment with sqlite and System.Data.SQLite. How do they make use of the connection string |DataDirectory| macro? I've found lots of references online showing that it is indeed used, but I haven't found how to extract the file path from it at runtime. Given a