>>Hi all,
>>i am having a few problems using the append procedures command to overwrite the RI code in a database. it keeps coming back saying that this function is not supported in this version of foxpro!!!! i am running version 6.0 with the latest patches applied.... what's going on???
>>
>>open data wimsmain exclusive
>>append procedures from newproc.txt overwrite
>>
>>seems simple doesn't it? but it doesn't work!!
>>
>>Jordan
>Hi Jordan,
>I am using VFP version 6.00.8862.00
>VFP 6 with SP4 on W2K Pro
>I can confirm that it is not working as advertised in the Help File.
>By default it is supposed to Append, in the test that I just ran,
>open data data\inventory exclusive
>append procedures from progs\test3.prg
>it overwrote without using the OVERWRITE option, on the occasion that it did anything. All other cases it complained that the file had an error. All that it contained was
>Function DoNothing2
>return ''
>Can you keep me in the replies so that I may learn how it gets fixed.
>Regards
Jordan,
Let me add to that previous reply.
quote
Q142551 - FIX: No Carriage Return Between RI Code and Appended Code
Summary: Using "APPEND PROCEDURES FROM " will append code to the stored procedures section of a database. Unfortunately, a carriage return is not placed between the last line of the Referential Integrity (RI)
endquote
if you put a blank line or two at the start of your .txt file that contains the additional or new procedures, all will be OK.
Then an
Append procedures from mytestfile.txt will work - or at least it did for me.
regards.