🚀 go-pugleaf

> dbfPathAndName = set("directory") + "\TMPX.DBF"
>

That's very short and sweet...

> The following courtesy of Romain (of course):
>
> FUNCTION GetDatabaseDir(oDatabase)
>    if type("GetAliasPath") # "FP"
>            extern cint GetAliasPath(cHandle,cString,;
>          cString,cString);
>                 IDAPI32 from "DbiFormFullName"
>    endif
>    cRet=space(261)
>    if ( GetAliasPath(oDatabase.handle,"YabbaDabbaDoo","",cRet ) == 0 )
>       cRet=cRet.left(cRet.lefttrim().lastindexof("\"))
>       else
>       cRet=""
>    endif
>    RETURN cRet
>

  Thanks Gary! Thanks Romain!   I don't think I'd EVER think of
somethinglike the above code.   It's so complicated, especially with the
extern function.

 Edmund

PS: I solved the temporary database file in the wrong directory problem.
I just
had to SET DATABASE TO before the Create table and everything worked!
Of course, I had to get rid of the Query and Database objects as I'd
figured
having them on the form might give me instability errors.