TMemDataSet doesn't support ftMemo field
lazarus / 16-Databases

----------------------------------------------------------------------
vladvons · 2013-10-19 13:32

PostgreSQL table has a TEXT field.
TSQLQuery reads some data from table.

Now i want to clone TSQLQuery into TMemDataSet
TMemDataSet.CopyFromDataset()
MDSError: field doesnt suport!

How to clone DataSet with ftMemo field into MemDataSet?

Or schould i use another field type in PostgreSQL to store text data?
For my purpose  ftString (2^32 bytes) is more than enough.

----------------------------------------------------------------------
LacaK · 2013-10-21 12:29

you can try cast TEXT to VARCHAR

----------------------------------------------------------------------
vladvons · 2013-10-21 13:58

thanks LacaK,
if you mean SQL casting, this doesnt suit for my DB engine conception
Code: [Select]SELECT 
  CAST (Description AS VARCHAR (10000)) AS DescriptionCasted
FROM
....