Subject Re: [IBO] TIB_Query with master link not allowing updates
Author Helen Borrie
At 03:54 PM 25/08/2004 +0000, you wrote:
> I have a problem with a query where it will not allow
>updates/inserts, etc when the masterkey is defined.
>In the SQL statement I use:
>In the KeyLinks field:
>A generator:
>In the MasterLinks field:
>When I set this up I am unable to get the records to
>allow an insert (the set is empty). If I use the SQL
>it will allow edits, but I am then unable to link it
>to the Master set that I need to use.
>What am I missing?

a) MASTERID in the master set isn't unique, or has nulls?
b) Master set is joined and you don't have KeyLinks for it?
c) Both?
d) Master set comes from an unkeyed table?

>IB4.3Aa, XP Pro, TIB_Query/TIB_Datasource/TIB_Connection

Now I'm *really* going to bed.