Using Database Object Editor Templates to set default values

Toad for IBM DB2
1

Recently, a question was asked about setting default values for object attributes when creating new objects. Toad does not use Tools | Options… for setting default values for database object attributes, however by using Database Object Editor ‘templates’ you can set and use your own default attributes.

Toad’s Database Object Editors (DOEs) are the GUIs\Forms that allow you to create\maintain objects. In DOEs, there are ‘template’ features that allow you to define and reuse sets of attributes to be used while creating your new objects.
Using the top toolbar found on DOE’s you can define and reuse templates, including a default template. The attached image highlights the DOE Template toolbar and the attached document provides more details and examples.
Hope this helps,
Jeff

DoeTemplatePic.jpeg

Server Error in ‘/’ Application.

Operation is not valid due to the current state of the object.

    Operation is not valid due to the current state of the object.

         **Description:**
        An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

         **Exception Details:** System.InvalidOperationException: Operation is not valid due to the current state of the object.

        **Source Error:**

`

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.`

        **Stack Trace:**

   [InvalidOperationException: Operation is not valid due to the current state of the object.] System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959 System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213 Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270

``

Version Information:
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

">ToadDB2DOETemplates.docx