DataWindow .NET 1.5.1 allows you to create and edit temporary tables when you use the SYC native driver to connect to an Adaptive Server Enterprise database. You can create temporary tables in the Database painter, SQL painter, or DataWindow painter. Temporary tables persist for the duration of a database connection, residing in a special database called “tempdb”.
Add a temporary table to the tempdb database by assigning a name that starts with the # character when you create a new table in a painter. (Temporary tables must start with the # character.)
After you create a temporary table, you can create indexes and a primary key for the table. If you define a unique index or primary key, you can execute INSERT, UPDATE, and DELETE statements for a temporary table. Select Edit Data from the pop-up menu of a temporary table to retrieve data that you store in that table.
Standard catalog query limitations
When you click Refresh from the pop-up menu for the Tables
node in the Database painter or the Objects view of the DataWindow
painter, the list of tables displays temporary tables even though
they exist only in the tempdb database. However,
once you refresh table definitions from the database, the Objects
view can no longer list the index or primary key information of
the temporary tables and the Layout view can no longer display that
information graphically.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
