Re: Datatype boolean Informix DB

Thank you very much, that's a very good solution that will help us to
test both options... we will keep you posted about the tests, because of
the holidays, probably 2nd week of January. Regards

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

> I've committed code for
>
> if (A4GL_isyes(acl_getenv("A4GL_BOOLTOINT"))) {
>         if ((idtype&DTYPE_MASK)==45) {
>                 idtype=2;
>         }
> }
>
> if (A4GL_isyes(acl_getenv("A4GL_BOOLTOCHAR1"))) {
>         if ((idtype&DTYPE_MASK)==45) {
>                 idtype=0;
>                 if (idtype!=idtype) { idtype|=DTYPE_MASK; }
>                 isize=1;
>         }
> }
>
>
> to variables_new.c
>
> Basically - set  A4GL_BOOLTOCHAR1=Y in the environment or aubitrc to
> generate a char(1), use A4GL_BOOLTOINT=Y to generate an integer.
>
>
>
> On Mon, 21 Dec 2020 at 13:52, Mike Aubury <[email protected]> wrote:
>
>> 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
>>>
>>

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

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