Could someone please tell me what is wrong with my syntax here? I'd be much appreciative.
objCmd = New SQLCommand("SELECT CASE WHEN objDR('Item') = 'Enter Bill of Lading' then enterbol " _
& "WHEN objDR('Item') = 'Bill of Lading History' THEN bolhistory " _
& "WHEN objDR('Item') = 'Request Transfer' or objDR('Item') = 'View Transfer in Progress' THEN transfers " _
& "END from plantGroups where plantgroupid=@plantgroupid", objConn)
View Complete Post