Archives: 09/26/2012

SPLIT STRING AND USE IT IN WHERE CLAUSE

CREATE OR REPLACE PROCEDURE SP_TMP_CERCA_CON_SPLIT(p_CD_GRMS varchar2) as BEGIN — PROCEDURA D’ESEMPIO PER FARE UNA “IN” CON VALORI PASSATI IN INPUT COME STRINGA SEPARATI DA VIRGOLA INSERT into TMP_ARRAY(char30) select g.ds_grm from anag_gruppi_merceologici g where g.cd_grm in (select regexp_substr(p_CD_GRMS,'[^,]+’, 1, level) from dual connect by regexp_substr(p_CD_GRMS, ‘[^,]+’, 1, level) is not null); COMMIT; END; https://blogs.oracle.com/aramamoo/entry/how_to_split_comma_separated_string_and_pass_to_in_clause_of_select_statement

BACKGROUNDWORKER THREADS

Introduction This article is for novice and amateur developers who recognize areas of their application that could use threading but don’t want to be burdened with some of the complexity that comes with threading. Threading is a concept that many programmers tend to avoid because it can be difficult to understand, debug and implement. You…

MAKE THREAD-SAFE CALLS TO WINDOWS FORMS CONTROLS

Access to Windows Forms controls is not inherently thread safe. If you have two or more threads manipulating the state of a control, it is possible to force the control into an inconsistent state. Other thread-related bugs are possible as well, including race conditions and deadlocks. It is important to ensure that access to your…

USE COM CLSID TO GET ASSOCIATED .NET SYSTEM TYPE

How to use in your the project the COM reference “HNetCfg.HNetShare”, which can be found in the “hnetcfg.dll” server (typically located in the “C:\WINDOWS\system32\” directory). private const string CLSID_NETSHARINGMANAGER = “{5C63C1AD-3956-4FF8-8486-40034758315B}”; private static NETCONLib.INetSharingManager GetSharingManager() { Type objectType = Type.GetTypeFromCLSID( new Guid(CLSID_NETSHARINGMANAGER)); return Activator.CreateInstance(objectType) as NETCONLib.INetSharingManager; } void Main(){ //Now i can use NET version…

Go Top