Hi,Jordan

I don't recall for sure, but I believe VFP3 already had a GENDBC utility. Have a look and see how the compiled version is transferred from the source database to the target (IIRC you have to store the pre-compiled code in the StoredProceduresObject as well - if you can provide it then maybe this can help).

>i seem to have somewhat of a dilemma. i need to append procedures to the vfp3 database and then compile it programmatically. i did it as follows:
>
>use wimsmain.dbc
>LOCATE FOR objecttype = "Database" AND objectname = "StoredProceduresSource"
>IF FOUND()
> APPEND MEMO CODE FROM procs.txt overwrite
>ENDIF
>close data
>compile database wimsmain
>
>however, it seems that i can't recompile the database programmatically outside the vfp3.0 programming environment. what alternatives do i have??

bye