X
PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10 Aug 2023 08:32 AM by  Pierre Le Dantec
getField in dataminer
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages

Pierre Le Dantec



New Member


Posts:
New Member


--
10 Aug 2023 08:32 AM
    Hello,

    I am using dataminer in IDL to get the content of a table: res = OBJ_NEW('idlDbRecordset', database, SQL = sqlString). One of the field in my postgresql table is a jsonb structure. When I get the content of that field with 'Getfield', I have a corresponding string which work most of the time. In some table, that jsonb structure can be pretty long and it seems that the GetField function is truncating the string to 255 characters.
    Any idea on how to get the full string from the db even if it is more than 255 characters.

    Thanks

    Pierre
    You are not authorized to post a reply.