/aoo41x/main/offapi/com/sun/star/sdbc/ |
H A D | XSQLInput.idl | 59 instance of a SQL structured or distinct type. 92 the attribute; if the value is SQL NULL, return null. 101 the attribute; if the value is SQL NULL, return null. 110 the attribute; if the value is SQL NULL, return null. 119 the attribute; if the value is SQL NULL, return null. 128 the attribute; if the value is SQL NULL, return null. 137 the attribute; if the value is SQL NULL, return null. 146 the attribute; if the value is SQL NULL, return null. 155 the attribute; if the value is SQL NULL, return null. 164 the attribute; if the value is SQL NULL, return null. [all …]
|
H A D | XRow.idl | 71 /** reports whether the last column read had a value of SQL NULL. 74 SQL NULL. 77 <TRUE/> if last column read was SQL NULL and <FALSE/> otherwise 88 the column value; if the value is SQL NULL, the result is null 99 the column value; if the value is SQL NULL, the result is null 110 the column value; if the value is SQL NULL, the result is null 121 the column value; if the value is SQL NULL, the result is null 132 the column value; if the value is SQL NULL, the result is null 143 the column value; if the value is SQL NULL, the result is null 154 the column value; if the value is SQL NULL, the result is null [all …]
|
H A D | XStatement.idl | 40 /** is used for executing a static SQL statement and obtaining the results 58 /** executes a SQL statement that returns a single ResultSet. 60 the SQL statement which should be executed 69 /** executes an SQL INSERT, UPDATE, or DELETE statement. In addition, 70 SQL statements that return nothing, such as SQL DDL statements, 74 a SQL INSERT, UPDATE or DELETE statement or a SQL statement that returns nothing 83 /** executes a SQL statement that may return multiple results. 87 Under some (uncommon) situations a single SQL statement may return 91 unknown SQL string. The navigation through multiple results is covered by 97 method executes a SQL statement and indicates [all …]
|
H A D | XArray.idl | 43 /** is used for mapping the SQL type 49 reference to an SQL array. By default, an 53 is implemented using a SQL LOCATOR(array) internally. 58 /** returns the SQL type name of the elements in 66 this method returns the fully-qualified SQL type name. 91 /** retrieves the contents of the SQL array designated by this 103 is a map object that contains mappings of SQL type names to 114 of the SQL array designated by this object. 129 successive elements of the SQL array. 149 of the SQL array, beginning with element [all …]
|
H A D | XConnection.idl | 50 database. Within the context of a Connection, SQL statements are 56 describing its tables, its supported SQL grammar, its stored 72 object for sending SQL statements to the database. 76 SQL statements without parameters are normally 77 executed using Statement objects. If the same SQL statement 104 A SQL statement with or without IN parameters can be 115 parametric SQL statements that benefit from precompilation. If 182 /** converts the given SQL statement into the system's native SQL grammar. 183 A driver may convert the JDBC SQL grammar into its system's 201 If a connection is in auto-commit mode, then all its SQL [all …]
|
H A D | XSQLData.idl | 40 /** is used for the custom mapping of SQL user-defined types. 54 /** returns the fully-qualified name of the SQL user-defined type 63 the name of the SQL type. 77 It must read each of the attributes or elements of the SQL 80 item, in the order that they appear in the SQL definition 90 for a Structured Type, read a value for each attribute of the SQL type. 100 the input SQL data stream 102 the SQL type of the value on the data stream 112 /** writes this object to the given SQL data stream. 118 It must write each of the attributes of the SQL type to the given output [all …]
|
H A D | XParameters.idl | 74 should be used with a target SQL type. 90 /** sets the designated parameter to SQL NULL. 104 SQL type code and the fully-qualified SQL type name when specifying 131 to a SQL BIT value when it sends it to the database. 245 to a SQL DATE value when it sends it to the database. 258 to a SQL TIME value when it sends it to the database. 331 to the SQL data stream. 334 value of the corresponding SQL type. 358 to the SQL data stream. 361 value of the corresponding SQL type. [all …]
|
H A D | XPreparedStatement.idl | 40 /** provides the possibilty of executing a precompiled SQL statement. 44 A SQL statement is pre-compiled and stored in a PreparedStatement object. 52 /** executes the SQL query in this 63 /** executes the SQL INSERT, UPDATE or DELETE statement in this 67 In addition, SQL statements that return nothing, such as 68 SQL DDL statements, can be executed. 70 …either the row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return … 77 /** executes any kind of SQL statement.
|
H A D | PreparedStatement.idl | 49 /** represents a precompiled SQL statement. 51 A SQL statement is pre-compiled and stored in a PreparedStatement object. 62 must specify types that are compatible with the defined SQL type of 63 the input parameter. For instance, if the IN parameter has SQL type 71 should be used with a target SQL type. 112 /** could be used for cancelling the execution of SQL statements, if both 113 the DBMS and the driver support aborting an SQL statement. 118 /** is the interface for executing SQL prepared commands. 154 /** covers the handling of multiple results after executing an SQL command. 199 /** defines the SQL cursor name that will be used by subsequent Statement [all …]
|
H A D | DataType.idl | 30 to identify the generic SQL types. The definition is based on JDBC 3.0. 83 /** indicates that the SQL type is database-specific and 110 /** indicates a type representing an SQL ARRAY. 115 /** indicates a type representing an SQL Binary Large Object. 120 /** indicates a type representing an SQL Character Large Object. 125 /** indicates a type representing an SQL REF, a referencing type. 129 /** identifies the generic SQL type
|
H A D | XStruct.idl | 41 /** is used for the standard mapping for a SQL structured type. 48 of the SQL structured type that it represents. 58 /** retrieves the SQL type name of the SQL structured type 63 the name of the SQL type. 71 /** produces the ordered values of the attributes of the SQL 85 is a map object that contains mappings of SQL type names to
|
H A D | Statement.idl | 47 /** is used for executing a static SQL statement and obtaining the results 75 /** could be used for cancelling the execution of SQL statements if both 76 the DBMS and the driver support aborting an SQL statement. 81 /** is the interface for executing SQL commands. 105 /** covers the handling of multiple results after executing an SQL command. 152 /** defines the SQL cursor name that will be used by subsequent Statement 157 This name can then be used in SQL positioned update/delete statements to 220 escape substitution before sending the SQL to the database.
|
H A D | XClob.idl | 41 /** is the mapping for the SQL 47 A SQL 54 object using a SQL 59 contains a logical pointer to the SQL 71 length of a SQL 94 access the SQL
|
H A D | XBlob.idl | 41 /** is the representation (mapping) of an SQL 48 A SQL 59 SQL 63 object contains a logical pointer to the SQL 84 allow a programmer to access the SQL 92 interface provides methods for getting the length of a SQL
|
H A D | XDatabaseMetaData.idl | 285 /** What's the string used to quote SQL identifiers? 399 The SQL AS clause can be used to provide names for 559 /** <TRUE/>, if the database supports ODBC Core SQL grammar, 599 <TRUE/>, if the database supports ANSI92 full SQL grammar, 864 /** Is SQL UNION supported? 873 /** Is SQL UNION ALL supported? 1064 /** return the maximum length of a SQL statement 1298 <b>DATA_TYPE</b> short => SQL type from java.sql.Types 1488 <b>DATA_TYPE</b> short => SQL type from java.sql.Types 1692 <b>DATA_TYPE</b> short => SQL data type from java.sql.Types [all …]
|
/aoo41x/main/connectivity/source/parse/ |
H A D | sqlflex.l | 104 %s SQL 429 <SQL>[A-Za-z\200-\277\300-\337\340-\357\360-\367\370-\373\374-\375][A-Za-z\200-\277\300-\337\340-\3… 431 <SQL>([0-9]+) | 432 <SQL>([0-9]+"."[0-9]*) | 433 <SQL>("."[0-9]*) {SQL_NEW_INTNUM; } 435 <SQL>[0-9]+[eE][+-]?[0-9]+ | 436 <SQL>[0-9]+"."[0-9]*[eE][+-]?[0-9]+ | 437 <SQL>"."[0-9]*[eE][+-]?[0-9]+ {SQL_NEW_APPROXNUM; } 461 <SQL>\" { return gatherString('\"',0); } 462 <SQL>` { return gatherString('`' ,0); } [all …]
|
/aoo41x/main/offapi/com/sun/star/sdb/ |
H A D | QueryDesign.idl | 42 /** implements a component which allows the creation of SQL statements. 44 …<p>This service implements a user interface for creating SQL statements either through a graphical… 45 interface or simply to enter the SQL statement directly.</p> 48 …where columns can be selected for the SQL statement. The second part contains the columns which sh… 49 in the selection of the SQL statement or criterias which narrow the query.</p> 66 … <p>In <code>Command Mode</code>, the designer is used to design an standalone SQL command.</p> 86 …ecifies the name of the globally registered <type>DataSource</type> for which a query, view, or SQL 101 being <member>CommandType::COMMAND</member>, the initial SQL command.<br/> 119 <a href="#command_mode">command mode</a>, that is, a standalone SQL command 120 should be designed. When the user attempts to save the designed SQL statement, [all …]
|
H A D | XSingleSelectQueryAnalyzer.idl | 185 which in some respect understands SQL features usually not present at the database 191 … as if it really is a table -, <code>getQueryWithSubstitution</code> gives you the SQL statement 192 where all those features have been stripped, and replaced with appropriate standard SQL.</p> 195 This query is not known to the underlying database, so an SQL statement like 226 means in case the <member>Command</member> specifies an SQL statement, the inherited 229 It then can be to used to specify whether the SQL statement should be analyzed on the 232 is <TRUE/>. By switching it to <FALSE/>, you can pass backend-specific SQL statements, 233 which are not standard SQL, to your database.</p>
|
H A D | XCommandPreparation.idl | 40 A command could be a table, query, or any kind of SQL statement 49 object for sending parameterized SQL statements to the database. 52 A SQL statement with or without IN parameters can be 58 the command to be prepared. Any SQL statement.
|
H A D | SQLQueryComposer.idl | 38 /** represents a tool for composing SQL select statements. 42 It hides the complexity of parsing and evaluating SQL Statements and provides 43 sophisticated methods for expanding a SQL-Statement with filter and order
|
/aoo41x/main/offapi/com/sun/star/chart2/data/ |
H A D | XDatabaseDataProvider.idl | 92 For instance, you could base the report on the SQL statement 116 means in case the <member>Command</member> specifies an SQL statement, the inherited 119 It then can be to used to specify whether the SQL statement should be analyzed on the 122 is <TRUE/>. By switching it to <FALSE/>, you can pass backend-specific SQL statements, 123 which are not standard SQL, to your database.</p> 143 <p>The Filter string has to form a SQL WHERE-clause, <em>without</em> the WHERE-string itself.</p> 184 backend-specific SQL statements, which are not standard SQL, to your database.</p>
|
/aoo41x/main/dbaccess/source/ui/querydesign/ |
H A D | query.src | 258 Text [ en-US ] = "The SQL statement created is too long."; 274 Text [ en-US ] = "SQL syntax error" ; 287 …Text [ en-US ] = "The statement will not be applied when querying in the SQL dialect of the databa… 300 Text [ en-US ] = "Syntax error in SQL statement" ; 374 Text [ en-US ] = "$object$ is based on an SQL command which could not be parsed."; 379 Text [ en-US ] = "$object$ will be opened in SQL view."; 394 Text [ en-US ] = "The SQL statement";
|
/aoo41x/main/offapi/com/sun/star/form/binding/ |
H A D | BindableDataAwareControlModel.idl | 75 External value bindings overrule any active SQL-column binding. If an external 76 component is bound to a control model which currently has an active SQL binding, 77 this SQL binding is suspended, until the external binding is revoked. 81 difference to SQL bindings, which only are effective when the parent form 87 in the external binding. This is a difference to SQL bindings of most 114 column of an SQL <type scope="com::sun::star::form::component">DataForm</type>.
|
/aoo41x/main/offapi/com/sun/star/form/component/ |
H A D | DatabaseListBox.idl | 53 form which the list box belongs to, but can be based on an arbitrary table or SQL statement.</p> 101 <member scope="com::sun::star::form">ListSourceType::SQL</member> or 130 <dt><member scope="com::sun::star::form">ListSourceType::SQL</member></dt> 132 contains the SQL statement which the list result set should be based on.</p> 136 contains the SQL statement which the list result set should be based on.<br/> 138 … SQL features here, but, on the other hand, loose features like parameter value substitution.</dd>
|
/aoo41x/main/offapi/com/sun/star/report/ |
H A D | XReportDefinition.idl | 215 means in case the <member>Command</member> specifies an SQL statement, the inherited 218 It then can be to used to specify whether the SQL statement should be analyzed on the 221 is <TRUE/>. By switching it to <FALSE/>, you can pass backend-specific SQL statements, 222 which are not standard SQL, to your database.</p> 242 … <p>The Filter string has to form a SQL WHERE-clause, <em>without</em> the WHERE-string itself.</p> 260 backend-specific SQL statements, which are not standard SQL, to your database.</p>
|