In OnGetParams is it possible to find out which SQL statement you are on ?..

ie if I have 4 different SQL Statements in the same query and all require
different parameters, how do I know what statement the query is requesting
params for ?

Thanks
Clive.

Clive,

<< In OnGetParams is it possible to find out which SQL statement you are on
?.. >>

Yep, check out these parameters:

http://www.elevatesoft.com/dbisam4d5_tdbisamquery_sqlstatementtype.htm
http://www.elevatesoft.com/dbisam4d5_tdbisamquery_text.htm

Or did you mean the position of the statement in the script (numeric) ?

--
Tim Young
Elevate Software
www.elevatesoft.com

More the Numeric, ie Statement number 2 of 4 is being executed?.

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:E8F0BC77-5D9E-4874-9BB5-74F5CE70B759@news.elevatesoft.com...
> Clive,
>
> << In OnGetParams is it possible to find out which SQL statement you are
> on ?.. >>
>
> Yep, check out these parameters:
>
> http://www.elevatesoft.com/dbisam4d5_tdbisamquery_sqlstatementtype.htm
> http://www.elevatesoft.com/dbisam4d5_tdbisamquery_text.htm
>
> Or did you mean the position of the statement in the script (numeric) ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Clive,

<< More the Numeric, ie Statement number 2 of 4 is being executed?. >>

In that case, you'll have to increment a variable on your own every time the
OnGetParams event handler is called.

--
Tim Young
Elevate Software
www.elevatesoft.com