DataRow.Select Weirdness!

  • Thread starter Thread starter Lucas Tam
  • Start date Start date
L

Lucas Tam

Hi all,

I'm doing something really simple with my datarows:

Dim DIAL As DataTable
DIAL = DS.Tables("Dial")

' Define the whereClause as a string to select the record by refno
Dim whereClause As String = ("refno = " + CType(Me.refno, String) _
+ " AND campaignID = " + CType(Me.campaignID, String))

' Define an array of DataRows to hold the results of the query.
Dim DR() As DataRow
DR = DIAL.Select(whereClause)


Sometimes DR.Length returns > 1... BUT, the dataset is GUARANTEED to have
only 1 reference number that matches (I checked the database).

So my question is - how come DataTable.Select returns more than one
row... when in case there should be only one matching row?

Unfortunately this error happens rarely (once every 2500 - 3000
iterations)... so i can't use a debugger to reproduce it easily.
 
Back
Top