Sonny Software

Hi Jon,

I have in my attachment folder 1201 pdf files of journals that I use in the Bookends database. Presumably, if all are attached to a reference in the database, the following SQL search that I have named "Refs with PDFs" should report "showing 1201 of 1201 references".

varCharField REGEX '[a-z]'

However, instead Bookends reports 1165 of 1171 references showing. When I scan this list by the attachment paperclip icon I find 9 references with no attachment indicated, yet these still appear in the list. By subtraction you would expect 6 references, however I find 9 without an attachment icon.

Similarly the opposite SQL search named "Refs without PDFs" shows 1415 of 1416 references.

NOT varCharField REGEX '[a-z]'

Apparently there are approximately 30 references that are not attached in my database but I don't know which ones. Also the discrepancy in the number of references reported by the searches is problematic.

Is there a better way to organize your attached files so that the numbers in the database correspond to what the finder reports? Going through over a thousand files is not practical and I would like to find an automated way to verify that the files are attached to the correct reference in the database.

Matt

Actually after clicking the search icon in the groups pane the number of refs was updated to "showing 1182 of 1171", the difference being 9 (see above) in the "Refs with PDFs" group.

However these 9 refs without an attachment still appear in the search. Why?

The "Refs without PDFs" group now shows 1418 of 1416. How can this be?

The group "All" shows 2591 of 2591.

Need your help.

Matt

In fact every time I click on the search group the number of references showing changes.

What is happening?

My first thought is that you should try rebuilding your database and see what happens. If there are still problems, you should contact me directly for tech support (this is not a forum issue).

Jon
Sonny Software