Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 To: Thomas Holt
  Where is Thomas Holt?
 Gloucester
 United Kingdom
 Thomas Holt
 Tags
Subject: RE: Why is my code missing records i know are t...
Thread ID: 15774 Message ID: 15775 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Monday, September 30, 2002 1:44:36 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

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