#76 Query builder: keep table position, sort and pack information as a comment in SQL

2014.09
closed
Anu
evol (16)
3
2014-09-09
2012-09-24
PAscal
No

exemple

SELECT
J.JOB_ID,
PUBLIC.COUNTRIES.COUNTRY_ID
FROM
PUBLIC.COUNTRIES /*SQLeo x=1 y=2 sort */,
PUBLIC.JOBS as J /*SQLeo x=10 y=2 pack */

Syntax : /*SQLeo_x_y_pack*/
Example: /*SQLeo_10_10_true*/

Discussion

1 2 > >> (Page 1 of 2)
  • PAscal
    PAscal
    2012-09-24

    Should be used as well for reverse SQL
    and could replace XLQ format

     
  • PAscal
    PAscal
    2013-06-12

    This format should be saved as .sql (with graph properties)
    But user can still save as .sql (standard)

     
  • PAscal
    PAscal
    2014-03-09

    • priority: --> 3
     
  • PAscal
    PAscal
    2014-04-02

    • Milestone: not planned --> Candidates
     
  • PAscal
    PAscal
    2014-05-19

    • Milestone: Candidates --> 2014.07
     
  • PAscal
    PAscal
    2014-07-09

    • Milestone: 2014.07 --> 2014.08
     
  • PAscal
    PAscal
    2014-08-11

    • Milestone: 2014.08 --> 2014.09
     
  • PAscal
    PAscal
    2014-08-24

    • status: open --> commited
    • assigned_to: Anu
     
  • Anu
    Anu
    2014-09-03

    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -6,3 +6,5 @@
     FROM
          PUBLIC.COUNTRIES /\*SQLeo x=1 y=2 sort \*/,
          PUBLIC.JOBS as J /\*SQLeo x=10 y=2 pack \*/
    +
    +Syntax : /*SQLeo_x_y_pack*/ Example- /*SQLeo_10_10_true*/
    
     
  • Anu
    Anu
    2014-09-03

    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -7,4 +7,5 @@
          PUBLIC.COUNTRIES /\*SQLeo x=1 y=2 sort \*/,
          PUBLIC.JOBS as J /\*SQLeo x=10 y=2 pack \*/
    
    -Syntax : /*SQLeo_x_y_pack*/ Example- /*SQLeo_10_10_true*/
    +Syntax : /\*SQLeo_x_y_pack\*/ 
    +Example: /\*SQLeo_10_10_true\*/
    
     
1 2 > >> (Page 1 of 2)