Difference between revisions of "Documentation/DevGuide/Database/The RowSet Service"
OOoWikiBot (Talk | contribs) m (Robot: Changing Category:Database Access) |
m |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 6: | Line 6: | ||
|NextPage=Documentation/DevGuide/Database/Usage | |NextPage=Documentation/DevGuide/Database/Usage | ||
}} | }} | ||
| − | {{DISPLAYTITLE:The RowSet Service}} | + | {{Documentation/DevGuideLanguages|Documentation/DevGuide/Database/{{SUBPAGENAME}}}} |
| + | {{DISPLAYTITLE:The RowSet Service}} | ||
<!--<idltopic>com.sun.star.sdb.RowSet</idltopic>--> | <!--<idltopic>com.sun.star.sdb.RowSet</idltopic>--> | ||
| − | The service <idl>com.sun.star.sdb.RowSet</idl> is a high-level client side | + | The service <idl>com.sun.star.sdb.RowSet</idl> is a high-level client side rowset that retrieves its data from a database table, a query, an SQL command or a row set reader, which does not have to support SQLl. It is a <idl>com.sun.star.sdb.ResultSet</idl>. |
The connection of the row set is a named <code>DataSource</code>, the URL of a data access component, or a previously instantiated connection. Depending on the property <code>ResultSetConcurrency</code>, the row set caches all data or uses an optimized method to retrieve data, such as refreshing rows by their keys or their bookmarks. In addition, it provides events for row set navigation and row set modifications to approve the actions, and to react upon them. | The connection of the row set is a named <code>DataSource</code>, the URL of a data access component, or a previously instantiated connection. Depending on the property <code>ResultSetConcurrency</code>, the row set caches all data or uses an optimized method to retrieve data, such as refreshing rows by their keys or their bookmarks. In addition, it provides events for row set navigation and row set modifications to approve the actions, and to react upon them. | ||
| Line 16: | Line 17: | ||
{{PDL1}} | {{PDL1}} | ||
| − | [[Category:Documentation/ | + | [[Category:Documentation/Developer's Guide/Database Access]] |
Latest revision as of 11:12, 17 January 2024
- The RowSet Service
The service com.sun.star.sdb.RowSet is a high-level client side rowset that retrieves its data from a database table, a query, an SQL command or a row set reader, which does not have to support SQLl. It is a com.sun.star.sdb.ResultSet.
The connection of the row set is a named DataSource, the URL of a data access component, or a previously instantiated connection. Depending on the property ResultSetConcurrency, the row set caches all data or uses an optimized method to retrieve data, such as refreshing rows by their keys or their bookmarks. In addition, it provides events for row set navigation and row set modifications to approve the actions, and to react upon them.
The row set can be in two different states, before and after execution. Before execution, set all the properties the row set needs for its work. After calling execute() on the RowSet, move through the result set, or update and delete rows.
| Content on this page is licensed under the Public Documentation License (PDL). |
