Re: [sqlite] sqlite:Deletion in Joins method

2007-12-07 Thread Dennis Cote
Sreedhar.a wrote: Hi Dennis, I have created 2 tables for PlayList as u suggested as Follows. "CREATE TABLE MUSIC (MusicId INTEGER PRIMARY KEY NOT NULL,Album_Id INTEGER,Artist_Id INTEGER,Bgm_Id INTEGER, Track Text);" MusicId Album_Id Artist_Id Bgm_Id Track 1

RE: [sqlite] sqlite:Deletion in Joins method

2007-12-06 Thread Sreedhar.a
Hi Dennis, I have created 2 tables for PlayList as u suggested as Follows. "CREATE TABLE MUSIC (MusicId INTEGER PRIMARY KEY NOT NULL,Album_Id INTEGER,Artist_Id INTEGER,Bgm_Id INTEGER, Track Text);" MusicId Album_Id Artist_Id Bgm_Id Track 11

Re: [sqlite] sqlite:Deletion in Joins method

2007-12-06 Thread Dennis Cote
Sreedhar.a wrote: Thanks a lot for ur help. You are welcome. Right now I am trying to INSERT and UPDATE by means of triggers. My doubt is: "CREATE TABLE ALBUM (AlbumId INTEGER PRIMARY KEY NOT NULL, Album Text,unique(Album));" "CREATE TABLE ARTIST (ArtistId INTEGER PRIMARY KEY NOT

[sqlite] sqlite:Deletion in Joins method

2007-12-05 Thread Sreedhar.a
rds in one table It has to be changed in all the others Please help to solve this. Thanks & Regards, Sreedhar.A -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 04, 2007 9:56 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite:Deletion

Re: [sqlite] sqlite:Deletion in Joins method

2007-12-04 Thread Dennis Cote
Sreedhar.a wrote: CREATE TABLE ALBUM (AlbumId INTEGER NOT NULL PRIMARY KEY,Album Text); CREATE TABLE ARTIST (ArtistId INTEGER NOT NULL PRIMARY KEY,Artist Text); CREATE TABLE BGM (BgmId INTEGER NOT NULL PRIMARY KEY,Bgm Text); CREATE TABLE MUSIC (Id INTEGER NOT NULL PRIMARY KEY,Album_Id INTEGER

RE: [sqlite] sqlite:Deletion in Joins method

2007-12-03 Thread Sreedhar.a
st_Id) IS NOT NULL THEN 'DELETE FROM ARTIST WHERE ArtistId=OLD.Artist_Id' END; END;" -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Monday, December 03, 2007 11:53 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite:Deletion in Joins method Sreedh

Re: [sqlite] sqlite:Deletion in Joins method

2007-12-03 Thread Dennis Cote
Sreedhar.a wrote: I have only one ALBUM named 'Confession' with id 1 and only one ARTIST named 'Madonna' with id 2 and one BGM named 'rock' with id 5. MUSIC table will have all these details. Now If I delete the Album 'Confession' From table ALBUM. Then it is deleting that record

Re: [sqlite] sqlite:Deletion in Joins method

2007-12-03 Thread Sreedhar.a
Hi, Thanks for your suggestion Dennis. Now I normalized the database as follows: * CREATE TABLE ALBUM (AlbumId INTEGER NOT NULL PRIMARY KEY,Album Text);" * CREATE TABLE ARTIST (ArtistId INTEGER NOT NULL PRIMARY KEY,Artist Text);" * CREATE TABLE BGM (BgmId

RE: [sqlite] sqlite:Deletion in Joins method

2007-12-02 Thread Sreedhar.a
Hi, Thank you very much Dennis for the reply. I will try the method suggested by you. Best Regards, A.Sreedhar. -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Saturday, December 01, 2007 1:31 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite:Deletion

Re: [sqlite] sqlite:Deletion in Joins method

2007-11-30 Thread Dennis Cote
Sreedhar.a wrote: Hi, I have created database using the joins method. My database caontains 4 tables with the Artist(1),Album(2),Genre(or) BGM(3),Combination of all these and Track names in one table. I am having 4 tables as follows. * "create table ALBUM(AlbumId integer

[sqlite] sqlite:Deletion in Joins method

2007-11-29 Thread Sreedhar.a
Hi, I have created database using the joins method. My database caontains 4 tables with the Artist(1),Album(2),Genre(or) BGM(3),Combination of all these and Track names in one table. I am having 4 tables as follows. * "create table ALBUM(AlbumId integer primary key,Album