>Nick,
>
>As I explained to you in another thread, you over-complicate your life. Since you're using cursors, you don't need to create unique names for them. Get rid of all names convenctions and macros and just use plain Cursor1, Cursor2, etc. names, or you can use something like CurToUpdate, curVals, etc.
Nadya,
You don't know for sure if this level of complexity is needed or not. What if all processing takes place in one datasession? There may be a requirement to handle multiple result sets. Using the same alias (e.g. Cursor1, Cursor2) will close those work areas. IMO, you presume too much. You mentioned your opinion in the other thread; let it go.
Just my $0.02.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao