<div>
That was easy :)<br />
<br />
Thanks!
</div>


<div>
<div class="content wysiwyg-content">
I'm having some problems with an app I'm making.<br />
<br />
It collects data from a text-file, but I'm dependent on having unique values. Unfortunatly the text-file I'm grabbing data from, has a few duplicate entries and this is causing a problem when using this code where tbl_data_unique is Primary Key:<br />
<br />
dtagames.Recordset.AddNew<br />
&nbsp; &nbsp; <br />
dtagames.Recordset!tbl_dat<wbr />a_unique= ldata(0) <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
dtagames.Recordset!tbl_dat<wbr />a_name = ldata(1)<br />
<br />
It's possible to remove the primary-key and remove duplicate records afterwards, but my preferred solution would be to have some error handling, skipping the recordset-creation if the fieldvalue already exists (As I'm getting an error message, it should be possible to trap this message and move on, shouldn't it?).<br />
If this is not possible however, I would like to get some advice on removing duplicate entries in my table efficiently.<br />
<br />
Thank you for your time...<br />
<br />
EDIT: Sorry for posting this in the wrong section. Visual Basic -&gt; VB DB would be more appropriate.<br />
<br />
Tyrron<br />

</div>
</div>


I'm having some problems with an app I'm making.

It collects data from a text-file, but I'm dependent on having unique values. Unfortunatly the text-file I'm grabbing data from, has a few duplicate entries and this is causing a problem when using this code where tbl_data_unique is Primary Key:

dtagames.Recordset.AddNew
    
dtagames.Recordset!tbl_data_unique= ldata(0) 
                
dtagames.Recordset!tbl_data_name = ldata(1)

It's possible to remove the primary-key and remove duplicate records afterwards, but my preferred solution would be to have some error handling, skipping the recordset-creation if the fieldvalue already exists (As I'm getting an error message, it should be possible to trap this message and move on, shouldn't it?).
If this is not possible however, I would like to get some advice on removing duplicate entries in my table efficiently.

Thank you for your time...

EDIT: Sorry for posting this in the wrong section. Visual Basic -> VB DB would be more appropriate.

Tyrron


A problem with duplicate records

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.