Subject | Re: error with RecordCount and Int64 |
---|---|
Author | achidan |
Post date | 2002-04-06T22:26:04Z |
Ok, another reply to myself....
statement works correctly:
SELECT COUNT( DISTINCT '.zZz.' || ParamID || '.zZz.' || ParamName ||
'.zZz.' || ParamDesc || '.zZz.' || ParamTypeCd )
FROM Param join ParamType on Param.ParamTypeID = ParamType.ParamTypeID
join ActType on Param.ActTypeID = ActType.ActTypeID WHERE ActTypeCd
= ? /* pActTypeCd */
So, I just need to add another string constant at the beginning. Now I
have a question to Jason: Could you give me a hint where in the source
I can find the creation of the statements to do a record count in
IBObjects. I would like to add this additional constant.
Regards
Daniel
> > I get the following message:I found now quite a simple workaround for the problem: The following
> > arithmetic exception, numeric overflow, or string truncation
> > Cannot transliterate character between character sets
> >
> > In SQL Trace I find that it is cause by a statement like this:
> >
> > SELECT COUNT( DISTINCT ParamID || '.zZz.' || ParamName || '.zZz.' ||
> > ParamDesc || '.zZz.' || ParamTypeCd )
> > FROM Param join ParamType on Param.ParamTypeID = ParamType.ParamTypeID
> > join ActType on Param.ActTypeID = ActType.ActTypeID WHERE ActTypeCd
> > = ? /* pActTypeCd */
statement works correctly:
SELECT COUNT( DISTINCT '.zZz.' || ParamID || '.zZz.' || ParamName ||
'.zZz.' || ParamDesc || '.zZz.' || ParamTypeCd )
FROM Param join ParamType on Param.ParamTypeID = ParamType.ParamTypeID
join ActType on Param.ActTypeID = ActType.ActTypeID WHERE ActTypeCd
= ? /* pActTypeCd */
So, I just need to add another string constant at the beginning. Now I
have a question to Jason: Could you give me a hint where in the source
I can find the creation of the statements to do a record count in
IBObjects. I would like to add this additional constant.
Regards
Daniel