Re: 4GL Cursors again

Margus V'li wrote: > > hi there > > 4gl 4.20 wd1: got 4 cursors in one module, different names and all, > and the error file looks as follows. Could anyone please point > out what's wrong with it? > prepare l6pp_lause from sel_lause -- teeme executable SQL lause > declare k_ajal cursor for l6pp_lause > prepare l6pp_lause from sel_lause -- teeme executable SQL lause > declare k_ajak cursor for l6pp_lause > | > | Cursors must be uniquely declared within one program module. > | See error number -4371. > on and on 2 more times like this (got 4 functions containing > curson declarations, l6pp_lause is a local scope char variable) prepare <statement-id> from <char variable> statement-id's are not 'variables' character or otherwise, in a conventional sense. You must change the name of the second instance of '16pp_lause'. Douglas Wilson