Tuesday, January 30, 2007
Tip of the Day: Using ON CONNECT Command in R:BASE 7.6 and V-8 Supported Versions: . R:BASE 7.6 for Windows (Build: 7.6.1.30125 or higher ...) . R:BASE C/S:I 7.6 for Windows (Build: 7.6.1.30125 or higher ...) . R:BASE Turbo V-8 for Windows (Build: 8.0.14.30125 or higher ...) Did you know that you can use the ON CONNECT ... SAVE to save your ON CONNECT parameters in R:BASE? The latest updates of R:BASE 7.6, C/S:I 7.6 and Turbo V-8 now includes an option "SAVE" to save all your ON CONNECT parameters. Syntax: ON CONNECT RUN commadfile SAVE Where: . CONNECT indicates the command file should be run when connecting a database. . RUN specifies the name of the command file to run. . commandfile specifies the name of the command file to run. . SAVE indicates the defined ON CONNECT parameters be saved. . Any options without the SAVE parameters will only be active for a session. Example 01: CONNECT RRBYW10 IDENTIFIED BY NONE ON CONNECT RUN RRBYW10.DAT SAVE To RESET the ON CONNECT parameters: Syntax: ON CONNECT RESET SAVE Where: . RESET turns the ON CONNECT procedure off. . SAVE indicates the defined ON CONNECT parameters be saved. Example 02: CONNECT RRBYW10 IDENTIFIED BY NONE ON CONNECT RESET SAVE Enjoy and make sure to have fun! Very Best R:egards, Razzak.
