CODEWITHSUNDEEP
lotus-notes
Michele De Nardi
Michele De Nardi

Reputation: 636

Lotus notes: change view selection formula by script

I'm trying to change view selection formula by script with this selection formula:

formula = "SELECT (@Modified = [" & Left(doc1.LastModified,10) & "])  &  form = ["& Cstr(doc1.form(0)) &"]"

But when I try to execute it Notes retrive me the following error:

Notes error: Unknown [KeyWord] for @Function (SELECT (@Modified = [03/02/2015]) & form=[myform])

Upvotes: 1

Views: 632

Answers (1)

nempoBu4
nempoBu4

Reputation: 6621

You should use quotes for form instead of square brackets.
Here is example:

formula$ = {SELECT (@Modified = [} & Left(doc1.LastModified,10) & {]) & form = "} & doc1.form(0) & {"}

Which generate this string:

SELECT (@Modified = [03/02/2015]) & form = "myform"

Upvotes: 3

Related Questions