Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Please Explain

Can anyone please Explain the following stmt (ODBC32.dll):
SQLSetConnectOption(*hdbc, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC);
[127 byte] By [sirama] at [2007-11-11 8:17:38]
# 1 Re: Please Explain
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/default.asp?url=/library/en-us/vccore/html/_core_odbc.asp
nspils at 2007-11-11 21:01:28 >
# 2 Re: Please Explain
Hi,
NsPils, First my Thanks. Is the above function forces Server side Cursors or Client side cursors?
sirama at 2007-11-11 21:02:34 >
# 3 Re: Please Explain
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.
nspils at 2007-11-11 21:03:27 >