Adding a table to an existing grid

Scriptcase 9 General
#1

I have a grid with a single table. I need to add a 2nd table to this grid.
The first thing I do is change the variable values in SQL from var1, var2. to tableName.var1, tableName.var2
I still need to then change the names in event, Ajax,search etc.

I am still getting Search Fields not defined error.

Has anyone tried this and is there a simpler way?

#2

I think you must create a new grid with a join: table1 and table2. that is correct way.

#3

If you mean display the information of 2 similar tables in the grid you need to select field that are the same format in each table and use an UNION to merge the 2 tables

SELECT Field1 AS F1, Field2 AS F2, Field3 AS F3 FROM Table1 WHERE xxx
UNION
SELECT Field4 AS F1, Field5 AS F2, Field6 AS F3 FROM Table2 WHERE yyy
#4

Looks like only ismpleway is to redo the grid.

Everything else fails somewhere