Re: Datatype boolean Informix DB

Elier Tiapa <[email protected]> Mon, 21 Dec 2020 09:45:39 -0400
Newsgroups gmane.comp.lang.4gl.aubit.general
Message-ID <CAG8=PRMLcTp9KFqfiOF4Ovv5bktOL0Hr94ER8oGtVp-zh8gwyA@mail.gmail.com>
The version of the Informix DB is 14.10.FC1DE and the values for the
booleans columns are "f" and "t" (weird, should be 0 and 1 but there are
"'f" and "t"), so, it should be treated as char(1), is that possible?
Thanks a lot.

On Mon, Dec 21, 2020 at 9:32 AM Mike Aubury <[email protected]> wrote:

> 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]> wrote:
>
>> The error is :"| Unsupported type id ()"
>>
>> On Mon, Dec 14, 2020 at 11:00 PM Elier Tiapa <[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]
>> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>>
>

-- 
Elier Tiapa
Consultor asociado
Consultores INNOSOFT 365 C.A.

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