Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
Result Set Cursor Sensitivity |
Thu, Jan 29 2009 6:07 PM | Permanent Link |
Leslie | 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 |
Thu, Jan 29 2009 7:01 PM | Permanent Link |
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 |
Thu, Jan 29 2009 7:46 PM | Permanent Link |
Fernando Dias Team Elevate | Leslie,
I think it's a documentation typo - the word 'JOIN' shouldn't be in that sentence. -- Fernando Dias [Team Elevate] |
Fri, Jan 30 2009 6:49 AM | Permanent Link |
Leslie | 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 |
Sun, Feb 8 2009 10:27 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |