Subject | Problem with Search Mode |
---|---|
Author | Christian Gütter |
Post date | 2003-11-15T00:38:10Z |
Hi,
I am trying to write an application which makes use of the
search mode. After four years of using IBO I finally needed
this feature and I thought it would be piece of cake to use
it.
Now, having tried for six hours, having read through dozens
of help files, TI sheets, online FAQs etc. I must confess that
I did not succeed.
I have not even managed to enter the search mode :-(
Every time I press the search button on my IB_SearchBar the
following query shows up in the DML monitor, accompanied by
the following error:
SELECT Firma, Nachname FROM T_Personal WHERE PID =
FIELDS = [ Version 1 SQLd 29 SQLn 30
T_PERSONAL.ID = <NIL>
T_PERSONAL.PID[PID] = <NIL>
T_PERSONAL.NACHNAME = <NIL>
T_PERSONAL.VORNAME = <NIL>
T_PERSONAL.TITEL = <NIL>
T_PERSONAL.FIRMA = <NIL>
T_PERSONAL.STRASSE = <NIL>
T_PERSONAL.PLZ = <NIL>
T_PERSONAL.STADT = <NIL>
T_PERSONAL.GEBURTSDATUM = <NIL>
T_PERSONAL.ANMERKUNG = <NIL>
T_PERSONAL.TELEFON = <NIL>
T_PERSONAL.SALDO = <NIL>
T_PERSONAL.KONTO = <NIL>
T_PERSONAL.BLZ = <NIL>
T_PERSONAL.ANBINDUNG = <NIL>
T_PERSONAL.AUSNAHME = <NIL>
T_PERSONAL.BANK = <NIL>
T_PERSONAL.LKZ = <NIL>
T_PERSONAL.GESCHLECHT = <NIL>
T_PERSONAL.ANREDE = <NIL>
T_PERSONAL.IST_FIRMA = <NIL>
T_PERSONAL.FIRMA2 = <NIL>
T_PERSONAL.E_MAIL = <NIL>
T_PERSONAL.MOBILTELEFON = <NIL>
T_PERSONAL.WWW = <NIL>
T_PERSONAL.POSTFACH = <NIL>
T_PERSONAL.PLZ_POSTFACH = <NIL>
T_PERSONAL.POSTFACH_VERWENDEN = <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
Has anybody a clue what might be going on?
If you need more information, please tell me.
Right know, I have no clue which further information
could be needed because I am totally lost (and tired).
Thanks in advance,
Christian
PS: I am using IBO 4.3 and Delphi 6 SP2.
I am trying to write an application which makes use of the
search mode. After four years of using IBO I finally needed
this feature and I thought it would be piece of cake to use
it.
Now, having tried for six hours, having read through dozens
of help files, TI sheets, online FAQs etc. I must confess that
I did not succeed.
I have not even managed to enter the search mode :-(
Every time I press the search button on my IB_SearchBar the
following query shows up in the DML monitor, accompanied by
the following error:
SELECT Firma, Nachname FROM T_Personal WHERE PID =
FIELDS = [ Version 1 SQLd 29 SQLn 30
T_PERSONAL.ID = <NIL>
T_PERSONAL.PID[PID] = <NIL>
T_PERSONAL.NACHNAME = <NIL>
T_PERSONAL.VORNAME = <NIL>
T_PERSONAL.TITEL = <NIL>
T_PERSONAL.FIRMA = <NIL>
T_PERSONAL.STRASSE = <NIL>
T_PERSONAL.PLZ = <NIL>
T_PERSONAL.STADT = <NIL>
T_PERSONAL.GEBURTSDATUM = <NIL>
T_PERSONAL.ANMERKUNG = <NIL>
T_PERSONAL.TELEFON = <NIL>
T_PERSONAL.SALDO = <NIL>
T_PERSONAL.KONTO = <NIL>
T_PERSONAL.BLZ = <NIL>
T_PERSONAL.ANBINDUNG = <NIL>
T_PERSONAL.AUSNAHME = <NIL>
T_PERSONAL.BANK = <NIL>
T_PERSONAL.LKZ = <NIL>
T_PERSONAL.GESCHLECHT = <NIL>
T_PERSONAL.ANREDE = <NIL>
T_PERSONAL.IST_FIRMA = <NIL>
T_PERSONAL.FIRMA2 = <NIL>
T_PERSONAL.E_MAIL = <NIL>
T_PERSONAL.MOBILTELEFON = <NIL>
T_PERSONAL.WWW = <NIL>
T_PERSONAL.POSTFACH = <NIL>
T_PERSONAL.PLZ_POSTFACH = <NIL>
T_PERSONAL.POSTFACH_VERWENDEN = <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
Has anybody a clue what might be going on?
If you need more information, please tell me.
Right know, I have no clue which further information
could be needed because I am totally lost (and tired).
Thanks in advance,
Christian
PS: I am using IBO 4.3 and Delphi 6 SP2.