Tag Info

New answers tagged

0

You can use stored procedures for performing CRUD operations on data related to different tables. Check this for more information: http://spsamer.com/2012/05/08/implementing-ects-in-spd-using-stored-procedures/


0

In my BDC Model, I added "cast([Quantity] as int) as" before [Quantity] : And it display correctly Quantity as an int: Problem Solved :D


0

Solution for 2nd Problem: I guess your database table column type as decimal(18, 20). If you correct it into decimal(18, 0) then you will not get decimal value in suffix. Solution in SharePoint By default external list have Read List.aspx view. By editing view in SharePoint Designer you can control the decimal value. Step 1: Open the list in SharePoint ...


0

Alright I figured it out: First create an external content type, and add read list, create item, update item and delete item operations to that content type based on your table or stored procedure in SQL server (I do not suggest using view since SQL cannot update data to multiple tables at once). Then in SPD’s external content type menu, right click your ...


0

No way of doing it dynamically OOTB as far as I know.. I have a situation where I need to be flexible about SQL table changes and I use editing of existing content type instead of creating ECT again from scratch every time the table changes.. You can edit your existing content type like this: Open external content types in your sp designer Open the ...


0

After weeks of labour this issue decided to import external data direct to SharePoint internal lists using MS SQL SSIS adapters.



Top 50 recent answers are included