🚀 go-pugleaf

Been sometime since I last wrote here, so I just want to wish everyone a
very
Happy New Year.

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?  What I
want to do is create a temporary datafile(table) to the current
directory(the
one in which the program is being run in), but whenever the program runs

the CREATE TABLE command, it saves it to the DATA directory(as
stated in the alias).  Here's a snippet of the code in question:-

IF FILE("TMPX.DBF")
     ERASE "TMPX.DBF"
ENDIF

CREATE TABLE "TMPX.DBF";
      ( STOCK  CHAR(5),  QTY   NUMERIC(3,0),;
        COST     NUMERIC(10,2))

The first three lines obviously checks if there is a TMPX.DBF file in
the
current directory, but after that it tries to create a table but it
keeps on
saying that "TABLE TMPX.DBF EXISTS" (or something like that)

How would I create a table using the above structure, in the
applications
directory(as a work directory)?   Using the FILE object wouldn't work
as I'd have to save the information bit by bit/char by char to the file
and
in the same format as a db7 one(I think that's how I'd do something like

that).

Actually, I hope this is the right newsgroup to post in.

Any help appreciated

Edmund