>i tried to use his prg by opening my project dna saying
>do (prgname).prg
>but its giving me the error table number is invalid and pointing to
>"select (tcalias)
>not exactly sure why cause my database is open

Well, what do you have in tcAlias variable and do you have a table opened with this alias? Try debugging this stuff, I haven't had a need to work with it myself.