>>>>>I have several apps running that process tables of several million records. I chose FoxPro because it had the fastest db engine available. My apps regularly post several 100,000 record files in text format using low level file functions to a VFP .dbf of 1.8 million records.
>>>>>
>>>>>"30,000 Records?" You won't have time to get a cup of coffee before VFP has processed your records, up, down, sideways and backwards!
>>>>>
>>>>>>I want to import a text file that has about 30,000 records
>>>>>>into vfp50. Can visual foxpro handle 30,00 or maybe 100,00
>>>>>>records? thanks
>>>>
>>>>thanks Steffen for your answer.. with your text file, are you using APPEND FROM to post to the vfp dbf file? I want to move a text file (using a low level file
>>>>functions) to a vfp dbf file. Could you show me some code?..thanks again..rob
>>>
>>>if you really want to use low level file functions to do this, you are either crazy or wanting to pad your billable hours. what does the help for append from tell you to do?
>>
>>Call me crazy Dave, but how do YOU append from a file with out CR and LF at the end of each record. Keep in mind that the IBM Main Frame world doesn't always conform to our neat little desktop ASCII standards! When APPEND from includes a RECORD LENGTH parameter which enables it to parse records without CR or CRLF, then I will save my clients the extra billable hours. Until then they are perfectly happy to PAY EXTRA to get the first record along with 1.8 million records which follow it!!!
>>
>>JP
>
>hay Steffen - don't mind Dave, he is having a caffiene fit.. he will
>be ok soon..

I know, I have those days too!