[SOLVED] Grid creation error

Applications Grid / Reports
#1

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 :slight_smile:

#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

#3

No, it doesn’t work again

#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;

#5

Just did it and … doesn’t work again

#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

#7

If you have the ; in the SQL section then you need to get rid of that.

#8

Thank you aducom for the solution :slight_smile: