I found that if a #39 shows up that means to substitute with a quote mark. I did try it both ways though and didn't get much luck. I also tried creating the list box with a similar where clause and running this:
GETPROPERTY PrecNo LookUpWhereClause 'vLWhere' PAUSE 2 USING .vLWhere SET VAR vLWhere = (SRPL(.vLWhere, 'b', 'e', 0)) PROPERTY Precno LookupWhereClause .vLWhere PROPERTY PrecNo Refreshlist 'True' The list still seems to go blank afterwards. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Oakes Posted At: Thursday, January 20, 2005 8:04 AM Posted To: RB7-L Conversation: [RBG7-L] - Re: Dynamical Listboxes 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'
