troubleshooting Question

Urgent Help

Avatar of varvoura
varvoura asked on
Lotus IBM
15 Comments2 Solutions220 ViewsLast Modified:
Hi all,

I need some clarification on the following code. What I am trying to do is to check against a multivalue field and explode its list then use the evaluate command to evaluate and use the variable in my Lotusscript and odbc query.

Here's what I am trying to do, please let me know if it works,

fielda - multivalue field on a configuration document which contains may codes on some documents and one code on other documents, for example, 10, c, 34,....

in my lotusscript, I will get the value of this field:

getfielda=doc.fielda(0)

Then I will declare a variable

fieldacontent=("@explode(getfielda,doc)
fieldaeval=Evaluate(fieldacontent)

To what I understand is that I can now use fieldaeval in my script to check whether an imported field has a value which is contained in fieldaeval so that if it does, we don't import the document.

qry.sql = select fieldb, fieldc, fieldd, fielde, from testtablea Order by fieldd " and NOT +fieldaeval+ contains '" & fielde & "'"

Where fielde is the field that i want to make sure that the value in it is not equal to any of the values in fielda which is on the configuration document.
Will this work? is the syntax of at the end of the query correct ? NOT .........

Thank you all in advance.

ASKER CERTIFIED SOLUTION
madheeswar

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros