Subject | Re: [IBO] Problem with Search Mode |
---|---|
Author | Christian Gütter |
Post date | 2003-11-15T11:04Z |
Hello Helen,
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?
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
>>I have, but it does not work:As I said, I cannot enter the search mode.
>>
>>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?
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:Tried it, but no difference.
> t_personal.firma=firma
> 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