>OK, thanks. This 'seems' to be a little inconsistent with how you were constructing the WHERE clause back in Message #
1295677, but maybe I'm missing something.
>
>So I'm just trying to get a handle on what specifically is in the SQL text that you're passing to sqlexec.
That depends on the actual contents of the 'cWhere' variable :). That could include the parameters (just a question mark in front of the variable). IOW, I did not specify whether parameters or merge text was used.
so the whereclause could be something like:
City = ?THISFORM.City AND Address LIKE ?m.Address
As long as the variable is in scope (Public or private), this would work well
Walter,