At 08:25 AM 03-07-02 +0000, you wrote:

>Helen,
>did you try using parameters and parametrized where conditions as I
>described in my first message? The example you posted works
>correctly, but mine was different!
>If you use a parameter for SKIP and another for a WHERE condition it
>will returns 0 rows.

It works as expected:

select first 2 skip :par1 * from AIRCRAFT

{prepare]

parambyname('par1').AsInteger := 2;

output:

OID REGISTRATION
3 WOMBAT
4 TAZTIGER

select first 2 skip :par1 * from AIRCRAFT
where registration not starting with 'W'

parambyname('par1').AsInteger := 2;

OID REGISTRATION
4 TAZTIGER

Do you notice that only one row comes back, although the statement
requested two? This is correct behaviour, too. You don't get an exception
in the case where there are insufficient eligible rows.

regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com