I am using the following syntax to populate the array.
varRecords = rs.GetRows()
GetRows does not appear to return more than 1 record ... just a 1 dimensional array. I've looped through the recordset to check that there is data there. Maybe I am not referncing my array correctly.
Should be varRecords(column, row) ... right ... not working out for me. Can someone let me know what I am doing wrong or can you supply the right structure to iterate for an array (under my circumstances)?
FYI ... I am looping through a staging table that I imported from excel (which users updated) ... I am looping through the staging table you dynamically write sql statements and upate tables in my project.
thanks in advance.
Blair
varRecords = rs.GetRows()
GetRows does not appear to return more than 1 record ... just a 1 dimensional array. I've looped through the recordset to check that there is data there. Maybe I am not referncing my array correctly.
Should be varRecords(column, row) ... right ... not working out for me. Can someone let me know what I am doing wrong or can you supply the right structure to iterate for an array (under my circumstances)?
FYI ... I am looping through a staging table that I imported from excel (which users updated) ... I am looping through the staging table you dynamically write sql statements and upate tables in my project.
thanks in advance.
Blair