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 sqlite3.c doesn't compile
> ho
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 i
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 wrote:
> On Jan 25, 2017, at 8:33 AM, Clyde Eisenbeis wrote:
>>
>> The use of .
; 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 Eise
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 '%'
, 2017 at 8:14 AM, heribert wrote:
> There are some missing spaces i think:
>
> string stCmdString = "SELECT " + stFieldNames + " FROM " + stTableName
> + " WHERE " + stLikeFieldName + " LIKE '%'||" +
> liststLikeFieldValue[0] + "||'
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 wrote:
> I've also tried:
>
> string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName
> +
markers with the "
> liststLikeFieldValue" strings.
>
> HTH
>
> Andy
>
> -Original Message-
> From: sqlite-users [mailto:[email protected]] On
> Behalf Of Clyde Eisenbeis
> Sent: Thu 26 January 2017 15:04
> To: SQLite mailing
e compiler starts complaining.
On Thu, Jan 26, 2017 at 9:18 AM, Clyde Eisenbeis wrote:
> I'm searching the internet for sqlite3_bind_* () examples.
>
> On Thu, Jan 26, 2017 at 9:14 AM, Andy Ling wrote:
>> I think the point is, you need to use a prepared statement and bind the
&
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 wrote:
> Not finding much.
>
&g
, 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 wrote:
> On Jan 26, 2017, at 8:40 AM, Clyde Eisenbeis wrote:
>>
>> When I tried enter
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 wrote:
>
> Clyde Eisenbeis wrote:
>>
>> It appears that sqlite3 is not part of System.Data.SQLite.
>>
t parameters supplied to the command"
On Fri, Jan 27, 2017 at 1:10 AM, GB 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 the beginning t
sqliteCmd.CommandText = SELECT fstPriority, fstInfo, fstDateCreated,
fstDateModified, fiKeyID FROM MemoPadTable WHERE fstInfo LIKE '%' ||
?1 || '%'"
liststLikeFieldValue[0] = "bruce"
On Fri, Jan 27, 2017 at 11:55 AM, Simon Slavin wrote:
>
> On 27 Ja
Hi SQLite 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
wrote:
> On Thu, 26 Jan 2017 11:45:41 -0600
> Clyde Eisenbeis wr
:09 PM, Clyde Eisenbeis 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 works as well as it does. Given a choice of where ou
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 ";
Do
tails. I also suggest
> you look at http://sqlite.org/datatype3.html too
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users [mailto:[email protected]] Im
> Auftrag von Clyde Eisenbeis
> Gesendet: Dienstag, 31. Jänner 2017 17:07
> An: SQLite mail
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 wrote:
>
>
> On 2017/02/01 5:41 PM, Clyde Eisenbeis wrote:
>>
>> I don't see MEMO listed
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())
{
...
; On Fri, Feb 3, 2017 at 1:51 PM, Clyde Eisenbeis wrote:
>
>> For OLE DB SQL, I have retrieved the primary key:
>>
>> -
>> using (System.Data.OleDb.OleDbConnection oledbConnect = new
>> System.Data.OleDb.OleDb
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?
__
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 wrote:
> Am Sat, 4 Feb 2017 09:04:58 -0600 schrieb Clyde Eisenbeis:
>
>> When I ent
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: System.Data.Sqlite _is_ sqlite3
>>
>
>
elect and get it
>
> the .net library has it as a connection property LastInsertRowId
>
> https://www.crestron.com/reference/simpl_sharp/html/P_Crestron_SimplSharp_SQLite_SQLiteConnection_LastInsertRowId.htm
>
> On Sun, Feb 5, 2017 at 5:54 AM, Simon Slavin wrote:
>
>>
RY KEY
>
> Last_insert_rowid()
>
> https://www.sqlite.org/c3ref/last_insert_rowid.html
>
> On Fri, Feb 3, 2017 at 1:51 PM, Clyde Eisenbeis wrote:
>
>> For OLE DB SQL, I have retrieved the primary key:
>>
>> -
>> using (System.Data.OleDb.Ol
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 wrote:
> Clyde Eisenbeis wrote:
>
eb 2017, at 1:30pm, Clyde Eisenbeis 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 = (int)oledbCmd.ExecuteScalar().
>
> last_ins
s://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, Feb 6
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 wrote:
> On Tue, Feb 7, 2017 at 4:11 PM, Clyde Eisenbeis wrote:
>
>> int iKeyID = (int)sqliteCmd.Exe
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
the
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 wrote:
>
> On 16 Feb 2017, at 8:40pm, Clyde Eisenbeis wrote:
>
>> Is there an SQLite version that is comprised of fewer dlls, etc.? ...
>> Pe
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, Warren Young wrote:
>>
>
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...
&g
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
output
> directory and you can ignore them.
>
> 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 l
in my SQLite.dll library program.
On Tue, Feb 21, 2017 at 2:42 PM, Clyde Eisenbeis 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 works fine.
>
> W
---
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 System.Data.SQLi
ld 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 build a
> few years down the line you'll run into the problem ag
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
>
40 matches
Mail list logo
