Crainiate Community

Hi,

The following code raises a concurrency error:

Person P = new Person();
P.Id = 3;
P.Select();
P.Vat = 15.67M;
P.Update() // Concurrency exception


Database is MSSQL2005 and table has 3 columns: Id (Integer, auto), Name (String, Max(30)), Vat (Decimal, Precision 18, Scale 4)

Please advise.
Archer

Could you please post the code for the Person class?

Hi,

Following is the Person class:

class Person : Table
{
private int _Id;
private string _Name;
private decimal _Vat;

[PrimaryKey(1,1)]
public int Id
{
get
{
return _Id;
}
set
{
_Id = value;
}
}

[Column, MaximumLength( 30 )]
public string Name
{
get
{
return _Name;
}
set
{
_Name = value;
}
}

[Column]
public System.Decimal Vat
{
get
{
return _Vat;
}
set
{
_Vat = value;
}
}

public Person()
{
}
public Person( string Name, Decimal Vat, Context C )
{
this.Name = Name;
this.Vat = Vat;
this.Context = C;
}
}

Regards,
Archer

I have to add the following info:

When the table is created, the VAT field is created as Decimal(18,0). I manually modify the field to be Decimal(18,2). Then I add the record manually with Vat field equal to 12.30

If It was a 12.00 or any other whole number, the code above doesn't raise an exception but the updated value is rounded up.

Ops, I just realized why it didn't work.
I've changed the field definitions manually but I forgot to change the stored procedures as well. Hence the values are updated by parameters with the old definitions.

This immediately brings another question to my mind. Is it possible to specify column parameters like precision or scale on the class definition?

There should in fact be attributes for the special case of decimal,which is a fixed point and not a floating point data type.

We will add this as a feature in the next release in the meantime you could change the procedures and table by hand, or use a floating point data type, such as float, double etc.

Ok great.

Thanks.

This has now been addressed with the new Fixed attribute in build 1.0.2542. See the following post for more details:

http://support.crainiate.net/Forums/forums/176/ShowPost.aspx#176