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

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: Cannot add a column with non-constant default Ok that makes sense - but why can

Re: [sqlite] Suggests for improving the SQLite website

I think 4 looks great, Mark On Nov 9, 2007 1:45 PM, <[EMAIL PROTECTED]> wrote: > "Mark Wyszomierski" <[EMAIL PROTECTED]> wrote: > > Not a terribly useful comment but was just glancing through the new > > look and noticed a typo: > > > > http:

Re: [sqlite] Suggests for improving the SQLite website

Not a terribly useful comment but was just glancing through the new look and noticed a typo: http://sqlite.hwaci.com/about.html "We believe that General Electric uses SQLite in some product or another because they twice wrote the to SQLite developers ".. "wrote the to " On Nov 9, 2007 1:2

Re: [sqlite] unresolved external symbol _TryEnterCriticalSection

Thanks guys. On 10/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "Mark Wyszomierski" <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I'm trying to upgrade to the latest version of sqlite (3.5.1) for > > windows. Compiling the sqlite l

[sqlite] unresolved external symbol _TryEnterCriticalSection

Hi, I'm trying to upgrade to the latest version of sqlite (3.5.1) for windows. Compiling the sqlite library is fine, but linking to it I always get one unresolved symbol: unresolved external symbol _TryEnterCriticalSection There seems to be one entry on it in the archives but I don't underst

[sqlite] Re: sqlite ODBC?

t? Thanks, Mark On 10/3/07, Mark Wyszomierski <[EMAIL PROTECTED]> wrote: > Hi, > > Are there are ODBC drivers out there for sqlite on win32? I'm already > using an ODBC library and wanted to see if I could get around > rewriting everything using the n

[sqlite] sqlite ODBC?

Hi, Are there are ODBC drivers out there for sqlite on win32? I'm already using an ODBC library and wanted to see if I could get around rewriting everything using the native sqlite API. Thanks, Mark - To unsubscribe, sen

Re: [sqlite] Re: where is SQLITE_OPEN_READONLY defined?

Ah shoot didn't realize that, thanks. Do you happen to know by any chance if opening in read-only mode improves performance at all? Or is it really just a safe-guard feature. Thanks, Mark On 9/23/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Mark Wyszomierski <[EMAIL PR

[sqlite] where is SQLITE_OPEN_READONLY defined?

Hi, I wanted to open a sqlite database read-only - where is: SQLITE_OPEN_READONLY defined? Thanks - To unsubscribe, send email to [EMAIL PROTECTED] --

Re: [sqlite] Re: dates and times in sqlite

Oh I forgot to put quotes around the result, thanks Igor, Mark On 9/20/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Mark Wyszomierski <[EMAIL PROTECTED]> > wrote: > > I've made a text field called "timestamp" which has dates in the form: > > >

[sqlite] dates and times in sqlite

Hi, I've made a text field called "timestamp" which has dates in the form: -MM-DD HH:MM:SS I want to test if the day portion is a Tuesday for example - something like: SELECT * FROM my_table WHERE DAY(timestamp) = TUESDAY is something like that at all possible? I've looked at the e

[sqlite] remote access to sqlite db?

Hi, Does sqlite offer the ability to connect to a sqlite db file on a remote machine? I've been using it locally for awhile and it's great. Wanted to see if it could be used remotely for some simple tasks. Thanks, Mark -

Re: [sqlite] starting with unicode

after being busy, or will it again reset the entire statement and throw back to an infiinite loop? Thanks, Mark On 8/15/06, Nikki Locke <[EMAIL PROTECTED]> wrote: Mark Wyszomierski wrote: >strSql.Format(_T("SELECT * FROM test")); > >sqlite3_stmt *pStmt; >

Re: [sqlite] starting with unicode

} but can I use the string "SELECT * FROM test", if not how do I use those question marks or AAA variable identifiers in the string itself to achieve binding? Thanks, Mark On 8/14/06, Mark Wyszomierski <[EMAIL PROTECTED]> wrote: John, Cory, thank you very much. I got execute plain s

Re: [sqlite] starting with unicode

Thanks, Mark On 8/14/06, John Stanton <[EMAIL PROTECTED]> wrote: Mark Wyszomierski wrote: > Hi Cory, > > Alright I gave it a shot from the docs but I'm not handling the > prepare statement correctly. I'm trying the ASCI version first. The > prepare statement return

Re: [sqlite] starting with unicode

reak; case SQLITE_MISUSE: TRACE("MISUSE\n"); break; default: break; } sqlite3_finalize(pStmt); return true; Any hints? Thanks, Mark On 8/13/06, Cory Nelson <[EMAIL PROTECTED]> wrote: On 8/13/06, Mark Wyszomierski <[EMAIL PROTEC

[sqlite] starting with unicode

Hi, I have been using sqlite on windows for a few months, it is great. I need to switch over to unicode support now though, and I am confused how to do this with sqlite. 1) First, when I compiled the original sqlite project, I have the character set to MBCS. Should I switch this to Unicode and r

Re: [sqlite] translate time comparison statement

Cool thanks, Mark On 1/11/06, Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > > You may want > > WHERE julianday(date('now')) - julianday(date(arrival_date)) > 7 > > so that time of day isn't part of the comparison; otherwise, > you're correct. > > Regards >

[sqlite] translate time comparison statement

Hi all, I'm trying to translate some MySQL to sqlite. Ran into a problem with this time comparison statement. I translated as best I could, it seems to work, is this alright? (I'm trying to see if any records are more than 7 days old, based on the value of 'arrival_date' field): Original: SELECT

Re: [sqlite] specifying field type, any benefit?

Got it, thank you very much all, Mark On 1/4/06, Henry Miller <[EMAIL PROTECTED]> wrote: > > On Wednesday 04 January 2006 02:54 pm, Mark Wyszomierski wrote: > > Hi all, > > > > I switched to sqlite from mysql awhile ago, I maintained the field types > >

[sqlite] specifying field type, any benefit?

Hi all, I switched to sqlite from mysql awhile ago, I maintained the field types in my sqlite implementation such as: create table students (first_name TEXT, age INTEGER); I'm just wondering if there is any point to specifying the field type as if I try adding a string type into the age fiel

Re: [sqlite] primary, secondary keys

Thanks Dennis On 9/30/05, Dennis Cote <[EMAIL PROTECTED]> wrote: > > Mark Wyszomierski wrote: > > >Hi all, > > Does sqlite allow multiple keys? When I created a table I did: > > CREATE TABLE test (name, address, fav_color, primary key(name, address)) > >

[sqlite] primary, secondary keys

Hi all, Does sqlite allow multiple keys? When I created a table I did: CREATE TABLE test (name, address, fav_color, primary key(name, address)) Is that valid? I would like to not have any duplicate name + address entries. There was no error reported but later I tried modifying the table in SQLi

Re: [sqlite] tracing memroy leak

PostMessage() - then there are no memory leaks. But opening and closing the database everytime I have to post a message may be too burdensome, Thank you! On 9/15/05, Dennis Jenkins <[EMAIL PROTECTED]> wrote: > > Mark Wyszomierski wrote: > > > app1: > >S

Re: [sqlite] tracing memroy leak

rn 0; } Thanks! Mark On 9/15/05, Dennis Jenkins <[EMAIL PROTECTED]> wrote: > > Mark Wyszomierski wrote: > > >I traced this error down a bit, it only appears when using windows' > >PostMessage() to communicate between applications. Both applications have > >t

Re: [sqlite] tracing memroy leak

I traced this error down a bit, it only appears when using windows' PostMessage() to communicate between applications. Both applications have their own database handles for sure. When one app gets some data, it simply uses PostMessage() to inform the other app that some data has been received.

[sqlite] tracing memroy leak

Hi all, Is there anyway to track down memory leaks with using sqlite? I have 2 apps sharing one database file. Application #1 only ever uses a single thread, so I just open the db struct at startup, and close it at shutdown. Closing down returns SQLITE_OK. My second app opens a handle to the da

[sqlite] create database file at runtime

Hi everyone, Two quick questions: 1) Is there anything special the supplied sqlite3.exe does to create a database file. I want to programatically create a database file at runtime, so can I just create an empty xxx.db file, and go ahead with create table statements to populate it? The document

Re: [sqlite] how to store date/time in sqlite?

Ah excellent, thanks Jay, Mark On 9/13/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > See the wiki section of the documentation on the web site. There's a page > devoted to this. > > On 9/13/05, Mark Wyszomierski < [EMAIL PROTECTED]> wrote: > >

[sqlite] how to store date/time in sqlite?

Hi all, Moving from a mysql database to sqlite. I had some date/time fields in my mysql database. I would just populate them using the now() function. How could I achieve the same in my new sqlite database? Thanks! Mark