Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.11

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: sdbcx ::

service View
Description
is used to specify views on data. A view object is only used for creation and deletion. Inspecting the command of a view is normally not supported.

If a view is going to be added to a database, the view must have a unique name within the view and the table container, as it can be used like a table. Note: After addition, both the containers for views and the container for tables must contain an element for the view.


Exported Interfaces - Summary
XRename

is optional for implementation. (details)

::com::sun::star::beans::XPropertySet
(referenced entity's summary:)
provides information about and access to the properties from an implementation.
XAlterView

allows changing the view's Command. (details)

Properties' Summary
[ readonly ] string
Name
is the name of the view.  
[ readonly ] string
CatalogName
is the name of the views catalog, may be empty.  
[ readonly ] string
SchemaName
is the name of the view's schema, may be empty.  
[ readonly ] string
Command
is the command for creating the view.  
[ readonly ] long
CheckOption
indicates if a check option should be used for the view.  
Exported Interfaces - Details
XRename
Usage Restrictions
optional
Description
is optional for implementation.
::com::sun::star::beans::XPropertySet
(referenced entity's summary:)
provides information about and access to the properties from an implementation.
XAlterView
Usage Restrictions
optional
Description
allows changing the view's Command.
Properties' Details
Name
[ readonly ] string Name;
Description
is the name of the view.
CatalogName
[ readonly ] string CatalogName;
Description
is the name of the views catalog, may be empty.
SchemaName
[ readonly ] string SchemaName;
Description
is the name of the view's schema, may be empty.
Command
[ readonly ] string Command;
Description
is the command for creating the view.

This is typically a SQL Select-Statement.

This property might be empty when a backend does not support retrieving the current SQL command of a view. However, if the View supports altering its command via the XAlterView interface, then it's required to also provide the current SQL command in the Command property.

CheckOption
[ readonly ] long CheckOption;
Description
indicates if a check option should be used for the view.
See also
CheckOption

 
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.