/*************************************************************************
*
* $RCSfile: PreparedStatement.idl,v $
*
* $Revision: 1.13 $
*
* last change: $Author: hr $ $Date: 2003-03-26 13:55:24 $
*
* 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_PreparedStatement_idl__
#define __com_sun_star_sdbc_PreparedStatement_idl__
#ifndef __com_sun_star_lang_XComponent_idl__
#include
A SQL statement is pre-compiled and stored in a PreparedStatement object.
This object can then be used to efficiently execute this statement multiple
times.
Note:
The
If arbitrary parameter type conversions are required, the method
Example of setting a parameter; setXXX
methods for setting IN parameter values
must specify types that are compatible with the defined SQL type of
the input parameter. For instance, if the IN parameter has SQL type
Integer, then the method
con
is an active connection.
@example:StarBASIC
Only one
execute
methods implicitly close a statement's current ResultSet if an open one exists.
A driver implementing batch execution must return
This limit is the maximum number of bytes that can be returned
for any column value. The limit applies only to
There is no limitation, if set to zero.
*/ [property] long MaxFieldSize; // DocMerge from idl: property com::sun::star::sdbc::PreparedStatement::MaxRows /** retrieves the maximum number of rows that a ResultSet can contain. If the limit is exceeded, the excess rows are silently dropped.execute
methods.
This name can then be used in SQL positioned update/delete statements to identify the current row in the ResultSet generated by this statement. If the database does not support positioned update/delete, this property is a noop. To insure that a cursor has the proper isolation level to support updates, the cursor's SELECT statement should be of the form 'select for update ...'. If the 'for update' phrase is omitted, positioned updates may fail.
Note: By definition, positioned update/delete execution must be done by a different Statement than the one which generated the ResultSet being used for positioning. Also, cursor names must be unique within a connection.
*/ [property] string CursorName; // DocMerge from idl: property com::sun::star::sdbc::PreparedStatement::ResultSetConcurrency /** retrieves the result set concurrency. @see com::sun::star::sdbc::ResultSetConcurrency */ [property] long ResultSetConcurrency; // DocMerge from idl: property com::sun::star::sdbc::PreparedStatement::ResultSetType /** Determine the result set type. @see com::sun::star::sdbc::ResultSetType */ [property] long ResultSetType; // DocMerge from idl: property com::sun::star::sdbc::PreparedStatement::FetchDirection /** retrieves the direction for fetching rows from database tables that is the default for result sets generated from thisStatement
object.
If this
Statement
object has not set a fetch direction,
the return value is implementation-specific.
Statement
object.
If this
Statement
object has not set a fetch size,
the return value is implementation-specific.