Hi
I reported this problem in April, I waited for the release V8 thinking it would be fixed.
I need to use a variable for table’s name in SQL grid but with select union don’t works.
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
Can you resolve, please ?
thanks