Hiya Jim and Richard ---

If I recall, there is a reserved words list for VFP somewhere here in the UT Files section....I don't remember where.

>
>I have tried to find the VFP reserved/restricted words list in the online help (index) for VFP 6, but I came up dry. I'm sure it's in there somewhere, but under some 'title' which I do not 'intuit' to!
>
>My concern is that you may well have some other reserved word in use. When I see things like "filename' i get worried about that.
>
>In any case, I wish you luck.
>
>>>Jim,
>>>
>>>>I'll be happy to tell you: DO NOT USE ANY VFP RESERVED WORDS AS NAMES ANYWHERE IN YOUR CODE!
>>>
>>>I've been naming my primary index PRIMARY since I can rememeber and I've never had a single problem doing so.
>>>
>>>I've done things like SET ORDER TO PRIMARY and INDEX ON accountid TAG PRIMARY without suffering any consequences. Although I can see your point, maybe a better tag name would be PRIMARYKEY or something.
>>------------------
>>
>>Ok guys,
>>I went off and did a few other things for a while. Now I'm back to this. I've just re-read the entire thread. It's really been interesting.
>>
>>Here's what I did...
>>...I changed the PRIMARY tag name to PrimaryKey
>>...I updated all my affected views (no forms or reports are involved),
>>...and I rebuilt my project.
>>
>>Here what happened...
>>...Same stuff
>>...it made no difference.
>>
>>Is there a limit on the length of a tags definition?...or resulting string?
>>
>>
>>I now have an index named PrimaryKey, which is my primary index.
>>I get the message when I'm trying to INSERT records into my table...
>>MergeList.dbf
>> FileName (Character 200)
>> Source (Character 30)
>> Received (DATETIME)
>>
>>My primary index, "PrimaryKey", is defined as:
>>LEFT(ALLTRIM(filename),RAT("\",ALLTRIM(filename)))+RIGHT(ALLTRIM(filename),11)+SUBSTR(ALLTRIM(filename),RAT("\",ALLTRIM(filename))+1,1)
>>
>>The reason I'm doing this is becuase my file names belong in pairs and this way I can display them as pairs.
>>
>>Basically, it takes file names like
>> \DEVELOP\OFAX2\data\date\October061998\C1001012.TXT
>> \DEVELOP\OFAX2\data\date\October061998\R1001012.TXT
>>
>>and turns them into
>> \DEVELOP\OFAX2\data\date\October061998\1001012.TXTC
>> \DEVELOP\OFAX2\data\date\October061998\1001012.TXTR
>>
>>What I don't understand is why I'm getting this message. I can insert the first record fine (of course), but as I continue I get this message and what I'm inserting is new, unique information.
>>
>>Here's my code:
>>* get a list of the C*.txt and R*.txt files in the cSourceDirectory
>>* add these to the MergeList table with Source = "FDLE"
>>* and received = today's date and time
>>* cBaseDirectory is the starting directory of my app
>>* cSourceDirectory is "Download" ....not that it really matters for this question.
>>* I've tried this with the Table and with this updateable view
>>* the view is the same as the table...all fields updatable...key is FileName
>>*
>>IF adir(aDir_Info, cBaseDirectory+"data\"+cSourceDirectory+"\*.txt") > 0
>> FOR nRow = 1 to ALEN( aDir_Info, 1)
>> INSERT INTO vMergeList2 ;
>> (FileName, ;
>> Source, ;
>> Received) ;
>> VALUES ;
>> (cBaseDirectory+"data\date\"+cDestinationDirectory +"\"+ aDir_Info[ nRow, 1], ;
>> cSupplier, ;
>> DATETIME())
>> ENDFOR
>>ENDIF