>I have a procedure that goes thru a recordset from a DLL gets the structure of the fields, creates a cursor,and then attempts to load the actual data from the record set into an array. Then I append from that array into my cursor. Works great until I exceed array limit. Im trying to append the cusor from the array and reset the array when I hit the limit,THen I would continue on thru my loop. If I redimension the array will that clear all data or is there a better way or should I go to lunch?

Dan,

I'm not sure why you have an array involved in the process, but:

dimension myArray[10]
myArray[5] = "hello world"
myArray = ""   && contents are gone
               && but it will still be dimensioned the same size.
? myArray[5]  && returns empty string

If you are hungry, you should go to lunch < g >

HTH,