22 August 2012

Familiar programming model using web standards in SharePoint 2013

One of the interesting things I see in this SharePoint 2013 - Familiar programming model using web standards
According to the article - What's new for developers in SharePoint 2013, Although the article does not specifically extends,, But it gives us a big picture of the structure of SharePoint 2013.
Like I said before - the SP 15 gives us the OAuth 2 protocol - available to help us connect to other social like Facebook.



Then of course there is support for HTML, CSS and JavaScript. Also has support for OData (Open Data protocol). and it has a support for ReST ( Represntationl State Transfer).

I will update soon after I will learn it.

Yours,
Roi

02 August 2012

Invalid column name - sql server

This case that happened to me when creating SQL table column

I created a SQL table column.
Then I received the following message on StoredProcedure or even in Select.

Invalid column name


Invalid column name


Invalid column name
What can be problem
  • 2 tables or one table with both columns
  • use Stored procedures to decouple scope
I wrote this query to see if there is a problem with my columns

select   name  from  sys.columns  where  object_id = object_id('Your_Table')

I didn't see any problem with my columns

OK....

What to do
  • Go to the table where they are added to the column, check whether it has a trigger (for each table by columns also have triggers), and if there is a table trigger, stopped him, and suddenly everything starts to work. If you open the trigger you will understand that change is copying the data to another table that there has to add the column and so on.
  • Press CTRL+SHIFT+R  on table !!!
It will solve your problem (I hope :) )

Yours,
Roi