Jump to content

AlphabetizedTitle, what happened to you?


Fred Slota
 Share

Recommended Posts

Scanned new books with the App.

Added the current date in the Notes field for each book.

Imported into ComicBase with New Sales and Purchases.

Load up the Advanced Find I've been using for a couple of years to pull up the new issues, so I can verify the quantities and scan the covers. 

Put in the correct date, press find, and... Error?

 

My Advanced Find does a custom sort to put list the Issues in ComicBase order, as that is how my collection is organized.  The first field in the sort order is ComicTitles.AlphabetizedTitle.  This is now being reported as an SQL error, that the column no longer exists.

 

Has this been renamed?  Has this been hidden from access via Advanced Find?

 

Help would be appreciated.  Thank you.

Link to comment
Share on other sites

And the saga continues.....  One problem on me, and two more problems on ComicBase...

 

I replace ComicTitles.AlphabetizedTitle with I.[Title] and no more errors...   But no books found.  ???

 

Okay, maybe I entered the month without a leading 0, let's try that.  Still no books found.

So, I search for one of the added books.  Yup, it's there.  Quantity 1.  What's in the note field?   Well, today is my birthday, and instead of putting today's dat in the Notes field, I entered it with my birth year.   Duh.

 

 

So, I correct the year in the search, and rerun the search.   Still no books found.  What is going on now?

I search for just the two digit year, let's say I.[Notes] LIKE "%89%" (Similar to Dragnet, the Years have been changed to protect the old).  Okay, that returns a lot of books, my newly added books, books where the notes mention that year, books where the note mention a matching issue number.

So, let's expand, and I try a search for the month and year, "%10/89%".  No books found.  What's up with the '/' character, which has been part of my usual search test for years?

And lastly, I try a wildcard.  I.[Notes] LIKE "%10_89%".  Again, no books found.  What's up with the wildcard, or is it the wildcard for '/'?

I figure I'll sidestep all this with ANDing LIKEs for "%07%", "%10%" and "%89%".  Well, that returned items.  I see references to issue #1071 and the like.

 

 

 

 

Aaaaaaand, it is at this point that I realize what is going on.

Because, I notice that the Title of the first returned item isn't a Comic Book.  It's a magazine.

My collection is at least 99.999% Comic Books.  I'm almost always manipulating Comic Books.  Buuuut, the last thing I had previously done was enter an issues of Marvel Previews, which is....  a Magazine.

So, when I launched ComicBase today, I was starting up looking at a Magazine.  And when I launched Find, it started out on Magazine.  Which, of course, does not have a ComicTitles.AlphabetizedTitle field. And even when I looked up a specific Comic Book I had entered, to verify what was typed in the Notes filed, of course that doesn't change the focus of the Find window when I reopen it.   And of course, Magazines did not have any issues with my birthdate in the Notes field, as I hadn't entered any new Magazines.  And of course, searches for the date with a "/", or a wildcard, wouldn't find any.

 

Find on Comic Books, Load my saved Advanced Find, fill in the correct date, as I entered, and everything works as should, like it has been doing for years.

 

*Sigh*

Congratulations, ComicBase.  You have made me feel old on my birthday.

 

 

 

 

 

Link to comment
Share on other sites

Quote

My Advanced Find does a custom sort to put list the Issues in ComicBase order, as that is how my collection is organized.  The first field in the sort order is ComicTitles.AlphabetizedTitle.  This is now being reported as an SQL error, that the column no longer exists.
 Has this been renamed?  Has this been hidden from access via Advanced Find?

I just tried an Advanced Find using ComicTitles.AlphabetizedTitle in the ORDER BY and it worked with no problem
Can you supply a screen print of the SQL error message?
One possibility is if you are in a different Type. For example, Book Types require BookTitles instead of ComicBookTitles.

PS the Use of the Title Columns in Advanced Find is unsupported and could stop working at any time without any warning.

PPS I just finished reading both of the lengthy posts and see you already figured out that the Types were being mixed.

Link to comment
Share on other sites

Not a problem. I think I have mentioned the Type mis-match (so to speak) between what is displayed and what the Find window type is to Pete.

If not, I will mention it again during the next version beta-testing. Not sure if it is an easy, hard, or impossible fix.

Link to comment
Share on other sites

Yeah, it's not reeeeealy wrong...  Comicbase follows it's own logic - Search has its own memory of which media it is focused on, and its own widget for changing the media.. It starts focused on whatever media you were browsing, but after that it goes its own way, regardless of how you change when browsing.  It's fools like me, who spend nearly all the time thinking about Comics Books and just assume everything defaults to Comics all the time, or that the Search will always follow the Browse, well, which one of us is wrong, me or the software?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...