Steven L. Dasinger

Delete or Move 1.jpg From: Pictures\W\Warren\Horror of Party Beach, The To: Pictures\W\Warren\Famous Films Delete or Move ALL (1.jpg - 1-I.jpg) From: Pictures\D\DC\J\Joker 80th Anniversary 100-Page Super Spectacular To: Pictures\D\DC\J\Joker 80th Anniversary 100-Page Super Spectacular, The Delete or Move 1-A.jpg From: Pictures\O\Oni\Rick and Morty Presents Council of Ricks To: Pictures\O\Oni\Rick and Morty Presents- Council of Ricks Delete 1.jpg From: Pictures\R\Red Giant\Duel Identity

It has been awhile but I don't recall any major problems. Pay to upgrade to Archive Edition. Down the Archive Edition. You can either Un-Install the Pro Edition and then install the Archive Edition (probably safest) or (possibly) just install the Archive Edition (which should do the un-install for you). The only thing I can think of that could give a problem is if the Serial # of the Archive Edition is different from your Pro Edition Serial #. You can check in you account act ComicBase.com by looking at the Registrations. If it is different, you will need to enter it somewhere ( I can't seem to find where but you may be prompted for it when installing or first opening the database. If you have problems send an email to Support@comicbase.com. Also, either order the disks to get all the covers or download all the picture files then install them from inside CB. You will use the same database as it is not deleted during any install process.

Delete or Move 1.jpg From: Pictures\I\It's Alive\Battle for Britain To: Pictures\I\It's Alive\Battle for Britain- From the Pages of Combat Rename Bk 1.jpg to Bk 1-HC.jpg From: Pictures\D\DC\B\Batman Who Laughs Rename Bk 1-LE.jpg to Bk 2-LE.jpg From: Pictures\D\Dark Horse\U\Umbrella Academy, The- Dallas

You can try deleting the Thumbnail folders located at: C:\Users\Public\Documents\Human Computing\Thumbnails. (they are recreated by CB as needed). You can either delete the whole directory (there are different ones per cover Icon size that has been used) or drill down and delete the Title folder or the individual thumbnail.

Not sure what you formula is doing but this seems to work for me. Note: I am multiplying Height and Width by 1.0 because the columns seem to be defined as Integer (no decimal value) and Integer / Integer results in an integer value. By multiplying by a decimal, it turns all the output into decimal. I.[QtyInStock] >= 1 AND ( I.[PictureWidth] * 1.0) / ( I.[PictureHeight] * 1.0) > 1 Also, there are some books that are wider than they are high and are not wraparound or gate-fold which will also show up with this query. If you want to fine tune it a little, you can change > 1 to something like 1.2 to control how much wider than high the cover is.

Rename TPB.jpg to TPB 2.jpg From: Pictures\I\Idea + Design Works\Art of John Byrne's Next Men, The Rename TPB.jpg to TPB 18.jpg From: Pictures\D\Dark Horse\B\Bettie Page- Queen of Hearts Rename TPB 1.jpg to TPB.jpg & TPB 1-A.jpg to TPB-A From: Pictures\B\Ballantine\Shadow, The (Ballantine)

Hmm... The only thing I can think that I might have done differently is I ran Optimize Database after the Rebuild Lists Picture info. Since the Picture columns can't be displayed, I have to determine what is stored there. Using The Phantom (1st Series) #3.jpg as a test, multiple finds with Between shows the value for this is 3149. This matches the Property values for the file which has the value for Size: 3.07 KB (3,149 bytes). So try using Byte values instead of KB values. Keep in mind that if NULL is stored there NULL is not < (or equal) to anything.

By the way, on my computer, I ran into a problem when displaying a Find result that has more items than rows to display in a Grid (causing the < number - number > at the bottom of the page). For now, to get around that, you can use Preferences to set Rows to display in Grid to more than 5000 (I have mine set to 100000).

After about 1 hour , the Pictures files list rebuild completed. After that an Advanced Find using: I.[QtyInStock] >= 1 AND I.[PictureHeight] IS NULL Seems to have found Items I own that do not have a picture.

What version of CB are you using? A new version (v3599) was just posted today. Until this version, using File Tools->Rebuild lists and checking the box regarding pictures actually didn't work. This have been fixed with the newest version. I have downloaded / installed this and am currently running the process which will take a LONG time. How long depends on where you pictures are located and how many you have. I have mine on an M2 drive which should run faster than if on a Solid State Drive which should be faster than on a regular hard drive. Once this has completed, the various Picture columns 'should' be updated and then your Finds should work (at least I hope so...).

Mine does the same thing but doesn't take near as long. About 10 seconds. My database is on a M2 drive, however.

I believe HC doesn't have a problem with installing CB on two computer (home and laptop) but they will have to let you know that (I think the question has come up before). As for the app, I don't think it allows you to access you home computer database directly. You have to save a copy (or a report?) to the cloud and then the app reads that, I think. Never having done this, I will let other explain in more detail and how to do this.

Rename 1-HC.jpg to HC 1.jpg From: Pictures\D\Dynamite\Art of Dejah Thoris and The Worlds of Mars, The Rename 1.jpg to TPB.jpg From: Pictures\I\Idea + Design Works\Art of John Byrne's Next Men, The Rename 1.jpg to TPB.jpg From: Pictures\D\Dark Horse\B\Bettie Page- Queen of Hearts Delete or Move 1.jpg From: Pictures\W\Whitman\Big Little Book To: Pictures\W\Whitman\Tailspin Tommy (Whitman) Rename TPB.jpg to TPB 1.jpg & TPB-A.jpg to TPB 1-A.jpg From: Pictures\B\Ballantine\Shadow, The (Ballantine) Rename 2.jpg to 2-A.jpg From: Pictures\V\Vault\Finger Guns

I guess we will have to agree to disagree. To me, Cost is what I Paid for an Issue. I don't own it, then the Cost is 0.00. If I ever change Qty to 1 or more then Cost would be some value. If you handle cost differently, then that is your choice. I will just have to set discount to Zero to get the Cost to act the way I expect.

CB currently has Title "World's Finest: The Guardians of Earth". The actual Title (on cover and indicia) is "World's Finest: Guardians of Earth".