The more you guys teach me the harder simple tasks get. Ten plus years back I had data-based all my music to around 13-thousand songs. With your advice and a few books, I added artists, photos, album covers and biographies. A couple of years back, I stepped up the normalization by making a separate song instance table. Now when I'm listening to my own version of Pandora on a Sunday, I hear a song and I want to add lyrics to the song playing but I don't want to exit my application.
My Pandora version is based on views so you can change mood preferences. It has a timer function so as the song ends it brings up a new random song that fit preference settings but it is not very update friendly. To add a lyric I need to set the songTitle table record lyricID from 0 to the new lyric record number. That way, several songTitle records (same song but different artist) can share a lyric record when appropriate. Can I slyly do this and requery the songTitle so the lyrics suddenly show up and not disrupt the timer that tells the ir-blaster to play a new cd-instance (at the end of a song). It takes about 1-minute or less to do a google search a grab the lyrics in a copy buffer and have it ready to paste. Gary Jeurink --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/365600BED8E24309BD21356410238D16@OwnerPC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
