Monthly Archives: May 2009

Update( FIELD_NAME) in SQL trigger

In SQL trigger programming, sometimes people put if ( update( FIELD_NAME ) ) BEGIN END to determine if a field is being changed or not. However the SQL server doesn’t seems to really check the previous and new value. As … Continue reading

Posted in SQL | Tagged | Leave a comment

Search Engine friendly Redirect

Response.Status = “301 Moved Permanently”; Response.AddHeader(“Location”, “http://www.newaddress.com”);

Posted in ASP.NET | Leave a comment

Sortable property in SalesLogix DataGrid control and few other tricks

When checked, the sort happens in client but very slow (2+ seconds on 1500 records) When unchecked, sorting still supported but it’s on server side (SQL query). So the name of the property should really be ‘Client Sorting’ If the … Continue reading

Posted in SalesLogix | Leave a comment