posted 22 years ago
Yes, you closed your result set by requesting a new one from the statement.
you can get around this by 3 methods:
- improve your sql (if your tables have data that relates to each other)
- instantiate a second statement
- copy your data from the first result set into an array, list or vector before requesting your second result set
I'd try the first, but you didn't specify any fields in your example so it's difficult to tell in your case
Adam
I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.