Dear Mr. McNally,
thanks for the patch, it works great.
Have a nice day.
-----Urspr�ngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im
Auftrag von John McNally
Gesendet: Wednesday, September 05, 2001 9:04 PM
An: [EMAIL PROTECTED]
Betreff: Re: Cannot acces primary or foreign keys
I have added a patch to Village that should allow the conversion from a
smallint (short) to BigDecimal to work. Please replace your village.jar
with one built from the latest village cvs at share.whichever.com
john mcnally
Patrick Tonidandel wrote:
>
> Hi there,
>
> i have noticed that it is not possible to visualize the value of the
object
> NumberKey when it gets
> his values from database columns that are smallint.
>
> for example :
>
> public static void populateObject (Record row,
> int offset,
> Areasellerrel obj )
> throws Exception
> {
> obj.setAselNarea(
> new NumberKey(row.getValue(offset+0).asBigDecimal()));
> obj.setAselNsellerid(
> new NumberKey(row.getValue(offset+1).asBigDecimal()));
> }
>
> The result of row.getValue(offset+0).asBigDecimal() and of
> row.getValue(offset+1).asBigDecimal() is NULL, because the fields in the
> database are smallint and AselNarea is mapped as PRIMARY KEY and
> AselNsellerid is
> mapped as FOREIGN KEY.
>
> Any help is very appreciated.
>
> Regards
> Patrick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
