Re: How big is my result set?

[clipped] > Mostly. It's made a little bit more tricky because if one of the > records in my reult set is deleted, there is still a place holder for > it. I don't recall exactly what sits there as I worked around it > several months ago. My problem is that just because fetch next returns > a record doesn't mean that it's a real record or that it's valid for my > program to leave the next button sensitive. [clipped] What kind of isolation level are you using? Gorazd

Gorazd Hribar Rajteric wrote: >[clipped] > > >>Mostly. It's made a little bit more tricky because if one of the >>records in my reult set is deleted, there is still a place holder for >>it. I don't recall exactly what sits there as I worked around it >>several months ago. My problem is that just because fetch next returns >>a record doesn't mean that it's a real record or that it's valid for my >>program to leave the next button sensitive. >> >> >[clipped] > >What kind of isolation level are you using? > >Gorazd > > > > To be honest, I have no idea. We never tweak those sorts of things here. The database has always been up to the job with default setings. Of course, even with our clients in full swing I doubt they do more than 10 update/insert/delete operations each minute. In the middle of the night, it might be as low as 1 per minute... -- Scott Burns Mirrabooka Systems Tel +61 7 3857 7899 Fax +61 7 3857 1368

Does my result set look big in this? -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche