sql reader question

[Ricky D]

Hi people,

in my Taxi app I use a reader to access data from my SQLite database.

Is there a way to tell if the reader is open? I run into this error

Cannot set CommandText when a DataReader is active

I'd like to do something like

If reader.IsOpen=true Then reader.Close

before I try to set the command's CommandText method.

Is there a way to tell if the reader is open?

If not should I use reader.Dispose to get rid of it and then use reader.New1 when i need to use the reader?

any help appreciated.

regards, Ricky

Edit: tried doing .Dispose then when I need it use .New1. Here is my code

ErrorLabel(frmShifts_Show_Error1)
retry:
reader.Value=cmd.ExecuteReader
.
. other code
.
Return

frmShifts_Show_Error1:
reader.New1
Goto retry

I find the code at .New1 keeps getting executed once the 1st error is trapped
Any ideas?

[Erel]

After you set the reader's value once you can close it even after it's closed.
IsNull(reader.value) will return true before you set the reader's value for the first time.

Something like this should solve your problem:

If IsNull(reader.value) = false then reader.close
cmd.CommandText = ...

[Ricky D]

Thanks Erel.

That works just right

regards, Ricky