Progress.Data.BindingSource: Clob field containing special c

Posted by Fabian Frank on 21-Feb-2014 10:57

I realized it by binding a TempTable via BindingSource to an UltraGrid, but as the code below confirms it's

not related to UI. Codepage used is 1252, tested with oe 11.1 and 11.3.2.

DEF TEMP-TABLE tTest NO-UNDO
    FIELD fString AS CHAR
    FIELD fClob   AS CLOB.

DEFINE VARIABLE v-longchar AS LONGCHAR NO-UNDO.
        
v-longchar = "Über".
        
CREATE tTest.
tTest.fString = "Über".
COPY-LOB v-longchar TO tTest.fClob.
        
DEFINE VARIABLE v-bindingSource AS Progress.Data.BindingSource NO-UNDO.
        
v-bindingSource = NEW Progress.Data.BindingSource(BUFFER tTest:HANDLE).
        
DEFINE VARIABLE v-descriptorCollection AS System.ComponentModel.PropertyDescriptorCollection NO-UNDO.
        
v-descriptorCollection = v-bindingSource:GetItemProperties(?).
        
DEFINE VARIABLE v-descriptor1 AS System.ComponentModel.PropertyDescriptor NO-UNDO.
DEFINE VARIABLE v-descriptor2 AS System.ComponentModel.PropertyDescriptor NO-UNDO.
        
v-descriptor1 = CAST(v-descriptorCollection[0], System.ComponentModel.PropertyDescriptor).
v-descriptor2 = CAST(v-descriptorCollection[1], System.ComponentModel.PropertyDescriptor).
        
MESSAGE
    v-descriptor1:GetValue(v-bindingSource:List[0]) SKIP
    v-descriptor2:GetValue(v-bindingSource:List[0]) SKIP
    VIEW-AS ALERT-BOX.


OpenEdge Development - Forum

All Replies

Posted by Mike Fechner on 21-Feb-2014 13:07

Same result with utf-8
 
[collapse]
From: Fabian Frank [mailto:bounce-fabianffrank@community.progress.com]
Sent: Freitag, 21. Februar 2014 17:58
To: TU.OE.Development@community.progress.com
Subject: Progress.Data.BindingSource: Clob field containing special chars doesn't work
 
Thread created by Fabian Frank

I realized it by binding a TempTable via BindingSource to an UltraGrid, but as the code below confirms it's

not related to UI. Codepage used is 1252, tested with oe 11.1 and 11.3.2.

DEF TEMP-TABLE tTest NO-UNDO
    FIELD fString AS CHAR
    FIELD fClob   AS CLOB.
 
DEFINE VARIABLE v-longchar AS LONGCHAR NO-UNDO.
        
v-longchar = "Über".
        
CREATE tTest.
tTest.fString = "Über".
COPY-LOB v-longchar TO tTest.fClob.
        
DEFINE VARIABLE v-bindingSource AS Progress.Data.BindingSource NO-UNDO.
        
v-bindingSource = NEW Progress.Data.BindingSource(BUFFER tTest:HANDLE).
        
DEFINE VARIABLE v-descriptorCollection AS System.ComponentModel.PropertyDescriptorCollection NO-UNDO.
        
v-descriptorCollection = v-bindingSource:GetItemProperties(?).
        
DEFINE VARIABLE v-descriptor1 AS System.ComponentModel.PropertyDescriptor NO-UNDO.
DEFINE VARIABLE v-descriptor2 AS System.ComponentModel.PropertyDescriptor NO-UNDO.
        
v-descriptor1 = CAST(v-descriptorCollection[0], System.ComponentModel.PropertyDescriptor).
v-descriptor2 = CAST(v-descriptorCollection[1], System.ComponentModel.PropertyDescriptor).
        
MESSAGE
    v-descriptor1:GetValue(v-bindingSource:List[0]) SKIP
    v-descriptor2:GetValue(v-bindingSource:List[0]) SKIP
    VIEW-AS ALERT-BOX.

 

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by Garry Hall on 21-Feb-2014 13:17

Please contact Tech Support and log a bug. At a guess, I’d say we are missing a conversion from UTF-8 somewhere.
 
[collapse]
From: Mike Fechner [mailto:bounce-mikefechner@community.progress.com]
Sent: Friday, February 21, 2014 2:08 PM
To: TU.OE.Development@community.progress.com
Subject: RE: Progress.Data.BindingSource: Clob field containing special chars doesn't work
 
Reply by Mike Fechner
Same result with utf-8
 
[collapse]
From: Fabian Frank [mailto:bounce-fabianffrank@community.progress.com]
Sent: Freitag, 21. Februar 2014 17:58
To: TU.OE.Development@community.progress.com
Subject: Progress.Data.BindingSource: Clob field containing special chars doesn't work
 
Thread created by Fabian Frank

I realized it by binding a TempTable via BindingSource to an UltraGrid, but as the code below confirms it's

not related to UI. Codepage used is 1252, tested with oe 11.1 and 11.3.2.

DEF TEMP-TABLE tTest NO-UNDO
    FIELD fString AS CHAR
    FIELD fClob   AS CLOB.
 
DEFINE VARIABLE v-longchar AS LONGCHAR NO-UNDO.
        
v-longchar = "Über".
        
CREATE tTest.
tTest.fString = "Über".
COPY-LOB v-longchar TO tTest.fClob.
        
DEFINE VARIABLE v-bindingSource AS Progress.Data.BindingSource NO-UNDO.
        
v-bindingSource = NEW Progress.Data.BindingSource(BUFFER tTest:HANDLE).
        
DEFINE VARIABLE v-descriptorCollection AS System.ComponentModel.PropertyDescriptorCollection NO-UNDO.
        
v-descriptorCollection = v-bindingSource:GetItemProperties(?).
        
DEFINE VARIABLE v-descriptor1 AS System.ComponentModel.PropertyDescriptor NO-UNDO.
DEFINE VARIABLE v-descriptor2 AS System.ComponentModel.PropertyDescriptor NO-UNDO.
        
v-descriptor1 = CAST(v-descriptorCollection[0], System.ComponentModel.PropertyDescriptor).
v-descriptor2 = CAST(v-descriptorCollection[1], System.ComponentModel.PropertyDescriptor).
        
MESSAGE
    v-descriptor1:GetValue(v-bindingSource:List[0]) SKIP
    v-descriptor2:GetValue(v-bindingSource:List[0]) SKIP
    VIEW-AS ALERT-BOX.

 

Stop receiving emails on this subject.

Flag this post as spam/abuse.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse][/collapse]

Posted by Jean Richert on 21-Feb-2014 13:51

To open a case from a thread, have a look at

community.progress.com/.../34480.aspx

Posted by Fabian Frank on 26-Feb-2014 11:10

[mention:f822c6bf04534292b3fe04704ddd8dd6:e9ed411860ed4f2ba0265705b8793d05]: Unfortunately I dont have the SupportLink option because this is my personal account, not the esd account from my employer. To which email address should I send it?

This thread is closed