If error messages are the following contents and TRichEdit has a cause,
I will think.
-------------------
ISC ERROR CODE:335544321

ISC ERROR MESSAGE:
arithmetic exception, numeric overflow, or string truncation

STATEMENT:
TIB_Cursor: "<TApplication>.frmSQL.cnEdit.<TIB_Cursor>."
------------------------------

I think that the above-mentioned error will be lost if ScriptEdit of
IBF_Metadata is changed to TMemo.

However, correction of a program is needed by changing to Tmemo.
Jason Wharton wrote:

> I don't know what to do about this issue.
> It seems there is a need of some kind of transliteration.
> Where do we look first?
>
> Jason
>
>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
>> Behalf Of Martijn Tonies
>> Sent: Friday, February 23, 2007 3:20 AM
>> To: ibobjects@yahoogroups.com
>> Subject: [IBO] Error when using UTF8 charset during metadata queries?
>>
>>
>> Hi Jason,
>>
>> I'm connecting via Database Workbench to an UTF8 charset database.
>>
>> When I do this:
>> select
>> *
>> from
>> UTF8TEST
>>
>> in a (wrapped) TIBODataset, I get:
>> arithmetic exception, numeric overflow, or string truncation
>>
>> with a trace of:
>> SELECT S.RDB$FIELD_NAME
>> , I.RDB$RELATION_NAME
>> FROM RDB$RELATION_CONSTRAINTS C
>> , RDB$INDICES I
>> , RDB$INDEX_SEGMENTS S
>> WHERE C.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
>> AND C.RDB$RELATION_NAME = I.RDB$RELATION_NAME
>> AND C.RDB$INDEX_NAME = I.RDB$INDEX_NAME
>> AND I.RDB$INDEX_NAME = S.RDB$INDEX_NAME
>> ORDER BY I.RDB$RELATION_NAME ASC
>> , S.RDB$FIELD_POSITION ASC
>>
>> SELECT S.RDB$FIELD_NAME
>> FROM RDB$RELATION_CONSTRAINTS C
>> , RDB$INDICES I
>> , RDB$INDEX_SEGMENTS S
>> WHERE C.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
>> AND C.RDB$RELATION_NAME = I.RDB$RELATION_NAME
>> AND C.RDB$INDEX_NAME = I.RDB$INDEX_NAME
>> AND I.RDB$INDEX_NAME = S.RDB$INDEX_NAME
>> AND I.RDB$RELATION_NAME = ? /* RDB$RELATION_NAME */
>> ORDER BY S.RDB$FIELD_POSITION ASC
>>
>> PARAMS = [ Version 1 SQLd 1 SQLn 1
>> [RDB$RELATION_NAME] = 'UTF8TEST
>> ' ]
>>
>>
>> SELECT UTF8TEST.*
>> , UTF8TEST.RDB$DB_KEY
>> from
>> UTF8TEST
>>
>> PLAN (UTF8TEST NATURAL)
>>
>> SELECT R.RDB$FIELD_NAME
>> , R.RDB$RELATION_NAME
>> FROM RDB$RELATION_FIELDS R
>> , RDB$FIELDS F
>> WHERE R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME
>> AND F.RDB$COMPUTED_SOURCE IS NOT NULL
>> AND NOT R.RDB$RELATION_NAME STARTING WITH 'RDB$'
>> ORDER BY 1 ASC
>>
>>
>> SELECT R.RDB$RELATION_ID || '=', R.RDB$RELATION_NAME
>> FROM RDB$RELATIONS R
>> ORDER BY 1 ASC
>>
>> PLAN SORT ((R NATURAL))
>>
>>
>> Whenever I retry the query in the Query Editor, it works
>> fine. So it appears
>> IBO is raising the error in the last metadata query, because
>> it doesn't
>> execute
>> those anymore.
>>
>> A second attempt gives me this trace:
>>
>> SELECT UTF8TEST.*
>> , UTF8TEST.RDB$DB_KEY
>> from
>> UTF8TEST
>>
>> PLAN (UTF8TEST NATURAL)
>>
>>
>>
>> Got a clue?
>>
>> Martijn Tonies
>> Database Workbench - tool for InterBase, Firebird, MySQL,
>> NexusDB, Oracle &
>> MS SQL Server
>> Upscene Productions
>> http://www.upscene.com
>> My thoughts:
>> http://blog.upscene.com/martijn/
>> Database development questions? Check the forum!
>> http://www.databasedevelopmentforum.com
>>
>
>
>