Tim

Is there a way within a script to generate a unique table name, AND pass it back to the outside world?

Roy Lambert

Roy,

<< Is there a way within a script to generate a unique table name, AND pass
it back to the outside world? >>

Not currently, other than to use the CURRENT_GUID function.   Why not just
use a temporary table and not have to worry about naming conflicts ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Not currently, other than to use the CURRENT_GUID function. Why not just
>use a temporary table and not have to worry about naming conflicts ?

I currently have the code in place to generate the unique names I just thought it would be nice to do it all in one place. I'll keep on with memory tables until you can guarantee clean up of temporary tables in the event of 1) user just turning PC off, 2) my code or something else crashing the app

Roy Lambert

Roy,

<< I currently have the code in place to generate the unique names I just
thought it would be nice to do it all in one place. I'll keep on with memory
tables until you can guarantee clean up of temporary tables in the event of
1) user just turning PC off, 2) my code or something else crashing the app
>>

We could never guarantee either of those things.   If you're concerned about
temporary tables being left on the disk, then just delete every file in the
temporary directory upon application startup.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>We could never guarantee either of those things. If you're concerned about
>temporary tables being left on the disk, then just delete every file in the
>temporary directory upon application startup.

Hmm. I need to give that one some thought. I usually use the Windows temporary directory and other apps may do as well.

Do I detect a leaning toward temporary tables from you. If so why?

Roy Lambert

Roy,

<< Hmm. I need to give that one some thought. I usually use the Windows
temporary directory and other apps may do as well. >>

Yes, you might want to consider a special temporary directory or just leave
it up to the user to clean up their temporary files directory when necessary
using the Windows cleanup facilities.

<< Do I detect a leaning toward temporary tables from you. If so why? >>

Mainly because they're much easier to deal with in general and hide all of
the nasty little implementation details of where/how they are created on
disk, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Yes, you might want to consider a special temporary directory or just leave
>it up to the user to clean up their temporary files directory when necessary
>using the Windows cleanup facilities.

Users - clean up - what planet are you from?

><< Do I detect a leaning toward temporary tables from you. If so why? >>
>
>Mainly because they're much easier to deal with in general and hide all of
>the nasty little implementation details of where/how they are created on
>disk, etc.

If I create one in a script how do I get its name to apply to a TEDBTable?

Roy Lambert

Roy,

<< If I create one in a script how do I get its name to apply to a
TEDBTable? >>

The name is whatever name is given to the table in the script.  For example:

CREATE TEMPORARY TABLE MyTable....

in a script would allow you to simply refer to it using "MyTable" in a
TEDBTable component.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


duh - why did I think it was going to generate its own name?


Roy Lambert

Roy,

<< duh - why did I think it was going to generate its own name? >>

That's "DBISAM thinking".

--
Tim Young
Elevate Software
www.elevatesoft.com