1*d1766043SAndrew Rist/************************************************************** 2cdf0e10cSrcweir * 3*d1766043SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*d1766043SAndrew Rist * or more contributor license agreements. See the NOTICE file 5*d1766043SAndrew Rist * distributed with this work for additional information 6*d1766043SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*d1766043SAndrew Rist * to you under the Apache License, Version 2.0 (the 8*d1766043SAndrew Rist * "License"); you may not use this file except in compliance 9*d1766043SAndrew Rist * with the License. You may obtain a copy of the License at 10*d1766043SAndrew Rist * 11*d1766043SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*d1766043SAndrew Rist * 13*d1766043SAndrew Rist * Unless required by applicable law or agreed to in writing, 14*d1766043SAndrew Rist * software distributed under the License is distributed on an 15*d1766043SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*d1766043SAndrew Rist * KIND, either express or implied. See the License for the 17*d1766043SAndrew Rist * specific language governing permissions and limitations 18*d1766043SAndrew Rist * under the License. 19*d1766043SAndrew Rist * 20*d1766043SAndrew Rist *************************************************************/ 21*d1766043SAndrew Rist 22*d1766043SAndrew Rist 23cdf0e10cSrcweir#ifndef __com_sun_star_sdbcx_XRowLocate_idl__ 24cdf0e10cSrcweir#define __com_sun_star_sdbcx_XRowLocate_idl__ 25cdf0e10cSrcweir 26cdf0e10cSrcweir#ifndef __com_sun_star_uno_XInterface_idl__ 27cdf0e10cSrcweir#include <com/sun/star/uno/XInterface.idl> 28cdf0e10cSrcweir#endif 29cdf0e10cSrcweir 30cdf0e10cSrcweir#ifndef __com_sun_star_sdbc_SQLException_idl__ 31cdf0e10cSrcweir#include <com/sun/star/sdbc/SQLException.idl> 32cdf0e10cSrcweir#endif 33cdf0e10cSrcweir 34cdf0e10cSrcweir module com { module sun { module star { module sdbcx { 35cdf0e10cSrcweir 36cdf0e10cSrcweir 37cdf0e10cSrcweir/** is used to identify rows within a result set and to find rows by a bookmark. 38cdf0e10cSrcweir 39cdf0e10cSrcweir 40cdf0e10cSrcweir <p> 41cdf0e10cSrcweir Bookmarks are only valid in the scope of the current result set and 42cdf0e10cSrcweir are not interchangeable between result sets. A bookmark could be a complex data 43cdf0e10cSrcweir structure, so it could not be compared in a safe way. Because of that, a provider 44cdf0e10cSrcweir has to implement the compare method for bookmarks. 45cdf0e10cSrcweir </p> 46cdf0e10cSrcweir */ 47cdf0e10cSrcweirpublished interface XRowLocate: com::sun::star::uno::XInterface 48cdf0e10cSrcweir{ 49cdf0e10cSrcweir 50cdf0e10cSrcweir /** returns the bookmark of the current row of a result set. 51cdf0e10cSrcweir @returns 52cdf0e10cSrcweir the current bookmark 53cdf0e10cSrcweir @throws com::sun::star::sdbc::SQLException 54cdf0e10cSrcweir if a database access error occurs. 55cdf0e10cSrcweir */ 56cdf0e10cSrcweir any getBookmark() raises (com::sun::star::sdbc::SQLException); 57cdf0e10cSrcweir //------------------------------------------------------------------------- 58cdf0e10cSrcweir 59cdf0e10cSrcweir /** moves the cursor to the row identified by an valid bookmark. 60cdf0e10cSrcweir 61cdf0e10cSrcweir <p> 62cdf0e10cSrcweir If the bookmark could not be located, a result set will be positioned 63cdf0e10cSrcweir after the last record. 64cdf0e10cSrcweir <br/> 65cdf0e10cSrcweir If the bookmark is invalid, or not generated by the current result set, then 66cdf0e10cSrcweir the behaviour is not defined, even an abnormal termination is possible. 67cdf0e10cSrcweir </p> 68cdf0e10cSrcweir @param bookmark 69cdf0e10cSrcweir the bookmark where to move 70cdf0e10cSrcweir @returns 71cdf0e10cSrcweir <TRUE/> if successful 72cdf0e10cSrcweir @throws com::sun::star::sdbc::SQLException 73cdf0e10cSrcweir if a database access error occurs. 74cdf0e10cSrcweir */ 75cdf0e10cSrcweir boolean moveToBookmark([in]any bookmark) raises (com::sun::star::sdbc::SQLException); 76cdf0e10cSrcweir //------------------------------------------------------------------------- 77cdf0e10cSrcweir 78cdf0e10cSrcweir /** moves the cursor a relative number of rows, either positive or negative 79cdf0e10cSrcweir starting at a given bookmark position. 80cdf0e10cSrcweir 81cdf0e10cSrcweir 82cdf0e10cSrcweir <p> 83cdf0e10cSrcweir If the bookmark could not be located, a result set will be positioned 84cdf0e10cSrcweir after the last record. 85cdf0e10cSrcweir <br/> 86cdf0e10cSrcweir If the bookmark is invalid, or not generated by the current result set, then 87cdf0e10cSrcweir the behaviour is not defined, even an abnormal termination is possible. 88cdf0e10cSrcweir </p> 89cdf0e10cSrcweir @param bookmark 90cdf0e10cSrcweir the bookmark where to move 91cdf0e10cSrcweir @param rows 92cdf0e10cSrcweir count of rows move relative to the bookmark 93cdf0e10cSrcweir @returns 94cdf0e10cSrcweir <TRUE/> if successful 95cdf0e10cSrcweir @throws com::sun::star::sdbc::SQLException 96cdf0e10cSrcweir if a database access error occurs. 97cdf0e10cSrcweir */ 98cdf0e10cSrcweir boolean moveRelativeToBookmark([in]any bookmark, [in]long rows) 99cdf0e10cSrcweir raises (com::sun::star::sdbc::SQLException); 100cdf0e10cSrcweir //------------------------------------------------------------------------- 101cdf0e10cSrcweir 102cdf0e10cSrcweir /** compares two bookmarks and returns an indication of their relative values. 103cdf0e10cSrcweir 104cdf0e10cSrcweir <p> 105cdf0e10cSrcweir The bookmarks must apply to the same ResultSet. You cannot reliably 106cdf0e10cSrcweir compare bookmarks from different ResultSets, even if they were created from 107cdf0e10cSrcweir the same source or statement. 108cdf0e10cSrcweir <br/> 109cdf0e10cSrcweir A bookmark that is not valid, or incorrectly formed, will cause an exception. 110cdf0e10cSrcweir </p> 111cdf0e10cSrcweir @param first 112cdf0e10cSrcweir the first bookmark 113cdf0e10cSrcweir @param second 114cdf0e10cSrcweir the second bookmark 115cdf0e10cSrcweir @returns 116cdf0e10cSrcweir a value of <type scope="com::sun::star::sdbcx">CompareBookmark</type> 117cdf0e10cSrcweir @throws com::sun::star::sdbc::SQLException 118cdf0e10cSrcweir if a database access error occurs. 119cdf0e10cSrcweir 120cdf0e10cSrcweir @see com::sun::star::sdbcx::CompareBookmark 121cdf0e10cSrcweir 122cdf0e10cSrcweir */ 123cdf0e10cSrcweir long compareBookmarks([in]any first, [in]any second) 124cdf0e10cSrcweir raises (com::sun::star::sdbc::SQLException); 125cdf0e10cSrcweir //------------------------------------------------------------------------- 126cdf0e10cSrcweir 127cdf0e10cSrcweir /** determines whether the bookmarks of a result set are ordered or not. 128cdf0e10cSrcweir @returns 129cdf0e10cSrcweir <TRUE/> if so 130cdf0e10cSrcweir @throws com::sun::star::sdbc::SQLException 131cdf0e10cSrcweir if a database access error occurs. 132cdf0e10cSrcweir @see com::sun::star::sdbcx::CompareBookmark 133cdf0e10cSrcweir */ 134cdf0e10cSrcweir boolean hasOrderedBookmarks() raises (com::sun::star::sdbc::SQLException); 135cdf0e10cSrcweir //------------------------------------------------------------------------- 136cdf0e10cSrcweir 137cdf0e10cSrcweir /** returns the hash value for a specified bookmark. 138cdf0e10cSrcweir @param bookmark 139cdf0e10cSrcweir the bookmark to hash 140cdf0e10cSrcweir @returns 141cdf0e10cSrcweir the hashed value 142cdf0e10cSrcweir @throws com::sun::star::sdbc::SQLException 143cdf0e10cSrcweir if a database access error occurs. 144cdf0e10cSrcweir */ 145cdf0e10cSrcweir long hashBookmark([in]any bookmark) raises (com::sun::star::sdbc::SQLException); 146cdf0e10cSrcweir}; 147cdf0e10cSrcweir 148cdf0e10cSrcweir//============================================================================= 149cdf0e10cSrcweir 150cdf0e10cSrcweir}; }; }; }; 151cdf0e10cSrcweir 152cdf0e10cSrcweir/*=========================================================================== 153cdf0e10cSrcweir===========================================================================*/ 154cdf0e10cSrcweir#endif 155