DataSet Select error

[tshad]

I have the following line which I believe was working before. The error I
am getting is:

An unhandled exception of type 'System.Data.Ev aluateException ' occurred in
system.data.dll

Additional information: Cannot find column [F1].

I am getting this error from the last line of:

sTemp = DataSetObj.Tabl es(1).Rows(0)(0 )
sTemp = DataSetObj.Tabl es(1).Rows(0)(1 )
drCollection = DataSetObj.Tabl es(1).Select("F 1 = 'FRANK'")

I am getting data in the 1st 2 lines so obviously there there is a column 1
(which is what F1 is supposed to mean).

So why the error?

Thanks,

Tom

[Cor Ligthert [MVP]]

Re: DataSet Select error

thad,

But is there a column with the name "F1"

Cor

"tshad" <t@home.comschr eef in bericht
news:udzM7eMcHH A.4352@TK2MSFTN GP03.phx.gbl...

>I have the following line which I believe was working before. The error I
>am getting is:
>
An unhandled exception of type 'System.Data.Ev aluateException ' occurred in
system.data.dll
>
Additional information: Cannot find column [F1].
>
I am getting this error from the last line of:
>
sTemp = DataSetObj.Tabl es(1).Rows(0)(0 )
sTemp = DataSetObj.Tabl es(1).Rows(0)(1 )
drCollection = DataSetObj.Tabl es(1).Select("F 1 = 'FRANK'")
>
I am getting data in the 1st 2 lines so obviously there there is a column
1 (which is what F1 is supposed to mean).
>
So why the error?
>
Thanks,
>
Tom
>
>