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.
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.