In article <[log in to unmask]>,
[log in to unmask] says...
>
>I have successfully converted a couple of Image Databases to Image/SQL
and am
> able to access them
>using MS/Access, Excell and Word.  However some of the DB's contain real
numbers
> (R2 and R4) data types.
>
>Following the directions in the manual, I updated the type in the DBE to
CHAR(4)
> and CHAR(8) respectivly.
>This however puts the data in an unviewable format.
>
>The problem that I have is I need to be able to view these fields with
their
> correct values, have call the
>response center and they haven't gotten back to me with a fix yet.
>
>Help!! Anyone who can help answer this it would be greatly appreciated.
>
>Jim Roach
Those types are I believe HP real types. And SQL and many other systems
now use IEEE real types, which HP now supports on their not-new any more
PA-RISC architecture. You can extract the data and change the image
databases to hold the IEEE real datatypes convert the extracted data and
put it back. The other option is when the data is read out convert it
then. I think there is an option in HP Pascal to allow dual declaration of
the two different internal storage of real numbers within the same
program.
Hope this helps.
James