I'm trying to create an array that is the same size as the number of records in a table. I did a query to find out how many records are in the table, but when I create the array, I get the error "Expected integer constant"

Does anyone know how I can convert to an integer format? My code is below:

openrs rsSeverityCount, "SELECT Count(*) AS severityCount FROM severity;"
Dim severityLen : severityLen = rsSeverityCount("severityCount")
Dim arrDays(severityLen)

The parameter in a Dim statement must be a literal constant - variables are not allowed.

You could rearrange your code to use ReDim as follows:
Bruce Luckcuck
Director, Applications & Support Services
Wiley Publishing, Inc.