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