Subject | TIB_Qry and Multiple Rows... |
---|---|
Author | Magno Costa |
Post date | 2007-03-29T19:26:50Z |
Hello Friends.
I have a TIB_Query with following SQL:
SELECT CTTALHAO.COD_TALHAO,
CTTALHAO.DESCRICAO,
CTTALHAO.HA_TALHAO,
CTTALHAO.COD_PROPRIEDADE,
CTTALHAO.COD_LOCAL,
CTTALHAO.COD_INSC
FROM CTTALHAO
In KeyLinks:
CTTALHAO.COD_PROPRIEDADE=CTPROPRIEDADE.COD_PROPRIEDADE
In MasterLinks:
CTTALHAO.COD_PROPRIEDADE=CTPROPRIEDADE.COD_PROPRIEDADE
The property KeySource and MasterSource, linked to the same datasource and the property CachedUpdates as true.
When I am navigating in the registrations the following message appears:
Multiple Rows in singleton fetch
Check KeyLinks and JoinLinks properties
"My SQL appears here, following for:"
Where CTTALHAO.COD_PROPRIEDADE=?/*BIND_0*/
As I can solve that, I already researched all of the previous messages, however I didn't get to solve.
Magno
[Non-text portions of this message have been removed]
I have a TIB_Query with following SQL:
SELECT CTTALHAO.COD_TALHAO,
CTTALHAO.DESCRICAO,
CTTALHAO.HA_TALHAO,
CTTALHAO.COD_PROPRIEDADE,
CTTALHAO.COD_LOCAL,
CTTALHAO.COD_INSC
FROM CTTALHAO
In KeyLinks:
CTTALHAO.COD_PROPRIEDADE=CTPROPRIEDADE.COD_PROPRIEDADE
In MasterLinks:
CTTALHAO.COD_PROPRIEDADE=CTPROPRIEDADE.COD_PROPRIEDADE
The property KeySource and MasterSource, linked to the same datasource and the property CachedUpdates as true.
When I am navigating in the registrations the following message appears:
Multiple Rows in singleton fetch
Check KeyLinks and JoinLinks properties
"My SQL appears here, following for:"
Where CTTALHAO.COD_PROPRIEDADE=?/*BIND_0*/
As I can solve that, I already researched all of the previous messages, however I didn't get to solve.
Magno
[Non-text portions of this message have been removed]