Hi Grigore,

Check this thread: Databases,Tables, Views, Indexing and SQL syntax Re-create Stored Procedure Thread #454240

Perhaps your problem, what your file has txt extension? Weird.


>Hello, All.
>
>I'm in a hurry, because my local time is 03:40 and this have to be done until 08:00.
>
>Please, can anyone tell me how to append procedures in a database? I've tried all my ideas, but with a very limited success (none, basically :)
>
>I have the procedure in a file named 'Proceduri.txt'. It's a runnable procedure, which works ok. I try to append this procedure in a brand new database, programatically, using 'APPEND PROCEDURE' command, in a following sintax:
>
>

>APPEND PROCEDURES FROM 'proceduri.txt' OVERWRITE
>

>
>It seems to work ok, because in 'Data' tab of the project manager I see the entry for my new procedure. But when I click on it and then 'Modify' I receive an error 'Record out of range'. It seems to me that the database doesn't have all the things in place.
>
>Can anyone give me a right, lite and clean way to do my task?
>
>Thanks in advance,
>Grigore Dolghin