BCB5/IBO4.2.Id
Anybody else had a problem with patch Id?
I get the following in the monitor now when I edit a record, and I
think it's in the **IBO-generated** SQL below. My table has a
FIRSTNAME field, and going back to Ib it works fine, with no sign of
this select.

[ 27/04/2003 10:18:43 AM ]
PREPARE STATEMENT
TR_HANDLE = 17322604
STMT_HANDLE = 23600008

SELECT First NAME CLIENTS.CLIENTNO
FROM CLIENTS C1
WHERE CLIENTS.CLIENTNO=?
AND IS_ACTIVE='T'

FIELDS = [ Version 1 SQLd 1 SQLn 1
CLIENTS.CLIENTNO = 519 ]

SECONDS = 0.010

ERRCODE = 335544569
------------------------*/
16/*-----------------------
[ 27/04/2003 10:18:43 AM ]
INTERPRETE BUFFER =

SECONDS = 0.000

ERRCODE = 17
------------------------*/
17/*-----------------------
[ 27/04/2003 10:18:43 AM ]
INTERPRETE BUFFER = Dynamic SQL Error

SECONDS = 0.000

ERRCODE = 21
------------------------*/
18/*-----------------------
[ 27/04/2003 10:18:43 AM ]
INTERPRETE BUFFER = SQL error code = -104

SECONDS = 0.000

ERRCODE = 31
------------------------*/
19/*-----------------------
[ 27/04/2003 10:18:43 AM ]
INTERPRETE BUFFER = Token unknown - line 1, char 14

SECONDS = 0.000

ERRCODE = 4
------------------------*/
20/*-----------------------
[ 27/04/2003 10:18:43 AM ]
INTERPRETE BUFFER = NAME

SECONDS = 0.000

ERRCODE = -1

I have 2 TIB_Queries on this form for this table, one for a
TIB_Grid...
SELECT C1.CLIENTNO
, C1.LASTNAME
, C1.FIRSTNAME
, C1.FULL_NAME
, C1.ELEMENTNO
, (select E.ELEMENT from ELEMENTS E where
C1.ELEMENTNO=E.ELEMENTNO)
as ELEMENT
, C1.OFFICE
, C1.LAB
, C1.BLDGNO
, (select B.BLDGNAME from BUILDINGS B where C1.BLDGNO=B.BLDGNO)
as BUILDING
, C1.CAMPUSNO
, (select C.CAMPUSNAME FROM CAMPUS C where
C.CAMPUSNO=C1.CAMPUSNO)
as CAMPUS
, C1.PHONE1
, C1.PHONE2
, C1.FAX
, C1.EMAIL
, C1.USE_EMAIL
, C1.ACCNTHLDR
, C1.IS_ACTIVE
, C1.IS_ACCNTHLDR
FROM CLIENTS C1
where IS_ACTIVE='T'

and one for a TIB_LookupCombo...
SELECT CLIENTNO
, FULL_NAME
FROM CLIENTS
where IS_ACCNTHLDR='T'

Regards,
Steve