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

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