Subject Re: [IBO] UpdateSQL
Author Helen Borrie
At 08:43 PM 11/01/2004 -0600, you wrote:
>Sometimes when I use the "Generate for table" on the updatesql tab of
>tIBOQuery it uses the db_key instead of the primary key field in the where
>statement. What causes this? How do I get it to use the primary key(s)?
>(other than typing them in, of course).

By setting KeyLinks. If you can't be bothered with the typing, set
KeyLinksAutoDefine to true. But do prepare the query in the IDE and check
what IBO gets as KeyLinks.

KeyLinksAutoDefine doesn't always work. You can't avoid the typing if the
query is joined or if a single-table query doesn't include the PK.

Even if you include KeyLinks and they are not valid, IBO won't be able to
generate valid UpdateSQL. xxxSQL has to target one and only one row in one
and only one table. It can use the db_key to do this for a single-table
query but not for the KeyRelation of a joined query.