#95146# new interface to query for autogenerated values

4 files changed, 128 insertions, 6 deletions

diff --git a/offapi/com/sun/star/sdbc/PreparedStatement.idl b/offapi/com/sun/star/sdbc/PreparedStatement.idl
index f4d4de5eed05..7e08b7b8a960 100644
--- a/offapi/com/sun/star/sdbc/PreparedStatement.idl
+++ b/offapi/com/sun/star/sdbc/PreparedStatement.idl
@@ -2,9 +2,9 @@
  *
  *  $RCSfile: PreparedStatement.idl,v $
  *
- *  $Revision: 1.7 $
+ *  $Revision: 1.8 $
  *
- *  last change: $Author: mi $ $Date: 2001-11-01 16:46:46 $
+ *  last change: $Author: oj $ $Date: 2002-07-19 10:09:03 $
  *
  *  The Contents of this file are made available subject to the terms of
  *  either of the following licenses
@@ -82,6 +82,7 @@ interface XWarningsSupplier;
 interface XMultipleResults;
 interface XResultSetMetaDataSupplier;
 interface XCloseable;
+interface XGeneratedResultSet;
 
 
 // DocMerge from idl: service com::sun::star::sdbc::PreparedStatement
@@ -136,6 +137,10 @@ service PreparedStatement
      */
     [optional] interface com::sun::star::util::XCancellable;
 
+    /** could be used to retrieve a result set which gives access to automatically generated values after an insert statement.
+             The implementation is optional.
+     */
+    [optional] interface com::sun::star::sdbc::XGeneratedResultSet;
 
     // DocMerge from xml: service com::sun::star::sdbc::PreparedStatement: interface com::sun::star::sdbc::XPreparedStatement
     /** is the interface for executing SQL prepared commands.
@@ -264,6 +269,9 @@ service PreparedStatement
 
 /*===========================================================================
     $Log: not supported by cvs2svn $
+    Revision 1.7  2001/11/01 16:46:46  mi
+    proofreading and corrections from Richard Holt
+
     Revision 1.6  2001/02/20 13:30:07  fs
     #82875# removed XClearParameters - this interface is obsolete, the functionality is covered by XParameters
 
diff --git a/offapi/com/sun/star/sdbc/Statement.idl b/offapi/com/sun/star/sdbc/Statement.idl
index 7294d8ecfb9b..cf6041a873c7 100644
--- a/offapi/com/sun/star/sdbc/Statement.idl
+++ b/offapi/com/sun/star/sdbc/Statement.idl
@@ -2,9 +2,9 @@
  *
  *  $RCSfile: Statement.idl,v $
  *
- *  $Revision: 1.6 $
+ *  $Revision: 1.7 $
  *
- *  last change: $Author: mi $ $Date: 2001-11-01 16:46:46 $
+ *  last change: $Author: oj $ $Date: 2002-07-19 10:09:02 $
  *
  *  The Contents of this file are made available subject to the terms of
  *  either of the following licenses
@@ -80,6 +80,7 @@ interface XStatement;
 interface XBatchExecution;
 interface XMultipleResults;
 interface XCloseable;
+interface XGeneratedResultSet;
 
 
 // DocMerge from xml: service com::sun::star::sdbc::Statement
@@ -118,6 +119,11 @@ service Statement
      */
     [optional] interface com::sun::star::util::XCancellable;
 
+    /** could be used to retrieve a result set which gives access to automatically generated values after an insert statement.
+             The implementation is optional.
+     */
+    [optional] interface com::sun::star::sdbc::XGeneratedResultSet;
+
 
     // DocMerge from xml: service com::sun::star::sdbc::Statement: interface com::sun::star::sdbc::XStatement
     /** is the interface for executing SQL commands.
@@ -246,6 +252,9 @@ service Statement
 
 /*===========================================================================
     $Log: not supported by cvs2svn $
+    Revision 1.6  2001/11/01 16:46:46  mi
+    proofreading and corrections from Richard Holt
+
     Revision 1.5  2001/01/23 10:08:29  mi
     optional interfaces now marked as [optional] instead of just a prosa description of this fact
 
diff --git a/offapi/com/sun/star/sdbc/XGeneratedResultSet.idl b/offapi/com/sun/star/sdbc/XGeneratedResultSet.idl
new file mode 100644
index 000000000000..3d7ce9094b18
--- /dev/null
+++ b/offapi/com/sun/star/sdbc/XGeneratedResultSet.idl
@@ -0,0 +1,104 @@
+/*************************************************************************
+ *
+ *  $RCSfile: XGeneratedResultSet.idl,v $
+ *
+ *  $Revision: 1.1 $
+ *
+ *  last change: $Author: oj $ $Date: 2002-07-19 10:08:32 $
+ *
+ *  The Contents of this file are made available subject to the terms of
+ *  either of the following licenses
+ *
+ *         - GNU Lesser General Public License Version 2.1
+ *         - Sun Industry Standards Source License Version 1.1
+ *
+ *  Sun Microsystems Inc., October, 2000
+ *
+ *  GNU Lesser General Public License Version 2.1
+ *  =============================================
+ *  Copyright 2000 by Sun Microsystems, Inc.
+ *  901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ *  This library is free software; you can redistribute it and/or
+ *  modify it under the terms of the GNU Lesser General Public
+ *  License version 2.1, as published by the Free Software Foundation.
+ *
+ *  This library is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ *  Lesser General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Lesser General Public
+ *  License along with this library; if not, write to the Free Software
+ *  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ *  MA  02111-1307  USA
+ *
+ *
+ *  Sun Industry Standards Source License Version 1.1
+ *  =================================================
+ *  The contents of this file are subject to the Sun Industry Standards
+ *  Source License Version 1.1 (the "License"); You may not use this file
+ *  except in compliance with the License. You may obtain a copy of the
+ *  License at http://www.openoffice.org/license.html.
+ *
+ *  Software provided under this License is provided on an "AS IS" basis,
+ *  WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
+ *  WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ *  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ *  See the License for the specific provisions governing your rights and
+ *  obligations concerning the Software.
+ *
+ *  The Initial Developer of the Original Code is: Sun Microsystems, Inc.
+ *
+ *  Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ *  All Rights Reserved.
+ *
+ *  Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************/
+#ifndef __com_sun_star_sdbc_XGeneratedResultSet_idl__
+#define __com_sun_star_sdbc_XGeneratedResultSet_idl__
+
+#ifndef __com_sun_star_uno_XInterface_idl__
+#include <com/sun/star/uno/XInterface.idl>
+#endif
+
+#ifndef __com_sun_star_sdbc_SQLException_idl__
+#include <com/sun/star/sdbc/SQLException.idl>
+#endif
+
+ module com {  module sun {  module star {  module sdbc {
+
+interface XResultSet;
+
+// DocMerge from xml: interface com::sun::star::sdbc::XGeneratedResultSet
+/** provides a result set which gives access to automatically generated values after a new row was inserted.
+
+    @see com::sun::star::sdbc::Statement
+    @see com::sun::star::sdbc::PreparedStatement
+    @since #95146#
+ */
+interface XGeneratedResultSet: com::sun::star::uno::XInterface
+{
+    //-------------------------------------------------------------------------
+    /** gives access to automatically generated values after a new row was inserted.
+        @returns
+            a result set that contains the data produced by the query
+        @throws SQLException
+            if a database access error occurs.
+    */
+    XResultSet getGeneratedValues() raises (SQLException);
+
+};
+
+//=============================================================================
+
+}; }; }; };
+
+/*===========================================================================
+    $Log: not supported by cvs2svn $
+
+===========================================================================*/
+#endif
diff --git a/offapi/com/sun/star/sdbc/makefile.mk b/offapi/com/sun/star/sdbc/makefile.mk
index 0a14d8252e1d..06758516ecae 100644
--- a/offapi/com/sun/star/sdbc/makefile.mk
+++ b/offapi/com/sun/star/sdbc/makefile.mk
@@ -2,9 +2,9 @@
 #
 #   $RCSfile: makefile.mk,v $
 #
-#   $Revision: 1.4 $
+#   $Revision: 1.5 $
 #
-#   last change: $Author: oj $ $Date: 2001-04-26 10:40:37 $
+#   last change: $Author: oj $ $Date: 2002-07-19 10:09:06 $
 #
 #   The Contents of this file are made available subject to the terms of
 #   either of the following licenses
@@ -133,6 +133,7 @@ IDLFILES=\
     XSQLOutput.idl \
     XStatement.idl \
     XStruct.idl \
+    XGeneratedResultSet.idl \
     XWarningsSupplier.idl
 
 # ------------------------------------------------------------------