Paradox Community

Items in pnews.paradox-client_server

Subject:Re: Postgresql text columns in memory TC
Date:Fri, 21 Aug 2020 11:44:12 +1000
From:Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Newsgroups:pnews.paradox-client_server
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
> 


Copyright © 2004 thedbcommunity.com