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

interface XRowLocate

Methods' Summary
getBookmark returns the bookmark of the current row of a result set.  
moveToBookmark moves the cursor to the row identified by a valid bookmark.  
moveRelativeToBookmark moves the cursor a relative number of rows, either positive or negative starting at a given bookmark position.  
compareBookmarks compares two bookmarks and returns an indication of their relative values.  
hasOrderedBookmarks determines whether the bookmarks of a result set are ordered or not.  
hashBookmark returns the hash value for a specified bookmark.  
Methods' Details
getBookmark
any
getBookmark()
raises( ::com::sun::star::sdbc::SQLException );

Description
returns the bookmark of the current row of a result set.
Returns
the current bookmark
Throws
com::sun::star::sdbc::SQLException if a database access error occurs.
moveToBookmark
boolean
moveToBookmark( [in] any  bookmark )
raises( ::com::sun::star::sdbc::SQLException );

Description
moves the cursor to the row identified by a valid bookmark.

If the bookmark could not be located, a result set will be positioned after the last record.
If the bookmark is invalid, or not generated by the current result set, then the behavior is not defined, even an abnormal termination is possible.

Parameter bookmark
the bookmark where to move
Returns
`TRUE` if successful
Throws
com::sun::star::sdbc::SQLException if a database access error occurs.
moveRelativeToBookmark
boolean
moveRelativeToBookmark( [in] any  bookmark,
[in] long  rows )
raises( ::com::sun::star::sdbc::SQLException );

Description
moves the cursor a relative number of rows, either positive or negative starting at a given bookmark position.

If the bookmark could not be located, a result set will be positioned after the last record.
If the bookmark is invalid, or not generated by the current result set, then the behavior is not defined, even an abnormal termination is possible.

Parameter bookmark
the bookmark where to move
Parameter rows
count of rows move relative to the bookmark
Returns
`TRUE` if successful
Throws
com::sun::star::sdbc::SQLException if a database access error occurs.
compareBookmarks
long
compareBookmarks( [in] any  first,
[in] any  second )
raises( ::com::sun::star::sdbc::SQLException );

Description
compares two bookmarks and returns an indication of their relative values.

The bookmarks must apply to the same ResultSet. You cannot reliably compare bookmarks from different ResultSets, even if they were created from the same source or statement.
A bookmark that is not valid, or incorrectly formed, will cause an exception.

Parameter first
the first bookmark
Parameter second
the second bookmark
Returns
a value of com::sun::star::sdbcx::CompareBookmark
Throws
com::sun::star::sdbc::SQLException if a database access error occurs.
See also
CompareBookmark
hasOrderedBookmarks
boolean
hasOrderedBookmarks()
raises( ::com::sun::star::sdbc::SQLException );

Description
determines whether the bookmarks of a result set are ordered or not.
Returns
`TRUE` if so
Throws
com::sun::star::sdbc::SQLException if a database access error occurs.
See also
CompareBookmark
hashBookmark
long
hashBookmark( [in] any  bookmark )
raises( ::com::sun::star::sdbc::SQLException );

Description
returns the hash value for a specified bookmark.
Parameter bookmark
the bookmark to hash
Returns
the hashed value
Throws
com::sun::star::sdbc::SQLException if a database access error occurs.
Top of Page