I ran this utility and what I discovered is problematic.
On my development machine, it is always looking for this dependency in
the GAC first and loading it from there. as opposed to the start-up
folder where the DLL is located. Why is this looking for the DLL in the
GAC first? This is not
Hi Richard,
Thanks for the info.
I got this link from the site for 3.8.7.4
http://www.sqlite.org/cgi/src/info/f66f7a17b78ba617
Hope this is fine.
I want this version because my project is using this release.
Best Regards,
Saurav
On Thu, Mar 19, 2015 at 8:38 PM, Richard Hipp wrote:
> On
Hi All,
Can anyone please tell me how can i get the source code for 3.8.7.4 ?
In the website of SQLite i could get hold of a amalgamation source code of
latest release 3.8.8.3 in a zip file.
Can i similarly get for 3.8.7.4 ?
thanks and Regards,
Saurav
On 3/19/2015 7:48 PM, Bart Smissaert wrote:
> I know this is basic and should be in the documentation, but it is not
> quite clear to me.
> Basically I have 3 type of procedures:
>
> 1. Getting values from a table. For this I have the following steps:
>
> (Open)
> Prepare
>
> Then in a loop:
>
>
On 2015-03-19 05:32 PM, Paul wrote:
>>On 19 Mar 2015, at 3:19pm, Paul wrote:
>>
>>> This may cause very nasty hard-to-find bugs, since SQLite allows to store
>>> any content inside BLOB field:
>>>
>>> sqlite> create table foo(a int, b int, primary key(a, b));
>>> sqlite> insert into foo(a,
> On 19 Mar 2015, at 3:19pm, Paul wrote:
>
> > This may cause very nasty hard-to-find bugs, since SQLite allows to store
> > any content inside BLOB field:
> >
> > sqlite> create table foo(a int, b int, primary key(a, b));
> > sqlite> insert into foo(a, b) VALUES(1, ''), (1, x'');
> >
> On 3/19/15, Paul wrote:
> > Maybe this question was already asked and explained.
> > Or maybe it is documented somewhere (could not fiund it).
> > Sorry, if this is the case, but why does
> >
> > SELECT '' = x'';
> >
> > yields 0?
> >
>
> Because it has never before occurred to the
Maybe this question was already asked and explained.
Or maybe it is documented somewhere (could not fiund it).
Sorry, if this is the case, but why does
SELECT '' = x'';
yields 0?
Suppose I have data in FOO table. By what means can I tell
what is inside of my_blob column of FOO, when
SELECT
On 03/18/2015 02:39 AM, Bart Smissaert wrote:
> OK, let me try to explain:
>
> Simple table with primary integer key, call the field ID
>
> strSQL = "Insert into table1 values(?)"
>
> lReturnValue = sqlite3_prepare16_v2(lDBHandle,
>StrPtr(strSQL),
>
On 19 Mar 2015, at 3:19pm, Paul wrote:
> This may cause very nasty hard-to-find bugs, since SQLite allows to store any
> content inside BLOB field:
>
> sqlite> create table foo(a int, b int, primary key(a, b));
> sqlite> insert into foo(a, b) VALUES(1, ''), (1, x'');
> sqlite> select *,
On 19 Mar 2015, at 2:56pm, Paul wrote:
> Maybe this question was already asked and explained.
> Or maybe it is documented somewhere (could not fiund it).
> Sorry, if this is the case, but why does
>
> SELECT '' = x'';
>
> yields 0?
One is a string. The other is a BLOB. SQLite doesn't even
On 6 March 2015 at 08:38, Carabas, Costin wrote:
> Hello,
>
> I was working on version 3.8.8.2 of sqlite3 and I found a bug that is trace
> related. It can be reproduced in 3 steps:
>
> 1. ".t log" - opens log for tracing
>
> 2. ".t" - no argument. Closes the file descriptor that was
On Thu, Mar 19, 2015 at 10:30 AM, Richard Hipp wrote:
> On 3/18/15, Scott Hess wrote:
>> I'm thinking I could use something like:
>>
>> SQLITE_API int sqlite3_attach(sqlite3* db, const char* zPath, const
>> char* dbname);
>> SQLITE_API int sqlite3_detach(sqlite3* db, const char* dbname);
>>
>>
On 3/18/15, Scott Hess wrote:
> I'm thinking I could use something like:
>
> SQLITE_API int sqlite3_attach(sqlite3* db, const char* zPath, const
> char* dbname);
> SQLITE_API int sqlite3_detach(sqlite3* db, const char* dbname);
>
> Right now, I have a helper in Chromium which does "ATTACH
Hallo,
I had a little hint for "Building A Windows DLL".
Best Regards
Ewald Einwanger
Weitergeleitete Nachricht
Betreff:Building A Windows DLL - missing exports
Datum: Thu, 19 Mar 2015 13:24:18 +0100
Von:Ewald Einwanger
An: sqlite-users at sqlite.org
This bug reproduces to the latest Sqlite release (3.8.8.3).
The log from the bug:
sqlite> .t file
sqlite> .t
Usage: .trace FILE|off
sqlite> .d
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
Segmentation fault
I also found another bug with the same root cause:
sqlite> .t file
sqlite> .t
Usage:
Hi,
I would like to continue a discussion started here:
https://www.sqlite.org/src/tktview/c25aab7e7ea55c861313
First I assume the sqlite3 shell still has the related problem (I'm using
Ubuntu, so not sure if the last version has fixed it).
I would like to desagree of a comment posted on the
As a general rule of thumb, if things are different type, they can't be equal.
One already knows the column type. To compare apples to apples, one
would cast to convert them.
sqlite> SELECT '' = x'';
0
sqlite> SELECT cast('' as blob) = x'';
1
Perhaps some confusion comes from how numbers are
On 3/19/15, Paul wrote:
> Maybe this question was already asked and explained.
> Or maybe it is documented somewhere (could not fiund it).
> Sorry, if this is the case, but why does
>
> SELECT '' = x'';
>
> yields 0?
>
Because it has never before occurred to the developers that somebody
would
On 3/19/15, Saurav Sarkar wrote:
> Hi All,
>
> Can anyone please tell me how can i get the source code for 3.8.7.4 ?
> In the website of SQLite i could get hold of a amalgamation source code of
> latest release 3.8.8.3 in a zip file.
>
> Can i similarly get for 3.8.7.4 ?
>
Over 14,400 different
On 19 Mar 2015, at 12:29am, Keith Medcalf wrote:
> A statement may fail, however that does not affect other statements within
> the transaction. You still have to end a transaction with either a commit
> (to commit the changes made by statements WHICH DID NOT FAIL) or rollback to
> discard
Pardon the long post everyone, but it seems from the other posts there
is a large misconception to address here and I will attempt to do so as
briefly as possible (Also, feel free to chime in where I am vague or wrong):
On 2015-03-18 11:24 PM, Jason Vas Dias wrote:
> OK, I discovered the OR
22 matches
Mail list logo