hi folks, any idea how to loop through a cursor until it's eof? i'll try to do it this way: declare cursor ..... (with param) open cursor .... (param); fetch into record .... while found ... anything here fetch into record end loop am i right? can not try it at the moment. any suggestions? thanx, tom -- Geschenkt: 3 Monate GMX ProMail gratis + 3 Ausgaben stern gratis ++ Jetzt anmelden & testen ++ http://www.gmx.net/de/go/promail ++ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx