Marc-
It seems like you haven't identified what 'a' is supposed to be representing within your program. When the program can't match up an unidentified value with one that has been specified, you're going to run into trouble. Just as you stated 'WHERE table_name.field_name = ?b', you need to do the same thing for 'a'. Good luck solving your problem.
-Charlie



>Hi, all...
>
>I am trying to create a quary to use with a view. I want the query to be as generic as possible so that it can be used with different run-time specified fields in the table.
>
>The following works.
>
>SELECT
> FROM database_name!table_name
> WHERE table_name.field_name = ?b
>
>It prompts me for b and I give it something that I know will be found in field field_name and it gives me the results. Great.
>
>However, this does not work.
>
>SELECT
> FROM database_name!table_name
> WHERE ?a = ?b
>
>It prompts me for a and I give it table_name.field_name (_just_ like I specified in the first example). Then it prompts me for b and, again, I give it something that I know will be found in field field_name and I get results of 0.
>
>What is different between these two that causes it to not do what I want? How can I make it do what I want?
>
>As always, TIA...
>
>Marc Mandel