Re: [sqlite] Re: sqlite_open

qlite_master WHERE type='table' AND name='%q'; sqlite is lean and mean, feature creep detracts from that. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 e

Re: [sqlite] Right() function

configured to support UTF-8, then characters indices refer to actual UTF-8 characters, not bytes. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that wor

Re: [sqlite] Accommodating 'Insert' and 'Update'

Rich Shepard wrote: On Tue, 28 Nov 2006, Craig Morrison wrote: Another method is to have a field declared UNIQUE and use the syntax: INSERT OR REPLACE INTO table ... The UNIQUE constraint will trigger the REPLACE constraint if it already exists and the row will get updated instead

Re: [sqlite] Accommodating 'Insert' and 'Update'

constraint will trigger the REPLACE constraint if it already exists and the row will get updated instead of inserted. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that wor

[sqlite] OT: filenaming conventions -- was: Re: [sqlite] Saving tables

ite you, for instance: dir *.sql Will list not only *.sql files, but *.sqlite too. Imagine: del *.sql Deleting all your *.sqlite files. Whoopsie.. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessiona

Re: [sqlite] C++ SQLite

] - -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You

Re: [sqlite] Date and time

to adjust the timestamp display in accordance with your local settings. IOW, the offset from UTC of your system is used in the calculation of the displayed date. Google: "strftime", "asctime" and "localtime" for a better e

Re: [sqlite] Date data type

Lloyd wrote: Thanks gg and Craig Morrison for your informative reply. I would like to know one more thing, can I use these date and time functions with comparison operators? Will they return the correct result or as per the string comparison rules? Same rules apply, if it smells like a string

Re: [sqlite] Date data type

Lloyd wrote: Hi, How can I manage date and time using sqlite? [Do I have to do it outside sqlite?] http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http

Re: [sqlite] unsupported file format

. This subject has been beat to death.. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You.

Re: [sqlite] Major projects using SQLite

Jon García de Salazar Bilbao wrote: Hi, Could you give examples of some major software projects using SQLite? Thanks, Jon. FireFox 2.0.. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com

Re: [sqlite] How do you find out the names of the fields within a table?

=/library/en-us/vblr7/html/vastmReDim.asp Google is your friend.. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You.

Re: [sqlite] How do you find out the names of the fields within a table?

want to spend some time getting up to speed on VB. Or better yet, why don't you just pass a reference to the list box and add them directly to it? I'm not going to comment further on this topic as it is now QUITE far off-topic. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://ps

Re: [sqlite] Problems with multiple threads?

Lite works. Sometimes you just have to learn the quirks of the system and then deal with them. File a bug report or submit a patch with the "correct" behavior and I am sure DRH will be more than happy to review it. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

[sqlite] OT: SQL Help

) UNIQUE, filestamp INTEGER, filename VARCHAR(2048)); I suck at SQL, so I plead for your advice.. I want to be able to delete all rows from 'files' that do *not* exist in 'snapshot'. My efforts to date have done nothing but leave me with less hair. Thanks. -- Craig Morrison

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

s archive is out of the question. +1 for moderated posting status after days, -10 for all of the other suggestions that will cause me to jump through hoops to stay subscribed. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine

Re: [sqlite] "SQL logic error or missing database"

were to hazzard a guess, its because there was a second handle opened to the database that modified the schema which the first handle doesn't know about until it does its sanity check before operating on the database. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse

Re: [sqlite] scary warnings

. Plug in the warning number(s) you don't want to see. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You.

Re: [sqlite] sqlite2 api question - updates

d it to sqlite_exec(..). So it seems in theory the normal escaping mechanisms should work. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You.

Re: [sqlite] sqlite2 api question - updates

f(..); can also be used similarly.. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You.

Re: [sqlite] Sqllite As server

if this is of any use.. http://www.it77.de/sqlite/sqlite.htm Look around the Wiki for SQLite, there's some good information there. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email

Re: [sqlite] Compile SQLite

/sqlite-source-3_3_2.zip -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You.

Re: [sqlite] Re: Copy tables from one memory database to another with no disk access?

. ':MEMORY:' ? -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You.

Re: [sqlite] Multi-threading.

you step, because some of what you step into stinks. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://www.mtsprofessional.com/ A Win32 email server that works for You.

Re: [sqlite] PHP5 && SQLite3

brary that implements a self-contained, embeddable, zero-configuration SQL database engine." The focus is there, anything beyond that is up to the implementation. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://www.mtsprofessional.com/ A Win32 email server that works for You.