Re: ESQL/C - Reuse a Cursor?

Posted in 1994

Danni Bauer — 28 Sep 1994 13:01:05 GMT — source: Informix-list mailing list archive (1991-1998)

Edward (Nick) Nobbe (nnob@loc.gov) wrote: > Does anyone know a way to reuse a cursor in an ESQL/C program? > I have a standard report routine that fetches & formats & formats data > from four group-by queries. The group-by queries work on same temp table. > It would be convenient if I could declare a new group-by with the same > cursor because the cursor and the routine are tightly linked, but Informix > won't let me redeclare the same cursor for the next routines even after > I have closed and freed the cursor. <sig removed> I think it would work if you use the same set of code i.e. build a string, PREPARE and DECLARE. -- ooooOOOOoooo....ooooOOOOoooo....ooooOOOOoooo....ooooOOOOoooo....ooooOOOOoooo o-o Danni Bauer | \\ o | O oo o-o o-o bauer@gtetel.com | / | | | | | | | o-o o-o-o o o o | 73764.63@compuserve.com