Geoffrey,
I am not sure I can help but I have a few questions to ask and maybe I can. >From your question, I take it you have a POPUP menu in a form. If that is the case, is the field a DBEDIT field that you are populating as you enter information? Based on how you choose the information from the POPUP, You should make sure your dynamic where clause at the bottom of the form has the correct syntax. My example here gives me the option of choosing from a list based on the first few letters in the model#. WHERE Model# LIKE '&%' ORDER BY Model#. The #DUP function is still valid. I use it in my forms under Object Properties in the Effects section for a default value. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Geoffrey Wheeler Sent: Tuesday, March 03, 2009 10:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Syntax error in WHERE builder Hi, I've upgraded from 3.1a to 7.6.6 running on WinXP. It's been several years since I've written Rbase code. I am learning about forms right now. I have some things I need to learn: - I'm trying to get a popup menu to work. It gives me a Syntax Error. I tried to play with the WHERE builder and it always gives me a syntax error even if I just do a WHERE columname IS NOT NULL using clicks on the [add column name] and [IS NOT NULL] buttons. It seems I'm missing something simple. I checked my WHERE clause at the R> and it worked. Why does it not work in my Form popup menu? Geoffrey
