Subject Re: [Firebird-Java] RE: Exception in preparestatement
Author Niki Ivanchev
Luca is right, the error is
arithmetic exception, numeric overflow, or string truncation


Luca Lafranchi wrote:

>Hi :)
>
>
>
>>String sql = "Select distinct(universal_id), max(descr) descr from
>>aspect where aspect_num between ? and ? and secondary_only=0 group by
>>universal_id order by descr";
>>
>>
>>
>
>
>I may be wrong, but
> "where aspect_num between ? and ?"
> doesn't sound like a right syntax to me.
>Try
> "where aspect_num>=? and aspect_num<=?"
>
>Ciao
>Luca
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>



[Non-text portions of this message have been removed]