Hi All,

How do I avoid overwritting other workstations' data in my own
temporary tables? If two workstations are doing the following at the
same time:

SELECT * INTO TempTable1 FROM Table1

Is there some way TempTable1 will only have my data? I've heard that
Microsoft's SQL Server provides support for this using #TempTable1 and
in similar cases ##TempTable1 where #TempTable1 is my own temporary
table. How can I do something similar with Pervasive?

Many thanks,
Dale

You could create the SQL statement to build the temp table into a
unique name, leveraging the user's connection ID or some other unique
value.

PSQLv9 has this feature in it with the EXECUTE statement, if you need
this capability within stored procedures.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - November, 2005 ***
*** Chicago: Pervasive DataExchange Class - November, 2005 ***

DaleM (AT) MooreWorks (DOT) Net wrote: