Because I beleive there is a bug in IBO and it won't allow me to use
an aliased table name in the KeyLinks property.

I have a query:

SELECT T1.ID, T2.ID
FROM TABLE1 T1
LEFT OUTER JOIN TABLE1 T2
ON (T1.ID = T2.PARENTID)

The BindingCursor for the InvalidateBookmark generates the following

SELECT T1.ID, T2.ID
FROM TABLE1 T1
LEFT OUTER JOIN TABLE1 T2
ON (T1.ID = T2.PARENTID)
WHERE TABLE1.ID = ?BIND_0

when it should actually generate

SELECT T1.ID, T2.ID
FROM TABLE1 T1
LEFT OUTER JOIN TABLE1 T2
ON (T1.ID = T2.PARENTID)
WHERE T1.ID = ?BIND_0

I've tried everything I can to put in T1.ID into the key links but it
won't allow it, it gives me a invalid keylinks.

So I'm just trying to do a work around and set the where clause
myself before the prepare of the BindingCursor. I'm quite certain
this is a bug but I need a solution fast and so I'm just trying to
get some other option.

Thanks.

--- In IBObjects@yahoogroups.com, "IB Objects" <jwharton@i...> wrote:
> There is not point in doing that because by definition that query
should
> only return a single record.
>
> What special consideration are you looking for?
>
> Jason
>
> ----- Original Message -----
> From: "Matt Nielsen" <mnielsen@c...>
> To: <IBObjects@yahoogroups.com>
> Sent: Friday, June 06, 2003 3:14 PM
> Subject: [IBO] KeyLinks
>
>
> > Is there a way to manually add the WHERE clause to the SQL
statement
> > that InvalidateBookmark will use at the last posible moment via an
> > event or other? I want to customize the WHERE clause to be more
than
> > just the KeyLinks = KeyFields.Value.
> >
> > Thanks,
> >
> > Matt
> >