Soooo, are you saying that this is essentially a SAFE way to attach a server table without worrying about some careless user messing up the attached table data? Is there any speed advantage / disadvantage?
This sounds interesting.... BC Robert M. Castanaro Director, Clinic Outpatient Services Barberton Citizens Hospital 155 Fifth Street, N.E. Barberton, Ohio 44203 330-615-3188 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Tuesday, May 15, 2007 4:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Tip of the Day: Attaching Server Tables as TEMPORARY Tables Tuesday, May 15, 2007 If designing databases and programming in R:BASE 7.6/Turbo V-8 were cake, here's the icing! Tip of the Day: Attaching Server Tables as TEMPORARY Tables Supported Versions: . R:BASE 7.6 for Windows (Build: 7.6.1.30514 or higher) . R:BASE C/S:I 7.6 for Windows (Build: 7.6.1.30514 or higher) . R:BASE Turbo V-8 for Windows (Build: 8.0.15.30514 or higher) Did you know that now you can attach server tables as TEMPORARY tables? Among sooooooooo many enhancements and features in R:BASE 7.6, R:BASE 7.6 (C/S) and R:BASE Turbo V-8, the traditional SATTACH command has been enhanced to include the option for attaching server tables as TEMPORARY. Syntax: SATTACH TEMPORARY tablename AS tablealias USING ... The optional TEMPORARY parameter allows you to create a Temporary Table with the SATTACH command and all supported parameters. The temporary tables will disappear when the database is DISConnected. Use this option to take the exact snapshot of the sever table to manage and analyze the data as you wish. Note: Any changes made to the temporary table will not be reflected upon the original SQL data source. The sole purpose of this enhancement is to let R:BASE attach server tables as TEMPORARY tables specific to that User/R:BASE session even when the database is connected with STATICDB ON. Imagine the possibilities! Enjoy all of the requested enhancements and make sure to have fun! Very Best R:egards, Razzak.
