Hi,

In the online documentation  there is a list of conditions needs to be met for sensitivie
cursors. One point is not clear for me:

6) There are no correlated sub-queries in the JOIN or WHERE clauses of the SELECT statement.

Does this mean that sensitivie cursor is possible with joins in the query, but only if the
select fields  do not contain any field  from the joined tables?

Regards, Leslie

This what is confusing me :

As far as I understand point 6 tells that joins are allowed with restrictions, but the
first part of the following part of the help suggests otherwise.


"Multi-table queries

All queries that join two or more tables or merge two or more SELECT statements via the
UNION/INTERSECT/EXCEPT operators will automatically produce an insensitive result set
cursor, irrespective of the requested result set cursor type."


Regards, Leslie

Leslie,

I think it's a documentation typo - the word 'JOIN' shouldn't be in that
sentence.

--
Fernando Dias
[Team Elevate]

Fernando ,

<<I think it's a documentation typo - the word 'JOIN' shouldn't be in that
sentence.>>

Yep, I thought that would be the more likely answer. Any change in the joined tables would
require to update  the result set, which would require registering every sensitive cursor
for change notification with every joined table.

Thank you,
Leslie

Leslie,

<< Does this mean that sensitivie cursor is possible with joins in the
query, but only if the select fields  do not contain any field  from the
joined tables?  >>

No.  Joins can never generate a sensitive result set because they violate
this rule:

Multi-table queries

All queries that join two or more tables or merge two or more SELECT
statements via the UNION/INTERSECT/EXCEPT operators will automatically
produce an insensitive result set cursor, irrespective of the requested
result set cursor type.

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=0&topic=17

--
Tim Young
Elevate Software
www.elevatesoft.com