Hi
can you pls help me for code to check the duplicate data before instert or update records....
i work with Ms Access database 2003 with disconnection mode (dataset) into vb.net 2008
أبو_1
0
Newbie Poster
Recommended Answers
Jump to PostI can't give you a specific query without knowing the structure of your table but in general if you do something like
SELECT COUNT(*) FROM mytable WHERE pkfieldname = value
where pkfieldname is the name of your primary key field and value is the value of …
All 4 Replies
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
أبو_1
0
Newbie Poster
أبو_1
0
Newbie Poster
KenSquare
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.