Hi all,
OE11.2, any OS.
I know it is possible to define a static temp-table with a character field that is set to be CASE-SENSITIVE, but I do not see an option to create a field on a dynamic temp-table with a case sensitive character field. There is an attribute on the buffer field object, but that is read-only (which makes sense), but how would I be able to mark my field as case sensitive before I prepare my temp-table?
TIA
It seems that it cannot be done directly, but here is a workaround, although it fattens up the r-code with a dead temp-table...:
DEFINE VARIABLE hT AS HANDLE NO-UNDO.
DEFINE TEMP-TABLE ttTemplate NO-UNDO
FIELD caseSensitive AS CHARACTER CASE-SENSITIVE
FIELD notCaseSensitive AS CHARACTER NOT CASE-SENSITIVE
.
CREATE TEMP-TABLE hT.
hT:ADD-LIKE-FIELD ("myCSString","ttTemplate.caseSensitive").
hT:ADD-LIKE-FIELD ("myCIString",BUFFER ttTemplate:BUFFER-FIELD ("notCaseSensitive")).
hT:TEMP-TABLE-PREPARE("myTable").
MESSAGE
hT:DEFAULT-BUFFER-HANDLE:BUFFER-FIELD ("myCSString"):CASE-SENSITIVE SKIP
hT:DEFAULT-BUFFER-HANDLE:BUFFER-FIELD ("myCIString"):CASE-SENSITIVE
VIEW-AS ALERT-BOX.