Announcement

Collapse
No announcement yet.

Error using UNION

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error using UNION

    Guys, wanna ask

    When i'm using "Select" Data Type and in the Lookup Setting, the query i used using UNION it works fine

    but, when i'm using "Text Auto-Complete" Data Type and in the Lookup Setting, the query i used using UNION it doesn't work

    Is this a bug or what ?

    I already checked my query using Query Builder, it works fine

    Thanks

  • #2
    Perhaps it's a bug, I don't know. But a work-around might be to create a view.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      I hope it's reported to bugs team if it is. Thanks albert

      Comment


      • #4
        Hello,

        Issue reported to our bugs team.

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Guys, Is there any news about this update ?

          Comment


          • #6
            For addition information about Error using UNION,

            I have :
            - Data Type "Select"
            - Lookup Settings -> SQL Select Statement using UNION
            - it work well after compiling

            But, If we use "Ajax Processing - Events onChange" to pass parameters to next Data Type "Select", the data show nothing, only "loading process"...

            need Solution...

            Comment

            Working...
            X