Hi,
Below is my sql:
SELECT w.columnA, w.columnB, w.columnC FROM tableA w
UNION
SELECT q[LEFT][SIZE=13px].columnA, q.columnB, q.columnC [/SIZE][/LEFT]FROM tableB q
When the user open the grid, I need the grid to show no record.
But when user key in a match in the search, the result will then display.
May I know how can I go about doing?
You can set your grid in initial mode for SEARCH.
The initial mode in search is actually the advanced search. Possible to be quick search mode instead (i.e. one search field to do the search)?
My alternate solution is I have to use a blank application to create a form and assigned a global variable to pass to the grid inside the sql statement.