Forum Discussion

kktsenthil's avatar
kktsenthil
Occasional Contributor
9 years ago

Need Help on Data retrieval from DB and Find the particular value count

Hi All,   I need a valuable help please   right now i retrieved value from the database and wat to find the field value count for example   User Name: King i inserted a record in to the DB an...
TanyaYatskovska's avatar
TanyaYatskovska
SmartBear Alumni (Retired)

Hi,

The code looks good. Doesn’t it work?

kktsenthil's avatar
kktsenthil
Occasional Contributor
9 years ago

Yes the code works fine and need to find the duplicate value..

  • leandroaraujoso's avatar
    leandroaraujoso
    Contributor
    9 years ago

    Try this:

     

    Qry.SQL = "select * from Test_Main.dbo.tbtable where name_field = 'King'

     

    and then ...

     

    if (Qry.RecordCount > 1)

      Log.Message("There are duplicate records for the query executed.");

     

    Let me know if that helps.

     

    Regards,

     

    Leandro de Araújo Souza

     

     

  • NisHera's avatar
    NisHera
    Valued Contributor
    9 years ago

    Please have a look at this 

    • Ravik's avatar
      Ravik
      Super Contributor
      9 years ago
      Hi If you want to get count for perticular records the try query like - "select count(*) as Recordcount from Test_Main.dbo.tbtable where name_field = 'King'" it would be give you the count of all record where field value = "King"