How to use a primary key query

[sunnysrivastava84]

Iam using VB6.0
i want to know the query of how to check for the record which is already in the database using the primary key

[Killer42]

Iam using VB6.0
i want to know the query of how to check for the record which is already in the database using the primary key

How are you accessing the database? And what kind of database is it - an MDB file?

[sunnysrivastava84]

Well i am using VB6.0 nd SQL server 2000,i am connecting via a string.can u tell how to look wheather a record already exists or not before adding a new record using the primary key,plz give me the query

[sukeshchand]

suppose you have a table having structure like this
PurMaster-Fields(PurID,PDt,Amt)
Write an sql query like the following before you start insert to database
"Select Count(*) from Purmaster where PurID=" & val(txt_PurID.text)"
and if the query results >0 then avoid updating

[sukeshchand]

In the above note the PurID is the Primary Key

[sunnysrivastava84]

Thanx,but can you give the full code using an example to check wheather a record exists or not before adding the record

[sukeshchand]

Dim rs As New ADODB.Recordset
rs.Open "Select count(*) from Purmaster where PurID=" & Val(txt_PurID.Text), conn, adOpenForwardOnly, adLockReadOnly
If rs(0) > 0 Then
    MsgBox "the Pur ID is already exist. please enter another one...", vbCritical
    rs.Close
    Exit Sub
End If
rs.Close
'Code for adding project