[sqlite] sqlite:Deletion in Joins method

Hi Dennis, Thanks a lot for ur help. Ya.Its deleting properly in all the tables by the following trigger. "CREATE TRIGGER fkdc_MUSIC AFTER DELETE ON MUSIC FOR EACH ROW BEGIN DELETE from ARTIST where ArtistId = old.Artist_Id and not exists (select id from MUSIC where Artist_Id = old.Artist_Id)

Re: [sqlite] SQLite is in Android

Actually the SQLite Database doesn't need to be encrypted it shouldn't be jailbroken or hacked into, or broken in any way. Also I am sure that an encryption algorithm inside the iPhone would cause long boot times, etc. and space issues since it already has limited space for the actual OS an

RE: [sqlite] SQLite is in Android

One of my co-workers was playing around with SQLite on his iPhone and was able to access data including contacts and call log and pretty much everything. It's a SQLite database and not encrypted. Sam --- We're Hiring! Seeking a passionate developer to jo

RE: [sqlite] unable to open a temporary database file for storing temporary tables

Thanks for the response. I have finally been able to look at the system where this is running. You are correct. They are on an older system (2.8.17). I'll try to get them to update. They are using 3 different databases. When I issue a .databases command I see that all three are using the same

Re: [sqlite] determining storage type

Hua-Ying Ling wrote: How do you tell what the storage type of a field is? If a field returns 1234, how can you tell if it is stored as an integer or text? If you are using the command line shell the typeof() function will return the type. select field, typeof(field) from a_tabe; HTH Den

[sqlite] Re: determining storage type

Hua-Ying Ling <[EMAIL PROTECTED]> wrote: How do you tell what the storage type of a field is? If a field returns 1234, how can you tell if it is stored as an integer or text? sqlite3_column_type Igor Tandetnik - To u

Re: [sqlite] SQLite is in Android

> http://www.sqlite.org/famous.html Btw, you write there: > There are unconfirmed reports on the internet that Apple also uses SQLite in > the iPhone and in the iPod touch. I'm pretty sure that SQLite is used there, I browsed my phone and saw several instances of SQLite there, I'd say that they

[sqlite] determining storage type

Hi, How do you tell what the storage type of a field is? If a field returns 1234, how can you tell if it is stored as an integer or text? Thanks Hua-Ying

Re: [sqlite] How to check if the column is existed in the table

Hi Joanne, On Wed, 5 Dec 2007 11:53:03 -0800 (PST), Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi Kees, > Is there anyway that we can find out how > many columns are defined in the table? Interpret the results of PRAGMA table_info(tablea); or Do a SELECT * LIMIT 1 on the table and get the

Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

Kees Nuyt <[EMAIL PROTECTED]> writes: > > Just a suggestion: Perhaps even on the home page. > > "This the homepage for SQLite - a library that implements a > self-contained, serverless, zero-configuration, _portable_, > transactional SQL database engine." > > With a link to a 'Portable' paragrap

Re: [sqlite] unable to open a temporary database file for storing temporary tables

Regarding the DOS-like name, it may be the canonical name on Windows for FAT/VFAT file systems. Is that what you're using? I wonder if there's a hash collision in trying to get the file name down to DOS 8.3 file name format. Do you have many sqlite_* files in that directory? Since the file pref

Re: [sqlite] How to check if the column is existed in the table

Hi Kees, Is there anyway that we can find out how many columns are defined in the table? Thanks for the info. JP - Original Message From: Kees Nuyt <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, December 5, 2007 10:18:48 AM Subject: Re: [sqlite] How to check if the colu

Re: [sqlite] How to check if the column is existed in the table

On Wed, 5 Dec 2007 09:56:30 -0800 (PST), Joanne Pham <[EMAIL PROTECTED]> wrote: >Hi All, >Is it possible to check if the certain column is existed in the table. >For example : I had the table as define below: > create table tablea (appid int, bytesIn int, bytesOut int) You can get information a

[sqlite] Re: How to check if the column is existed in the table

Joanne Pham wrote: Is it possible to check if the certain column is existed in the table. For example : I had the table as define below: create table tablea (appid int, bytesIn int, bytesOut int) and I want to add one more column with default value of 1 and I don't want to drop the table and

[sqlite] How to check if the column is existed in the table

Hi All, Is it possible to check if the certain column is existed in the table. For example : I had the table as define below: create table tablea (appid int, bytesIn int, bytesOut int) and I want to add one more column with default value of 1 and I don't want to drop the table and recreate it

[sqlite] unable to open a temporary database file for storing temporary tables

This is my first post. I thought I had osted yesterday but do not see it so forgive me if this is a duplicate. I have seen the error "malformed database schema - unable to open a temporary database file for storing temporary tables" discussed in another thread relative to PHP and BSD Unix. Ho

Re: [sqlite] Damaged database file

On Wed, 05 Dec 2007 13:17:55 +0100, Pannonvision <[EMAIL PROTECTED]> wrote: >Hi, > >Do you have any experiments on damaged file recovery? How can be >damaged the opened database file? We are using windows XP. It's really hard to damage: http://www.sqlite.org/atomiccommit.html and SQLite repairs t

RE: [sqlite] Is this a valid use of attach?

Thanks, that solved the issue, of course if I had checked the error message I would have solved it myself :( Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 05 December 2007 16:27 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is this a valid use of att

[sqlite] how to cast utf16 text to int?

I have table that holds values of different types in utf16. I also know value type for the current row. How should I cast value to compare it with integer? This test shows 1 instead of 17 that I expected. sqlite> create table t (value text, field_type int); sqlite> insert into t values (X'3100370

Re: [sqlite] Is this a valid use of attach?

"Mike Marshall" <[EMAIL PROTECTED]> wrote: > Possibly a stupid question but I'm trying to do an attach and then query via > a single sqlite3_exec() statement. > > > > Is the following a valid use? It is if the name of your database file is literally "dbpath". But from context, I suspect you ar

[sqlite] Is this a valid use of attach?

Possibly a stupid question but I'm trying to do an attach and then query via a single sqlite3_exec() statement. Is the following a valid use? sqlite3_exec(pDB,"ATTACH dbpath as universe;select * from othertable where identifier IN (select identifier from universe.identifierlist)",cbfn,NULL,

Re: [sqlite] File Is Encrypted Or Is Not a Database

Mark Easton wrote: It seems more than a little strange that I cannot determine the version of a sqlite db. I see you have solved your problem, but for future reference (and for others' information) you could have simply executed the following query using Perl to determine the version of s

Re: [sqlite] UNION and ORDER BY errors starting from sqlite 3.4.2

> Not in principle. But I think changes that break backwards > compatibility would be more trouble than they're worth for > something like this. In the absence of clearer guidance > from sql-92, it's probably more important to be compatible > with earlier sqlite versions than with mysql and friends

[sqlite] SOLVED: Allocating Memory For A Pool Of Database Connections

It works when passing the db_cache_list[i]->db to sqlite3_open_v2 without trying to allocate it. Thanks a lot Richard and Ken. - Never miss a thing. Make Yahoo your homepage.

[sqlite] Damaged database file

Hi, Do you have any experiments on damaged file recovery? How can be damaged the opened database file? We are using windows XP. We would like to integrate error handling into our software to handle all cases. Regards, Laszlo -- www.pannonvision.com -

Re: [sqlite] File Is Encrypted Or Is Not a Database

"Mark Easton" <[EMAIL PROTECTED]> wrote: > Sorry ... how do I get sqlite v3.4.2? > Any version of SQLite from 3.0.0 through 3.5.3 will open, read, and write a version 3.4.2 database file. If it says "file is encrypted or is not a database" then you do not have a 3.4.2 database file. Something

Re: [sqlite] search time in FTS3 tables sometimes very long

Hi Scott! You're great! I checked the attached modification and found no search taking longer than 20s now! It's a great improvement. I didn't find any other problems, so I will leave the modification in my FTS3 compilation. Many thanks! Ingo Scott Hess schrieb: 2007/12/4 Scott Hess <[EMA

Re: [sqlite] UNION and ORDER BY errors starting from sqlite 3.4.2

On Dec 5, 2007, at 1:24 AM, Joe Wilson wrote: --- Dan <[EMAIL PROTECTED]> wrote: The "b" in the ORDER BY does not match "x1.b" because it is not a simple identifier (according to matchOrderbyToColumn()). It does not match either "" or " as ". After failing to find a match for "b" in the left