How to concatenate image data in Postgres to use in fast report
Define your own aggregate to do binary concatenation and use it sql.
eg.
CREATE AGGREGATE bytea_add(bytea) ( sfunc = byteacat, stype = bytea, initcond = E'' );
select bytea_add(logoimage) from emplimage where recordid=:recordid
Related Articles
Unable to use regional language (Tamil/Kannada) in Fastreport and not showing output
Please try with below options Font used in Fast Report component should support TAMIL (Recommended : Arial Unicode MS / any other Tamil fonts) In AxFastLink Table , EFONT field value should be updated as 'T' for the report, which uses embedded fonts. ...Validate file attachments or image upload on save
There are two variables available to have the attached or image field values in comma separated string. Axp_AttachedFiles - is a variable that will contain the list of files (header attachments) attached as comma separated string. Axp_LoadedImages - ...Signature Capture Issue in Axpert Mobile v10.9
The issue is with the signature capture functionality in the latest version of Axpert Mobile (v10.9). There is no default feature to draw signatures on the input field. If it is referred to saving through an image field and using it on fast report, ...Postgres 14 version has an issue in establishing connection from Axpert
PostgresSQL 14 uses “scram-sha-256” method for authentication by default (as per pg_hba.conf file), which is causing the connectivity issues in Axpert. Solution for the issue : The method “scram-sha-256” needs to be replaced as “trust” in pg_hba.conf ...Install PostgreSQL
Refer to the attached document for details on how to setup PostgresSQL.