devxlogo

The Latest

The ORA-01555 Error: A PL/SQL Developer Solution

he “ORA-01555 snapshot too old” error, which causes user transactions to fail, is a nightmare for Oracle DBAs and developers. It usually occurs after queries or batch processes have been

Ensure that a TextBox caret is visible

Setting a multiline TextBox’s SelStart property doesn’t ensure that the insertion point (the caret) is visible. You can achieve this by sending the control an appropriate message: Private Declare Function

Object.hashCode() and Object.equals()

The Object.hashCode() method returns a number that is effectively random. This number is also implementation- and instance-dependent. This has a couple consequences: 1 – The order of iteration for elements

Making a Collection Read-Only

The Collections class provides static APIs to generate a read-only or unmodifiable collection, list, set, or map from the specified entity. For instance, if you are sure that the ArrayList

Making a Thread-Safe or Synchronized Collection

As you know by now, the commonly used collection classes, such as java.util.ArrayList, are not synchronized. However, if there’s a chance that two threads could be altering a collection concurrently,

Conditional Compilation in Java

The C preprocessor provides for conditional compilation in instances where large areas of text are ignored and stripped out, regardless of whether a given preprocessor constant was defined. For example:

Determining the Size of an Oracle Database

The size of the database is the total size of the datafiles that make up the tablespaces of the database. These details are found in the dba_extents view. Type the

Use VB’s Date/Time Picker Control With No Date

Using the DTPicker control is good except if you Related Posts Airwallex Eyes Explosive Latin American GrowthJames Webb telescope uncovers early black holesUse the Preload Resource Hint for Super-fast CSSBiden

Initializing Fields in Interfaces

Fields defined in interfaces are automatically public, static, and final. Being final, they cannot be Related Posts Batagay megaslump reveals ancient permafrost layersCircle to Search hints at potential upgradesReport: Apple

Reduce the Size of an ATL DLL

When writing an ATL DLL or an ActiveX Control DLL, developers used to take off the ATL_MIN_CRT. However, this action will increase the size of the DLL up to almost

An Essential Use For Explicit Typecasting

If one is not careful with implicit typecasting, one can get very weird results that are not easy to detect.Look at the code below: int number;.. //some computation and codeint

Make Collections Work Like Standard VB Collections

Add the following procedure to your collection object: Public Function Item(ByVal Value as Variant) _as SomeObject Set Item = mCollection.Item(Value) ‘mCollection is your private module level ‘collection object.End Function Now,

Return Any Name String in Proper Capitalization

Function FormatProper(ByVal strName As String) As String’**********************************************************************’* Take any name string and return it in proper capitalization’********************************************************************** Dim strProperName As String Dim varProperName As Variant Dim intCount As Integer Dim

Animating the Window on Showing or Hiding

You can easily add animation when showing or hiding a window using the AnimateWindow API. There are three types of animation: roll, slide, and alpha-blended fade. The declaration of API

How to Alleviate

There are a few reasons why one would see this error, but the most common is in the ordering of the MFC header files. Over time, Microsoft has weeded out

ShowHtmlHelp – Show a HTML Help page

Private Declare Function HtmlHelpTopic Lib “hhctrl.ocx” Alias “HtmlHelpA” _ (ByVal hwnd As Long, ByVal lpHelpFile As String, ByVal wCommand As Long, _ ByVal dwData As String) As Long’A HTML Help

BrowseFolders – Show the BrowseForFolders standard dialog

Option ExplicitPrivate Declare Function SHGetPathFromIDList Lib “shell32.dll” Alias _ “SHGetPathFromIDListA” (ByVal pidl As Long, ByVal pszPath As String) As LongPrivate Declare Function SHGetSpecialFolderLocation Lib “shell32.dll” (ByVal _ hwndOwner As Long,