User wants to create their own Code Templates in View | Toad Options | Editor | Behavior | Languages | Code Template. We haven't been able to figure away to allow him to automatically populate the code with today's date or the current user logged in. We have tried using Substitution Variables, but Code Complete doesn't accept them.
For example,
User goes to View | Toad Options | Editor | Behavior | Languages | Code Template, creates a new one called MYTEMPLATE.
User wants it to look like the following, but the Date field is automatically has today's date, and author is automatically the current user logged in.
CREATE OR REPLACE TYPE |&cls_name AS OBJECT
/******************************************************************************
NAME: &cls_name
PURPOSE:
REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 20071207 Jzhao 1. Created this type.
******************************************************************************/
Is this possible in Toad?
WORKAROUND:
Try using "Proc Templates" in Toad instead. You can then use %DATETIME% or %SYSDATE% and %USERNAME% substitution variable and Toad will automatically fill in the info.
STATUS:
This enhancement has been deferred.
