BOM and SQL2005 Computed Columns


Author
Message
Sarosh
Sarosh
StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 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

Reply
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Just double-click BO in the Solution Explorer to bring up the BO in the component designer, then go to the property sheet and you will find these properties.

These are just properties on the BO, so you could set this in code also if you had the need. 

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