Syntax Error (missing operator)

[nreel]

It is true you may edit the SONGS.MDB and either DELETE the quotation marks (") or change the quotation marks to another character and when you "View By Artists" in HOSTER the problem will have gone away.

But, if you rebuild the database any time thereafter, the original artists, that had the Quotation Marks, will return.

When the Database is REBUILT, HOSTER gets the information from the HEADER info of each song, which is established upon IMPORTING. The HEADER info may be edited if you have a TEXT EDITER program.

Without the ability to EDIT the HEADER info directly, the only way to permanently correct this is to re-import the offending song and correct the ARTIST name, delete the SONGS.MDB database, and re-build the DATABASE.

I have, just now, successfully edited the HEADERS of all KMA files containing Nat "King" Cole (27 KMA files)(and you MUST correct them all to correct the ARTIST SEARCH FIELD), deleted the SONGS.MDB, and Re-built the DATABASE. Upon viewing the ARTIST FIELD and searching for Nat "King" Cole, only Nat..King..Cole appears (I placed two PERIODS between the names to hold the spacing).

Notice the spacing of Nat King Cole - when editing the HEADER, I just overtyped the Quotation Mark with a space, and, this is exactly how it appears in the ARTIST FIELD...with the extra spaces...so, I know that the information is coming directly from the HEADERS of the KMA files.

I am experimenting with editing the BUCKET.MDB database with my TEXT EDITOR, as I am unable to open the BUCKET database with the version of MS ACCESS that I use. I have been successful in searching on the Artists in question and have successfully replaced the Quotation Marks with Spaces. Now, I need to IMPORT a disc to see if the Disc Information, which comes from the BUCKET.MDB, shows up correctly. That way, I will not have to worry about correcting the ARTIST FIELD upon future importing...it would be a GLOBAL and ROOT change, if you will (of course, until this is corrected by MTU, all future Software Upgrades, which contain a new, updated BUCKET.MDB, will overwrite any corrected/edited BUCKET Database, unless you save a Backup of the corrected/edited BUCKET Database, and then, you realize you will not have access to the updated songs that may be in any future Software Upgrade if you use the Backup).

Hope this helps,

Norm