At 07:53 AM 4/22/2005, Rhett McPeake wrote:
In RBase 7.1 is there way to save the definition of
a view from the sys_views table to recreate the view
at a later time?
Rhett,
Here's how:
01. Database Explorer | Views
02. Highlight the appropriate View
03. Right-click and then select the "Unload" option
from the speed-menu
04. Select the appropriate directory to save the file
You may RBEdit the unloaded .vie structure file and
add the following three lines before the CREATE VIEW
`viewname` statement:
SET ERROR MESSAGE 677 OFF
DROP VIEW viewname
SET ERROR MESSAGE 677 OFF
That's all there is to it!
Very Best R:egards,
Razzak.
P.S.
R:BASE 7.5 for Windows Database Explorer includes the
options to EXPORT Data as well as Schema using the
same technique by the simple click of a mouse!
