>>>>Hi everybody,
>>>>
>>>>I can not get to work this simple command:
>>>>
>>>>append from (m.tcFileName) delimited with tab ;
>>>> for inlist(state,'MA','CT','RI','NH') and reccount()<100
>>>>
>>>>I want to append only few records, then check the file, then if it's correct, append all.
>>>>
>>>>Could you please advise, why it doesn't work, as I think, it should?
>>>>
>>>>Thanks in advance.
>>>
>>>
>>>Maybe you already have more than 100 recs.
>>>Cetin
>>
>>No, I zapped the table before appending.
>
>And there is at least one row with one of those states in file ?
>Result is 0 recs ?
>No trigger etc that would deny recs ?
>Strange.
>Cetin
Really strange. I'll try again. The file indeed contains CT records (945K of them)
Still doesn't work.
More info: each time it seems like VFP hangs and I have to kill VFP.
Here is my test command:
append from (m.tcFileName) delimited with tab ;
for inlist(state,'MA','CT','RI','NH') and not m.plHalt and reccount()<5
I'm trying it from command window
I set plHalt = .f.
on escape plHalt = .t.
I guess, it would not work for some reason. The text file contains more than 1MM records, could it be a problem?
If it's not broken, fix it until it is.
My Blog