Geoffrey, Couple of things to check. What is your quote settings?
If your quote settings are " then I believe you will get an error with your syntax. Also it should be ORDER BY Funder not ORDERED BY Funder. So if your quote settings are " then use Status LIKE "o" ORDER BY Funder If your quote settings are ' then use Status LIKE 'o' ORDER BY Funder Jan -----Original Message----- From: "Geoffrey Wheeler" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 04 Mar 2009 22:35:32 +0700 Subject: [RBASE-L] - RE: Syntax error in WHERE builder Dear Jim, Yes this is a custom popup menu in a form. I'm away from my PC now but yes, I believe that is a DBEDIT field, one of 3 or 4 that I use for entering data into a row in TempExp table (I think you call that populating). I have not made the where clause dynamic. I might though. My clause looks like this now: Status LIKE 'o' ORDERED BY Funder I think I'm overlooking a form or system setting because I can see that there is any syntax error here. It gives me the syntax error message 2 times. I have gotten a couple of Windows system errors but nothing that hung the program. I don't think they're related. Thanks for letting me know #DUP is still valid. Peace & papayas, Geoffrey On 4 Mar 2009 at 4:59, Jim Belisle wrote: 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 Geoffrey
