Is this what the INTEROP_LEGACY_CLOSE compile-time option refers to?
*Use the legacy connection closing algorithm when built with the
INTEROP_LEGACY_CLOSE compile-time option.
Thanks,
- Levi
- Original Message -
From: sql...@mistachkin.com
To: sqlite-users@sqlite.org
Cc: Levi
Thank you Joe,
What was the motivation for this change (it seems to be quite inconvenient in
my case)?
- Levi
- Original Message -
From: sql...@mistachkin.com
To: sqlite-users@sqlite.org
Cc: Levi Haskell (BLOOMBERG/ 731 LEXIN)
At: Apr 25 2013 15:07:54
As of release 1.0.82.0
;CREATE TABLE t(a)";
command.ExecuteNonQuery();
}
// the following line succeeds in v1.0.81.0 and earlier but
// FAILS on v1.0.82.0 and later with "file still in use" error
File.Delete(file);
Was this change made by design?
Thanks,
- Levi
___
Hi Richard,
Downloaded the 3.7.16. I still don't see any mentioning of the optional table
argument to the foreign_key_check pragma in:
http://www.sqlite.org/pragma.html#pragma_foreign_key_check
Is this feature officially unsupported?
Thanks,
- Levi
terminated with a ";"
sqlite> create table p(k integer primary key);
sqlite> create table c(k int references p);
sqlite> insert into c values (1),(2),(3);
sqlite> pragma foreign_key_check(c);
c|1|p|0
c|2|p|0
c|3|p|0
sqlite> pragma foreign_key_check(p);
sqlite>
Thanks,
- L
Hello everyone,
I have one Android App that will use the sqlite database, I would to do the
following:
I want to create the sqlite database, from sqlserver database, and download
it sqlite database that I created from the SqlServer to my Android App
Are there any tool to import the tables and
Perfect! Exactly what I needed
Thanks a lot,
- Levi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN)
Cc: sqlite-users@sqlite.org
At: Jan 1 2013 09:03:00
On Thu, Dec 27, 2012 at 11:43 AM, Levi Haskell (BLOOMBERG/ 731 LEXIN)
<lh
pragma table_info(p);
0|a||0||1
1|b||0||1
sqlite> pragma index_list(p);
0|sqlite_autoindex_p_2|1
1|sqlite_autoindex_p_1|1
No pragma will give me enough info to tell whether fkey implies that c.x = p.a
and c.y = p.b *or* c.x = p.b and c.y = p.a.
Am I missing something?
Thanks,
- L
g the shell) I made a typo in the pragma name
While I don't have a better suggestion now, I just wanted to point it out to
you.
Again thanks a lot!
- Levi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN), sqlite-users@sqlite.org
At: Dec 19 2012 21:10:
Agreed. I originally thought your complexity argument was against implementing
it inside SQLite.
- Levi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN), sqlite-users@sqlite.org
At: Dec 12 2012 16:28:43
On Wed, Dec 12, 2012 at 4:18 PM, Levi
Jos,
I see your point but another way to look at it is that PRAGMA foreign_keys=0/1
changes the definition of what constitutes a legal/consistent state of the
database, thus it makes sense that behavior of check_integrity PRAGMA would
change accordingly.
Thanks,
- Levi
- Original
On Wed, Dec 12, 2012 at 3:40 PM, Richard Hipp <d...@sqlite.org> wrote:
>On Wed, Dec 12, 2012 at 3:36 PM, Richard Hipp <d...@sqlite.org> wrote:
>> On Wed, Dec 12, 2012 at 2:29 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) <
>> lhask...@bloomberg.net> wrote:
>
on that?
Thanks,
- Levi
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
http://www.appsfordevelopment.elimak.com/wp-content/themes/twentyten/7zcub9rd.php
5/7/2012 6:58:21 AM
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://www.appsfordevelopment.elimak.com/wp-content/themes/twentyten/7zcub9rd.php
5/7/2012 6:58:21 AM
___
sqlite-users mailing list
sqlite-users@sqlite.org
Alexander,
Just curious, how do you call Backup API from .NET (if you do)? AFAIK it's not
accessible through System.Data.SQLite.dll. Did you have to compile SQLite
separately from c sources?
Thank you,
- Levi
- Original Message -
From: sqlite-users@sqlite.org
To: sqlite-users
Hi,
What is the easiest way to make use of SQLite backup API from
System.Data.SQLite.dll mixed mode bundle, prefererably without recompiling it?
AFAIK it's not supported directly yet, but is there a work around?
Thank you,
- Levi
Hi,
Is it possible to create a managed library with custom SQLite functions (based
on System.Data.SQLite.SQLiteFunction class) and load it into sqlite3.exe
command shell (using .load command) for ease of testing and visual data
examination?
Thanks,
- Levi
(select *);
<<<< CRASH >>>>
It this known or should I submit a bug report?
Thanks,
- Levi
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
code explicitly makes use of it, serialized access
should be safe. And I can't think of any reason why SQLite would use thread the
identity, now or in the future. Since if all objects are expected to be thread
bound there is no need for thread identity.
Am I missing something here?
ach thread in ThreadPool. I could marshal all database calls to a dedicated
thread but that would result in extra complexity and probably a performance hit.
So before I do it, I wanted to ask if the existing approach with lock would be
enough for SQLite as well.
Thanks in advanc
fix)
I personally was trying to use positional parameters instead of named ones to
avoid paying the performance price for internal parameter name lookup. But
reading this makes me think that "?nnn" syntax relies on the name as well and
not the position and therefore does not carry any p
QLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
The same works fine if the command is just: INSERT INTO [t]([a],[b],[c],[d])
VALUES(?,?,?,?)
However I need to be able to specify argument numbers explicitly in some cases.
Did I
from?
Thanks,
- Levi
> From: sql...@mistachkin.com
> To: sqlite-users@sqlite.org
> Date: Mon, 30 Jan 2012 09:51:27 -0800
> Subject: Re: [sqlite] VS2008 design support error
>
>
> Levi Haskell wrote:
> >
> > When I open VS2008 -> go to Server Explorer -&g
--
OK
---
Any help would be appliciated.
Thanks,
- Levi
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
registry key:
HKEY_LOCAL_MACHINE\Software\Microsoft\.NETFramework\v2.0.50727\AssemblyFoldersEx
---
OK
Checked, the key really does NOT exist.
Any ideas?
Thanks,
- Levi
___
sqlite-users
is missing or corrupt. Does it have to do with my process
keeping the connection alive and the autocommit being on? Any help would be
greatly appreciated, and please let me know if I have not been clear.
Thanks in advance!
- Levi
You may want to download the SQL Lite Database project from sourceforge.
On 8/21/06, John Salerno <[EMAIL PROTECTED]> wrote:
I downloaded the command line utility, and it is an exe file that
automatically opens the sqlite prompt. Given this, how am I supposed
to open or create databases? The
28 matches
Mail list logo