Powerhouse dictionary not matching Image

[Zanotelli, Barb]

Hello listers

I have an image database that was defined in the Powerhouse dictionary
way back when the dictionary was defined.  I tried to do a Quiz select
with the main search item but It would never get any results even though
I could see what it should have found in Query. Obviously we have no
Powerhouse programs accessing this database.   I tried various ways of
selecting and have narrowed it down to the fact that it will select a
specific number (a date in this case) but will not when I do >= or <= as
in "select if sl-date-time>= 201104282400 and sl-date-time<=
201104302400". The dictionary element is defined as:
  Element SL-DATE-TIME &
    Numeric Size 012 &
    Leading Sign " " &
    Picture "^^^^^^^^^^^^"

And the in the dataset it is defined as:
    Item SL-DATE-TIME     Datatype Integer Signed   Size 8

Image refers to it as an I4. Powerhouse version is 8.19.c2.

Any ideas will be greatly appreciated!


Barb

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20110527/d031abfa/attachment.htm