Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.4 released

Developer's Guide

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 and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.