Duplication & insert that data to database

<i><b>Originally posted by : Azlin (azlin@inovasi.po.my)</b></i><br />hello there..<br />Anyone can help me reg. duplication data...<br />I want to insert a new data and detect if one of the field has a duplication data.<br />The problem is that the process can detect if has a dupplication data but if not, it give a error when inserting process.<br /><br />Error Message:<br />Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.<br /><br />Anyone can help me for writing the coding.<br /><br />Thanks

<i><b>Originally posted by : jeff (jeff.dillon@medcath.com)</b></i><br />I haven't seen your code so I am just guessing here...<br /><br />The error message denotes an empty record set.<br /> <br />If I understand correctly, the script fails only if you don't find duplicate data. If you are querying the database to find the duplicate data before inserting that data into the database, then check the record set against BOF and EOF before trying to evaluate any data that might be in it.<br /><br />' RS is the recordset<br /><br /><br />If not RS.BOF and not RS.EOF Then<br /><br />' the result set is not empty<br />' there is duplicate data<br />' do something here<br /> <br />Else<br /><br />' the result set is empty<br />' there is no duplicate data<br />' insert new record here<br /><br />End If<br /><br /><br />------------<br />Azlin at 5/29/2000 2:34:43 AM<br /><br />hello there..<br />Anyone can help me reg. duplication data...<br />I want to insert a new data and detect if one of the field has a duplication data.<br />The problem is that the process can detect if has a dupplication data but if not, it give a error when inserting process.<br /><br />Error Message:<br />Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.<br /><br />Anyone can help me for writing the coding.<br /><br />Thanks