Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append for few records
Message
From
28/12/2001 16:25:45
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00598952
Message ID:
00598968
Views:
18
>>>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform