Re: [sqlite] macro redefinition

2008-09-30 Thread Ajinkya Kale
I tried the first option you suggested , i get the following error log : -- Build started: Project: Source Tagging System, Configuration: Debug Win32 -- Compiling... sqlite3.c c:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\Source Tagging

Re: [sqlite] Can't insert timestamp field with value CURRENT_TIME

2008-09-30 Thread Dan
On Sep 27, 2008, at 7:13 AM, Mark Wyszomierski wrote: > Hi, > > I'm trying to add a timestamp field to an existing table using the > following > statement: > >ALTER TABLE test ADD COLUMN lunchtime TIMESTAMP NOT NULL DEFAULT > CURRENT_TIME > > this fails with the following error: > >

Re: [sqlite] SQLITE_CONFIG_SERIALIZED

2008-09-30 Thread Mohit Sindhwani
D. Richard Hipp wrote: > > SQLITE_CONFIG_SERIALIZED has been the default behavior since version > 3.5.0. All it does is move the locks to inside of SQLite so that your > application code does not have to mess with them. It does not > magically provide you any additional concurrency. >

[sqlite] more on networked file access failures

2008-09-30 Thread Dave Dyer
I tracked the initial failure into sqlite3WinDelete, which is used to delete journal files. There is a semi-kludge to retry the deletion, based on the ad-hoc observation that sometimes the delete fails because some other process has the file open. Two observations: (1) the retry count of 3

Re: [sqlite] how to connect to existing db with sqlite3.exe

2008-09-30 Thread Stephen Woodbridge
I think that the problem is with your understanding of what the .databases command does. I could be mistaken, but I thought is only listed attached databases. It is not a command to search for possible databases that may exist on your file system. So when you use the command: sqlite3 foo.db

Re: [sqlite] how to connect to existing db with sqlite3.exe

2008-09-30 Thread P Kishor
On 9/30/08, Ryan Walker <[EMAIL PROTECTED]> wrote: > Hi Enrique, > I'm not referring to the syntax. I know the syntax. I'm wondering how > to connect to a local database with sqlite3.exe. That is, how do I tell > sqlite3.exe where the database file is on my computer? When I use the >

Re: [sqlite] how to connect to existing db with sqlite3.exe

2008-09-30 Thread Ryan Walker
Hi Enrique, I'm not referring to the syntax. I know the syntax. I'm wondering how to connect to a local database with sqlite3.exe. That is, how do I tell sqlite3.exe where the database file is on my computer? When I use the .databases command, my database is not listed, so I assume I need

Re: [sqlite] how to connect to existing db with sqlite3.exe

2008-09-30 Thread Enrique Ramirez
You mean a command like ALTER TABLE? Maybe check the SQL Syntax available to SQLite (http://sqlite.org/lang_altertable.html) On Tue, Sep 30, 2008 at 4:09 PM, Ryan Walker <[EMAIL PROTECTED]> wrote: > Hi, > I have a database file in windows that I want to connect to with > sqlite3.exe so I can add

Re: [sqlite] how to connect to existing db with sqlite3.exe

2008-09-30 Thread P Kishor
On 9/30/08, Ryan Walker <[EMAIL PROTECTED]> wrote: > Hi, > I have a database file in windows that I want to connect to with > sqlite3.exe so I can add a column to a table. Not sure how to so it. > There doesn't appear to be any relevant command when I enter .help. > Thanks, > Ryan > >

[sqlite] how to connect to existing db with sqlite3.exe

2008-09-30 Thread Ryan Walker
Hi, I have a database file in windows that I want to connect to with sqlite3.exe so I can add a column to a table. Not sure how to so it. There doesn't appear to be any relevant command when I enter .help. Thanks, Ryan -- Ryan Walker www.WebCommunicate.net: Insights and resources for

Re: [sqlite] seeking storage design assistance

2008-09-30 Thread Stephen Woodbridge
It also helps to know how you want to access/manipulate your data and what you want to do with it in SQL versus with your application. For instance, you could just store all the cad data as a blob, along with the attributes in columns. Then you can fetch the data based on attributes, and

Re: [sqlite] seeking storage design assistance

2008-09-30 Thread Jeffrey Becker
ORM is always a tricky business. My experience is that unless the entity is very very simple, it's often inappropriate to attempt to do 1 row = 1 entity mapping. If things are collections of points, then by all means have a points table. A lot of this type of stuff can be made easier by 1)

[sqlite] seeking storage design assistance

2008-09-30 Thread Jeff Godfrey
Hi All, I've got some general db storage design questions that I hope someone can offer some advice on... I have a need to store some CAD-type geometry in a SQLite database, and I'm trying to decide on the best db design. Specifically, I need to store "entity" data, which will include such

Re: [sqlite] SQLITE_CONFIG_SERIALIZED

2008-09-30 Thread D. Richard Hipp
On Sep 30, 2008, at 11:39 AM, Rick Keiner wrote: > Hi, > > Which version introduced this option? > > I am accessing the same connection with multiple threads. > > I'm seeing a problem since the application locks the database > connection > during a prepare/step sequence for SELECT operations.

[sqlite] SQLITE_CONFIG_SERIALIZED

2008-09-30 Thread Rick Keiner
Hi, Which version introduced this option? I am accessing the same connection with multiple threads. I'm seeing a problem since the application locks the database connection during a prepare/step sequence for SELECT operations. It also locks the connection for transactions that perform

Re: [sqlite] macro redefinition

2008-09-30 Thread Eric Minbiole
> Hi, > I am getting the following error log when i try to build sqlite source : > ... > c:\Documents and Settings\Administrator\My Documents\Visual Studio > Projects\Source Tagging System\sqlite\where.c(2902): fatal error C1010: > unexpected end of file while looking for precompiled header

[sqlite] macro redefinition

2008-09-30 Thread Ajinkya Kale
Hi, I am getting the following error log when i try to build sqlite source : c:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\Source Tagging System\sqlite\where.c(37): warning C4005: 'WHERETRACE' : macro redefinition c:\Documents and Settings\Administrator\My