BOM and SQL2005 Computed Columns


Author
Message
Sarosh
Sarosh
StrataFrame Beginner (26 reputation)StrataFrame Beginner (26 reputation)StrataFrame Beginner (26 reputation)StrataFrame Beginner (26 reputation)StrataFrame Beginner (26 reputation)StrataFrame Beginner (26 reputation)StrataFrame Beginner (26 reputation)StrataFrame Beginner (26 reputation)StrataFrame Beginner (26 reputation)
Group: Forum Members
Posts: 22, Visits: 116
Hi!

I am having a problem while saving a BO that I created using the SF BOM (Business Object Mapper) which is based on a SQL2005 table that has a computed column in it.

I made that BO column/property ReadOnly in the BOM but if I make changes to any other column and then try to save that BO I get an error that I cannot update a computed column. This is not a calculated/computed column defined at the BO level it is defined as a computed column at the SQL table level. Which brings up two questions:

1] How do I handle SQL2005 computed columns defined at the table level in a BO.

2] How do I selectively pick columns from a table for a BO.

e.g. I have a few text columns with lots of data in them and so I don't want them to be a part of the BO.

It seems that right now the BOM only allows me to pick a table and not specific columns from within that table.

Thanks

Sarosh

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search