‘ Delete a role from a COM+ application, and return True if the operation is ‘ successfull’ Note: requires a reference to the COM+ Admin Type Library” Example: DelComPlusAppRole(“MyComPlusApp”, “MyTestRole”,

‘ Delete a COM+ application, and return True if the operation is successfull’ Note: requires a reference to the COM+ Admin Type Library” Example: DelComPlusApplication(“MyComPlusApp”, “”)Function DelComPlusApplication(ByVal applicationName As String,

Sometimes it’s necessary to perform a simple validation on a string to ensure, for example, that a string destined to be converted to a float contains only a single ‘.’.

What if you wanted to use a COM object through TSQL Statement? SQL Server facilitates this task by provding a few system sorted procedures like sp_OACreate, sp_OAMethod, etc. Check out

For some reason, there exists a common misconception that there is no cross-platform, built-in way in Perl to handle binary files. The copy_file code snippet below illustrates that Perl handles

//create the file object,//set the image to the statement object as//binary streamtry{ … File fileObject = new File(…); FileInputStream fisObject = new FileInputStream(fileObject); PreparedStatement pstmt = conn.prepareStatement(“insert into IMAGE_TABLE values

If you want to code an event procedure (such as GotFocus) for each textbox on a freshly designed form, you must switch manually from the Change event to the GotFocus

This VB procedure returns decimal numbers (integers) as Roman numerals (a string), ranging from 1 to 4999. Numbers outside this range return the same number as a string. The optional

‘ Invert the case of all characters of the input string” Examples:’ Debug.WriteLine(FlipCase(“Hello World”)) ‘ => hELLO wORLD’ Debug.WriteLine(FlipCase(“hELLO wORLD”)) ‘ => Hello World’ Debug.WriteLine(FlipCase(“3) this is message n. 3”))

‘ Replace all accented characters in the input string’ Note: this function was written according to Italian rules. Rules for your ‘ language may vary, for example È may not

‘ Convert the input word from plural to singularFunction PluralToSingular(ByVal plural As String) As String ‘ convert to lowercase for easier comparison Dim lower As String = plural.ToLower() Dim res

‘ Convert the input word from singular to pluralFunction SingularToPlural(ByVal singular As String) As String ‘ convert to lowercase for easier comparison Dim lower As String = singular.ToLower() Dim res

‘ Return a boolean indicating whether the input connection string is for the ‘ ADO.NET’s Oracle managed provider” Examples:’ Debug.WriteLine(IsOracleProviderConnString’ (“Server=myserver;Uid=myid;Pwd=mypwd;”)) ‘ => TrueFunction IsOracleProviderConnString(ByVal connString As String) As Boolean

‘ Concatenate an array of strings with commas and a final “and”,’ or other separators” Example:’ Debug.WriteLine(“Choose one from ” & CreateStringList(New String() {“item1”,’ “item2”, “item3”}))’ ‘ => Choose one

In MDI applications, a user might have two or three or even more MDI child windows open at any given time. But in applications where you have user log-in and

Say you wanted to transfer data from an unnormalized source table in Excel (a worksheet) to SQL Server. Take a look at the columns in the source table, TABLE_A, with

There is a common and tricky problem that arises when you’re sending data from an HTML form to the server?the amount of data you can send depends on which method

To test if an integer is a power of 2 (1,2,4,8,16…256…), use the following code: if (!(x & (x-1)) then … Because 2^N-1 numbers have no common bits with 2^N

Say Employee_Table has fields like EMP_NO, EMP_NAME, etc. In java, try this: try{ Connection conn =…//opening connection. PreparedStament ps = con.prepareStatement(“Select conn.setAutoCommit(false); Statement stmt = conn.createStatement(); stmt.addBatch( sql 1st insert