Multiple Tables

Greetings,

I am new at using the DBI module and have a simple question, I think.
However it is more complicated than I seem to be able to figure out.
Your help is appreciated.

I am using the Pervasive data base, and accessing it via DBI::ODBC. No
problem there. My problem is when I wish to access multiple programs
in the same program.

Access table 1.
Return multiple rows.
Manipulate the data in each row.
For each row, access table 2.
Return Multiple rows.
Manipulate the data in each row.
For each row, access table 3.

I do the read of the first table just fine.
I then do the read of the second table just fine.
I then do the read of the third table just fine.
Then I wish to go back to the read of the third table, using the second
row of the second table, and I get a data base handle error. As near
as I can tell, the third table handle overwrites the handle for the
second table.

I have tried to do it multiple ways, and always seem to do fine going
downwards, but have errors when seeing the second row.

I have looked in the Programming Perl DBI and can't seem to find this
situation discussed.

Would someone be kind enough to point me in the right way? I suppose
that I could do it creating hashes, but I would think that there must
be another way. (Like a "Get Next" command).

Any ideas would be appreciated!

Richard Hug

.