Announcement

Collapse
No announcement yet.

Problem with variable database

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

  • Problem with variable database

    Hi,

    I need to use a variable for database's name in SQL grid :

    This works
    works.jpg

    but if I use SELECT UNION don't works :

    noworks.jpg

    Can you help me ?

    Thanks

  • #2
    Hi,

    excuse me I wrong not database's name but table's name.

    Thank for your reply.

    Comment


    • #3
      I think the problem is a bug of scriptcase and i hope the staff can resolve it

      Comment


      • #4
        Hello,

        Have you tried to remove the "Variable per la tabella" to see if he issue happens?

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Hi,

          without the variable table, the SQL query with SELECT UNION works, with the variable table works with only SELECT but not with SELECT UNION
          I think that the variable table works only on the first name table and not on the next others names

          If I write for example (without variable table) : SELECT * name from calendario where name="pippo" UNION SELECT * surname from calendario where name="pippo" it works
          If I write for example (with variable table) : SELECT * name from calendario where name="pippo" it works
          If I write for example (with variable table) : SELECT * name from calendario where name="pippo" UNION SELECT * surname from calendario where name="pippo" not works

          thanks

          Comment


          • #6
            Hello,

            Thanks for your feedback.

            Issue reported to our bugs team.

            regards,
            Bernhard Bernsmann

            Comment

            Working...
            X