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 codePROCEDURE 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
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...