Re: [sqlite] Indexing and Search speed

> select types.Track,types.URL from ALBUM inner join (select * from MUSIC > where Artist_Id =?) types on ALBUM.AlbumId=types.Album_Id order by > ALBUM.YomiAlbumName ; How does the subquery work in this statement? I thought subqueries could only retrieve a single column.

Re: [sqlite] Sqlite catalog - datebase with pictures

Hello Lukasz, to insert a picture (or any binary data for that matter), you can read the data from the file and use sqlite3_bind_blob to insert (or update) it. When selecting it from the database, use sqlite_column_blob to retrieve the data and sqlite3_column_bytes to get the length. An

Re: [sqlite] BCD representation of floats

John, I'm not sure what you mean. What do 64-bit SQLite integers do for me? Oracle 8 uses the BCD, and I'm trying to temporarily match that. I'm not looking for sufficient precision, I'm looking for the exact same 64 bit floating point number as from Oracle. Liam On Wed, Mar 26, 2008 at 9:25

Re: [sqlite] BCD representation of floats

Ken, Thanks for your detailed response. I thought of your remedies, but I perhaps didn't explain myself well enough. The Oracle we are using is Oracle 8, yes, ancient I know, but a fact of life. It has no binary_double type; that was introduced for Oracle 10 evidently. Second, I know there is

[sqlite] Sqlite catalog - datebase with pictures

Hi. I would like to write an application wich helps me to manage with my cd/dvd collections. It will scan all files on cd/dvd add it to a datebase and it could also insert pictures (cd/dvd covers). My questions are: - is there any possiblity to add in sqlite datebase pictures like gif, jpg ? -

Re: [sqlite] "Unsupported File Format" from 3.1.3

On Mar 29, 2008, at 12:34 AM, Jerry Krinock wrote: > Someone sent me an sqlite database file. > > Opening in Mac OS 10.5 with the built-in sqlite 3.4.0, no problems. > > Opening in Mac OS 10.4 with the built-in sqlite 3.1.3, any query > returns sqlite error 1, "unsupported file format". > >

[sqlite] Indexing and Search speed

Hi, I am having 4 records in my database. I am using Joins method. My Table Looks like: "PRAGMA encoding = UTF16;" "CREATE TABLE ALBUMARTIST (AlbumArtistId INTEGER PRIMARY KEY NOT NULL, AlbumArtistName TEXT NOT NULL COLLATE NOCASE, YomiAlbumArtistName TEXT NOT NULL, UNIQUE

Re: [sqlite] Go to specific row in database

Apologies for not being too clear. Normally, I'd just query a database based on "where" criteria to get results, but that is based on a continually expanding and dynamically changing database. In this case, I have a static (book records) database and I want to select a specific row based on the

Re: [sqlite] Go to specific row in database

Hi flakpit, > MySql and msSql have seek commands to go to a( or return) a specific > row in a database base don the internal row number rather than an id > or other identifier. > > Is there a generic SELECT statement that can do this for sqlite or > indeed, any other sql variant? SQL is