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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.