Search code examples
lotusscriptlotus-formula

Translate SQL script to Lotus Formula

how to translate this code?

Select * from view.view where ageYear = "combobox.value"

I know the code in sql but i cant do it in lotus script,

Solution

  • @DBlookup is your friend. I haven't written Formula in a long, long time--all my major code for Domino is in Java now, but something like

     @dblookup("Notes": "NoCache"; "" : "ViewName"; "combobox.value"; columnnumber)

    You cannot look up multiple columns with one @dblookup the way you can select them in SQL. You will need multiple @dblookups.

    Also, this assumes you have a view sorted by the indexed value, in your case ageYear.

    If you really need multiple columns, perhaps you should be using LotusScript or Java, or reanalyzing what you are trying to do. Context would help.