StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Business Object Mapper and Numeric field type (9,2)

Business Object Mapper and Numeric field type (9,2)

Scott — Tue, 07 Nov 2006 15:54:38 GMT

When using the business object mapper and setting the business object properties using SQL Server as the data source the table fields are not mapped\added. There are two fields in the table that are of type numeric 9,2.

If I use the Database Development Toolkit it will map the fields. When using the business object there is a "Specified cast is not valid" message for the numeric fields.

I know I should use a currency field, and I will be changing this. I just wanted to point this out incase it is an issues that needs to be looked into.

RE: Business Object Mapper and Numeric field type (9,2)

Trent L. Taylor — Tue, 07 Nov 2006 15:54:38 GMT

:hehe: not today!!! So I can "tell the truth" :D

RE: Business Object Mapper and Numeric field type (9,2)

Ivan George Borges — Tue, 07 Nov 2006 15:52:24 GMT

I knew it!

(I bet he is not at the office)

RE: Business Object Mapper and Numeric field type (9,2)

Trent L. Taylor — Tue, 07 Nov 2006 13:49:03 GMT

Yeah...same thing here :D every bug that we have ever had...Ben's fault :laugh:

RE: Business Object Mapper and Numeric field type (9,2)

Keith Chisarik — Tue, 07 Nov 2006 13:37:38 GMT

actually it was another developer here I was helping.... I would never make such an error :Whistling:

RE: Business Object Mapper and Numeric field type (9,2)

Trent L. Taylor — Tue, 07 Nov 2006 13:30:39 GMT

That's good because I could not figure out what was going on here...I will get out of my test now :)

RE: Business Object Mapper and Numeric field type (9,2)

Keith Chisarik — Tue, 07 Nov 2006 13:23:01 GMT

nevermind......I had one field set to scale of zero. my bad.

RE: Business Object Mapper and Numeric field type (9,2)

Keith Chisarik — Tue, 07 Nov 2006 13:00:51 GMT

I am getting errors trying to save values to a decimal(6,2) field.

I tried changing the type to money, BO Mapper still shows it as decimal.

What do we use for numeric fields?

RE: Business Object Mapper and Numeric field type (9,2)

Keith Chisarik — Tue, 07 Nov 2006 12:53:36 GMT

As am I

RE: Business Object Mapper and Numeric field type (9,2)

StrataFrame Team — Tue, 26 Sep 2006 14:53:40 GMT

Thanks for the heads up, Ivan... I'll take a look at it.

RE: Business Object Mapper and Numeric field type (9,2)

Ivan George Borges — Fri, 22 Sep 2006 13:48:47 GMT

Hya.

No need to look at this now. Just to say I'm facing this "Decimal" data type problem, at run time.

RE: Business Object Mapper and Numeric field type (9,2)

Trent L. Taylor — Tue, 22 Nov 2005 17:16:09 GMT

Scott,

Thanks for the tip. This has been fixed and was actually caused by .NET excluding the Numeric data type from the SqlDbType enumeration. I suppose they don't want us using the numeric type anymore. At any rate, this has been fixed in the update that is now available through the downloads.

RE: Business Object Mapper and Numeric field type (9,2)

StrataFrame Team — Tue, 22 Nov 2005 16:54:02 GMT

So, the SQL Server database has a field type of Decimal(9,2)?

Are you getting this error message at runtime, or when the Business Object Mapper is generating the partial class?

What I mean is, does the Business Object Mapper properly create the partial and then you get the error when you access the field, or do you get the error message when you choose "Rebuild Partial" within the Business Object Mapper?