ODBC and scripts in version 6 vs version 7

I am currently a version 6 user. I have scripts that import data from MS Access.

There are two limitations of v6 that I would like to ged rid of. And I am wondering if v7Pro solves these issues. I browsed the user manual for v7 but did not find what I need.

The ODBC connectivity in version 6 does not allow me to use a parameter. In other words, I cannot run a parameter query. I cannot say, give me all rows where price > 5, where 5 is a value that my user entered.

The second limitation is the script maker field mapping. V6 has the way of remembering the last field mapping you did when you record the script. Once you create multiple scripts you really cannot go back and debug the field mappings. At least I cannot. I happen to be an advanced programmer with various languages and tools and I find the script maker in v6 to be very limiting.

Is there anyone who can comment on v7Pro ODBC and script making capabilities. Is v7 Pro sufficiently better than v6? Does one have to go to the advanced version to have robust ODBC imports and script making?

I would appreciate your direction.

Thank you

Erol