Reports Issue with Apostrophe in Full Name

[kent]

I have discovered that if you attempt to create a Recipient List Report and check the "Full Names" checkbox and have users with an apostrophe (such as O'Dell) then you will get an error and the PG Admin will crash. The error is "Excessive database errors: 3075 Syntax Error (missing operator) in query expression '(full_name = 'O'DELL,XXXX')'. in Procedure:frmPrintPreviewRecipientListReport Program Halted. The report TXT file gets created up to the first person with an apostrophe.

It does it when printing to a file and I'm not sure if it does it when actually printing to a printer.

I have PageGate 7.0.23 (the latest) and it also did it on my previous version, 7.0.5.

[Tech Support]

Thank you for bringing this to our attention. We've resolved the issue and have an update you'll want to apply:

1) Close the PG Admin.

2) Download the updated executable here: http://www.notepage.net/download/dev/pgadmin.exe

3) Copy and paste the file you downloaded in step 2 in to the PageGate program directory.

3a) Say yes, you do want to overwrite the file.

This patch will packaged as part of our installer for future installations.

_________________
Tech Support
support@notepage.com
http://www.notepage.net

[kent]

Thanks so much for the quick fix! That did correct the issue.