Skip to Content
0
Former Member
Jan 06, 2012 at 09:19 AM

Recordset Issue

29 Views

Experts,

I have written

Dim query As String = "Select DateDiff (dd, getdate(). ExpDate) from OBTN where DistNumber = ' " & BatchNum & " ' "

MessageBox.Show (oRec.Fields.Item (0).Value) is giving invalid index etc...

How to get this value?

It will always return 1 value.

so looping can be excaped.