However....it doesn't work when I try the property command. -----Original Message----- From: Dawn Oakes Sent: Thursday, January 20, 2005 9:04 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Dynamical Listboxes
Charlie - you are so resourceful! What a great idea. So if you type your where clause into a lookup box and then paste it into notepad, you should see the proper syntax. I typed WHERE custname contains 'FRANK' ORDER BY custno ASC in my where clause and this it what it looks like in notepad - LookUpWhereClause = 'WHERE custname contains '#39'FRANK'#39' ORDER BY custno ASC' Dawn -----Original Message----- From: Charles Parks [mailto:[EMAIL PROTECTED] Sent: Thursday, January 20, 2005 8:42 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Dynamical Listboxes Precno is the <ComponentID> of my DBListBox Pno is one of the columns in the table that drives the DBListBox. A trick that I have found out is to copy a component from the designer into notepad. Make a change to the component copy the new component into notepad and then compare the old definition to the new definition. Each item that appears between object and end is a candidate for the property command. Making changes to component in the designer and the pasting then object to notepad returns possbile values. I have found a few instances where this won't work though. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Posted At: Thursday, January 20, 2005 6:37 AM Posted To: RB7-L Conversation: [RBG7-L] - Re: Dynamical Listboxes Subject: [RBG7-L] - Re: Dynamical Listboxes Charlie, Where are you getting the syntax for these property commands? >PROPERTY Precno LookupWhereClause 'where Pno = 12'
