Clovertech

SQL Count in Advanced DB Lookup

› Clovertech Forums › Cloverleaf › SQL Count in Advanced DB Lookup

  • Creator
    Topic
  • July 11, 2019 at 4:50 pm #110585
    Mary Kobis
    Participant

      I’m trying to do a  SQL select Count(column) from DB where condition. I’m not getting any value back, not even the 0 (zero) for Use default. Does it work here, or do we need to call a stored procedure instead? Thanks, Mary.

      CL6.2/AIX7

    • Creator
      Topic
    Viewing 0 reply threads
    • Author
      Replies
      • July 12, 2019 at 2:14 pm #110607
        Mary Kobis
        Participant

          Ok.. needed to add “as <value>” to the  select Count(column)  for it to work! Thank you Peter!

      • Author
        Replies
      Viewing 0 reply threads
      • You must be logged in to reply to this topic.