[PostgreSQL] String concatenation result is memo

[Thomas J.]

Hello support,

SELECT *, c_name || ', ' || c_vorname AS Name FROM t_user

c_name and c_vorname is type STRING and result is with TUniQuery MEMO.

Thanks for your help
Thomas

[Plash]

PostgreSQL server returns VARCHAR field with undefined length in such case. TStringField requires setting its Size property. So we don't use TStringField, and use TMemoField.

You can set the UnknownAsString option in SpecificOptions to True. In this case UniDAC creates TStringField with fixed size 8192 for such fields.

[Thomas J.]

Sorry but also this is not working.
I set the parameter to true and open the dataset. But in your data editor is for all rows (MEMO) and no sting.
Also at runtime the same problem.

Thanks for your help
Thomas

[Plash]

PostgreSQL returns fields of type TEXT for your query which is always mapped on TMemoField.

You should change your query like the following:

Code: Select all

SELECT *, (c_name || ', ' || c_vorname)::varchar(100) AS Name FROM t_user