June 28th, 2011, 07:41 AM
Check for existing DB entry
I am using FP 2003 with an Access DB, and I am looking for some assistance with checking for an exisiting value in the DB at the time of submitting the data to be certain a duplicate is not getting entered.
Any assistance would be greatly appreciated.
June 28th, 2011, 11:16 PM
There are a couple approaches you can take. I usually just query the db for the record in question, look at the resulting recordset and see if it's empty or not, if empty proceed with the insert else provide a message about the record already existing.
Within the DB you can put a unique index on the record, and your code can just do the insert and check for an error or not returned by the db.
I've never been able to appreciate the sublime arrogance of folks who feel they were put on earth just to save other folks from themselves .." - Donald Hamilton
July 22nd, 2011, 05:53 AM
delete duplicate querry
Deleting duplicate qurerry in your db is okay...but i have no idea how to use FP and instuct you that you have entered the same
To find a solution for this quite difficult
Thanks & Regards
web development company
Prodigy Apex technologies
Comments on this post