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
