If the literal string you are looking for = #39'SMC'#39 PROPERTY vlookuplist LookUpWhereClause 'WHERE LOCATION = ''#39''''SMC''''#39'' ORDER BY LastName ASC' The are multiple levels of quote interpretation going on here.
If you were to use this where clause in a direct SQL statement it would need to be: WHERE LOCATION = '#39''SMC''#39' ORDER BY LastName ASC You have to double the quotes contained in the string so '#39''SWC''#39' is evaluated to #39'SWC'#39 for the search Since you are creating a string to contain the clause you need to double all the quotes embedded in that string. Dennis McGrath ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Roberts, Jennifer Sent: Wednesday, December 10, 2008 10:52 AM To: RBASE-L Mailing List Subject: [RBASE-L] - LookUpWhereClause Hello, I have a variable listview, and I am trying to change the lookupwhereclause through code. It was working before when the clause with written like this: PROPERTY vlookuplist LookUpWhereClause 'WHERE LocationID = 1 ORDER BY LastName ASC' PROPERTY vlookuplist REFRESHLIST 'TRUE' So why wouldn't it work like this: PROPERTY vlookuplist LookUpWhereClause 'WHERE LOCATION = '#39'SMC'#39' ORDER BY LastName ASC' PROPERTY vlookuplist REFRESHLIST 'TRUE' Thank you, Jennifer Roberts Business Applications Specialist Ohio Masonic Home 937.525.3080 x5788 This electronic message contains information from The Ohio Masonic Home, its operating subsidiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute or otherwise use of this transmission or its contents. If you have received this transmission in error, please notify The Ohio Masonic Home immediately at [EMAIL PROTECTED]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home.
