devxlogo

Tip Bank

DevX - Software Development Resource

Improve Stored Procedure Speed

When developing stored procedures in SQL Server, use the SET NOCOUNT ON option at the start of your procedure. This will prevent the superfluous “row count” messages from being generated,

DevX - Software Development Resource

Declare Your Objects Properly

Never declare a variable as a “New” of type “object,” but always rather just as of type “object.” If you do so you will always increment the reference count of

DevX - Software Development Resource

Converting between hex/decimal

Question: Is there a way to ‘easily’ convert betweenHexadecimal and decimal with VB 5.0 Profesional.(ie. Without doing the long conversion from hex to ascii, then using the conversion factor, then

DevX - Software Development Resource

Visual Interdev and ODBC errors

Question: I developed a very tiny project in Visual Interdev: * Made a connection in de 32-bit ODBC (Control panel) with the Access97 Database and DSN name. * Add data

DevX - Software Development Resource

System calls

Question: How can I make shell level calls from a java program? For example, I want to execute the “ls -al” command from java and return its values back to

DevX - Software Development Resource

Garbage collection process

Question: If i have a code like this in the while loop while (true){ java.util.date ldt_date = new java.util.Date() …} Will the ldt_date variable be initialized with new location in

DevX - Software Development Resource

ASCII Value Conversions

Question: How can I convert an integer ascii representationof a number to its character equivalent in astring form. For example A= 72 What procedure will take in int 72 and

DevX - Software Development Resource

Byte to string conversion

Question: A variable retrieves its contents in the byte form, since I require to convert into the string format . Which is the method used in java or rather how