[Libreoffice-bugs] [Bug 124530] PostgreSQL Native Driver: Images aren't shown in form when content of field is created in query

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124530

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |WORKSFORME
             Status|NEW                         |RESOLVED

--- Comment #7 from Robert Großkopf <robert at familiegrosskopf.de> ---
Problem seems to be PostgreSQL doesn't set the datatype the right way.
If I change the query to
4. Create a query like
SELECT "ID", "PathName", "PicName", CONCAT( '/home/yourname/', "PicName" ) AS
"PicPathName" FROM "public"."PG_LOconn"

tO

SELECT "ID", "PathName", "PicName", CAST(CONCAT( '/home/yourname/', "PicName" )
AS VARCHAR(100)) AS "PicPathName" FROM "public"."PG_LOconn"

it will work.

So I will close this bug as WORKSFORME.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200209/6b0f70fe/attachment.htm>