At 08:24 PM 8/2/2008, Claudine Robbins wrote:
Does anyone know the correct syntax for the "Use Dynamic Where Clause"
in a form DBEdit popup?
Claudine,
Here are three different examples to demonstrate the use of Dynamic
WHERE Clause using LIKE, CONTAINS, and EQUAL (=) clauses for Variable
or DB Edit Pop-up menus.
In all there examples, first you have to make sure that the option for
[ ] Use Dynamic Where Clause is checked.
-- Using RRBYW14 Sample Database
IF (CVAL('DATABASE')) <> 'RRBYW14' OR (CVAL('DATABASE')) IS NULL THEN
CONNECT RRBYW14 IDENTIFIED BY NONE
ENDIF
-- Using RRBYW15 Sample Database
IF (CVAL('DATABASE')) <> 'RRBYW15' OR (CVAL('DATABASE')) IS NULL THEN
CONNECT RRBYW15 IDENTIFIED BY NONE
ENDIF
-- Pop-up Menus
Variable/DB Edit Properties | Pop-up Menus
[x] User can Access a Pop-up Menu
[x] Use a Custom Pop-up
Table/View Name: Customers
Pop-up Type: Multi-Column
Column Returned: CustID
Menu Values: Company
Menu Caption: Double-Click Pop-up Customer List
Menu Title: Select Customer
-- Example 01: (Dynamic WHERE clause with LIKE)
Message: Enter First Few Characters of Company
WHERE Clause: WHERE Company LIKE '&%' ORDER BY Company
-- Example 02: (Dynamic WHERE clause with CONTAINS)
Message: Enter Company Name
WHERE Clause: WHERE Company CONTAINS '&' ORDER BY Company
-- Example 03: (Dynamic WHERE clause with =)
Message: Enter State
WHERE Clause: WHERE CustState = '&' ORDER BY Company
Have fun!
Very Best R:egards,
Razzak.
