Parameters are Quicker
How is parametrizing a recordset faster than simply changing the filter and
reopening? I know that the parameter method will only generate one SELECT call
to the ODBC driver, wheras the filter method will rebuild the entire SELECT.
But how? When you change the parameters, the WHERE clause changes and it would
seem another SELECT statement would have to be sent to the ODBC driver. So
what kind of statements does the driver receive that makes the parametrizing
more effiecnt than refiltering? Thanks.
Chris