spiralmind
Technical User
i am attempting to fill an array of values used in my code with data pulled from a query or a sql string.
i have successfully incorporated sql strings and even an argument-fed sql-string generator into my code, and have used an ado recordset and the 'getrows' function to fill an array with values from a table, but when i try to define the recordset with a sql string instead of a table's name (which the built-in help seems, as far as i can tell, to say is possible) i get an error concering an non-optional argument (but which in no way indicates exactly what argument isn't optional and/or why it would be when i am pulling data from a table but not when i am pulling it from a sql 'select' statement.
is there something i am missing here (should i specify a different connection provider...), or should i find a different approach to fill my array).
thankyou for your time and advice.
i have successfully incorporated sql strings and even an argument-fed sql-string generator into my code, and have used an ado recordset and the 'getrows' function to fill an array with values from a table, but when i try to define the recordset with a sql string instead of a table's name (which the built-in help seems, as far as i can tell, to say is possible) i get an error concering an non-optional argument (but which in no way indicates exactly what argument isn't optional and/or why it would be when i am pulling data from a table but not when i am pulling it from a sql 'select' statement.
is there something i am missing here (should i specify a different connection provider...), or should i find a different approach to fill my array).
thankyou for your time and advice.
