Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am developing an external content type with sharepoint designer, based on a microsoft sql server table. One of the columns has the time(0) format. This is interpreted by sharepoint designer as System.TimeSpan, however if I create a list, the field is not implemented and shown. Is there a way to solve this issue?

share|improve this question
add comment

2 Answers

up vote 0 down vote accepted

You cannot do it. The BCS (External Lists) do not have this datatype implemented. Best way is to use it as a string. Later you can use jquery/code behind if binding to grid or any other control.

share|improve this answer
    
Thanks, I did that with a database view. The problem is that I have to write the data back which didn´t work. –  AGuyCalledGerald Nov 9 '12 at 10:01
add comment

The data type System.TimeSpan is not supported by external lists.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.