<html><body>
<p>I have two guesses.<br>
<br>
Therefore the selection value has to be restated as :<br>
<br>
<font face="Arial"> select if sl-date-time>= 2011042824000000 and sl-date-time<= 2011043024000000</font><br>
<br>
I would experiment with the number of zeroes required.<br>
<br>
<br>
If that doesn't work try the dateextract function.
<p><font face="Arial"> select if 20110429 <= dateextract(sl-date-time,date) and 20110430 <= dateextract(sl-date-time,date) </font><br>
<br>
<br>
<br>
<br>
<img width="16" height="16" src="cid:1__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt="Inactive hide details for "Zanotelli, Barb" ---05/27/2011 01:36:30 PM---Hello listers I have an image database that was defined"><font color="#424282">"Zanotelli, Barb" ---05/27/2011 01:36:30 PM---Hello listers I have an image database that was defined in the Powerhouse dictionary</font><br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">From:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2">"Zanotelli, Barb" <BarbZ@millercompressing.com></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">To:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2"><powerh-l@lists.sowder.com></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Date:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2">05/27/2011 01:36 PM</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Subject:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2">Powerhouse dictionary not matching Image</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Sent by:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF20EDFFBD9B18f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2">powerh-l-bounces+michael.cousins=ca.ibm.com@lists.sowder.com</font></td></tr>
</table>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<font face="Arial">Hello listers</font><font size="4"> </font>
<p><font 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> Element SL-DATE-TIME &<font size="4"> </font><br>
Numeric Size 012 &<font size="4"> </font><br>
Leading Sign " " &<font size="4"> </font><br>
Picture "^^^^^^^^^^^^"<font size="4"> </font>
<p><font face="Arial">And the in the dataset it is defined as:</font><font size="4"> </font><br>
Item SL-DATE-TIME Datatype Integer Signed Size 8<font size="4"> </font>
<p><font face="Arial">Image refers to it as an I4. Powerhouse version is 8.19.c2.</font><font size="4"> </font>
<p><font face="Arial">Any ideas will be greatly appreciated!</font><font size="4"> </font>
<p>
<p><font size="4">Barb </font><tt>-- <br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: powerh-l@lists.sowder.com<br>
Subscribe: 'subscribe' in message body to powerh-l-request@lists.sowder.com<br>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to powerh-l-request@lists.sowder.com<br>
<a href="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.</tt>
<p>
<p></body></html>