I am NOT using persistent fields,
the IB field is defined as Numeric(9,2)
I am running Dialect 1.

I will work on a test sample program - will be tomorrow before I
get it to you.

I agree BCD is better, but I think I just need to get another
report component ...... :( I hate to change everything over.

Thanks
Michael L. Horne

> -----Original Message-----
> From:
> sentto-402930-3795-982170164-guardian=pobox.com@...
> [mailto:sentto-402930-3795-982170164-guardian=pobox.com@....
> com]On Behalf Of Jason Wharton
> Sent: Wednesday, February 14, 2001 11:59 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] BUG - IBO 3.6cf stops Masks in QuickReport fields
>
>
> I had no idea this would result. I need to look into this to see
> what I can
> do about it.
>
> In short what I was trying to accomplish is to make IBO favor
> using the BCD
> field instead of the float field if precise decimal places were
> desired. By
> doing this there wouldn't be any rounding anomalies from using a float to
> store the value in.
>
> However, where matters of presentation are concerned there are additional
> differences I didn't foresee.
>
> I did have one person who was having problem switching between using float
> and BCD fields so I thought I would make it so they were essentially
> interchangeable.
>
> Can you show me how the mask stuff works in a little sample app? (I don't
> use QR)
>
> Thanks,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Michael L. Horne" <guardian@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Tuesday, February 13, 2001 10:36 AM
> Subject: [IBO] BUG - IBO 3.6cf stops Masks in QuickReport fields
>
>
> > Hello
> >
> > IB WI-V6.0.0.627 IBO 3.6cf
> >
> > I found after installing the new version IBO 3.6cf that all my
> > currency fields on QuickReports.TQRDBText that used a Mask ("#.00")
> > where printing out their field name instead of the data. I tracked
> > it down to a change in "IBDataset.pas" where the following was changed
> >
> > Version IBO 3.6cd IBDataset.pas line 1982
> >
> > NewDataType := ftFloat;
> > end
> > else
> > if ( SQLType = SQL_FLOAT ) or
> > ( SQLType = SQL_FLOAT_ ) or
> > ( SQLType = SQL_DOUBLE ) or
> > ( SQLType = SQL_DOUBLE_ ) then
> > NewDataType := ftFloat;
> >
> >
> > Changed to Version IBO 3.6cf IBDataset.pas line 1993
> >
> > if ( SQLScale >= -4 ) then
> > begin
> > NewDataType := ftBCD;
> > NewDataSize := 8;
> > end;
> > end;
> >
> > I am not sure what should be done to make it work correctly, but
> > replacing the change with the original code makes my reports
> > work. That might not be the right solution but maybe Jason or
> > someone will tell us the right thing to do.
> >
> > Thanks
> > Michael L. Horne
> >
> >
> >
> >
> >
>
>
>
>
>