Subject Re: [IBO] Problem with Search Mode
Author Christian Gütter
Hello Helen,

>>I have, but it does not work:
>>
>>OrderingItems: FIRMA=FIRMA;FIRMA DESC
>>OrderingLinks: FIRMA=ITEM=1
>>SearchingLinks: FIRMA=FIRMA

> In what way does it not work? Is the value that you type into your search
> control getting picked up and applied to the parameter?

As I said, I cannot enter the search mode.
When I click the search button on the IB_SearchBar,
IBO executes this query:

SELECT Firma, Nachname FROM T_Personal WHERE PID =

FIELDS = [ Version 1 SQLd 8 SQLn 30
T_ANSPRECHPARTNER.ANREDE = <NIL>
T_ANSPRECHPARTNER.VORNAME = <NIL>
T_ANSPRECHPARTNER.NACHNAME = <NIL>
T_ANSPRECHPARTNER.TITEL = <NIL>
T_ANSPRECHPARTNER.GEBURTSDATUM = <NIL>
T_ANSPRECHPARTNER.ID = <NIL>
T_ANSPRECHPARTNER.PID = <NIL>
T_ANSPRECHPARTNER.GESCHLECHT = <NIL> ]

ERRCODE = 335544569
----*/
/*---
INTERPRET BUFFER =

ERRCODE = 17
----*/
/*---
INTERPRET BUFFER = Dynamic SQL Error

ERRCODE = 21
----*/
/*---
INTERPRET BUFFER = SQL error code = -104

ERRCODE = 25
----*/
/*---
INTERPRET BUFFER = Unexpected end of command

ERRCODE = -1

It is quite strange that IBO puts the field PID
in the WHERE-condition of the query. PID is not
and ordering link or searching link.

One little addition: my IB_Query is the master
in a master-detail-relationship. This relationship
is established using the field PID. Perhaps that
could be why IBO gets confused when entering the
search mode?

> Would you try changing the SearchingLinks to:
> t_personal.firma=firma

Tried it, but no difference.

> What control are you using to enter search conditions?

I cannot even enter search conditions, because IBO executes
the wrong query I have shown above when I try to enter the
search mode.
Anyway, I would like to use TIB_Edits (which are normally used
for data entry) to enter search conditions. Like it is done
in the contact sample.

Thanks for your patience,


Christian