What is the mistake in formula for db search

HCL Domino Domino Forum
1

Hi

valueKB= LookUpValue * 1024 * 1024

SearchString = |(Form=“Database”) & ( Deleted != “Yes” ) |(

SearchString = SearchString + “&” +“(DBSize >=” + “”“” + valueKB + “”“)”

there is some problem in this formula… if i am harcoding DBSize it returns the correct collection but in this way it is not … what could be the problem ?

Please help…

thanks

Dev

2

Subject: What is the mistake in formula for db search

Within the dbsearch formula, a numeric field should not have quotes. Also, generally, do not use quotes as string delimiters when building formula strings in Lotuscript because they make them very difficult to read and parse.

try:

SearchString = {(Form=“Database”) & ( Deleted != “Yes” ) }

SearchString = SearchString & { & (DBSize >= } & Cstr(valueKB) & { )}

3

Subject: What is the mistake in formula for db search

in this line :SearchString = |(Form=“Database”) & ( Deleted != “Yes” ) |(

I’m not sure the final ( is needed

If DbSize is a number the quotes around the value might not be necessary.

And finally what is the type of valueKB ?

Here is something I think might work :

valueKB= LookUpValue * 1024 * 1024

SearchString = |(Form=“Database”) & ( Deleted != “Yes” ) |

SearchString = SearchString + “&” +“(DBSize >=” + cstr(valueKB) + “)”

As I’m not able to test it, I’m not sure if this will work either… ;-))

Renaud

4

Subject: RE: What is the mistake in formula for db search

valueKB= LookUpValue * 1024 * 1024 SearchString = {(Form=“Database”) & ( Deleted != “Yes” ) & (DBSize >=} & valueKB & {)}

Too many quotes.