Re: [sqlite] SQLite.Interop.dll

project folders with linked files as > above, or as previously mentioned by another poster, in other ways such as > Build Events or editing the project file's XML, etc. I did it my way so that > all of the required files could be seen at a glance in the solution/project > struct

Re: [sqlite] SQLite.Interop.dll

xplorer, or you can put in a pre or post > build event of your final project to copy the x64 and x86 folders (containing > the SQLite.interop.dll files) into its output directory. Doing it from > Windows explorer is easier, but you may forget then if you do a clean

Re: [sqlite] SQLite.Interop.dll

--- About two years ago, I downloaded and installed SQLite. I don't recall the details, but it was a program that installed SQLite. I ended up with files such as EntityFramework.dll, EntityFramework.SqlServer.dll, System.Data.SQLite.dll, etc. This required "using

Re: [sqlite] SQLite Options

in my SQLite.dll library program. On Tue, Feb 21, 2017 at 2:42 PM, Clyde Eisenbeis <cte...@gmail.com> wrote: > I don't recall how I obtained the SQLite files ... was two years ago. > > When I have SQLite installed on my genealogy program and on my SQLite > .dll library, it work

Re: [sqlite] SQLite Options

> Hope this helps. I am by no means an expert, I've only messed with it a few > times. I hope that if I have got things wrong that someone more experienced > can jump in and correct my mistakes. > > * This name might be a little confusing since Microsoft have recently > release an

Re: [sqlite] SQLite Options

er 32 or 64 bit > systems). > > You should not need the other libraries for a simple application. If you find > that visual studio is placing them in your project's output directory, check > if they are listed as a reference and try to remove them then recompile. > >> On 20 Fe

Re: [sqlite] SQLite Options

y get rid of the unnecessary dlls. > > *whether an ORM actually makes data access easier is debatable, they > basically allow you to write your data access queries in LINQ rather than > SQL, and automatically instansiate c# objects for each line in the results. I > find SQL easier.

Re: [sqlite] SQLite Options

Sorry for the slow response. My code is in C#. I don't know if the amalgamation source code in C can be compiled so it is compatible with C#. If it can, I'd be interested in details. Thanks! On Sat, Feb 18, 2017 at 1:29 AM, R Smith wrote: > > > On 2017/02/18 12:45 AM,

Re: [sqlite] SQLite Options

Is SQLite Version 3 the same as SQLite3? ... http://www.sqlite.org/download.html. On Thu, Feb 16, 2017 at 3:01 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 16 Feb 2017, at 8:40pm, Clyde Eisenbeis <cte...@gmail.com> wrote: > >> Is there an SQLite version that

[sqlite] SQLite Options

I started writing SQLite code about two years ago (Visual Studio 2013, C#, WPF) ... with a significant delay, since then, because of a physical move. The code is written for a specific use on my computer ... no other users. SQLite was chosen so my sons could eventually install this program on

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

nsertRowId; sqliteTran.Commit(); stKeyID = lKeyID.ToString(); This does not require SQLite3. Thanks to all on the SQLite Mailing List! Clyde On Tue, Feb 7, 2017 at 6:17 PM, Kevin Benson <kevin.m.ben...@gmail.com> wrote: > On Tue, Feb 7, 2017 at 4:11 PM, Clyde Eisenbeis <cte...@gmail.com&g

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

id() > > https://www.sqlite.org/c3ref/last_insert_rowid.html > > select @@identity and 'select last_insert_rowid()' perform the same action > - retrieving the last unique row reference. It was the answer to your > query. The link provides further research. > > > On Mon,

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

wrote: > > On 6 Feb 2017, at 1:30pm, Clyde Eisenbeis <cte...@gmail.com> wrote: > >> What is the correct nomenclature for using last_insert_rowid() for >> SQLite? For OLE DB I've used ... oledbCmd.CommandText = "Select >> @@Identity" ... int iKeyID = (

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

What is the correct nomenclature for using last_insert_rowid() for SQLite? For OLE DB I've used ... oledbCmd.CommandText = "Select @@Identity" ... int iKeyID = (int)oledbCmd.ExecuteScalar(). On Mon, Feb 6, 2017 at 7:24 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Cl

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

.org> > Betreff: Re: [sqlite] Retrieve INTEGER PRIMARY KEY > > Last_insert_rowid() > > https://www.sqlite.org/c3ref/last_insert_rowid.html > > On Fri, Feb 3, 2017 at 1:51 PM, Clyde Eisenbeis <cte...@gmail.com> wrote: > >> For OLE DB

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

avin <slav...@bigfraud.org> wrote: > >> >> On 5 Feb 2017, at 1:26pm, Clyde Eisenbeis <cte...@gmail.com> wrote: >> >> > The compiler complains about "SELECT last_insert_rowid()" ... which >> > appears to be limited to SQLite3. >> >&

Re: [sqlite] SQLite3 Pros / Cons

This is good information! I posted "[sqlite] Retrieve INTEGER PRIMARY KEY" a few days ago. The only solution proposed appears to use sqlite3. On Sat, Feb 4, 2017 at 5:34 PM, Joe Mistachkin wrote: > > Random Coder wrote: >> >> And in case it's not obvious:

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

The compiler complains about "SELECT last_insert_rowid()" ... which appears to be limited to SQLite3. Perhaps I'm missing something? On Sat, Feb 4, 2017 at 10:28 AM, Wolfgang Enzinger <sql...@enzinger.net> wrote: > Am Sat, 4 Feb 2017 09:04:58 -0600 schrieb Clyde Eisenbeis

[sqlite] SQLite3 Pros / Cons

I'm new to SQLite ... started using it a few months ago. I was unaware of SQLite3 until I joined the SQLite mailing list. What are the pros / cons of SQLite3? If I switched from "using System.Data.SQLite" to SQLite3, are all of the functions in a .dll I could download and use?

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

qlite.org/c3ref/last_insert_rowid.html > > On Fri, Feb 3, 2017 at 1:51 PM, Clyde Eisenbeis <cte...@gmail.com> wrote: > >> For OLE DB SQL, I have retrieved the primary key: >> >> - >> using (System.Data.OleDb.OleDbConnection oledbConnect = ne

[sqlite] Retrieve INTEGER PRIMARY KEY

For OLE DB SQL, I have retrieved the primary key: - using (System.Data.OleDb.OleDbConnection oledbConnect = new System.Data.OleDb.OleDbConnection(stConnectString)) { using (System.Data.OleDb.OleDbCommand oledbCmd = oledbConnect.CreateCommand()) { ...

Re: [sqlite] Does SQLite use field definitions?

What about the INTEGER PRIMARY KEY (defined in my first email post)? Does this field start at 1, and then auto increment for each new line? On Thu, Feb 2, 2017 at 5:02 AM, R Smith <rsm...@rsweb.co.za> wrote: > > > On 2017/02/01 5:41 PM, Clyde Eisenbeis wrote: >> >>

Re: [sqlite] Does SQLite use field definitions?

able.html for details. I also suggest > you look at http://sqlite.org/datatype3.html too > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im > Auftrag von Clyde Eisenbeis > Gesendet: Dienstag, 31. Jänner 2017 17:07 > A

[sqlite] Does SQLite use field definitions?

In the past, when using Access as a database, I have specified field definitions. These field definitions have been used when creating a table. public const string stFIELD_DEFINITIONS = " fstPriority TEXT, fstInfo MEMO, fstDateCreated TEXT, fstDateModified TEXT, fiKeyID INTEGER PRIMARY KEY ";

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

wrote: > On Jan 27, 2017, at 1:09 PM, Clyde Eisenbeis <cte...@gmail.com> wrote: >> >> The SQLite websites would be more useful with examples. > > Certainly. No question. > > The thing is, I think most of us are primarily grateful that SQLite *exists* > and that it

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

te Mailing List, I am grateful for the assistance I've received via SQLite Mailing List emails. This has helped me write the code I need. Thanks! Clyde On Fri, Jan 27, 2017 at 1:08 PM, James K. Lowden <jklow...@schemamania.org> wrote: > On Thu, 26 Jan 2017 11:45:41 -0600 > Clyde Eisen

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

; On 27 Jan 2017, at 5:51pm, Clyde Eisenbeis <cte...@gmail.com> wrote: > >> System.Data.SQLite.SQLiteCommand sqliteCmd = >> sqliteConnection.CreateCommand()); >> >> sqliteCmd.CommandText = "SELECT" + stFieldNames + "FROM " + >> stTableName + &

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

the command" On Fri, Jan 27, 2017 at 1:10 AM, GB <gbi...@web.de> wrote: > Clyde Eisenbeis schrieb am 26.01.2017 um 18:45: >> >> It appears that sqlite3 is not part of System.Data.SQLite. >> > Aaah! Now we get somewhere! You should have told us from t

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

I can't read CHM docs. I'd appreciate some example code which uses "sqlite3_bind_". Thanks! On Thu, Jan 26, 2017 at 12:02 PM, Joe Mistachkin <sql...@mistachkin.com> wrote: > > Clyde Eisenbeis wrote: >> >> It appears that sqlite3 is not part of S

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

, when I started entering "sqlite3_bind_" the compiler starts complaining. It appears that sqlite3 is not part of System.Data.SQLite. On Thu, Jan 26, 2017 at 10:59 AM, Warren Young <war...@etr-usa.com> wrote: > On Jan 26, 2017, at 8:40 AM, Clyde Eisenbeis <cte...@gmail.com>

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

To answer a previous question, here is an example of stCmdString contents: stCmdString = "SELECT fstPriority, fstInfo, fiKeyID FROM PadTable WHERE fstInfo LIKE '%macro%'" This works. On Thu, Jan 26, 2017 at 9:40 AM, Clyde Eisenbeis <cte...@gmail.com> wrote: > Not

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

mplaining. On Thu, Jan 26, 2017 at 9:18 AM, Clyde Eisenbeis <cte...@gmail.com> wrote: > I'm searching the internet for sqlite3_bind_* () examples. > > On Thu, Jan 26, 2017 at 9:14 AM, Andy Ling <andy.l...@s-a-m.com> wrote: >> I think the point is, you need to use a prepar

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

ot; > liststLikeFieldValue" strings. > > HTH > > Andy > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Clyde Eisenbeis > Sent: Thu 26 January 2017 15:04 > To: SQLite mailing list > Subjec

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Re-reading the previous emails, it appears I also need to use sqlite3_bind_*(). On Thu, Jan 26, 2017 at 9:04 AM, Clyde Eisenbeis <cte...@gmail.com> wrote: > I've also tried: > > string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName >

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

t <herib...@scharnagl.com> wrote: > There are some missing spaces i think: > > string stCmdString = "SELECT " + stFieldNames + " FROM " + stTableName > + " WHERE " + stLikeFieldName + " LIKE '%'||" + > liststLikeFieldValue[0] + "||'%'";

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

I tried replacing this: string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%" + liststLikeFieldValue[0] + "%'"; with this: string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

liststLikeFieldValue.Count; iii++) stCmdString += " AND " + stLikeFieldName + " LIKE '%" + liststLikeFieldValue[iii] + "%'"; which does not handle the cases where a ' is included in the field value. On Wed, Jan 25, 2017 at 9:50 AM, Clyde Eisenbeis <cte...@gmail.com> wrote: &g

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

1; iii < liststLikeFieldValue.Count; iii++) oledbCmd.CommandText += stLikeFieldName + " AND " + stLikeFieldName + " LIKE @p" + (iii).ToString(); On Wed, Jan 25, 2017 at 9:45 AM, Warren Young <war...@etr-usa.com> wrote: > On Jan 25, 2017, at 8:33 AM, Clyde Eisenbeis <cte...@

[sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters? This works to find bruce and baseball: string stCmdString = "SELECT fstInfo FROM PadTable WHERE fstInfo LIKE '%bruce%' AND fstInfo LIKE '%baseball%'" Not sure how to find bruce's and baseball. I know

Re: [sqlite] _SQLITEINT_H_ vs SQLITEINT_H

It's not clear how I post questions. Do I just send to this mailing list? On Wed, Jan 25, 2017 at 6:59 AM, Theo Veenker wrote: > Hi all, > > Just downloaded the 3.16.2 amalgamation (used 3.11.1 before). I then wanted > to apply the userauth extension. The resulting