>Naomi,
>
>I suppose Doris needs the neSigOpt field in her cursor for some kind of future processing, as for this particular query she could do with only:
>
>
>Select Lname, ;
> fname, ;
> (999 - Nvl(neSigOpt,0)) as nnIndex ,;
> Padr(confirmType(neSigOpt, lPin,lFingerReg),30) as Confdata ;
>from ther into cursor temp order by nnIndex, lName, fname
>
>
>which would give her (Isuppose) a sorting group as needed.
>
>Regards,
>
>Koen
Yes, looks like you're right, though I didn't read this thread very closely and not sure what exactly is the original problem.
If it's not broken, fix it until it is.
My Blog