What I describe for COM+, applies to MTS with some slight differences as well. Registering COM objects remotely has been quite a pain before MTS showed up (remember the VBR

Among the different COM details that VB hides to the programmers, one of the most problematic one is that it doesn’t let you take control on interface GUIDs. Binary compatibility

If you don’t take specific actions, you get an Access Denied Error when you try to raise an event from an MTS component into a client. This happens because the

Suppose you have a table: select * from tblTestName Amount— ——A 10B 20c 40D 50E 30 The following single SELECT query can be used to calculate cumulative totals: –//////////////////////////////////////SELECT t1.Name,

There may be certain situations where you have to sort character-based columns in a particular order.For example, Let us consider a table: –///////////////////////////////////SID Subject Marks— —— —–1 Physics 801 Chemistry

The following code is bad: char* charpointer= new char[SOMECONSTANT];delete charpointer; // should have been delete [] charpointer; new and new[] are allowed to use different memory pools. The default new/delete

The most common example where ‘open’ date is used is in the expiration_date for an entry. It could be set for a particular date, or be NULL if the expiration

A temporary object is destroyed at the end of the full expression in which it was created. Consider the following example: #include #include // for strlen()string s1, s2;int len=(s1+s2).c_str(); //

After all component settings, create an ImageIcon object with your desired image. Using this object, create a JLabel. Add the Jalbel to the lowest LayeredPane of the JFrame. Finally, add

A default ResultSet object is not updateable and has a cursor that moves forward only. Thus, it is possible to iterate through it only once and only from the first

Normally, you should not check for null after creating an object. MyObject o = new MyObject(); This check is not required in Java because ‘new’ is not allowed to return

A rule of thumb in class design says that if a class has at least one virtual function, it should have a virtual destructor, too. This is because the presence

I have a much simpler form for the IsAlphaNum function: Public Function IsAlphaNum(ByVal sString _As String) As BooleanIf Not sString Like “*[!0-9A-Za-z]*” _Then IsAlphaNum = TrueEnd Function You can modify

Although VB has an IsNumeric function, it has no IsAlpha function. Use this routine whenever you want to determine whether a character or string of characters is alphabetic (A-Z or

This can be done by using ResultSetMetaData. For example, to get the number of columns you can use: /* get the meta-information about the result set */ResultSetMetaData metaData = rs.getMetaData();

Traditional testing for alphabetic characters

Blank finals are fields that are declared as final, but are not given an initialization value. Java allows the creation of blank finals, but, in all cases, the blank final

Sometimes you need to know the number of bits set in a word. I often see code to count the number set bits written as a loop, processing one bit

When you need to add the same member function to several classes, you can use a template class, derived from its template argument. template class T : public P {public:

These days, many enterprises exchange data using a request/response approach. This data typically contains the date and time information regarding when a request was generated/received or a response generated/received. If

In DOM compliant browsers (IE5 & NS6), you can handle attributes of all similar elements with the getElementByTagName() function. For example, to change the background color of all the cells

SQL*Plus uses column names as default column headings while displaying query results. You can customize your own column heading and width with the help of following commands. To assign a

Suppose we have a class called A. A has a data member p which is a pointer to another object: class A{public: A() {p = new B[10];}private: int *p;}; We

Certain applications make use of very long strings. For example, a single string may contain generated HTML pages, a chapter of a book, a textual database and so on. Usually,

Although you can declare an entire class a friend of another class, like this: class A{ friend class B; //B has access to every member of A //..}; However, in

Java containers have a mechanism to prevent more than one process from modifying the contents of a container. The problem occurs if you

When displaying a recordset in a table with a border, if there is no data returned for a cell, the borders will not show up around that cell. To alleviate

Below is an example of passing in parameters when calling a stored procedure from an ASP page.

When you extend a class and override a method, Java insists that the new method cannot be declared as throwing checked exceptions of classes other than those that were declared