Re: Datatype boolean Informix DB

I can - but if you assign TRUE or FALSE to it - i dont think it would work
?
Are you assigning string literals in the 4gl code ?


On Mon, 21 Dec 2020 at 13:46, Elier Tiapa <[email protected]> wrote:

> 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
>

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