SQL Count in Advanced DB Lookup Homepage › Clovertech Forums › Cloverleaf › SQL Count in Advanced DB Lookup Search for: This topic has 1 reply, 1 voice, and was last updated 5 years, 2 months ago by Mary Kobis. Creator Topic July 11, 2019 at 4:50 pm #110585 Mary KobisParticipant 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 KobisParticipant 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. Log In Username: Password: Keep me signed in Log In
.
.