Menu

#270 Transform complex UPDATE in SELECT (for testing)

2015.04
closed
PAscal
Evol (198)
None
2015-04-18
2015-03-16
PAscal
No

UPDATE tab
set col = ( Sub1 )
where
...
and EXISTS ( Sub2)

-->
SELECT
col,
(Sub1)
from tab
where
...

This feature is available from
Query builder > syntax editor and check the diagram layout.
Command editor > select text , right click and format query.

Discussion

  • PAscal

    PAscal - 2015-03-18
    • labels: --> Evol
     
  • PAscal

    PAscal - 2015-04-06
    • status: open --> accepted
    • assigned_to: PAscal
    • Milestone: not planned --> 2015.05
     
  • PAscal

    PAscal - 2015-04-11
    • status: accepted --> commited
    • Milestone: 2015.05 --> 2015.04
     
  • Anu

    Anu - 2015-04-12
    • summary: Query builder: transform complex UPDATE in SELECT (for testing) --> Transform complex UPDATE in SELECT (for testing)
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -11,3 +11,7 @@
     from tab
     where
     ...
    +
    +This feature is available from 
    +Query builder  > syntax editor and check the diagram layout.  
    +Command editor > select text , right click and format query.
    
     
  • PAscal

    PAscal - 2015-04-14
    • status: commited --> tested
     
  • PAscal

    PAscal - 2015-04-18
    • status: tested --> closed
     

Log in to post a comment.