The GetDataValue method is a wonderful tool, especially if you combine it with an array. It allows you to retrieve data from Impromptu back into the macro and store the data into an array for loop processing. There is another set of methods, the SQLExec family, that can achieve the same results without the overhead of Impromptu. I use it when I want to 'slim down' the process, or when row count accuracy is vital.
Regards,
Dave Griffin