Thank you Razzak! These wonderful examples need to be added to the help files.
Claudine -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Saturday, August 02, 2008 8:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DBEdit Properties PopUp Dynamic Where Clause 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.
