>Hi Alex,
>Unfortunately this doesn't work in VFP. In cases where you use the SQL Insert command, VFP internally opens the database and table but never makes them active. Functions like DBC(), SET("DATABASE") and ALIAS() return nothing or erroneous information.
>
>FWIW, if the default value function is in the DBC (i.e. store procedure), you can get the name of the DBC using juststem(sys(16,1)). SYS(16) will return the procedure name with the procedure file speficied as the DCT (memo file) associated with the database. To see if the function is a stored procedure, check the extension justext(sys(16,1)) to see if it is "DCT".

Thanks for the info, Larry. I am finally really getting into VFP. What a cool product!

Alex