refresh/requery

Brazzo
06-10-2002, 04:14 AM
Hello,

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.

simondeutsch
06-10-2002, 09: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.

Brazzo
06-11-2002, 12:38 AM
Thanks, i'll trie.

Where can i find Books Online?

Brazzo
06-11-2002, 03: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.

simondeutsch
06-11-2002, 10: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?

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum