BROWSE with SQL Date Type Field

Moderator: Rathinagiri

Post Reply
melliott42
Posts: 119
Joined: Wed Feb 18, 2009 2:14 pm

BROWSE with SQL Date Type Field

Post by melliott42 » Tue Mar 15, 2016 5:49 pm

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
Posts: 119
Joined: Wed Feb 18, 2009 2:14 pm

Post by melliott42 » Tue Mar 15, 2016 6:06 pm

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)'}

Post Reply