Steven L. Dasinger

Fate/Grand Order-Mortalis:stella (with no space) is correct.

I got a reply from the support team that my email (sent through Gmail) was received.

Steve is fine. This may be a 'feature' of the database program (SQLite) handling the result set in the background and not a specific programming process 'filtering' out the changed row when it no longer qualifies for the Where clause. I am leaning towards filtering because if the Find was run again, it should( ? ) update the row count.

I just sent an email to support. I will let you know if it bounces back to me.

It appears you have some duplicate entries in your database. If you have Advanced Find in your Edition of CB, you can paste this: I.Title || I.ItemNumber IN ( (SELECT A.Title || A.ItemNumber FROM ComicIssues A WHERE I.Title = A.Title and I.ItemNumber = A.ItemNumber GROUP BY A.Title, A.ItemNumber HAVING COUNT(*) > 1 ) ) in the Where box and it will find any issues that have the same Title/IssueNumber. (if needed it can be modified to add Condition if you have duplicate issues with different Conditions.)

In my database and on Atomic Avenue "Doom's IV" #0.5 is only there once.

You can find them in 'Justice League of America' as Bk 1/HC and Bk 2/HC (along with BK 3/HC).

Actually, it either runs the Find again or at it filters out rows that were changed so they no longer qualify for the Where clause. Ran Advanced Find with I.Storylines LIKE "%'%" Search Results 97 Rows, Actual rows in Grid is 97. Double-clicked on a row to bring up the edit window. Changed the straight 'tick' to the curved 'apostrophe' and saved. After the 'wheels stop spinning', Search Results 97 Rows, Actual rows in Grid is 96. Either it ran the Find again or it Filtered out the changed row since it no longer qualified without the 'tick' mark. Note: If you edit in the Grid instead of the Edit window, the row is not filtered out.

I believe what you are experiencing is a side effect of Psychic Typing where it tries to figure out what you are doing. I will let Pete address whether this is fixable or not. Until then, to get around these problems, you can paste (CTRL+V) the values you want to add or select/high-light what you want to replace before pasting in the correction.

Delete or Rename HC.jpg to 1-HC.jpg From: Pictures\H\Hallmark\Wit and Wisdom of Snoopy, The Delete or Move ALL (1.jpg - 17.jpg) From: Pictures\G\Go!Comi\07-Ghost To: Pictures\G\Go! Comi\07-Ghost Delete or Move ALL (1.jpg - 10.jpg) From: Pictures\G\Go!Comi\After School Nightmare To: Pictures\G\Go! Comi\After School Nightmare Delete or Move 1.jpg From: Pictures\G\Go!\A.I. Revolution To: Pictures\G\Go! Comi\A.I. Revolution Delete or Move 1.jpg From: Pictures\G\Go!Comi\Angel's Coffin To: Pictures\G\Go! Comi\Angel's Coffin Delete or Move 1.jpg and 1-HC.jpg From: Pictures\G\Graphix\Animorphs To: Pictures\S\Scholastic\Animorphs Delete or Move ALL (1.jpg - 1-B.jpg) From: Pictures\H\Hack Shack Studios\Black and White (Hack Shack) To: Pictures\H\Hack Shack\Black and White (Hack Shack) Delete or Move ALL (1.jpg - Bk 1-HC.jpg) From: Pictures\G\Green Man Press\Book of Ballads and Sagas, The To: Pictures\G\Green Man\Book of Ballads and Sagas, The Delete or Move ALL (1.jpg - 3.jpg) From: Pictures\G\Graphitti Designs\Southland Tales To: Pictures\G\Graphitti\Southland Tales Delete or Move 3.jpg and 5.jpg From: Pictures\G\Graphic Information Services\Teen Timers To: Pictures\G\Graphic Information Service\Teen Timers Delete or Move 1.jpg From: Pictures\G\Graphic Universe\Accursed Inheritance of Henrietta Achilles, The To: Pictures\G\Graphic Universe\House Divided, A (Graphic Universe) Delete or Move ALL (1.jpg - 4.jpg) From: Pictures\G\Graphix\Baby Sitters Club, The (Ann M. Martin's-) To: Pictures\G\Graphix\Baby-Sitters Club, The (Ann M. Martin's-) Delete or Move ALL (2.jpg - 4-HC.jpg) From: Pictures\G\Graphix\Baby Sitters Little Sister To: Pictures\G\Graphix\Baby-Sitters Little Sister Delete or Move ALL (0.jpg - 40.jpg) From: Pictures\P\Panini\Cavalier dello Zodiaco-Episode G, I To: Pictures\P\Panini\Cavalieri dello Zodiaco-Episode G, I Delete or Move 318.jpg From: Pictures\C\Cape Magazine Company\Combat Picture Library (Cape Magazine Company) To: Pictures\C\Cape\Combat Picture Library (Cape) Delete of Move ALL (1.jpg - 3.jpg) From: Pictures\G\Greater Mercury\Daemmon's Blood To: Pictures\G\Greater Mercury\Daemon's Blood Delete or Move 1-LE.jpg From: Pictures\G\Graphitti Designs\Daredevil Visionaries To: Pictures\M\Marvel\D\Daredevil Visionaries- Kevin Smith Delete or Move 1.jpg From: Pictures\G\Gold Key\McClintock To: Pictures\G\Gold Key\McLintock Delete or Move Ash 1.jpg From: Pictures\S\Source Point\Night Walkers To: Pictures\S\Source Point\Nightwalkers Delete or Move Bk 1/HC.jpg From: Pictures\I\IDW\Reid Flemming World's Toughest Milkman To: Pictures\I\Idea + Design Works\Reid Fleming World's Toughest Milkman (IDW) Delete or Move ALL (3482.jpg - 3596.jpg) From: Pictures\H\H Bauer Publishing\Angling Times To: Pictures\H\H Bauer\Angling Times Delete or Rename TPB 1.jpg to TPB From: Pictures\H\HarperCollins\Wayne of Gotham Delete or Move 11.jpg From: Pictures\H\Harvey\Casper and the Ghostly Trio To: Pictures\H\Harvey\Casper And- Delete or Rename 27.jpg to 1.jpg then Move From: Pictures\E\Eureka\Graphic Classics To: Pictures\B\Barron's\David Copperfield (Barron's) Delete or Rename 35-2.jpg to 35-A-2.jpg, 36-2.jpg to 36-A-2.jpg and 38-2.jpg to 38-A-2.jpg From: Pictures\G\Gold Key\Magnus, Robot Fighter (Gold Key) Delete or Rename 1-C.jpg to 1-D.jpg From: Pictures\I\Idea + Design Works\Star Pig Delete or Move 1981.jpg and 1997.jpg From: Pictures\F\Federal Reserve Bank of New York\Story of Checks, The To: Pictures\F\Federal Reserve Bank of New York\Story of Checks and Electronic Payments, The Delete or Move ALL (568.jpg - 695.jpg) From: Pictures\H\H Bauer Publishing Ltd\Classic Cars (UK) To: Pictures\H\H Bauer\Classic Cars (UK) Delete or Move ALL (1.jpg - 17.jpg) From: Pictures\G\Go!Comi\07-Ghost To: Pictures\G\Go! Comi\07-Ghost Delete or Move ALL (1.jpg - 10.jpg) From: Pictures\G\Go!Comi\After School Nightmare To: Pictures\G\Go! Comi\After School Nightmare Delete or Move 1.jpg From: Pictures\G\Go!\A.I. Revolution To: Pictures\G\Go! Comi\A.I. Revolution Delete or Move 1.jpg From: Pictures\G\Go!Comi\Angel's Coffin To: Pictures\G\Go! Comi\Angel's Coffin Delete or Move ALL (1.jpg - 7.jpg) From: Pictures\G\Go!Comi\Black Sun Silver Moon To: Pictures\G\Go! Comi\Black Sun Silver Moon Delete or Move 1.jpg and 2.jpg From: Pictures\G\Go!Comi\Bogle To: Pictures\G\Go! Comi\Bogle Delete or Move ALL (1.jpg - 4.jpg) From: Pictures\G\Go!Comi\Bound Beauty To: Pictures\G\Go! Comi\Bound Beauty Delete or Move 1.jpg From: Pictures\G\Go!Comi\Bran Doll To: Pictures\G\Go! Comi\Bran Doll Delete or Move ALL (1.jpg - 10.jpg) From: Pictures\G\Go!Comi\Cantarella To: Pictures\G\Go! Comi\Cantarella Delete or Move ALL (1.jpg - 3.jpg) From: Pictures\G\Go!Comi\Cross X Break To: Pictures\G\Go! Comi\Cross X Break Delete or Move ALL (1.jpg - 7.jpg) From: Pictures\G\Go!Comi\Crossroad To: Pictures\G\Go! Comi\Crossroad Delete or Move 1.jpg and 2.jpg From: Pictures\G\Go!Comi\Crown To: Pictures\G\Go! Comi\Crown Delete or Move 1.jpg From: Pictures\G\Go!Comi\Days of Cool Idols To: Pictures\G\Go! Comi\Days of Cool Idols Delete or Move 1.jpg From: Pictures\G\Go!Comi\Get the Moon To: Pictures\G\Go! Comi\Get the Moon Delete or Move ALL (1.jpg - 11.jpg) From: Pictures\G\Go!Comi\Her Majesty's Dog To: Pictures\G\Go! Comi\Her Majesty's Dog Delete or Move ALL (1.jpg - 3.jpg) From: Pictures\G\Go!Comi\Kanna To: Pictures\G\Go! Comi\Kanna Delete or Move 1.jpg From: Pictures\G\Go!Comi\King of The Lamp To: Pictures\G\Go! Comi\King of The Lamp Delte or Move ALL (1.jpg - 5.jpg) From: Pictures\G\Go!Comi\Night of the Beasts To: Pictures\G\Go! Comi\Night of the Beasts Delete or Move ALL (1.jpg - 3.jpg From: Pictures\G\Go!Comi\Song of the Hanging Sky To: Pictures\G\Go! Comi\Song of the Hanging Sky Delete or Move ALL (1.jpg - 7.jpg) From: Pictures\G\Go!Comi\Tenshi Ja Nai!! To: Pictures\G\Go! Comi\Tenshi Ja Nai!! Delete or Move 1.jpg and 2.jpg From: Pictures\G\Go!Comi\Three in Love To: Pictures\G\Go! Comi\Three in Love Delete or Move ALL (1.jpg - 6.jpg) From: Pictures\G\Go!Comi\Train Plus Train To: Pictures\G\Go! Comi\Train Plus Train Delete or Move ALL (1.jpg - 5.jpg) From: Pictures\G\Go!Comi\Ultimate Venus To: Pictures\G\Go! Comi\Ultimate Venus Delete or Move 1.jpg - 2.jpg From: Pictures\G\Go!Comi\Yggdrasil To: Pictures\G\Go! Comi\Yggdrasil Delete or Move 2.jpg From: Pictures\G\Go!\Devil Within, The To: Pictures\G\Go! Comi\Devil Within, The (Go! Comi) Delete or Rename 1.jpg to LL.jpg From: Pictures\G\Green Man\Fall Of Stardust, A

Created New Database. Set Optimize on exit to >10% Optimized it. Closed CB Optimize did NOT run (correct) Opened CB Ran Weekly Update. (which increased size from .9 MB to 3.4 MB Closed CB Optimize DID run (correct)

With the Optimize on exit set to >10%, I am able to exit CB without Optimize running.

Try 'CS 1' Here are some examples: 'Harvey Horrors Collected Works: Chamber of Chills' CS 1 'Slipcover with 5 volumes. Collects #1-26' 'Doubt (Ki-oon)' CS 1 'The complete 4 volumes' 'Firefly (Boom!)' CS 1 'Includes all 8 regular covers #1, 1A thru 1E, 1G, 1H, the Box Set exclusive variant 1I, graphic novel Firefly Legacy Edition Book One and an exclusive art print by Dylan Todd' CS (Collector's Set) is sort of a 'catch-all' when multiple items are included in a single 'issue'.

Ah, I thought you were referring to Rebuild Lists (which repopulates instead of rebuilding the indexes) since this 'hidden' process isn't widely known.

Not sure if this will help, but it can't hurt... Close CB. Press and Hold CTRL while Opening CB. You will get a dialog box asking 'Recreate the database indexes?...' Click YES.