<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Bericht</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>I had a strange
thing yesterday.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>I have an app that I
wrote back in 1997 or something and for which I added regulary new
functions.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>Apparently from this
week on the app gave an error openening a report, at the customer
site.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>It is atleast a year
ago that I changed anything in the app, so it really started out of the
blue.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>They use the report
every end of the month, by several people.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>After some searching
I found out that I had a typo in a query.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>at a field (a
integer field) criteria I had 0 or 10 or "or -10" instead of 0 or 10 or
-10, so the query return a type mismatch.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>Just a stupid typo
with no big consequences.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>The thing is that I
don't understand why a type mismatch (string instead of integer)
only returns an error when the error was present since atleast beginning 2001
and the query was used severall times a month!!!</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>I checked my backups
(because I presumed the customer has changed this un intentionaly) and I
stopped checking when I got to beginning 2001.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial size=2>The app is used in
A97, but I develop and convert back to A97 since a year or two or
longer.</FONT></SPAN></DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484200306-07082003><FONT face=Arial
size=2>Erwin</FONT></SPAN></DIV></BODY></HTML>