Hi,
Whats the best way of capturing a null returned from a query?
What through me last night was I knew the table I was querying was empty, so
I thought the data reader HasRows method would be enough. Hoever, after
sleeping on the problem I thought I'd just try my query straight into Query
Analyser, and then it dawned on me that my query was a aggregate query. So
it returns a a Row with NULL.
This was what I was trying to do - avoid nulls
If MyDataread.HasRows Then
MyDatreader = .......(CommandBehavior.Default)
Do While MyDataread.Read
SELECT Max(Rank+1) as MaxRank FROM MyTable
......
Loop
Else
......
Any assistance greatfully accepted.
Thanks
JonesGJ