Hello,
I have a grid of words with a general where clause (where [glo_expression]) and also using globals to filter the grid at various Events. At ScriptInit and on a button I have code as follows:
[glow_expression]=(type=‘a’ OR type=‘v’);
The intent is that the grid will only show words of type a (Adjectives) or type v (Verbs). But this code hangs the grid, so something is wrong.
Similarly, I have a button which is [glow_expression]=urootoffset=‘100001740’; In this expression, the field urootoffset is a string.
I’ve tried enclosing in quotes, but doesn’t seem to help.
I also have an OnRecord event and a link to a related similar grid. The code is [glo_expression]=where urootoffset=[glo_uoffseta]; the global [glo_uoffseta] is set in the link to equal the field uoffseta of the current (clicked on) record.
So each of these is causing the grid to hang.
Could someone advise the correct way to state these expressions?
Thank you!!