Help Center›AfxNova
Databases
645 entries across 11 topics.
Topics
CAdoCommand Class
32 members
CAdoConnection Class
22 members
CADODB
14 members
CAdoEvents Class
20 members
CAdoFields Class
26 members
CAdoRecord Class
19 members
CADORecordset Class
57 members
CAdoStream Class
22 members
CODBCStmt Class
182 members
CSQLite Class
81 members
ODBC Classes
29 members
All entries
CAdoBase 14
ADO ErrorsADO errors.ADO IdentifiersPROGIDs, CLSIDs and IIDs.ADO Object ModelADO objects and their collections.ADO PropertiesRepresents a dynamic characteristic of an ADO object that is defined by the provider.AttributesFor a **Property** object, the **Attributes** property is read-only, and its value can be the sum of any one or more **PropertyAttributesEnum** values.ConstructorCountRetrieves the number of objects of the **Properties** collection.GetLastResultItemIndicates a specific member of the **Properties** collection, by name or ordinal number.NameReturns the name of a **Property**.RefreshRefreshes the contents of the **Properties** collection.SetResultType_Returns a **DataTypeEnum** value that indicates the operational type or data type of a **Property** object.ValueSets or returns a Variant value that indicates the value of the object. Default value depends on the **Type_** property.
CADOCommand 16
ActiveConnectionDetermines the **Connection** object over which the specified **Command** object will execute.CancelCancels execution of a pending, asynchronous method call.CommandStreamSets or returns the stream used as the input for a **Command** object.CommandTextSets or returns a string value that contains a provider command, such as an SQL statement, a table name, a relative URL, or a stored procedure call.CommandTimeoutSets or returns a Long value that indicates, in seconds, how long to wait for a command to execute.CommandTypeSets or returns one or more **CommandTypeEnum** values.CreateParameterCreates a new **Parameter** object with the specified properties.DialectIndicates the dialect of the **CommandText** or **CommandStream** properties.ExecuteExecutes the query, SQL statement, or stored procedure specified in the **CommandText** or **CommandStream** property.GetErrorInfoReturns information about ADO errors.NameSets or returns a string value that indicates the name of a **Command** object.NamedParametersIndicates whether parameter names should be passed to the provider.ParametersReturns a reference to the **Parameters** collection.PreparedSets or returns a Boolean value that, if set to True, indicates that the command should be prepared.PropertiesReturns a reference to the **Properties** collection.StateIndicates if the **Command** object is open or closed.
CAdoCommand 3
CAdoConnection 26
AttachAttributesIndicates one or more characteristics of an object.BeginTransBegins a new transaction.CancelCancels execution of a pending, asynchronous method call.CloseCloses a `Connection` object and any dependent objects.CommandTimeoutSets or returns a Long value that indicates, in seconds, how long to wait for a command to execute. Default is 30.CommitTransSaves any changes and ends the current transaction. It may also start a new transaction.ConnectionStringIndicates the information used to establish a connection to a data source.ConnectionTimeoutIndicates how long to wait while establishing a connection before terminating the attempt and generating an error.ConstructorCursorLocationIndicates the location of the cursor service.DefaultDatabaseIndicates the default database for a `Connection` object.ErrorsExecuteExecutes the specified query, SQL statement, stored procedure, or provider-specific text.GetErrorInfoReturns information about ADO errors.IsolationLevelIndicates the level of isolation for a `Connection` object.ModeIndicates the available permissions for modifying data in a `Connection` object.OpenOpens a connection to a data source.OpenSchemaObtains database schema information from the provider.PropertiesReturns a reference to the **Properties** collection.ProviderIndicates the name of the provider for a `Connection` object.RollbackTransSaves any changes and ends the current transaction. It may also start a new transaction.SetEventsSets the events sink.StateIndicates if a `Connection` is open or closed.VersionIndicates the ADO version number.vptr
CAdoConnectionEvents 10
BeginTransCompleteCommitTransCompleteConnectCompleteConstructorDisconnectExecuteCompleteInfoMessageRollbackTransCompleteWillConnectWillExecute
CAdoError 10
AttachConstructorDescriptionHelpContextHelpFileNativeErrorNumberSourceIndicates the name of the object or application that originally generated an error.SQLStateIndicates the name of the object or application that originally generated an error.vptr
CAdoErrors 8
CAdoEvents 20
BeginTransCompleteCalled after the **BeginTrans** operation.CommitTransCompleteCalled after the **CommitTrans** operation.ConnectCompleteCalled after a connection starts.DisConnectCalled after a connection ends.EndOfRecordsetCalled when there is an attempt to move to a row past the end of the **Recordset**.ExecuteCompleteCalled after a command has finished executing.FetchCompleteCalled after all the records in a lengthy asynchronous operation have been retrieved into the **Recordset**.FetchProgressCalled periodically during a lengthy asynchronous operation to report how many rows have currently been retrieved into the **Recordset**.FieldChangeCompleteCalled after the value of one or more Field objects has changed.InfoMessageCalled whenever a warning occurs during a **ConnectionEvent** operation.MoveCompleteCalled after the current position in the **Recordset** changes.RecordChangeCompleteCalled after one or more records change.RecordsetChangeCompleteRollbackTransCompleteCalled after the **RollbackTrans** operation.WillChangeFieldCalled before a pending operation changes the value of one or more **Field** objects in the **Recordset**.WillChangeRecordCalled before one or more records (rows) in the **Recordset** change.WillChangeRecordsetCalled before a pending operation changes the **Recordset**.WillConnectCalled before a connection starts.WillExecuteCalled just before a pending command executes on this connection and affords the user an opportunity to examine and modify the pending execution parameters.WillMoveThe **WillMove** event is called before a pending operation changes the current position in the **Recordset**.
CADOField 16
ActualSizeIndicates the actual length of a field's value.AppendChunkAppends data to a large text or binary data `Field`.AttachAttaches a reference to a `Field` object to the class.AttributesIndicates one or more characteristics of a field.DataFormatLinks the current `Field` object to a data-bound control.DefinedSizeIndicates the data capacity of a field.GetChunkReturns all, or a portion, of the contents of a large text or binary data field.NameReturns the name of the field.NumericScaleSets or returns a Byte value that indicates the number of decimal places to which numeric values will be resolved.OriginalValueIndicates the value of a field that existed in the record before any changes were made.PrecisionSets or returns a Byte value that indicates the maximum number of digits used to represent values.PropertiesReturns a reference to the Properties collection.StatusIndicates the status of a field.Type_Sets or returns a **DataTypeEnum** value.UnderlyingValueIndicates a field's current value in the database.ValueSets or returns a Variant value that indicates the value of the object
CAdoField 2
CADOFields 9
AppendAppends an object to a collection.AttachAttaches a reference to a `Fields` object to the class.CancelUpdateCancels any changes made to the `Fields` collection of a `Record` object before calling the **Update** method.CountRetrieves the number of objects in the `Fields` collection.Delete_Deletes an object from the `Fields` collection.ItemIndicates a specific member of the `Fields` collection, by name or ordinal number.RefreshRefreshes the contents of the `Fields` collection.ResyncResynchronizes the contents of the `Fields` collection.UpdateSaves any changes you make to the current `Fields` collection of a `Record` object.
CAdoFields 3
CADOParameter 11
AppendChunkAppends data to a **Parameter** object.AttachAttaches a reference to an ADO **Parameter** object to the class.AttributesIndicates one or more characteristics of an object.DirectionIndicates whether the **Parameter** represents an input parameter, an output parameter, an input and an output parameter, or if the parameter is the return value from a stored procedure.NameSets or returns a string value that indicates the name of a **Parameter** object.NumericScaleIndicates the scale of numeric values in a **Parameter** object.PrecisionIndicates the degree of precision for numeric values in a **Parameter** object.PropertiesReturns a reference to the **Properties** collection.SizeSets or returns a Long value that indicates the maximum size in bytes or characters of a value in a **Parameter** objectType_Indicates the operational type or data type of a **Parameter** object.ValueIndicates the value assigned to a **Parameter** object.
CAdoParameter 2
CADOParameters 5
AppendAppends an object to the **Parameters** collection.CountRetrieves the number of objects of the **Parameters** collection.Delete_Deletes an object from the **Parameters** collection.ItemIndicates a specific member of the **Parameters** collection, by name or ordinal number.RefreshRefreshes the contents of the **Parameters** collection.
CAdoParameters 4
CAdoProperties 7
CAdoProperty 7
CAdoRecord 20
ActiveConnectionIndicates to which `Connection` object the specified `Record` object currently belongs.AttachAttaches a reference to an ADO `Record` object to the class.CancelCancels execution of a pending, asynchronous method call.CloseCloses a `Record` object and any dependent objects.ConstructorCopyRecordCopies an entity represented by a Record to another location.DeleteRecordDeletes the entity represented by a `Record`.FieldsGets a reference to the Fields collection of a `Record` object.GetChildrenReturns a `Recordset` whose rows represent the children of a collection `Record`.GetErrorInfoReturns information about ADO errors.ModeSets or returns a **ConnectModeEnum** value.MoveRecordMoves an entity represented by a `Record` to another location.OpenOpens an existing `Record` object, or creates a new item represented by the `Record` (such as a file or directory).ParentURLIndicates an absolute URL string that points to the parent `Record` of the current `Record` object.PropertiesReturns a reference to the **Properties** collection.PutRefSourceRecordTypeIndicates the type of `Record` object.SourceIndicates the data source or object represented by the `Record`.StateIndicates for all applicable objects whether the state of the object is open or closed.vptr
CADORecordset 57
AbsolutePageSets or returns a Long value from 1 to the number of pages in the `Recordset` object (**PageCount**), or returns one of the **PositionEnum** values.AbsolutePositionA value from 1 to the number of records in the `Recordset` object (**RecordCount**).ActiveCommandIndicates the `Command` object that created the associated `Recordset` object.ActiveConnectionSets or returns a BSTR value that contains a definition for a connection if the connection is closed, or a Variant containing the current **Connection** object if the connection is open. Default is a null object reference.AddNewCreates a new record for an updatable `Recordset` object.AttachAttaches a recordset to the class.BOFIndicates that the current record position is before the first record in a `Recordset` object.BookmarkSets or returns a Variant expression that evaluates to a valid bookmark.CacheSizeSets or returns a Long value that must be greater than 0. Default is 1.CancelCancels execution of a pending, asynchronous method call.CancelBatchCancels a pending batch update.CancelUpdateCancels any changes made to the current or new row of a `Recordset` object before calling the **Update** method.CloneCreates a duplicate `Recordset` object from an existing `Recordset` object. Optionally, specifies that the clone be read-only.CloseCloses a `Recordset` object and any dependent objects.CollectSets or returns a Variant value that indicates the value of the object.CompareBookmarksCompares two bookmarks and returns an indication of their relative values.CursorLocationIndicates the location of the cursor service.CursorTypeSets or returns a **CursorTypeEnum** value. The default value is **adOpenForwardOnly**.DataMemberIndicates the name of the data member that will be retrieved from the object referenced by the **DataSource** property.DataSourceIndicates an object that contains data to be represented as a `Recordset` object.Delete_Deletes the current record or a group of records.EditModeIndicates the editing status of the current record.EOFIndicates that the current record position is after the last record in a `Recordset` object.FieldsGets a reference to the `Fields` collection of a `Record` object.FilterIndicates a filter for data in a `Recordset`.FindSearches a `Recordset` for the row that satisfies the specified criteria.GetErrorInfoReturns information about ADO errors.GetRowsRetrieves multiple records of a `Recordset` object into an array.GetStringReturns the `Recordset` as a string.IndexSets or returns a string value, which is the name of the index.LockTypeSets or returns the lock type, a Long value that must be greater than 0. Default is 1.MarshalOptionsIndicates which records are to be marshaled back to the server.MaxRecordsSets or returns a Long value that indicates the maximum number of records to return. Default is zero (no limit).MoveMoves the position of the current record in a `Recordset` object.MoveFirstMoves to the first record in a specified `Recordset` object and makes that record the current record.MoveLastMoves to the last record in a specified `Recordset` object and makes that record the current record.MoveNextMoves to the next record in a specified `Recordset` object and makes that record the current record.MovePreviousMoves to the previous record in a specified `Recordset` object and makes that record the current record.NextRecordsetMoves to the previous record in a specified `Recordset` object and makes that record the current record.OpenOpens a connection to a data source.PageCountIndicates how many pages of data the `Recordset` object contains.PageSizeSets or returns a Long value that indicates how many records are on a page. The default is 10.PropertiesReturns a reference to the **Properties** collection.RecordCountIndicates the number of records in a `Recordset` object.RequeryUpdates the data in a `Recordset` object by re-executing the query on which the object is based.ResyncRefreshes the data in the current `Recordset` object from the underlying database.SaveSaves the `Recordset` in a file or **Stream** object.SeekSearches the index of a `Recordset` to quickly locate the row that matches the specified values, and changes the current row position to that row.SetEventsSets the events sink.SortSets or returns a string value that indicates the field names in the `Recordset` on which to sort.SourceIndicates the data source for a `Recordset` object.StateIndicates for whether the state of the `Recordset` object is open or closed.StatusIndicates for whether the state of the `Recordset` object is open or closed.StayInSyncIndicates, in a hierarchical `Recordset` object, whether the reference to the underlying child records (that is, the chapter) changes when the parent row position changes.SupportsDetermines whether a specified `Recordset` object supports a particular type of functionality.UpdateSaves any changes you make to the current row of a `Recordset` object.UpdateBatchWrites all pending batch updates to disk.
CAdoRecordset 2
CAdoRecordsetEvents 12
ConstructorEndOfRecordsetFetchCompleteFetchProgressFieldChangeCompleteMoveCompleteRecordChangeCompleteRecordsetChangeCompleteWillChangeFieldWillChangeRecordWillChangeRecordsetWillMove
CAdoStream 26
AttachAttaches an ADO `Stream` to the class.CancelCancels execution of a pending, asynchronous method call.CharsetIndicates the character set into which the contents of a text `Stream` should be translated for storage in the `Stream` object's internal buffer.CloseCloses a `Stream` object and any dependent objects.ConstructorCopyToCopies the specified number of characters or bytes (depending on **Type_**) in the `Stream` to another `Stream` object.EOSIndicates whether the current position is at the end of the stream.FlushForces the contents of the `Stream` remaining in the ADO buffer to the underlying object with which the `Stream` is associated.GetErrorInfoGetIStreamLineSeparatorIndicates the binary character to be used as the line separator in text `Stream` objects.LoadFromFileLoads the contents of an existing file into a `Stream`.ModeIndicates the available permissions for modifying data in a `Stream` object.OpenOpens a connection to a data source.PositionIndicates the current position within a `Stream` object.ReadReads a specified number of bytes from a binary Stream object.ReadTextReads a specified number of characters, an entire line, or the entire stream from a `Stream` object and returns the resulting string.SaveToFileSaves the binary contents of a `Stream` to a file.SetEOSSets the position that is the end of the stream.SizeIndicates the size of the stream in number of bytes.SkipLineSkips one entire line when reading a text stream.StateIndicates for whether the state of the `Stream` object is open or closed.Type_Indicates the type of data contained in the `Stream` (binary or text).vptrWriteWrites binary data to a `Stream` object.WriteTextWrites a string to a `Stream` object.
CODBC 15
CommitTranRequests a commit operation for all active operations on all statements associated with an environment.ConstructorsRequests a commit operation for all active operations on all statements associated with an environment.EnvHandleReturns the environment handle.FunctionsReturns information about whether a driver supports a specific ODBC function.GetConnectAttrReturns the current setting of a connection attribute.GetDiagFieldReturns the current value of a field of a record of the diagnostic data structure (associated with an environment handle) that contains error, warning, and status information.GetDiagRecReturns the current values of multiple fields of a diagnostic record that contains error, warning, and status information.GetErrorInfoReturns a verbose description of the last error.GetInfoReturns general information about the driver and data source associated with a connection.GetSqlStateReturns the SqlState for the connection handle.HandleReturns the connection handle.NativeSqlReturns the SQL string as modified by the driver. NativeSql does not execute the SQL statement.RollbackTranRollbackTran requests a rollback operation for all active operations on all statements associated with an environment.SetConnectAttrSets attributes that govern aspects of connections.SupportsReturns information about whether a driver supports a specific ODBC function. It is an alias for **Functions**.
COdbc 3
CODBCBase 14
ErrorReturns TRUE if there has been an error; FALSE, otherwise.GetCPMatchReturns a 32-bit SQLUINTEGER value that determines how a connection is chosen from a connection pool.GetDataSourcesLists available DSN / Drivers installed.GetDriversLists driver descriptions and driver attribute keywords.GetEnvAttrReturns the current setting of an environment attribute.GetErrorInfoReturns a verbose description of the last error(s).GetLastResultReturns the last result code.GetOutputNTSReturns a 32-bit integer that determines how the driver returns string data.GetSqlStateReturns the SqlState for the specified handle.ODBCVersionReturns a 32-bit integer that determines whether certain functionality exhibits ODBC 2.x behavior or ODBC 3.x behavior.SetCPMatchReturns a 32-bit SQLUINTEGER value that determines how a connection is chosen from a connection pool.SetEnvAttrSets attributes that govern aspects of environments.SetErrorProcSets the address of an application defined error callback.SetOutputNTSReturns a 32-bit integer that determines how the driver returns string data.
COdbcBase 1
CODBCStmt 182
AddRecordAdds a record to the database.BindColBinds application data buffers to columns in the result set.BindColToBitBindColToDecimalBindColToNumericBindParameterBinds a buffer to a parameter marker in an SQL statement.BulkOperationsPerforms bulk insertions and bulk bookmark operations.CancelCancels the processing on a statement.CloseCursorCloses a cursor that has been opened on a statement and discards pending results.ColAttributeReturns descriptor information for a column in a result set.ColAutoUniqueValueChecks if the column is an autoincrementing column or not.ColBaseColumnNameReturns the base column name for the result set column.ColBaseTableNameReturns the name of the base table that contains the column.ColCaseSensitiveChecks if the column is treated as case-sensitive for collations and comparisons.ColCatalogNameReturns the catalog of the table that contains the column.ColConciseTypeReturns the concise data type.ColCountReturns the number of columns available in the result set.ColDisplaySizeReturns the maximum number of characters required to display data from the column.ColFixedPrecScaleChecks if column has a fixed precision and nonzero scale that are data source-specific.ColIsNullChecks if the column is null.ColLabelReturns the column label or title.ColLengthReturns the maximum or actual character length of a character string or binary data type.ColLiteralPrefixReturns the character or characters that the driver recognizes as a prefix for a literal of this data type.ColLiteralSuffixReturns the character or characters that the driver recognizes as a suffix for a literal of this data type.ColLocalTypeNameReturns the localized (native language) name for the data type that may be different from the regular name of the data type.ColNameReturns the column alias, if it applies.ColNullableChecks if the column can have NULL values.ColNumPrecRadixReturns the column numeric precision radix.ColOctetLengthThe length, in bytes, of a character string or binary data type.ColPrecisionA numeric value that for a numeric data type denotes the applicable precision.ColScaleA numeric value that is the applicable scale for a numeric data type.ColSchemaNameThe schema of the table that contains the column.ColSearchableIndicates if the column data type is searchable.ColTableNameThe name of the table that contains the column.ColTypeA numeric value that specifies the SQL data type.ColTypeNameData source-dependent data type name.ColUnnamedSQL_NAMED or SQL_UNNAMED. If the SQL_DESC_NAME field of the IRD contains a column alias or a column name, SQL_NAMED is returned.ColUnsignedSQL_TRUE if the column is unsigned (or not numeric). SQL_FALSE if the column is signed.ColUpdatableSQL_TRUE if the column is updatable; SQL_FALSE otherwise.ConstructorsAllocates a statement handle.DbcHandleReturns the connection handle.DeleteByBookmarkDeletes a set of rows where each row is identified by a bookmark.DeleteRecordDeletes the specified row of data.DescribeColReturns the result descriptor for one column in the result set.DescribeParamReturns the description of a parameter marker associated with a prepared SQL statement.ExecDirectExecutes a preparable statement.ExecuteExecutes a prepared statement.ExtendedFetchFetches the specified rowset of data from the result set and returns data for all bound columns.FetchFetches the next rowset of data from the result set and returns data for all bound columns.FetchByBookmarkFetches a set of rows where each row is identified by a bookmark.FetchScrollFetches the specified rowset of data from the result set and returns data for all bound columns.GetColumnPrivilegesReturns a list of columns and associated privileges for the specified table.GetColumnsReturns the list of column names in specified tables.GetCursorConcurrencyGets a SQLUINTEGER value that specifies the cursor concurrency.GetCursorKeysetSizeGets a SQLUINTEGER value that specifies the number of rows in the keyset-driven cursor.GetCursorNameReturns the cursor name associated with a specified statement.GetCursorScrollabilityGets a SQLUINTEGER value that specifies the scrollability type.GetCursorSensitivityGets a SQLUINTEGER value that specifies whether cursors on the statement handle made to a result set by another cursor.GetCursorTypeGets SQLUINTEGER value that specifies the cursor type.GetDataRetrieves data for a single column in the result set. It can be called multiple times to retrieve variable-length data in parts.GetDiagFieldReturns the current value of a field of a record of the diagnostic data structure (associated with an statement handle) that contains error, warning, and status information.GetDiagRecReturns the current values of multiple fields of a diagnostic record that contains error, warning, and status information.GetErrorInfoReturns a verbose description of the last errors.GetForeignKeysReturns list of foreign keys of the table.GetImpParamDescReturns the handle of the IPD.GetImpParamDescFieldReturns the current setting or value of a single field of a descriptor record.GetImpParamDescFieldNameReturns the name of a single field of a descriptor record.GetImpParamDescFieldNullableReturns the nullable value (TRUE or FALSE) of a single field of a descriptor record.GetImpParamDescFieldOctetLengthReturns the octet length of a single field of a descriptor record.GetImpParamDescFieldPrecisionReturns the precision value of a single field of a descriptor record.GetImpParamDescFieldScaleReturns the scale value of a single field of a descriptor record.GetImpParamDescFieldTypeReturns the type of a single field of a descriptor record.GetImpParamDescRecReturns the current settings or values of multiple fields of a descriptor record.GetImpRowDescReturns the handle to the IRD.GetImpRowDescFieldReturns the current setting or value of a single field of a descriptor record.GetImpRowDescFieldNameReturns the name of a single field of a descriptor record.GetImpRowDescFieldNullableReturns the nullable value (TRUE or FALSE) of a single field of a descriptor record.GetImpRowDescFieldOctetLengthReturns the octet length of a single field of a descriptor record.GetImpRowDescFieldPrecisionReturns the precision value of a single field of a descriptor record.GetImpRowDescFieldScaleReturns the scale value of a single field of a descriptor record.GetImpRowDescFieldTypeReturns the type of a single field of a descriptor record.GetImpRowDescRecReturns the current settings or values of multiple fields of a descriptor record.GetLongVarcharDataRetrieves long variable char data from the specified column of the result set.GetPrimaryKeysReturns the column names that make up the primary key for a table.GetProcedureColumnsReturns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures.GetProceduresReturns the list of procedure names stored in a specific data source.GetSpecialColumnsRetrieves information about columns within a specified table.GetSqlStateReturns the SqlState for the statement handle.GetStatisticsRetrieves a list of statistics about a single table and the indexes associated with the table.GetStmtAppParamDescGets the handle to the APD for subsequent calls to **Execute** and **ExecDirect** on the statement handle.GetStmtAppRowDescGets the handle to the ARD for subsequent fetches on the statement handle.GetStmtAsyncEnableGets an SQLUINTEGER value that specifies whether a function called with the specified statement is executed asynchronously.GetStmtAttrReturns the current setting of a statement attribute.GetStmtFetchBookmarkPtrGets a pointer that points to a binary bookmark value.GetStmtMaxLengthGets an SQLUINTEGER value that specifies the maximum amount of data that the driver returns from a character or binary column.GetStmtMaxRowsGets an SQLUINTEGER value corresponding to the maximum number of rows to return to the application for a SELECT statement.GetStmtNoScanGets an SQLUINTEGER value that indicates whether the driver should scan SQL strings for escape sequences.GetStmtParamBindOffsetPtrGets an SQLUINTEGER value that points to an offset added to pointers to change binding of dynamic parameters.GetStmtParamBindTypeGets an SQLUINTEGER value that indicates the binding orientation to be used for dynamic parameters.GetStmtParamOperationPtrGets an SQLUSMALLINT value that points to an array of SQLUSMALLINT values used to ignore a parameter during execution of an SQL statement.GetStmtParamsetSizeGets an SQLUINTEGER value that specifies the number of values for each parameter.GetStmtParamsProcessedPtrGets an SQLUINTEGER record field that points to a buffer in which to return the number of sets of parameters that have been processed, including error sets.GetStmtParamStatusPtrGets an SQLUSMALLINT value that points to an array of SQLUSMALLINT values containing status information for each row of parameter values after a call to **Execute** or **ExecDirect**.GetStmtQueryTimeoutGets an SQLUINTEGER value corresponding to the number of seconds to wait for an SQL statement to execute before returning to the application.GetStmtRetrieveDataGets an SQLUINTEGER value specifying the data retrieval mode.GetStmtRowArraySizeGets an SQLUINTEGER value that specifies the number of rows returned by each call to **Fetch** or **FetchScroll**.GetStmtRowBindOffsetPtrGets an SQLUINTEGER value that points to an offset added to pointers to change binding of column data.GetStmtRowBindTypeGets an SQLUINTEGER value that sets the binding orientation to be used when **Fetch** or **FetchScroll** is called on the associated statement.GetStmtRowNumberReturns an SQLUINTEGER value that is the number of the current row in the entire result set.GetStmtRowOperationPtrGets an SQLUSMALLINT value that points to an array of SQLUSMALLINT values used to ignore a row during a bulk operation using **SetPos**.GetStmtRowsFetchedPtrGets an SQLUINTEGER value that points to a buffer in which to return the number of rows fetched.GetStmtRowStatusPtrGets an SQLUSMALLINT value that points to an array of SQLUSMALLINT values containing row status values after a call to **Fetch** or **FetchScroll**.GetStmtSimulateCursorGets an SQLUINTEGER value that specifies whether drivers that simulate positioned update and delete statements guarantee that such statements affect only one single row.GetStmtUseBookmarksGets an SQLUINTEGER value that specifies whether an application will use bookmarks with a cursor.GetTablePrivilegesReturns a list of tables and the privileges associated with each table.GetTablesReturns the list of table, catalog, or schema names, and table types, stored in a specific data source.GetTypeInfoReturns information about data types supported by the data source.HandleReturns the statement handle.LockRecordSets the cursor position in a rowset and locks the record.MoreResultsDetermines whether more results are available on a statement containing SELECT, UPDATE, INSERT, or DELETE statements and, if so, initializes processing for those results.MoveMoves the cursor forward or backward the specified number of rowsets.MoveFirstFetches the first rowset of data from the result set and returns data for all bound columns.MoveLastFetches the last rowset of data from the result set and returns data for all bound columns.MoveNextFetches the next rowset of data from the result set and returns data for all bound columns.MovePreviousFetches the previous rowset of data from the result set and returns data for all bound columns.NumParamsReturns the number of parameters in an SQL statement.NumResultColsReturns the number of columns in a result set.ParamDataUsed in conjunction with **PutData** to supply parameter data at statement execution time.PreparePrepares an SQL string for execution.PutDataAllows an application to send data for a parameter or column to the driver at statement execution time.RecordCountGets the number of records in the result set.RefreshRecordSets the cursor position in a rowset and allows to refresh data in the rowset.ResetParamsReleases all parameter buffers set by **BindParameter** for the given statement handle.RowCountReturns the number of rows affected by update, insert or delete statements.SetAbsolutePositionFetches the rowset starting at the specified row.SetCursorConcurrencySets a SQLUINTEGER value that specifies the cursor concurrency.SetCursorKeysetSizeSets a SQLUINTEGER value that specifies the number of rows in the keyset-driven cursor.SetCursorNameSets the cursor name associated with a specified statement.SetCursorScrollabilitySets a SQLUINTEGER value that specifies the scrollability type.SetCursorSensitivitySets a SQLUINTEGER value that specifies whether cursors on the statement handle made to a result set by another cursor.SetCursorTypeSets a SQLUINTEGER value that specifies the cursor type.SetDynamicCursorSpecifies a dynamic cursor.SetForwardOnlyCursorSetKeysetDrivenCursorSpecifies a keyset driven cursor.SetLockConcurrencyCursor uses the lowest level of locking sufficient to ensure that the row can be updated.SetMultiuserKeysetCursorCreates a multiuser keyset cursor.SetOptimisticConcurrencyCursor uses optimistic concurrency control, comparing values.SetPosSets the cursor position in a rowset and allows an application to refresh data in the rowset or to update or delete data in the result set.SetPositionSets the cursor position in a rowset.SetReadOnlyConcurrencyCursor is read-only. No updates are allowed.SetRelativePositionFetches the rowset from the start of the current rowset.SetRowVerConcurrencyCursor uses optimistic concurrency control, comparing row versions such as SQLBase ROWID or Sybase TIMESTAMP.SetStaticCursorSpecifies a static cursor.SetStmtAppParamDescSets the handle to the APD for subsequent calls to **Execute** and **ExecDirect** on the statement handle.SetStmtAppRowDescSets the handle to the ARD for subsequent fetches on the statement handle.SetStmtAsyncEnableSets an SQLUINTEGER value that specifies whether a function called with the specified statement is executed asynchronously.SetStmtAttrSets attributes related to a statement.SetStmtFetchBookmarkPtrSets a pointer that points to a binary bookmark value.SetStmtMaxLengthSets an SQLUINTEGER value that specifies the maximum amount of data that the driver returns from a character or binary column.SetStmtMaxRowsSets an SQLUINTEGER value corresponding to the maximum number of rows to return to the application for a SELECT statement.SetStmtNoScanSets an SQLUINTEGER value that indicates whether the driver should scan SQL strings for escape sequences.SetStmtParamBindOffsetPtrSets an SQLUINTEGER value that points to an offset added to pointers to change binding of dynamic parameters.SetStmtParamBindTypeSets an SQLUINTEGER value that indicates the binding orientation to be used for dynamic parameters.SetStmtParamOperationPtrSets an SQLUSMALLINT value that points to an array of SQLUSMALLINT values used to ignore a parameter during execution of an SQL statement.SetStmtParamsetSizeSets an SQLUINTEGER value that specifies the number of values for each parameter.SetStmtParamsProcessedPtrSets an SQLUINTEGER record field that points to a buffer in which to return the number of sets of parameters that have been processed, including error sets.SetStmtParamStatusPtrSets an SQLUSMALLINT value that points to an array of SQLUSMALLINT values containing status information for each row of parameter values after a call to Execute or ExecDirect. This field is required only if PARAMSET_SIZE is greater than 1.SetStmtQueryTimeoutSets an SQLUINTEGER value corresponding to the number of seconds to wait for an SQL statement to execute before returning to the application.SetStmtRetrieveDataSets an SQLUINTEGER value specifying the data retrieval mode.SetStmtRowArraySizeSets an SQLUINTEGER value that specifies the number of rows returned by each call to **Fetch** or **FetchScroll**.SetStmtRowBindOffsetPtrSets an SQLUINTEGER value that points to an offset added to pointers to change binding of column data.SetStmtRowBindTypeSets an SQLUINTEGER value that sets the binding orientation to be used when **Fetch** or **FetchScroll** is called on the associated statement.SetStmtRowOperationPtrSets an SQLUSMALLINT value that points to an array of SQLUSMALLINT values used to ignore a row during a bulk operation using **SetPos**.SetStmtRowsFetchedPtrSets an SQLUINTEGER value that points to a buffer in which to return the number of rows fetched.SetStmtRowStatusPtrSets an SQLUSMALLINT value that points to an array of SQLUSMALLINT values containing row status values after a call to **Fetch** or **FetchScroll**.SetStmtSimulateCursorSets an SQLUINTEGER value that specifies whether drivers that simulate positioned update and delete statements guarantee that such statements affect only one single row.SetStmtUseBookmarksSets an SQLUINTEGER value that specifies whether an application will use bookmarks with a cursor.UnbindColUnbinds the specified column buffer bound by **BindCol** for the given statement handle.UnbindColumnsUnbinds all column buffers bound by **BindCol** for the given statement handle.UnlockRecordSets the cursor position in a rowset and unlocks the record.UpdateByBookmarkUpdates a set of rows where each row is identified by a bookmark.UpdateRecordUpdates a record.
COdbcStmt 2
CSQLite 28
CompileOptionUsedCompleteConstructorEnableSharedCacheErrStrFreeGetCompileOptionGetLastResultMallocMalloc64MemoryHighwaterMemorySizeMemoryUsedRandomnessReallocRealloc64RefCountReleaseMemorySetResultSleepSoftHeapLimit64SourceIDStatusStatus64StrGlobThreadSafeVersionVersionNumber
CSQLiteBlob 7
CSQLiteDb 20
ChangesCloseDbConstructorErrCodeErrMsgExecExtendedErrCodeExtendedResultCodeshDbcInterruptLastInsertRowIdLimitOpenBlobOpenDbPrepareProgressHandlerReleaseMemoryStatusTotalChangesUnlockNotify
CSQLiteStmt 81
BindBlobBinds a blob with the statement.BindBlob64BindDoubleBinds a double value with the statement.BindLongBinds a long value with the statement.BindLongIntBinds a longint value with the statement.BindNullBinds a null value with the statement.BindParameterCountThis method can be used to find the number of SQL parameters in a prepared statement.BindParameterIndexReturns the index of an SQL parameter given its name.BindParameterNameReturns the name of the N-th SQL parameter in the prepared statement P.BindTextBinds a text value with the statement.BindZeroBlobBinds a BLOB that is filled with zeroes.BindZeroBlob64BusyReturns true if the prepared statement has been stepped at least once using **Step_** but has not run to completion and/or has not been reset using **Reset**.ChangesReturns the number of database rows that were changed or inserted or deleted by the most recently completed SQL statement on the current database connection.ClearBindingsSets all the parameters in the compiled SQL statement to NULL.CloseDbCloses the database.ColumnBlobReturns information about a single column of the current result row of a query.ColumnBytesReturns the number of bytes of the column value.ColumnCountReturns the number of columns in the result set returned by the prepared statement.ColumnDatabaseNameReturns the database name that is the origin of a particular result column in SELECT statement.ColumnDeclaredTypeReturns the declared data type of a query result.ColumnDoubleReturns the column value as a double.ColumnLongReturns the column value as a long.ColumnLongIntReturns the column value as a quad.ColumnNameReturns the name assigned to a particular column in the result set of a SELECT statement.ColumnOriginNameReturns the column name that is the origin of a particular result column in SELECT statement.ColumnTableNameReturns the table name that is the origin of a particular result column in SELECT statement.ColumnTextReturns the column value as a UTF-16 string.ColumnTypeReturns the column type.CompileOptionUsedDetermines whether the specified option was defined at compile time.CompleteDetermines if the currently entered text seems to form a complete SQL statement.ConstructorDataCountReturns the number of columns in the result set returned by the prepared statement.DbHandleReturns the database connection handle to which a prepared statement belongs.EnableSharedCacheEnables or disables the sharing of the database cache and schema data structures between connections to the same database.ErrCodeReturns the numeric result code for the most recent failed sqlite3 call associated with a database connection.ErrMsgReturns English-language text that describes the error.ErrStrReturns English-language text that describes the result code.ExecConvenience wrapper for **Prepare** and **Step_**.ExtendedErrCodeGets the extended error code associated with this database connection.ExtendedResultCodesEnables or disables the extended result codes feature of SQLite.FinalizeDeletes a prepared statement.FreeReleases memory previously allocated by **Malloc** or **Realloc**.GetColumNamesGetCompileOptionAllows iterating over the list of options that were defined at compile time by returning the N-th compile time option string.GetLastResultReturns the last result code.GetRowAfter a prepared statement has been prepared using either Prepare this method must be called one or more times to evaluate the statement. **GetRow** is an alias for **Step_**.hDbcGets/sets the database handle.hStmtGets/sets the connection handle.InterruptThis function causes any pending database operation to abort and return at its earliest opportunity.IsColumnNullReturns true is the column value is null or false otherwise.LastInsertRowIdReturns the rowid of the most recent successful INSERT into the database from the database connection in the first argument.LimitThis function allows the size of various constructs to be limited on a connection by connection basis.MallocReturns a pointer to a block of memory at least N bytes in length, where N is the parameter.Malloc64MemoryHighwaterReturns the maximum value of **MemoryUsed** since the high-water mark was last reset.MemorySizeReturns the size of that memory allocation in bytes.MemoryUsedReturns the number of bytes of memory currently outstanding (malloced but not freed).OpenBlobOpens a handle to a BLOB.OpenDbOpens an SQLite database file as specified by the filename argument.PrepareCreates a new prepared statement object.ProgressHandlerThe **ProgressHandler** method causes a callback function to be invoked periodically during long running calls to **Step_** and **GetRow** for a database connection.RandomnessPseudo-random number generator.ReadOnlyReturns true if and only if the prepared statement makes no direct changes to the content of the database file.ReallocAttempts to resize a prior memory allocation to be at least the specified number of bytes.ReleaseMemoryResetResets a prepared statement object back to its initial state, ready to be re-executed.SleepCauses the current thread to suspend execution for at least a number of milliseconds specified in its parameter.SoftHeapLimit64Sets and/or queries the soft limit on the amount of heap memory that may be allocated by SQLite.SourceIDReturns the SQLite3 source identifier.SqlRetrieve a saved copy of the original SQL text used to create a prepared statement if that statement was compiled using **Prepare**.sqlite3_progress_handler_callbackStatusStatus64Step_After a prepared statement has been prepared using **Prepare** this method must be called one or more times to evaluate the statement.StrGlobThe **StrGlob** method returns zero if string *szStr* matches the glob pattern *szGlob*, and it returns non-zero if string *szStr* does not match the glob pattern *szGlob*. This function is case sensitive.ThreadSafeReturns zero if and only if SQLite was compiled with mutexing code omitted due to the SQLITE_THREADSAFE compile-time option being set to 0.TotalChangesThis function returns the number of row changes caused by INSERT, UPDATE or DELETE statements since the database connection was opened.UnlockNotifyRegisters a callback that SQLite will invoke when the connection currently holding the required lock relinquishes it.VersionReturns the SQLite3 version.VersionNumberReturns the SQLite3 version number.