954,566 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

How to check if a particular row is exist before inserting it?

hi all,
How to check if a particular row is exist before inserting it?
my table has ID as Primary key, and 2 other columns, say Process and technology..
thank you

isumasama
Newbie Poster
18 posts since Feb 2006
Reputation Points: 11
Solved Threads: 0
 
hi all, How to check if a particular row is exist before inserting it? my table has ID as Primary key, and 2 other columns, say Process and technology.. thank you


what i did was:

temp = DCount("Field", "Table", "Condition")


it worked, and if there's record then temp >0

isumasama
Newbie Poster
18 posts since Feb 2006
Reputation Points: 11
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: