Dear Razzak,
Thank you for your kind reply. My WHERE clause in the WHERE
builder (a very elegant tool if I do say so) does not include the command
WHERE, it only includes the clause generated by clicking on buttons. I
get the syntax error message twice.
I downloaded and looked at the Popups in your sample application:
they're beautiful. In the form titled as "single column" (mine is also single
column) in the popup object properties you have designated it as a mulitple
column type popup and listed one column in the menu values field. Why? I
tried that with mine and it made no difference. I still get the syntax
errors.
As there appears to be nothing wrong with the syntax of my
WHERE clause, is there something else that can cause a syntax error
outside of the where clause? It does seem to be the WHERE clause
though: When I try to enter data using the form and double click on the
popup field it gives the syntax error message twice. I only get the error
message by double click on this object.
Also, is there a way to run the form from the form designer
(another very elegant tool in Rbase) for form entry. My table is empty
and I get the "no rows satisfy . . . " error when I run the form. I have to
close the form designer and run it for entry from the database explorer.
Finally, I take it that the old #dup (in default value of a form
object) has bit the dust. I see no reference in help.
Thanks for your help and encouraging words.
Sincerely, Geoffrey Wheeler, Ban Thin, Thailand
On 3 Mar 2009 at 23:44, A. Razzak Memon wrote:
At 11:15 PM 3/3/2009, Geoffrey Wheeler wrote:
>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,
While in form designer, defining the WHERE clause for Pop-up Menus,
then clicking on the WHERE Builder button, the command should not
include the leading "WHERE" command, as in your example above.
Proper Steps:
. Select/highlight the column name
. Click on [Add Column] button
. Click on [IS NOT NULL] button
The resulting command, for example, should look like the following:
Company IS NOT NULL
Click on [Test Clause...] button to test the where clause.
You don't need to add the WHERE in front of Company IS NOT NULL.
For a sample application to demonstrate the use of WHERE clause in
Pop-up Menus, take a look at the "All About Pop-up Menus in Forms",
sample application, posted on 09/07/2008.
Sample Applications: http://www.razzak.com/sampleapplications/
Application: All About Pop-up Menus in Forms
Have fun!
Very Best R:egards,
Razzak.
Geoffrey
