Problem with variable database

Applications Grid / Reports
#1

Hi,

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

This works

but if I use SELECT UNION don’t works :

Can you help me ?

Thanks

noworks.jpg

works.jpg

#2

Hi,

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

Thank for your reply.

#3

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

#4

Hello,

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

regards,
Bernhard Bernsmann

#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

#6

Hello,

Thanks for your feedback.

Issue reported to our bugs team.

regards,
Bernhard Bernsmann