Re: [sqlite] cross-database time function.

2009-12-28 Thread Israel Brewster
On Dec 28, 2009, at 9:29 AM, Simon Slavin wrote: On 28 Dec 2009, at 5:06pm, Israel Brewster wrote: Or perhaps some other way to extract the time of a timestamp that works in all three databases? Sorry. Each database handles time/date information differently (there's no SQL standard

[sqlite] cross-database time function.

2009-12-28 Thread Israel Brewster
to extract the time of a timestamp that works in all three databases? Thanks. ------- Israel Brewster Computer Support Technician II Frontier Flying Service Inc. 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450

Re: [sqlite] [SOLVED] Force cache flush?

2009-11-20 Thread Israel Brewster
. Once I closed out the SELECT, my INSERTS started showing right up. Thanks for the feedback! On Nov 19, 2009, at 12:34 PM, Israel Brewster wrote: Nov 19, 2009, at 12:13 PM, Jay A. Kreibich wrote: On Thu, Nov 19, 2009 at 11:58:59AM -0900, Israel Brewster scratched on the wall: When

Re: [sqlite] Force cache flush?

2009-11-19 Thread Israel Brewster
Nov 19, 2009, at 12:13 PM, Jay A. Kreibich wrote: On Thu, Nov 19, 2009 at 11:58:59AM -0900, Israel Brewster scratched on the wall: When issuing an INSERT command on a SQLite database, is that insert cached before being written to the disk? Sometimes. It may be partly cached until

[sqlite] Force cache flush?

2009-11-19 Thread Israel Brewster
first. Thanks! --- Israel Brewster Computer Support Technician II Frontier Flying Service Inc. 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7250 x293

Re: [sqlite] SQLite, network share, and Qt

2009-11-17 Thread Israel Brewster
On Nov 16, 2009, at 3:41 PM, Simon Slavin wrote: On 16 Nov 2009, at 7:32pm, Israel Brewster wrote: Now I know that this sounds like a Qt problem, and in fact I believe that to be the case. However, when I ask them about it, they stubbornly keep insisting that it is a sqlite problem. I

Re: [sqlite] SQLite, network share, and Qt

2009-11-17 Thread Israel Brewster
On Nov 17, 2009, at 12:49 AM, Simon Slavin wrote: On 17 Nov 2009, at 7:45am, Dan Kennedy wrote: On Nov 17, 2009, at 2:32 AM, Israel Brewster wrote: Simple (I hope) question here for my first posting to this list: Running SQLite 3.4.0 on Mac OS X 10.5.8, should I or should I not be able

[sqlite] SQLite, network share, and Qt

2009-11-16 Thread Israel Brewster
? Or are the Trolltech/Qt people just not willing to accept that the problem is with their driver? Thanks. --- Israel Brewster Computer Support Technician II Frontier Flying Service Inc. 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7250 x293