Common APEX And Visualforce Errors And Solutions

June 28, 2013

Problem:  no viable alternative at character 

Solution: Make sure you don't mention enclose Strings with double quotes. quotes should be enclosed in single quotes.

Opportunity.Description__c='ABCD' NOT Opportunity.Description__c="ABCD"

Problem: Returning PageReference doesn't redirect to detail page

Solution (Possible):

Make sure DML statement insert or update is done before preparing and returning page reference. 

insert request;
PageReference pPage=new ApexPages.StandardController(request).view();
insert request;
return pPage;

Problem:  Incorrect code coverage OR Comments are considered for code coverage. OR Strange issues with code coverage. 


The solution to this problem is clearing the test Results log at the pathhttp://xyz.salesforce.com/07M where xyz is salesforce instance (ex: cs1,ap1 etc) or Go to Setup>Develop>Apex Test Execution>View Test History> Clear Test Results.


SQL Server

Uninstall SQL Server: Unable to find SQLEXPRESS in the dropdown

June 26, 2013


After following the following document to uninstall SQLEXPRESS instance on Windows 7
http://msdn.microsoft.com/en-us/library/ms143412.aspx., I couldn't find SQLEXPRESS in the drop down. But, it is listed in the available instances. 


I followed the stackoverflow answer. http://dba.stackexchange.com/questions/13683/remove-an-instance-of-sql-server-2008-r2-after-reinstalling-sql-server-2008

Step 1: Go to services and delete the folder where SQLEXPRESS's MSSQLSEVER service is running. 

Step 2:  Try to uninstall SQL Server from control panel (follow http://msdn.microsoft.com/en-us/library/ms143412.aspx

Now the drop down shows SQLEXPRESS instance as well. 

SQL Server

How to see the descriptions of all user defined columns in a database

June 24, 2013

        st.name [Table],
        sc.name [Column],
        sep.value [Description],
    from sys.tables st
    inner join sys.columns sc on st.object_id = sc.object_id
    left join sys.extended_properties sep on st.object_id = sep.major_id
                                         and sc.column_id = sep.minor_id
                                         and sep.name = 'MS_Description'
                                         where st.type='U'


Hooking Pocket Sphinx Into Android

June 17, 2013

In 2011, I have hooked Pocked Sphinx into Android using NDK. The following post has helped me a great deal.


I was the first one to thank the writer. I think the post still holds good.

The current demo can be found @

Swig folder can be found @


Sometime I may again try porting pocketsphinx to my mobile.

Popular Posts