[Progress Communities] [Progress OpenEdge ABL] Forum Post: Adding a case sensitive field to a temp-table

[Lieven De Foor]

Hi, Am I correct to conclude that a temp-table (static or dynamic) can't have a case sensitive field unless you define it LIKE an existing case sensitive db field? You can't seem to do this: DEFINE TEMP-TABLE myTT NO-UNDO FIELD caseSensitive AS CHARACTER CASE-SENSITIVE. Using ttHandle:ADD-NEW-FIELD() you can't specify case sensitivity either. The only way I see it possible is using FIELD caseSensitive LIKE someCaseSensitiveDbField or ttHandle:ADD-LIKE-FIELD(), which is problematic if you don't have a suitable field, or no db connection at all... There is a CASE-SENSITIVE attribute on buffer field, but that is read only according to the documentation...

Continue reading...