devxlogo

Tip Bank

Initializing a Static Array Member of a Class

You can initialize static arrays member of a class. The initialization must appear at the place of definition, not inside the class body. For example: class A{private: static char vars[2];

The ## Concatenation Operator

The preprocessor ## operator concatenates macro arguments. For example: #define paste(x,y) x ## y The paste() macro takes two arguments and concatenates them into one. The whitespaces surrounding the ##

Avoid Heap Fragmentation in Palm OS

Memory is precious in Palm OS, since the total amount of memory available is very small. Dynamic memory allocation is often necessary while building applications in which memory at runtime

Nested Transactions

You can use the @@TRANCOUNT function to determine whether any open transactions exist and how deeply they are nested.A BEGIN TRANSACTION statement increments @@TRANCOUNT by one, and a ROLLBACK statement

Lock Timeout!

With the SET LOCK_TIMEOUT option, it is possible to set the maximum amount of time that SQL Server allows a transaction to wait for the release of a blocked resource:

Caching/Releasing JDBC Connections

It happens quite often that a JDBC connection is declared as the instance-level variable. The actual connection is then obtained at construction time. All methods of the object that need

Changing Column Types in a Table

Changing column types in a tableSQL Server does not permit you to explicitly change the datatype or length of a column. But there is a trick to get around this.

Setting Proxy in Java Code

The java.net package contains classes that deal with connections across the network. If there is a direct connection to the Internet via a modem, various classes like the HttpConnection or