Re: [sqlite] Implementing LISTEN

The hard part is to do it portably. I use a multicast socket that writes the change-event. Then I use a select() call on the multicast socket in other clients- if they see the change event, they incorporate the new data into their cache. If you want it reasonably seamless, create triggers that

RE: [sqlite] Sort by TIMESTAMP?

On draw back to these is that they are pretty much non portable to other RDBMS. But they look good... Shawn -Original Message- From: Kurt Welgehausen [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:50 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Sort by TIMESTAMP? > May

RE: [sqlite] Sort by TIMESTAMP?

I'll give it a try, thanks :) -Original Message- From: Lloyd thomas [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:54 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Sort by TIMESTAMP? May try something like WHERE julianday(DBTimeStamp) < julianday('2004/4/4') but I might be

Re: [sqlite] Simultaneosly using sqlite on windows

Bronislav Klučka wrote: I've created application using SQLite as database (Windows application). The database is on remote server and application is accesing the database through file system (e.g. user connect server as P:\ disc and uses the path p:\databases\database.sdb). More users are

[sqlite] Simultaneosly using sqlite on windows

Hi, I've created application using SQLite as database (Windows application). The database is on remote server and application is accesing the database through file system (e.g. user connect server as P:\ disc and uses the path p:\databases\database.sdb). More users are accessing the database on

Re: [sqlite] ORDER BY terms must be non-integer constants

On Tue, 11 May 2004, Mitchell Vincent wrote: >This is a re-post as I didn't get any comments on what that error >message really means.. > >My view : > >CREATE view product_detail as SELECT * FROM products as p,categories as >c WHERE c.category_id = p.category_id; > >When I do this query (which

Re: [sqlite] Sort by TIMESTAMP?

> May try something like > > WHERE julianday(DBTimeStamp) < julianday('2004/4/4') > but I might be wrong. > > Lloyd Or, you could read the docs: www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions especially the section labeled 'Time Strings'. Regards

Re: [sqlite] testing for existence of an entity

this is likely a common and easy answer, so my for not being able to figure it out. How do I test for the existence of a table or a view so I can do something like... if exists then DROP else CREATE ()... what I do in such situations is SELECT 1 FROM