🚀 go-pugleaf

> >   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.
> ----
> Not so complicated. It _is_ only the externed function alone, the rest is
> only picking out the value it returns.
>

  Oh..  well, I guess the word extern somewhat spooked me, seeing asI see it
mostly when calling complicated Windows API functions.

> > 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.
> ---
> Use <mydatabase>.executeSQL("create table...") if you want the table
> created in that directory, no need for all the stuff above. It's only
> needed if you want to place non-table files in that directory as well,
> like special .INI files to store the indexes for recreation, or readme
> files to explain what those files are and do, to avoid that some
> administrator deletes or moves them etc.

  Ah.  Thank goodness there's always an easier way of tackling
creating database files.   I only just managed to figure out how
to create a table that contains a fieldname that's also a SQL
keyword.   It took me an hour or more to figure out that
all I needed to do was the following:-

   Create table  "&tablename." (  ... ,;
   "&tablename."."DESC" ... )

  It was quite exhilarating to find that it worked.  ;)

Thanks for the help!

Edmund