<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>Powerhouse dictionary not matching Image</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hello listers</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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:</FONT></P>
<P><FONT SIZE=2 FACE="r_ansi"> Element SL-DATE-TIME &</FONT>
<BR><FONT SIZE=2 FACE="r_ansi"> Numeric Size 012 &</FONT>
<BR><FONT SIZE=2 FACE="r_ansi"> Leading Sign " " &</FONT>
<BR><FONT SIZE=2 FACE="r_ansi"> Picture "^^^^^^^^^^^^"</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">And the in the dataset it is defined as:</FONT>
<BR><FONT SIZE=2 FACE="r_ansi"> Item SL-DATE-TIME Datatype Integer Signed Size 8</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Image refers to it as an I4. Powerhouse version is 8.19.c2.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Any ideas will be greatly appreciated!</FONT>
</P>
<BR>
<P><FONT FACE="Californian FB">Barb</FONT>
</P>
</BODY>
</HTML>