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.
