Creating a Temp Table with TBatchMove (MSSQL 6.0) 
Author Message
 Creating a Temp Table with TBatchMove (MSSQL 6.0)


I am currently using delphi Client/Server with MS SQL 6.0.

I am trying to create a temporary table that is available only
to that session.  I expect that several users will be running
this program at the same time, and do not want the temporary
tables to interfere with each other.

According to the SQL Manual (Transact SQL Reference) all I need
to do for a temporary table is place a '#' (pound sign) before
the table name.  When I do this, I receive the error: 'Invalid
Table Name.'  I know the whole system works if I use a 'normal'
name in the TableName property of the TBatchMove so I am
condifent that everything else is correct.  I do have
'privledges' to the Create Table command and can do it in the
utility 'Interactive SQL for Windows' (ISQL/w).

Does anyone out there have any experience in this or has anyone
found a way around it?  My goal is to be able to create a
table only available to the local process.

Thank you in advance.
Tony Thornton

Sun, 02 Aug 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. TBatchMove / Creating a databse table at runtime?

2. Creating MSSQL Tables locally

3. mssql and TBatchMove

4. Mssql y TBatchMove

5. Creating temp files for complex queries - how ?

6. Help! Codebase creating Temp files

7. Creating temp files for complex queries - how ?

8. MSSQL 6.0 and 6.5 and TDBMEMO field report (Memo too Large)

9. Copies into MSSQL-Server 6.0 are SLOW !?

10. Cached Updates & MSSQL 6.0 Memo fields

11. MSSQL 6.0 Stored procedures %#ยค RETURN_VALUE

12. (2nd Try) ( Native SQL Error #10037) Delphi 2.0/MSSQL 6.0 Problem, help requested


Powered by phpBB® Forum Software