None, leave them blank. Any query like this I presume is for read-only and
limited purposes.

Even if you leave KeyLinksAutoDefine to true it should not provide any. This
is an aggregate situation which it knows it cannot determine any keylinks
columns.

Remember, it isn't to resolve a unique fetch in the dataset but a unique
record in a table or view on the server.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Carlos H. Cantu" <ibo@...>
To: "Jason Wharton" <IBObjects@egroups.com>
Sent: Wednesday, January 17, 2001 4:45 AM
Subject: [IBO] KeyLinks ?


> What should I defined as the KeyLink in the following SQL :
>
> select v.cliente, cli.nome, sum(p.qtde) as totqtde
> from vendas v
> join prodnota p on p.id_num = v.id_num
> join clientes cli on cli.codcli = v.cliente
> where (p.codprod = :codprod) and (v.emissao between :dia1 and :dia2)
> group by v.cliente, cli.nome
>
> When I try to define it as vendas.cliente I get a "Invalid KeyLinks".
> Should I leave KeyLinksAutoDefine=true ?