Deleting songs from Singer's Database

[Karaoke Kiwi]

I don't disagree with any of the comments and in truth the real solution would be to fix the delete problem after sorting.

I have a handfull of NULL entries against my singer list which were created when I accidentally hit S+ with nothing selected. These I cannot delete. Can anybody help?

[Joe Nieves]

Originally Posted by Karaoke Kiwi

I don't disagree with any of the comments and in truth the real solution would be to fix the delete problem after sorting.

I have a handfull of NULL entries against my singer list which were created when I accidentally hit S+ with nothing selected. These I cannot delete. Can anybody help?

Not sure what the NULL name is all about but you can't rename, delete or add songs to it because it doesn't show up in the singers list box in Hoster.

Try to open it in access but not there either?

You'll need to ask dddouglass maybe he can explain this mystery of the third kind?

Also I checked my singer listings and found some 0 and was successful in deleting all I needed to.

Are you clicking the singers tab?


Joe.....

[Karaoke Kiwi]

When I select the Songs tab in the Singer's Database the first 6 entries read Singer NULL, # of song 0, Last Date NULL.

[Karaoke Kiwi]

Here goes

Under the Singers Tab Singer = NULL, # of Songs = 0, Last Date = NULL.

I think that when I pressed the S+ button neither song nor singer were selected!

It does not seem to pose any operational problems but only takes up the first 6 lines of the singer listing!

[Joe Nieves]

Originally Posted by Karaoke Kiwi

Here goes

Under the Singers Tab Singer = NULL, # of Songs = 0, Last Date = NULL.

I think that when I pressed the S+ button neither song nor singer were selected!

It does not seem to pose any operational problems but only takes up the first 6 lines of the singer listing!

In the singers database press the singers tab then you'll see a listing only of singers names and one column with total songs for that singer, you can then highlight the singer that has an "0" for amount of songs and press delete and it will delete.

What it doesn't delete is the Null name at the top of the list I only have one and I haven't a clue as to why it's there or what purpose it serves?

Good Luck

Joe.....

[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.

[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?