🚀 go-pugleaf

>What I'd like to ask is with the CREATE TABLE command, does it always
>save the table to the ALIAS directory and not the current one?

Because that's how it's designed to work, and the way it ought to work.

> What I
>want to do is create a temporary datafile(table)

I suggest you use the system temp directory for temporary tables. You can
determine the temp directory with GETENV(). Maybe something like this:

private cTmpTable
cTmpTable = getenv("TMP") + "\" + "TMP.DBF"
create table &cTmpTable. ( STOCK  CHAR(5), .........
__
Bowen Moursund (TeamB)
bowen at nerds dot com
http://lonestar.texas.net/~moursund/
Try this help resource:
http://www.dejanews.com/home_ps.shtml