--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:

> It might help if you included the SQL trace of the error.
>

Thanks for your reply Jason.

Following is the SQL trace if I execute 'select * from class'.
'select code, description from class' works OK.

PREPARE STATEMENT
TR_HANDLE = 13647736
STMT_HANDLE = 13646592
select * from CLASS
PLAN (CLASS NATURAL)
FIELDS = [ Version 1 SQLd 3 SQLn 1
CLASS.CODE = <NIL> ]
SECONDS = 0.020
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 13647736
STMT_HANDLE = 13646592
PARAMS = [ ]
SECONDS = 0.010
----*/
/*---
INTERPRETE BUFFER =
ERRCODE = 17
----*/
/*---
INTERPRETE BUFFER = Dynamic SQL Error
ERRCODE = 21
----*/
/*---
INTERPRETE BUFFER = SQL error code = -804
ERRCODE = 39
----*/
/*---
INTERPRETE BUFFER = Incorrect values within SQLDA structure
ERRCODE = -1
----*/
/*---
COMMIT
TR_HANDLE = 13647736
----*/

Thanks for your help.

Bob