Forum Discussion

kktsenthil's avatar
kktsenthil
Occasional Contributor
11 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
Icon for Alumni rankAlumni
11 years ago

Hi,

The code looks good. Doesn’t it work?

kktsenthil's avatar
kktsenthil
Occasional Contributor
11 years ago

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

  • leandroaraujoso's avatar
    leandroaraujoso
    Contributor
    11 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
    11 years ago

    Please have a look at this 

    • Ravik's avatar
      Ravik
      Super Contributor
      11 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"