Hello all!
I found a difference between DOS versions 6.1A and 6.5+.
In forms, for a popup menu on a field, if you were lazy and
abbreviated keywords you're in trouble. In the 'where/order by'
box, you CANNOT have the first word be abbreviated. Either
nothing will popup, or you will get a 'syntax error' message
when you try.
In other words, these won't work. The first word must be
spelled out completely:
ord by empid
wher empid is not null
whe empid is not null
But you can abbreviate elsewhere, so this will work:
where empid is not null ord by empid
You can search for these by doing:
select all from sys_forms where #2 like 'ord by%'
select all from sys_forms where #2 like 'wher %'
select all from sys_forms where #2 like 'whe %'
Then look at all the forms' rows to figure out which popup
they are on. You may get listings of variables that go onto
more than one row, but luckily the popup where box always is
the beginning of a row.
Karen
