[sqlite] Something to think about: Saving Select ID Lists

One thing that I really miss form another database is the ability to reuse select statements. I haven't programmed but I believe this is sort of possible using C, this is a command language version maybe? e.g. CREATE TABLE IF NOT EXISTS Transactions (ID Integer PRIMARY KEY AutoIncrement,

Re: [sqlite] Insert / Update images using MS VBScript

Ojansivu Sent: Saturday, 31 May 2008 9:40 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Insert / Update images using MS VBScript 2008/5/31 MoDementia <[EMAIL PROTECTED]>: > I have spent most of the day searching for examples in VBscript to add / > update an image int

[sqlite] Insert / Update images using MS VBScript

I have spent most of the day searching for examples in VBscript to add / update an image into a database without luck. If anyone has a snippet of code they could share I would be most grateful. I have either an image as an object in the script and or a physical file location i.e. "C:\image.jpg"

[sqlite] Setting Precision for Floating Point data

After experiencing some difficulty with comparing dates stored internally as a floating point I was informed about the following. "... due to the way floats are stored in computers, '=' isn't really a good choice of an operator for them. Instead of Date = 38953.5890509 you should use Date >

Re: [sqlite] Checking for open transactions attach/detach database

imilar SQL command to check for the existence of a ...-journal file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MoDementia Sent: Wednesday, 28 May 2008 6:10 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Checking for open transacti

Re: [sqlite] Checking for open transactions attach/detach database

ite Database Subject: Re: [sqlite] Checking for open transactions attach/detach database MoDementia wrote: > The database file is ready to (copy) Detach as soon as the commit completes. > Yes. > This is the problem. > Detach: "This statement will fail if SQLite is in the midd

Re: [sqlite] Checking for open transactions attach/detach database and Trigger behaviour with attached databases

What is the appropriate etiquette if I don't receive a solution/answer in ?? days -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MoDementia Sent: Friday, 23 May 2008 12:32 PM To: sqlite-users@sqlite.org Subject: [sqlite] Checking for open transactions

[sqlite] Checking for open transactions attach/detach database and Trigger behaviour with attached databases

Hi, My first submission 1 Problem and 1 question J My problem I have 2 processes that are causing problems after commits/locks 1. Copy main database to copydatabase using filesystem object How to determine when copydatabase is ready for attach? Attach copydatabase <-- need to