06-10-2002, 03:14 AM
My program is a multiuser-program.
I opened a SQL-Server Database-connection with ADO.
using Serverside Cursor and Cursortype Keyset.
But i cannot see the changes made by other users. only if i close the program and restart.
06-10-2002, 08:18 PM
After you have opened your recordset, check if your cursortype is actually a keyset. Due to various reasons, you very often don't get the type you are asking for. Likely your cursorlocation is Server, which is the default. Books Online has a page about implicit cursor conversions. Also, a keyset cursor only reflects other users' modifications, not additions.
06-10-2002, 11:38 PM
Thanks, i'll trie.
Where can i find Books Online?
06-11-2002, 02:09 AM
I watched the cursor type and as soon i bind a control to the table
the cursor type will be changed to static.
Does anybody know why?
i'm using SQL Server 2000 and a serverside connection.
06-11-2002, 09:40 AM
Books Online is on your SQL server setup disc. If you don't have the disc, you can download it from Microsoft's website.
These Keyset cursors will become static:
Select has a TOP clause
Query references no tables (only expresssions)
Query has aggregates, UNION, Group BY, Distinct or HAVING
Underlying table has a trigger
Query has at least one table without a unique index/primary key
Does your query match one of the above?
Are you perhaps binding it to a grid control?