Please Explain

Can anyone please Explain the following stmt (ODBC32.dll):
SQLSetConnectOption(*hdbc, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC);

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:

http://msdn.microsoft.com/library/de..._core_odbc.asp

Hi,
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.