Subject Re: IBOPipeline & RAP/Variables
Author bztrw
OK, now I'm learning...This problem only occurs when selecting from a
stored proceudre that returns DATE fields; changing the return type
to TIMESTAMP and modifying the code below to DateTimeToStr solves the
problem. So, where does this leave me?

--- In IBObjects@y..., "bztrw" <Byrne.Zumwalt@t...> wrote:
> D6, RB 6.03
> Has anyone else encountered/solved the problem with RAP and Date
> Fields? I cannot get Date values to work with TppVariables and RAP;
> they work fine as TppDBText, but when I try to concatenate values
> RAP I get an On Calc error.
> For Example: Value := DateToStr(rptPipe['DATE_FIELD']) + ' thru ' +
> DateToStr(rptPipe['ANOTHER_DATE_FIELD']);
> The example above works fine if I switch back to a DBPipeline and
> TIBODataset decendant. In the Data explorer in RAP, the fields are
> showing as Date. Unfortunately, I have idea where to even begin
> looking: IBO, RAP, or IBOPipeline.
> Thanks in advance.
> Byrne Zumwalt
> Byrne.Zumwalt@t...