Karen, When defining pop-up menu on a field, R:BASE 2000 (ver 6.5+) and higher does not require the optional/starting command with WHERE clause. The optional WHERE clause is defined by the pop-up itself. All previous versions did not mind the redundant WHERE clause. Have fun with 6.5+! Very Best Regards, Razzak. At 07:56 PM 5/4/2001 -0400, Karen Tellef wrote: > >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... ===================================-============================ R:BASE Developers's Conference: http://www.rbase.com/conference Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-=============================
