Member Avatar for isumasama

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

  • 1 Contributor
  • 1 Reply
  • 92 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by isumasama
Member Avatar for isumasama

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.