Dear Karen & all,
Thanks for your suggestions, they've helped me "be on my toes."
OK, I figured it out. With the mighty WHERE builder a syntax error
can be generated (by clicking on the "test" button) from the WHERE
clause in the WHERE builder or, from a syntax error in the WHERE
clause on the PopUp Menu Tab.
Now, you ask, aren't the WHERE clauses the same in both places?
The answer is, not necessarily. They are not the same if the WHERE
clause on the Popup Menu Tab does not begin with the WHERE
command in the clause box.
Now, you ask, when would this occur. The answer is, when I've
converted a form from Rbase 3.1 and the converter doesn't put a
WHERE there (or else I did something wrong in the conversion process
I don't know about yet).
So, now I've finished my first Rbase 7.6 form and I must say it is
spiffy.
Mirth & mangos, Geoffrey Wheeler, Thailand.
On 4 Mar 2009 at 11:24, [email protected] wrote:
2 things: it's ORDER BY, not ORDERED
Keep in mind that LIKE 'o', without a wildcard after the 'o', is the same as
saying "status = 'o' ". If your wildcard is the % sign, then it should say:
Status LIKE 'o%' ORDER BY funder
Karen
Status LIKE 'o' ORDERED BY Funder
Geoffrey
