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...
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