Re: Ascan wuestion
- From: Tom <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 20 Jul 2005 14:47:42 -0700
Rich, yes it is indexed on (Agency). i may have 5 records for each Agency and
dates of Changes 1/1/1974, 3/1/1988, 4/1/1994 and 5/1/2003.
each date has a new Code also. example
1/1/1974 Code 1
3/1/1988 Code 3 (Upgrade)
4/1/1994 Code 7 (Upgrade)
5/1/2003 Code 5 (Downgrade)
i need to scan the file, look at the last 2 records, determine if its an Up
or Down Grade, then update another File.
so for this i would update File2 with a '0' for a downgrade.
"Rich" wrote:
> Is your file indexed on code and/or date or both/neither? I assume from
> your question that there is at an index tag on (key).
> Rich
>
>
> "Tom" <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:8CE948B1-140C-48DC-99C6-B03B70C239A5@xxxxxxxxxxxxxxxx
> i have troubles with scans for some reason, this one is giving me fits.
>
> File 1 contain 4 fields, 1 field has codes in it, 1 has date changed, 1 has
> kind of change.
>
> Code are say 1-11
> for a (key) i need to scan the file, for the last code and date, then
> compare that to the next record in the file for the (key). if the code was a
> 9 and now its a 2 i will place a 1(upgrade) in another file, if the code was
> a 4 and now is a 9(downgrade) i will place a 0 in the other file.
>
> i have the basic scan done, but i am stumbling on the above routine. thank
> you for your assistance.
> Tom
>
>
>
.
- Follow-Ups:
- SV: Ascan wuestion
- From: Anders
- Re: Ascan wuestion
- From: Rich
- SV: Ascan wuestion
- References:
- Ascan wuestion
- From: Tom
- Re: Ascan wuestion
- From: Rich
- Ascan wuestion
- Prev by Date: Re: Ascan wuestion
- Next by Date: Re: SV: SV: SV: DateTime Picker force dropdown?
- Previous by thread: Re: Ascan wuestion
- Next by thread: Re: Ascan wuestion
- Index(es):
Relevant Pages
|