Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michael Gill
  Where is Michael Gill?
 Flora
 Illinois - United States
 Michael Gill
 To: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 Tags
Subject: RE: Why is my code missing records i know are t...
Thread ID: 15774 Message ID: 15781 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Monday, September 30, 2002 4:23:16 PM         
   


> > Hello
> >
> > This is my code, it works ok but it misses records it shouldnt, can anyone help the code is straight forward to understand i hope, I think it might be to do with the file extension ie are they case sensitive or some thing? tif as apposed to .TIF can i miss this out? if not what else could be wrong?
> >
> > SELECT appeals
> > SCAN all
> > reffy = ALLTR(appeals.fileref)
> > IF empty(reffy)
> > Skip
> > IF reffy = ">>REF"
> > Skip
> > ENDIF
> > ELSE
> > cyear = year(appeals.date)
> > lctempdir = "z:\decisions\"
> > lcdir = "" + ALLTRIM(STR(cyear))
> > lcappend = "Z:\DECISIONS\" + lcdir + "\" + reffy + ".tif"
> > *messagebox("append general original from [&lcappend] link")
> > REPLACE original with lcappend
> > ENDIF
> > ENDSCAN
> > SET PATH TO DEFAULT
> >
> > Tom
>
> Without knowing the contents of your table .... You have some SKIP statments in your SCAN loop.
> The SCAN loop does a SKIP each time - are you sure that you are wanting to do both of the SKIP statements .. Maybe you really only want the first one.
>
>
> Cheers,
> Jamie
> jamie.osborn@foxite.com

Yeah, I agree with Jamie. The SCAN does an automatic skip. You should use LOOP instead.

---

www.foxite.com - The Home of the Visual FoxPro Experts

ENTIRE THREAD

Why is my code missing records i know are there? Posted by Thomas Holt @ 9/30/2002 1:31:15 PM
RE: Why is my code missing records i know are t... Posted by Jamie Osborn @ 9/30/2002 1:44:36 PM
RE: Why is my code missing records i know are t... Posted by Michael Gill @ 9/30/2002 4:23:16 PM