<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Nachricht</TITLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=343551818-10072005>Dear
Ruslan,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=343551818-10072005>thanks for the new
Release - looks like it is more stable (or I have managed to build workarounds
for the precious problems), BUT</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=343551818-10072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=343551818-10072005>the following query
finds everyting except the last available date:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=343551818-10072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2>select * from hist where (mdate >= '2005-07-06')
and (mdate <= '2005-07-20')</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=343551818-10072005><FONT face=Arial size=2>the field mdate in
the table hist is string field and not a date field. The last entries in that
table are two records with date '2005-07-12'.</FONT></SPAN></DIV>
<DIV><SPAN class=343551818-10072005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=343551818-10072005><FONT face=Arial size=2>the cursor returns
all records up to and including '2005-07-11'.</FONT></SPAN></DIV>
<DIV><SPAN class=343551818-10072005><FONT face=Arial size=2>if just do select *
from hist it finds '2005-07-12' as well or if I insert '2005-07-12' for
both options (i.e. if I only look for one day) then it finds that day
alright.</FONT></SPAN></DIV>
<DIV><SPAN class=343551818-10072005></SPAN> </DIV>
<DIV><SPAN class=343551818-10072005></SPAN><SPAN class=343551818-10072005><FONT
face=Arial size=2>I've tried that also in Valentina Studio - same result.
WHY?</FONT></SPAN></DIV>
<DIV><SPAN class=343551818-10072005></SPAN><SPAN class=343551818-10072005><FONT
face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=343551818-10072005><FONT face=Arial size=2>rgs, john
m.</FONT></SPAN></DIV>
<DIV align=left>
<DIV align=left><FONT face=Arial size=2><A
href="mailto:miescher@bizdata.com"></A></FONT></DIV></DIV></BODY></HTML>