BROWSE with SQL Date Type Field

[melliott42]

Hello,

I am trying to get the most out of the IDE. I have the BROWSE control working well with Oracle on numeric and character (varchar2) field types. When I try to use the BROWSE control with a date field I get the error indicated below.

I am basically using the IDE\Browse as detailed in the docs. Giving values to the indicated properties (FIELDS,HEADERS,WORKAREA) and initializing the WorkArea as indicated via calling the corresponding PROCEDURE.

The moment I change a FIELDS property to that of a DATE type field I get the error.

OK = FIELDS: {'Test->ID','Test->Name'}
Error = FIELDS: {'Test->ID','Test->MyDateFld'}

ERROR

Code: Select all

BROWSE "BASE/1100 Argument error: TRIM"

What can you recommend?


Thanks,

Michael

[melliott42]

Got it! I wrapped a DTOC() around it. I did not know you could to that to an array element in this instance!

Working Example:
FIELDS: {'Test->ID','DTOC(Test->MyDateFld)'}