SELECT Parm_id, Parm_CreatedBy, Parm_CreatedDate, Parm_UpdatedBy, Parm_UpdatedDate, Parm_TimeStamp, Parm_Deleted, Parm_Name, Parm_Value, Parm_Component
FROM Custom_SysParams WHERE (Parm_Name = 'Dotnetdlldirectory')
Friday, 25 March 2011
Friday, 4 March 2011
Stop the solution appearing twice on the CRM system menu.
UPDATE Custom_Tabs Set Tabs_Caption = N'SolutionDELETE' Where Tabs_TabId <>
(SELECT MIN (Tabs_TabId) FROM Custom_Tabs WHERE tabs_Deleted is null AND
( Tabs_Entity = N'find' and Tabs_DeviceID is null and Tabs_InButtonGroup is null and
COALESCE(Tabs_Action, N'') <> N'newaccount' and Tabs_Caption = N'Solution'))
AND tabs_Deleted is null AND ( Tabs_Entity = N'find' and Tabs_DeviceID is null and
Tabs_InButtonGroup is null and COALESCE(Tabs_Action, N'') <> N'newaccount' and Tabs_Caption = N'Solution')
(SELECT MIN (Tabs_TabId) FROM Custom_Tabs WHERE tabs_Deleted is null AND
( Tabs_Entity = N'find' and Tabs_DeviceID is null and Tabs_InButtonGroup is null and
COALESCE(Tabs_Action, N'') <> N'newaccount' and Tabs_Caption = N'Solution'))
AND tabs_Deleted is null AND ( Tabs_Entity = N'find' and Tabs_DeviceID is null and
Tabs_InButtonGroup is null and COALESCE(Tabs_Action, N'') <> N'newaccount' and Tabs_Caption = N'Solution')
Subscribe to:
Posts (Atom)