>Don't specify alias if you want VFP to check every record.
APPEND FROM utemp For (SubStr(Submitter,1,1)="E")
>
>>SELECT estate
>>zap
>>APPEND FROM utemp For (SubStr(utemp.Submitter,1,1)="E")
>>go bottom
>>wait window estate.submitter
>>
>>Why would I get all records from UTEMP? I specified 'E' as first letter of first field!
>>
>>TIA
So -
.snip from Jim Nelson.
APPEND FROM Source FOR Source.lArchive
the lArchive field is evaluated only for the current record of the source, not for each one in turn. So either all records or no records are copied.
.endsnip.
- the inclusion of a Source acts as 'constant logical' for the entire dataset based on the current record...
I don't know that I would ever need that!
thanx to all
Edgar L. Bolton, B.S. B.B.A.