View RSS Feed

Development Team Blog

  1. ESQL: Dealing with Values Retrieved from Nullable Columns

    When a column contains a NULL value, its content is undefined. if you are using Visual DataFlex commands/methods, the Connectivity Kit has ways (e.g. DF_FIELD_IS_NULL) to deal with return values and take care of NULL values for you.

    Now, if you are using Embedded SQL (
    ESQL), you have direct access to what is stored in the SQL backend and will need to take care of NULL values yourself, otherwise you might see gibberish when the value returned is NULL -- and NULLs can be anything! In ...

    Updated 13-Apr-2022 at 10:02 AM by Marcia Booth