Hi,

Just for starters, I'm using FB 1.5 embedded and IBO 4.2Id.

An error occurs when changing the TIB_Query.OrderingItemNo.
Here's the exception error and call stack:

exception class : EIB_ISCError
exception message : ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 14
NAME
.

main thread ($558):
$0051AF84 Codiac.exe IB_Session TIB_SessionBase.HandleException
$00551E42 Codiac.exe IB_Components TIB_BDataset.SysLookupKeyForBufferFields
$005525BD Codiac.exe IB_Components TIB_BDataset.LookupKeyForFields
$0054ACD1 Codiac.exe IB_Components TIB_BDataset.SetBookmark
$00540F57 Codiac.exe IB_Components TIB_Dataset.SysRefresh
$00540915 Codiac.exe IB_Components TIB_Dataset.RefreshKeys
$0053F399 Codiac.exe IB_Components TIB_Dataset.SetOrderingItemNo
$00701C5F Codiac.exe PSearchFRMu 59 TPSearchFRM.ComboBox1Change

Here's the output by IB_Monitor prior to the error:

/*---
PREPARE STATEMENT
TR_HANDLE = 17722328
STMT_HANDLE = 17720596

SELECT First NAME PARENTS.FAMILY_ID
FROM PARENTS
WHERE PARENTS.FAMILY_ID=?

FIELDS = [ Version 1 SQLd 1 SQLn 1
PARENTS.FAMILY_ID = 3114 ]

ERRCODE = 335544569
----*/
/*---
INTERPRETE BUFFER =

SECONDS = 0.010

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

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

ERRCODE = 31
----*/
/*---
INTERPRETE BUFFER = Token unknown - line 1, char 14

ERRCODE = 4
----*/
/*---
INTERPRETE BUFFER = NAME

ERRCODE = -1
----*/


When reading the query that is automatically generated by IBO:
SELECT First NAME PARENTS.FAMILY_ID
FROM PARENTS
WHERE PARENTS.FAMILY_ID=?

I can see why the error occurs. What I'm finding odd, is that there
is no field called NAME in that table, or any table in the database.
I do have fields containing NAME in them(PG1_FIRSTNAME, PG1_LASTNAME,
PG2_FIRSTNAME and PG2_LASTNAME), and those fields do have display and
grid labels(i.e. "Parent/Guardian No.1 - First Name").

Is there an explanation why the above query might be generated as it
is?

And, before I forget, TIB_Query.CommitAction:=caRefresh,
TIB_Query.RefreshAction:=raOpen, TIB_Transaction.Isolation:=Committed
and TIB_Transaction.AutoCommit:=True.

Thank you in advance.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)