469,935 Members | 2,195 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,935 developers. It's quick & easy.

SELECT DISTINCT will always result in a static cursor

An example for my pb
1) Created a dynamic cursor :

DECLARE cursor_teste CURSOR DYNAMIC
FOR Select DISTINCT name from table WHERE ID = 1
OPEN cursor_teste
FETCH first FROM cursor_teste

2)The result for this cursor is for example 'teste'.

3) If now i do an update on that name with a new value 'teste1'
than if i fetch the cursor , i''ll get the old value (teste) .

i need to use Cursors,
any idea how to make a select distinct result in a dynamic Cursor?
Jul 31 '07 #1
0 1219

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Bob Bedford | last post: by
21 posts views Thread by John Fabiani | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.