> I have a record set which I am fetching using getrows, like: > > arData = rsData.GetRows() > > Now I can get the columns: Ubound(arData, 1) > and the records: Ubound(arData, 2) > > Now, what I need is a fixed array, where I always have 15 columns, and > Ubound(arData, 2) records. > > But when I try to: > > ReDim Preserve arData(14, 1) or > ReDim Preserve arData(14, max no of records) > > I am getting a "Subscript out of range" > > What am I doing wrong?
The Preserve keyword is probably the culprit. You can't change the number of dimensions when using this keyword. If you haven't already, try: dim arData() redim arData(14,1) redim preserve arData(14,max no of records) -- Lon Kraemer ----------------------------------------- --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
