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 11

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 NULL

[sqlite] sqlite:Deletion in Joins method

2007-12-05 Thread Sreedhar.a
ement looks like [For both insert and update]. Even if update any records 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

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 CO

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 meth

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 wi

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 IN

RE: [sqlite] sqlite:Deletion in Joins method

2007-12-02 Thread Sreedhar.a
in Joins method 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 ha

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 text