Announcement

Collapse
No announcement yet.

[SOLVED] Grid creation error

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

  • [SOLVED] Grid creation error

    Hi, I started using scriptcase last week, and I found a problem with the starting query of my grid.

    SELECT TB_1.ID, TB_1.Name, TB_1.Username, TB_1.Password, TB_1.Surname, TB_2.Group,
    FROM
    TB_1
    INNER JOIN
    TB_2
    ON
    TB_1.ID_Group=TB_2.ID;

    I try it on my database, and it work properly, so why doesn't it work on script case? Have I to add something specifically for this program?

    Thank you for all the answer
    Last edited by Raiden5692; 03-28-2014, 09:49 AM.

  • #2
    not sure, but I think it's due to the inner join. Would this work for you?

    select a.id, a. etc. from tb1 a, tb2 b where a.id=b.id
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      No, it doesn't work again

      Comment


      • #4
        Maybe (hopefully) this works:
        SELECT TB_1.ID as ID, TB_1.Name as Name, TB_1.Username as Username, TB_1.Password as Password, TB_1.Surname as Surname, TB_2.Group as Group
        FROM
        TB_1
        INNER JOIN
        TB_2
        ON
        TB_1.ID_Group=TB_2.ID;

        Comment


        • #5
          Just did it and ............. doesn't work again

          Comment


          • #6
            Uuhhm,...
            What actually is the problem? Any error messages? I suggest go to Application -> Settings -> Error Settings and set the option Debug Mode to yes and check the generated SQL statements.

            jsb

            Comment


            • #7
              If you have the ; in the SQL section then you need to get rid of that.
              Albert Drent
              aducom software netherlands
              scriptcase partner, reseller, support and (turn-key) development
              www.scriptcase.eu / www.scriptcase.nl

              Comment


              • #8
                Thank you aducom for the solution

                Comment

                Working...
                X