f2s_cursor_current_count¶
Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers
Syntax
**There is no set_attribute. This attribute is read only.**
get_attribute f2s_cursor_current_count of {DriverID} (f2s_ConstPointer({server})) to {variable}
Parameter |
Description |
|---|---|
DriverID |
The ID of the driver for which this applies. In most cases, you should use _f2s_ActiveDriverID. |
server |
Pointer to a string. Pointer to the name of the database server (optional) If this is not defined, the current active server will be used. |
variable |
Integer, the number of cursors currently open |
Description
Getting this read-only attribute returns the number of cursors that are current open on the server. This can be use in conjunction with the attribute f2s_max_cursors to tune the optimum number of cursors to have open at one time on the server.
Examples
get_attribute
string sCurrentServer
integer iNumCursors
get f2s_server of _f2s_Active_DriverId to sCurrentServer
Get_Attribute f2s_max_cursors of _f2s_ActiveDriverId (f2s_ConstPointer(sCurrentServer)) to iMaxCursors
get_attribute f2s_cursor_current_count of _f2s_ActiveDriverId (f2s_ConstPointer(sCurrentServer)) to iNumCursors
Showln (SFormat("The current # of open cursors on %1 is %2.", sCurrentServer, iNumCursors))
Related Attributes
Replaces: Command GET_OPENED_CURSORS