Syntax Error (missing operator)

[dlessnau]

If I search by "Artist" and try to select, Nat "King" Cole, I get this error and Holster closes.

Syntax error (missing operator) in query expression artist Nat "King" Cole 3075

If I bring up these songs using the book ID number all is fine. I suspect it is because I have the King with quotation marks. Is this the problem?

Does this mean I have to reimport all these songs and change the name to Nat King Cole?

[dlessnau]

I now have re-imported the Nat "King" Cole songs, and renamed them Nat King Cole. If I work VERY carefully and type in Nat King Cole I can now bring up a list of all his songs and play them.

However, in the drop down "add tracks" box, Nat "King" Cole is still listed, even though I no longer have songs with that name.

If I scroll down to that name, Holster gets the above error and closes. I suspect now, I have to rebuild the data base in order to get rid of the listing for Nat "King" Cole.

However, I am scared to do that, as I don't want to screw something up by doing it wrong.

Here is what I think I must do:

Select build data base. Source will be c\Holster songs

Destination will be c\program files\micro technology unlimited\holster\databases

I then click on build data base and that will build the data base to reflect what is in there now, and the Nat "King" Cole listing that is causing the problem will be gone.

Is all the above correct? I need to know before I push the build data base button.

[MTUSUPPORT]

Dave,
This is a bug in that access can't handle files that are in the double quotes as"". When you do this you should beable to remove them as you did. The only other thing that you might need to do is go to your c:\Program Files\Micro Technology Unlimited\Hoster\Databases directory. Delete the file songs.mdb.

Once you have done this, open Hoster back up click on the Configure menu, Build Song Database. Set these items and then Rebuild the song database.

Let me know if this will fix it.

[dlessnau]

Did not fix it. I deleted the file as you said and rebuilt it. It all worked OK. However, when I opened the add track box and selected Artist, the Nat "King" Cole listing is still there.

Any highlighting of it, even if you don't select it, causes Holster to crash.

No big deal, as I won't go there anymore, but I am a perfectionist and would like to get rid of that listing.

Dave

[dlessnau]

I did not delete the songs before I re-imported them. I just overwhrote them.

However, whan selecting by book ID the songs all come up with then new name without the Quotes.

I checked the holster song file and I only see one listing for those songs, and it is the updated one, according to the date.

Where is the Nat "King" Cole coming from, if it is not in the Holster Song Folder?

[Dave Heidersche]

Bobby "Boris" Pickett sings "The Monster Mash". Same error occurs when trying to open this song by the artist name, but Hoster closes only about half the time for me.

[Flipeoke]

Not sure if my thoughts are correct on this, but try deleting the song files and songs.mdb, then rebuild the database, then reimport the songs.

Pehaps when you do a rebuild it doesn't overwrite existing info. i.e. When you reimported with the new info, and rebuilt, it saw that the song was already in the database, and kept the old info... Just a thought...

Hope it helps,
Flip

[mindonstrike]

When rebuilding the database Hoster ignores anything not being overwritten instead of deleting it which is probably why MTUSUPPORT said to "delete the file songs.mdb".

I had the same problem with that song however simply reimporting took care of it .

Sam

[George]

When I delete tracks, then delete the songs.mdb file and rebuild the database, the unwanted track listings are still there. I've never been able to get rid of them.

George

[Wayne White]

I opened the Songs DB (with MS Access) & using the search function looked for " in first artist & then song. I either deleted the " altogether or changed it to' . When I Open Hoster the "s are gone.

Wayne

[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

[Wayne White]

I have several current copies of my Songs DB on different computers & also burned to a disc. I can't think of any reason why I would ever want to re-build my songlist using the header data. Besides the " problem. Very many of the songs Titles & Artists are wrong in my header data, but, have been corrected in my Songs DB....Wayne

[nreel]

Wayne is absolutely correct in that, if you never rebuild the database, after editing it with MS ACCESS, then your good to go.

And, Wayne, I apologize if my POST sounded, in any way, as a correction to your POST...that was, sincerely, not my intent.

It is just that, MTUSUPPORT has always suggested to DELETE the SONGS.MDB and, then, REBUILD THE DATABASE as a cure to most these situations.

Actually, I do not use HOSTER's search engine to find anything because of it's problem with finding all DUPLICATE songs. I use MS ACCESS, running in the background, to Search.

Like everyone, I will be very happy when MTU overhauls the BUCKET.MDB, as well as MANY other features in HOSTER.

Thanks,

Norm

[Wayne White]

I was just clarifying that once your data is correct in the Songs DB, you shouldn't really have to re-build it (if you have & know how to use Access, which is pretty handy to have if you have Hoster)...Wayne

[admin]

Originally posted by Wayne White
I have several current copies of my Songs DB on different computers & also burned to a disc. I can't think of any reason why I would ever want to re-build my songlist using the header data. Besides the " problem. Very many of the songs Titles & Artists are wrong in my header data, but, have been corrected in my Songs DB....Wayne

Wayne and all others who edit your Songs.mdb file... Hoster 2.100 is close at hand for releasing. It contains a new BUCKET.mdb database that has the " removed, the artists fixed (for example - Beatles, The will now appear under B, but print as The Beatles), and another 66,000 songs have been added, bringing it current to October, 2003 for most USA songs.

Also.......... we have added a new (yet old) command: Update KMA File Headers command. It will allow you to take your modified Songs database and modify each KMA file header to equal its edited entry in the Songs database, and do all in one operation... yep, fully automated! We wrote this as a Utility program last year, and it was used by everyone to update their database and kma files. After using it, rebuilding your Songs database should rebuild it identically to what it was before.

NOTICE! When using any powerful command that edits many files, ALWAYS backup all files that can be affected BEFORE you run the command. We don't want to hear any complaints that your KMA files have been damaged. As we all know, Microsoft can do very weird and unexplainable things to the applications programs it is supposed to only run.

nreel, you point about the Songs and Artist lookup not finding duplicates is correct. We intend on overhauling the entire Add CD Track command, placing the fields on the Playlist Screen at the bottom right. The Songname and Artist buttons will disappear, and we will add what one of you suggested some months ago... a Find button that allows you to use wildcards to locate any string or partial string, display the results in a separate window, allow selecting the song you want from that window and add it to the Play list. Adding the Singers and Keychange will be done in a popup window that appears before the song appears in the Playlist.

[mikedomi]

very nice well done thank you

[Sax&Dotty]

quote
Please note... when you are importing tracks where you enter the Song name and Artist names, please DO NOT ever use the " (double quote) character. We have to use that to delineate a ' (single quote) character, and when a " is encountered, it will lock up the system.

Using quotes in sql is simple so long as U know where U is is at with it

Sample

where (((ArtistName)Like '*Nat*')) AND (((ArtistName)Like '*"King"*')) And (((ArtistName)Like '*Cole*'))

Just watching