Can anyone please Explain the following stmt (ODBC32.dll):
SQLSetConnectOption(*hdbc, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC);
"Laziness is nothing more than the habit of resting before you get tired"
1. Pointer/handle of the connection to the data base
2. the kind of cursor you want to use to move about the result set
3. the "dynamic" characteristics of the cursor
Here's a link to the Microsoft Developer Network's reference on ODBC:
NsPils, First my Thanks. Is the above function forces Server side Cursors or Client side cursors?
The cursor is for control of the snapshot/recordset which is returned by the database in response to your query. The cursor's action is on the client side.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center