OpenEdge DataProvider Bug in LL26

English Forum
1

Unfortunatelly I introduced a bug on the LL26 OpenEdge side of the data provider that prevents tables from beeing registered properly. In ListLabel.OpenEdgeAdapter.OpenEdgeSchema there is method “LLSampleValue” that returns a sample value for each data-type for the LL designer.
I was returning “123.45” for DECIMAL. That means trouble depending on your OS setting for the decimal point. We will fix this in the next service packs. For now please use this code:

/------------------------------------------------------------------------------
Purpose: Sample Value for the LL Designer
Notes: Since LL24
20201118 Fix for decimal - without decimal point
------------------------------------------------------------------------------/
METHOD PUBLIC CHARACTER LLSampleValue( pcDataType AS CHARACTER ):

    DEFINE VARIABLE cSampleValue AS CHARACTER NO-UNDO.
    DEFINE VARIABLE dtDate       AS DATE NO-UNDO INIT TODAY.
    DEFINE VARIABLE dtDateTime   AS DATETIME NO-UNDO INIT NOW.
    DEFINE VARIABLE dtDateTimeTZ AS DATETIME-TZ NO-UNDO INIT NOW.

    CASE pcDataType:
        WHEN "INTEGER" OR WHEN "INT64" OR WHEN "DECIMAL" THEN 
            RETURN "123".
        WHEN "LOGICAL" THEN 
            RETURN "true".
        WHEN "CHARACTER" THEN 
            RETURN "Abc".
        WHEN "LONGCHAR" THEN
            RETURN "Abcdef".
        WHEN "DATE" THEN 
            RETURN ISO-DATE(dtDate).
        WHEN "DATETIME" THEN 
            RETURN ISO-DATE(dtDateTime).
        WHEN "DATETIME-TZ" THEN 
            RETURN ISO-DATE(dtDateTimeTZ).
    END.

    RETURN "".

END METHOD.