Subject | Lookup issue |
---|---|
Author | paulo@tgr.com.br |
Post date | 2004-04-20T21:41:42Z |
I have a TIB_LookupCombo whose SQL contains a where clause. Using the
monitor it showed that whenever I access the combo IBO executes the
same SQL changing the where clause using the fields in KeyLinks and
ignoring my where clause. I think that IBO is probably trying to
obtain the primary keys. But since it ignored my where clause I get a
message saying that the query is returning multiple records where a
singleton selecg is expected. That wouldn't happen if my where clause
weren't ignored. How could I go around it, having IBO maintaining my
where clause?
Thanks
monitor it showed that whenever I access the combo IBO executes the
same SQL changing the where clause using the fields in KeyLinks and
ignoring my where clause. I think that IBO is probably trying to
obtain the primary keys. But since it ignored my where clause I get a
message saying that the query is returning multiple records where a
singleton selecg is expected. That wouldn't happen if my where clause
weren't ignored. How could I go around it, having IBO maintaining my
where clause?
Thanks