Is it possible to use quotes in property command for LookUpWhereClause? I tried something like this PROPERTY Precno LookupWhereClause 'where paragraph contains ''e''' and my LookUpListBox goes blank. I do have paragraph fields that contain 'e'.
Also, if I do something like PROPERTY Precno LookupWhereClause 'where Pno = 12' I will get a valid listing. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Posted At: Wednesday, January 12, 2005 9:17 PM Posted To: RB7-L Conversation: [RBG7-L] - Re: Dynamical Listboxes Subject: [RBG7-L] - Re: Dynamical Listboxes > Can this done, is this a feature request, is this in the best is yet > to come? Or this to much to whish for? I'm not sure if I understand your question, but if it is "Can the properties used to specify the lookup information for a listbox be changed in code" the answer is Yes. The properties are: List Table: lstTable List Column: lstField Key Column: kFld Where Clause: LookupWhereClause So, for instance: PROPERTY MyListBox lstTable 'Customer' PROPERTY MyListBox lstField 'FirstName, LastName, PhoneNumber' PROPERTY MyListBox kFld 'CustomerID' SET VAR vWhere = 'WHERE CustStatus = ''Active'' ORDER BY LastName, FirstName' PROPERTY MyListBox LookupWhereClause .vWhere would set up your list box to display customers. -- Larry
