Re: Datatype boolean Informix DB

Not sure that integer is correct.
Informix 4GL returns 't', 'f'.
You also can use 't' or 'f' to select boolean if you use the <7.50 4GL 
against the newer engines with the boolean datatype. So far no issues if 
i use a CHAR(1) for bool collumns.

Are the 43 = LVCARCHAR, 52 = INT8, 53 = BIGSERIAL are working ?

Maybe you can find some input in the "Foreign Data Wrapper for Informix" 
for postgres ?
https://github.com/credativ/informix_fdw


> Looks like type ID 45 hasnt been implemented yet.
> 
> I can probably "fake" it easily enough by massaging a bool to be an 
> integer in the code ?
> (would allow 4gl code to assign any integer value to it)
> 
> Is that sufficient?
> 
> On Mon, 21 Dec 2020 at 13:12, Elier Tiapa <[email protected] 
> <mailto:[email protected]>> wrote:
> 
>     The error is :"| Unsupported type id ()"
> 
>     On Mon, Dec 14, 2020 at 11:00 PM Elier Tiapa <[email protected]
>     <mailto:[email protected]>> wrote:
> 
>         Best regards,
> 
>         I am getting a compile error because a definition of a variable
>         like a column from a database table with the type "boolean".
>         The A4GL_SQLTYPE is setted to esql.
>         There are other datatypes like lvarchar and nvarchar that don't
>         look right in the table info view using adbaccess, but look ok
>         using dbaccess.
> 
>         Thank you very much
> 
>         Elier
> 
> 
> 
>     -- 
>     Elier Tiapa
>     Consultor asociado
>     Consultores INNOSOFT 365 C.A.
>     _______________________________________________
>     Aubit4gl-discuss mailing list
>     [email protected]
>     <mailto:[email protected]>
>     https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>     <https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss>
> 
> 
> 
> _______________________________________________
> Aubit4gl-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
> 


SACO Software and Consulting GmbH, Mühlgasse 5, D-97840 Hafenlohr
Tel.: ++49 9391 90890-0, Fax: ++49 9391 90890-99, E-Mail: [email protected]
Amtsgericht Würzburg HRB 5410, Geschäftsführer: Peter Schubert, Dipl.-Wirt.ing.(FH) Thorsten Beck



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