(incubating) | The Free and Open Productivity Suite
Announcing Apache OpenOffice 3.4

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for OpenOffice.org version 3.3.

:: com :: sun :: star :: sdb ::

interface XCommandPreparation
Description
is used for preparation of commands.

A command could be a table, query, or any kind of SQL statement prepared by the user.

Developers Guide
Database - PreparedStatement From DataSource Queries

Methods' Summary
prepareCommand creates a ::com::sun::star::sdbc::PreparedStatement object for sending parameterized SQL statements to the database.  
Methods' Details
prepareCommand
::com::sun::star::sdbc::XPreparedStatement
prepareCommand( [in] string  command,
[in] long  commandType )
raises( ::com::sun::star::sdbc::SQLException );

Description
creates a ::com::sun::star::sdbc::PreparedStatement object for sending parameterized SQL statements to the database.

A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Parameter command
the command to be prepared. Any SQL statement.
Parameter commandType
kind of the command CommandType
Returns
the PreparedStatement object
Throws
com::sun::star::sdbc::SQLException if a database access error occurs.
Top of Page

Apache Feather

Copyright & License | Privacy | Contact Us

Apache and the Apache feather logos are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.