Deleting songs from Singer's Database

[Joe Nieves]

Originally Posted by ddouglass

Joe, "Null" name shows up in the Singer's list for the database if you have done as Karaoke Kiwi has said.
The only way I know how to get rid of them at the moment is to use Access to delete the records with blank names in the Singers table. They won't delete from in Hoster. I'll bring this up too in the beta testing to see if these can either not be created or to only create one for those times you want to put in a song without a singer's name such as Audio songs.
When ever you add a track using just the Add Track or the S+ Hoster saves the name in the database. That is why you get names in the list with 0 song entries.

I tried Access and the name Null doesn't show in the list in Access, What does show is a blank Name with no Date and a number in the SingeId column, could this be that Null entry in the singer tab?

Joe....

[ddouglass]

Originally Posted by Joe Nieves

I tried Access and the name Null doesn't show in the list in Access, What does show is a blank Name with no Date and a number in the SingeId column, could this be that Null entry in the singer tab?

Joe....

That's what I said.

The only way I know how to get rid of them at the moment is to use Access to delete the records with blank names in the Singers table.

[Joe Nieves]

Originally Posted by ddouglass

That's what I said.

Just Making Sure I don't want to cause havoc with the singers database and adversely effect anything else in the system.

Sorry for all the questions.

Joe....

[Karaoke Kiwi]

Dale, where do I find the Singer's Table?

[ddouglass]

Do you have Microsoft Access? If so double click on the Singers.mdb file in C:\MTU\Hoster and open it in Access. You will see two tables listed "Singers" and "Songs". Open Singers and find the ones with no name in the Name column.

[Karaoke Kiwi]

Cheers Dale!

I was looking under my programs and it didn't show there!

I thought I had Access on my work PC but IT must have removed it when they 'Upgraded' My Box.

I can get it sorted out now.

Thanks.

Albert

[ddouglass]

When you open it in Access if it asks if you want to "convert" the database tell it NO. The database has to remain in the format it is in (Access97) or Hoster won't be able to use it.