0

Error in formula

Hi

I have an issue with a formula.
When I write a query I have an alarm which says "Expected
end = select to the lire 2, column 6"
Can someone help me ?
Thanks

10 replies

null
    • Mconneen
    • 3 yrs ago
    • Reported - view

    You have two lines.  Put a 

    ;

    after the first line

    • Addinsell
    • 3 yrs ago
    • Reported - view

    Thanks but it still does not works…

    • Addinsell
    • 3 yrs ago
    • Reported - view
    • Addinsell
    • 3 yrs ago
    • Reported - view
    • Mconneen
    • 3 yrs ago
    • Reported - view

    It is hard to see the select statement above.. but it looks incorrect. 
    2020-07-07_12-19-55

    • Addinsell
    • 3 yrs ago
    • Reported - view

    Do you mean no quotes or simple quotes ?

    • Addinsell
    • 3 yrs ago
    • Reported - view

    I tried that but …44894A41-6622-46EE-9F55-8CC09C9E1812

    • Mconneen
    • 3 yrs ago
    • Reported - view

    Lost in the language..   I am not sure what line 1 is attempting.    Is this a field formula ??? or a view formula? 

    • Nick
    • 3 yrs ago
    • Reported - view

    In general has to be like this:

     

    select 'Table Name' where 'Field' = "Criteria 1" or 'Field' = "Criteria 2"

     

    e.g.

     

    select Customer where Name = "De Niro" or Name = "Ennio Morricone"

    • Nick
    • 3 yrs ago
    • Reported - view

    Oops! Sorry @Mconneen...

Content aside

  • 3 yrs agoLast active
  • 10Replies
  • 1318Views