Problem with Formats on computed fields of type string

As reported on https://www.appeon.com/standardsupport/search/view?id=5268 Two problems:
1). Doing GetItemString() or using dot notation on String fields include the format attribute as if it was part of the value .
2). GetItemString() and dot notation might return different values if the column is a computed field. PB2021 Download

Tip on readonly variables when array

Never pass arrays as 'readOnly' (especially when passing them to .Net). Only use 'by value' and 'by reference'. (https://www.appeon.com/standardsupport/search/view?id=7597 )

Error message Invalid character value for cast specification

On Oracle from .Net. This one cost me time to figure out: https://community.appeon.com/index.php/qna/q-a/invalid-character-value-for-cast-specification-error

Scanning tool for Log4J vulnerabilities

https://github.com/mergebase/log4j-detector Log4J 1.x vulnerabilities: https://access.redhat.com/security/cve/CVE-2021-4104 Log4J 2.x vulnerabilities: https://nakedsecurity.sophos.com/2021/12/13/log4shell-explained-how-it-works-why-you-need-to-know-and-how-to-fix-it/

Cursor issue on pb2019R3 and later

https://www.appeon.com/standardsupport/search/view?id=7758 You have to set the cursor in an "expression", as the workaround.

Menu images aren't showing correctly, pb2019R3 and later

Happens when the images are in PBR file. You have to deploy the images themselves to the folder of the EXE, as the workaround.

Incorrect SQL generation when using Datawindow in Graphics mode pb20.. and later (13/01/22)

Please see: https://www.appeon.com/standardsupport/search/view?id=7728 Best avoid graphics sql mode anyway.