RE: 4GL Cursors again

from your syntax below you are using the same name for each prepare statement. this is not allowed... prepare l6pp_lause from sel_lause -- teeme executable SQL lause prepare l6pp_lause from sel_lause -- teeme executable SQL lause this is your real error... Russ... }---------- }From: Margus V=E4li[SMTP:mvali@kirmus.ee] }Sent: Monday, March 31, 1997 8:49 AM }To: informix-list@rmy.emory.edu }Subject: 4GL Cursors again } }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? } }function raport_ajal() } . } . } . } prepare l6pp_lause from sel_lause -- teeme executable SQL lause } declare k_ajal cursor for l6pp_lause } . } . } . }end function } } }function raport_ajak() } . } . } . } prepare l6pp_lause from sel_lause -- teeme executable SQL lause } declare k_ajak cursor for l6pp_lause }|=20 }| Cursors must be uniquely declared within one program module. }| See error number -4371. } . } . } . }end function } }on and on 2 more times like this (got 4 functions containing }curson declarations, l6pp_lause is a local scope char variable) } }thanks for your time, }mv }