|Subject:||Re: Postgresql text columns in memory TC
|Date:||Fri, 21 Aug 2020 11:44:12 +1000
|From:||Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
I think you'll need to change the data type of the output field.
Whenever I extract data I do it through a function, using a record type
as the return type. With Paradox I redefined text as varchars in the
output and I didn't have any problems.
Although I used to use in memory tcursors only for reference type
tables, not often for data.
On 21/08/2020 3:01 am, Mark Bannister wrote:
> If I use a Postgresql text column data type and I query the column with
> resulting in an in memory TC, if I try to reference the column I get the
> error: Invalid BLOB handle in record buffer.
> The work around is to not use an in memory TC but I would prefer in memory.
> I've tried assigning the column to a memo or string first but get the
> same results.
> memovar =MEMO(mytc."Groupname") << error
> stringvar = string(mytc."Groupname") << error
> Can anyone think of something else to try?
> Mark B