Re: [sqlite] Re: UNIQUE constraint on column

On 2/6/07, Joe Wilson <[EMAIL PROTECTED]> wrote: --- Shane Harrelson <[EMAIL PROTECTED]> wrote: > On 2/5/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > > > Yes, it's typical. Each database instance is typically composed of > > > around 50k records, all inserted in a single pass. If I could do >

Re: [sqlite] database is locked (my solution)

Andrew, I wouldn't worry about it too much, at least your contributing. There are quite a few threads regarding locking, concurrency and multi threading. IMHO, everyone would benefit from your modification. I would especially like to be able to deal with Locking issues at the

Re: [sqlite] Re: UNIQUE constraint on column

Shane Harrelson wrote: We've declared an INTEGER column as the PRIMARY KEY on all tables as below: CREATE TABLE Strings ( StringId INTEGER PRIMARY KEY, Value VARCHAR(30) UNIQUE ) It is my understanding that this makes it an alias to the "internal" ROWID used by SQLite. On insertions we

[sqlite] SQlite3.exe .dump doesn't do anything for me

Greetings! I have a small database (seven tables with no more than 20 rows per table) that I want to dump, since I want to create similar databases. However, sqlite3 mydatabase.db ".dump" just gives me: BEGIN TRANSACTION; COMMIT; What would cause sqlite3 not to be able to see any tables in my

Re: [sqlite] SQlite3.exe .dump doesn't do anything for me

Did you try ".dump TABLENAME" where TABLENAME is one of your seven tables? Roger Rob Richardson wrote: Greetings! I have a small database (seven tables with no more than 20 rows per table) that I want to dump, since I want to create similar databases. However, sqlite3 mydatabase.db ".dump"

[sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

Greetings! The only tool I have for examining and manipulating SQLite databases is SQLiteSpy. If I want to change data in that program, I have to write an SQL statement. Every other database editor I've seen lets a use do simple things from a grid. Open a table and data is loaded into a grid,

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

Regarding: "If I want to change data ." Sqlite3Explorer is free software, and works as you describe. I imagine there are several others. http://www.singular.gr/sqlite/ (Not sure if there will be future releases of this or not) [opinions are my own, not necessarily those of my

[sqlite] Extension functions for SQLite in C for free

Hi, I've had these functions hanging around for some time. They are not fully tested and come with no warranty of fitness, but if anyone wants the code, please take it. I have all the code as a MS Visual Studio 2003 project. It is based on source code 3.3.5 abs(X) Return the absolute value

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

On Tue, 6 Feb 2007 15:13:55 -0500, Donald Griggs wrote: >Regarding: "If I want to change data ." > >Sqlite3Explorer is free software, and works as you describe. >I imagine there are several others. I second this wholeheartedly. >http://www.singular.gr/sqlite/ (Not sure if there >will be

[sqlite] foreign key contraints

I know that this was asked recently... didn't see an answer and so thought I'd ask as well. Any idea when the support for foreign key constraints might be released? Just curious, I'm not asking for a promise or hard date (not even a soft date- just a super super squishy date?), just wondering

[sqlite] sqlite3_prepare16_v2 crash

Hello, sqlite-users. I'm a windows user - I use VS2005. The DEBUG version of my program works fine, the RELEASE program crashes with Access Violation!!! LPWSTR szSqlInsert = (LPWSTR)malloc( 2048 ); swprintf( szSqlInsert, L"INSERT INTO fs VALUES( NULL, '%s', '%s', '%s', '%s', '%s', '%s', '%d',

[sqlite] Newbie SQL question

Hi all: Does exist some method to erase records and to obtain the number of erased records at the same time? It is to say: SELECT count() FROM someTable WHERE some-condition; DELETE FROM someTable WHERE some-condition; in only one statement? Thanks in advance --- A.J.Millan ZATOR

[sqlite] Re: Newbie SQL question

A.J.Millan <[EMAIL PROTECTED]> wrote: Does exist some method to erase records and to obtain the number of erased records at the same time? It is to say: SELECT count() FROM someTable WHERE some-condition; DELETE FROM someTable WHERE some-condition; in only one statement? See

Re: [sqlite] Newbie SQL question

A.J.Millan wrote: Does exist some method to erase records and to obtain the number of erased records at the same time? It is to say: SELECT count() FROM someTable WHERE some-condition; DELETE FROM someTable WHERE some-condition; in only one statement? Yes. See the documentation for

[sqlite] Bug using fts tables in attached databases.

http://www.sqlite.org/cvstrac/tktview?tn=2219 ATTACH DATABASE 'test2.db' AS two; CREATE VIRTUAL TABLE two.t2 USING fts2(content); will put t2_content, t2_segments, and t2_segdir in database 'main' rather than database 'two'. In many cases everything will appear to work, because the tables

[sqlite] help with understanding the C interface

int sqlite3_open( const char *filename, /* Database filename (UTF-8) */ sqlite3 **ppDb /* OUT: SQLite db handle */ ); int sqlite3_open16( const void *filename, /* Database filename (UTF-16) */ sqlite3 **ppDb /* OUT: SQLite db handle */ ); I'm trying to write a more

[sqlite] Re: help with understanding the C interface

Patrick X <[EMAIL PROTECTED]> wrote: int sqlite3_open( const char *filename, /* Database filename (UTF-8) */ sqlite3 **ppDb /* OUT: SQLite db handle */ ); int sqlite3_open16( const void *filename, /* Database filename (UTF-16) */ sqlite3 **ppDb /* OUT: SQLite db handle

[sqlite] Re: Bug using fts tables in attached databases.

Fix is in http://www.sqlite.org/cvstrac/tktview?tn=2219 [This covers both fts1 and fts2.] -scott On 2/6/07, Scott Hess <[EMAIL PROTECTED]> wrote: http://www.sqlite.org/cvstrac/tktview?tn=2219 ATTACH DATABASE 'test2.db' AS two; CREATE VIRTUAL TABLE two.t2 USING fts2(content); will

Re: [sqlite] Re: UNIQUE constraint on column

> Would there be any benefit to "pre-sorting" in this scenario? somewhat related discussion: http://www.mail-archive.com/sqlite-users@sqlite.org/msg19111.html Sucker-punch spam with award-winning protection.

[sqlite] SQLite CVSTrac ticket attachments prior to CVSTrac upgrade?

Are the corrupted attachments prior to the CVSTrac upgrade recoverable into the current SQLite Trac system? http://www.sqlite.org/cvstrac/tktview?tn=2208 If not, could you please post the old Trac attachment table in a compressed database on sqlite.org? thanks.

Re: [sqlite] Extension functions for SQLite in C for free

Thanks for sharing MIkey. On 2/6/07, Mikey C <[EMAIL PROTECTED]> wrote: Hi, I've had these functions hanging around for some time. They are not fully tested and come with no warranty of fitness, but if anyone wants the code, please take it.

Re: [sqlite] help with understanding the C interface

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Patrick X wrote: > the above functions have me a little confused. So sqlite3_open, does > it returns a pointer to the open database or just the success or error > code or both. The return code is an int which is the error code. The pointer

Re: [sqlite] Newbie SQL question

Dennis: Thank you very much for your's Help. A. J.Millan - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 06, 2007 11:16 PM Subject: Re: [sqlite] Newbie SQL question > > > Yes. See the documentation for PRAGMA

Re: [sqlite] Re: Newbie SQL question

Igor: Thank you very much for your's help A.J.Millan - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" Sent: Tuesday, February 06, 2007 10:50 PM Subject: [sqlite] Re: Newbie SQL question > > See sqlite3_changes,