Re: TEXT data type in postgresql

--===============5171314809119579583==
Content-Type: multipart/alternative; boundary="0000000000001aecac0643797bd5"

--0000000000001aecac0643797bd5
Content-Type: text/plain; charset="UTF-8"

Dont you need to LOCATE blobs before you can use them ?

On Thu, 13 Nov 2025 at 01:06, Iwan AB <[email protected]> wrote:

> Dear Mike, please consider the following table in postgresql
>
> table t_text (
>   old_data text,
>   new_data text
> )
>
> compiling this following program (p_text.4gl):
>
> DATABASE testdb
> MAIN
>     DEFINE  wt_text RECORD LIKE t_text.*
>
>     LET wt_text.old_data = 'A';
>     LET wt_text.new_data = 'B';
>
>     DISPLAY wt_text.old_data, " => ", wt_text.new_data
>
> END MAIN
>
> returns:
>
> Err:Program p_text.4ge stopped at 'p_text.4gl', line number 6.
> Error status number -30414.
> Unable to create blobfile.
>
> 4gl function call stack :
>     MAIN
>
> how to overcome this?
>
> Is it possible to convert TEXT data type in postgresql into STRING instead
> of BLOB?
>
> Thanks,
>
> Iwan
> _______________________________________________
> Aubit4gl-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>

--0000000000001aecac0643797bd5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Dont you need to LOCATE blobs before you can use them ?</d=
iv><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" cl=
ass=3D"gmail_attr">On Thu, 13 Nov 2025 at 01:06, Iwan AB &lt;<a href=3D"mai=
lto:[email protected]">[email protected]</a>&gt; wrote:<br></div><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Dear Mike, please co=
nsider the following table in postgresql<br>=C2=A0<br>table t_text (<br>=C2=
=A0 old_data text,<br>=C2=A0 new_data text<br>)<br><br>compiling this follo=
wing program (p_text.4gl):<br><br>DATABASE testdb<br>MAIN<br>=C2=A0 =C2=A0 =
DEFINE =C2=A0wt_text RECORD LIKE t_text.*<br><br>=C2=A0 =C2=A0 LET wt_text.=
old_data =3D &#39;A&#39;;<br>=C2=A0 =C2=A0 LET wt_text.new_data =3D &#39;B&=
#39;;<br><br>=C2=A0 =C2=A0 DISPLAY wt_text.old_data, &quot; =3D&gt; &quot;,=
 wt_text.new_data<br><br>END MAIN<br><br>returns:<br><br>Err:Program p_text=
.4ge stopped at &#39;p_text.4gl&#39;, line number 6.<br>Error status number=
 -30414.<br>Unable to create blobfile.<br><br>4gl function call stack :<br>=
=C2=A0 =C2=A0 MAIN<br>=C2=A0 =C2=A0 <br>how to overcome this? =C2=A0 =C2=A0=
<br><br>Is it possible to convert TEXT data type in postgresql into STRING =
instead of BLOB?<br><br>Thanks,<br><br>Iwan</div>
_______________________________________________<br>
Aubit4gl-discuss mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank"=
>[email protected]</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss" r=
el=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/lis=
tinfo/aubit4gl-discuss</a><br>
</blockquote></div>

--0000000000001aecac0643797bd5--


--===============5171314809119579583==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============5171314809119579583==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss

--===============5171314809119579583==--