Strange Problem

[Jeff Harrison]

--- GCC Consulting <gcc at optonline.net> wrote:
>  
> 
> > -----Original Message-----
> > From: filepro-list-bounces at lists.celestial.com 
> > [mailto:filepro-list-bounces at lists.celestial.com]
> On Behalf 
> > Of Rick Mitchell
> > Sent: Thursday, March 31, 2005 12:26 PM
> > To: filepro-list at lists.celestial.com
> > Subject: Strange Problem
> > 
> > I have two fields:
> > 
> > 29  Date of transaction   8  yymd
> > 30  Serial # of transact  9 
> > 
> > I have an index built on Field 29
> > 
> > File is called mbien04p
> > 
> > I am importing new data.
> > 
> > I get field 29 and 30 from the raw data.
> > 
> > I do a lookup to the file
> > 
> > 
> > lookup test=mbien04p k=29 i=h -nx
> > 
> > I will have data in field 29, i.e. 20040626 and
> when I do a 
> > lookup to it it fails.
> > 
> > Do I need to use these as integers instead of date
> edits?
> > 
> A few things come to mind.
> 
> 1. Have you checked the index H's length to insure
> that it is 8 characters long.
> 
> 2. Have you manually tested the date in IUA?  Are
> you taken to that or those
> records?
> 
> 3. Have you run your process with the debugger and
> checked the field value that
> is failing?
> 
> 4. What platform are you having this problem on?
> 
> Richard Kreiss
> GCC Consulting 
> 

I would add:

5.  Can you post the code so we can see what you are
doing exactly?  

6.  When does field 29 get populated, and when does it
get written?

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHImport and JHExport.  The fastest and
easiest way to generate code for filepro imports and
exports.




		
__________________________________ 
Yahoo! Messenger 
Show us what our next emoticon should look like. Join the fun. 
http://www.advision.webevents.yahoo.com/emoticontest