User input used in a SQL import?

I'm using FMP 9. I have a particular query I run that requires you to
enter a date so it only pulls data for that specific date. Right now I
have the import scripted but it just brings up the query window with my
original text and I have to hand-edit the date. I'd like this to be
more user friendly so when other people use it they would just get a
dialog box to type the date in and it would be inserted intot he SQL
statement.

Can you use variables in ODBC Imports?

Re: User input used in a SQL import?

On 2007-08-21 07:29:00 -0500, Doug Anderson said:

> I'm using FMP 9. I have a particular query I run that requires you to
> enter a date so it only pulls data for that specific date. Right now I
> have the import scripted but it just brings up the query window with my
> original text and I have to hand-edit the date. I'd like this to be
> more user friendly so when other people use it they would just get a
> dialog box to type the date in and it would be inserted intot he SQL
> statement.
>
> Can you use variables in ODBC Imports?

I finally figured this one out, just use "Calculated SQL Statement"
when setting up the script. That allowed me to concatenate the
statement together using some variables and fields.