CURSOR behavior

Help needed!!

I have two tables which each have a column called VERSIONNUM. I am doing a basic lookup query based on that field. I am using a cursor; that can't be changed because the results get put into and eventually parsed from the sqlda.

The function has three entry points: open, fetch, and close. At open time, both a cursor that checks the first table and a cursor that checks the second table are prepared. Initially, only one of the cursors is opened and the DESCRIBE SELECT LIST command issued.

At fetch time, if the FETCH fails (i.e. the row with VERSIONNUM cannot be found), it closes the first cursor, opens the second, does a DESCRIBE SELECT and fetches from there.

That executes fine and it exits my static query with no error, but some of the columns returned have corrupted results. Why? Each fetch fetches into the same sqlda but why should that be a problem since both tables are exactly the same? Is there a way to reset the sqlda?

Thanks for any help. Received on Wed Sep 06 2000 - 19:45:27 CDT