Fred Slota Posted July 10, 2022 Share Posted July 10, 2022 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 More sharing options...
Fred Slota Posted July 10, 2022 Author Share Posted July 10, 2022 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 More sharing options...
Steven L. Dasinger Posted July 10, 2022 Share Posted July 10, 2022 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 More sharing options...
Fred Slota Posted July 10, 2022 Author Share Posted July 10, 2022 Thank you for the reply. Sorry to waste your time. Hope you ended with the same chuckle at my expense that I had. Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted July 10, 2022 Share Posted July 10, 2022 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 More sharing options...
Fred Slota Posted July 10, 2022 Author Share Posted July 10, 2022 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now