Great I'll give this a try!

Thanks!

>Hi,
>VFP doesn't support APPEND PROCUDERE command at runtime. You need to "hack" into database file in order to do this.
>
>*NOTE: Backup your database before try this code
>
>

>PROCEDURE AppendProcedure(tcDBC As String, tcSPFile As String)
>
>USE (tcDBC) AGAIN SHARED ALIAS tmpData IN 0
>			
>SELECT tmpData			
>LOCATE FOR ObjectType = "Database" AND ObjectName = "StoredProceduresSource"
>IF FOUND()
>   REPLACE Code WITH Code + FILETOSTR(tcSPFile)
>ENDIF
>			
>USE IN SELECT("tmpData")
>ENDFUNC
>

>
>HTH