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

The code below is functionally equivalent to a VB Replace function, but, instead, it allows you to perform an action in a Text type field in a SQL Server Stored

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:

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 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.

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

If you have a line in your code you are trying to debug or you don’t know how you got there, or where you came from (who called it), you

This simple class provides you with a mechanism for the creation of a logfile: import java.io.*;public class logfile { private String myFile = Related Posts Placer.ai raises $75M, boosts valuation

The result of adding unnecessary catch blocks is code like this, where exceptions are caught and then immediately re-thrown: try { // some code here } catch (Exception e) {

You can create windows of different shapes using windows API calls in Visual Basic. Use the API Text Viewer tool to see all the API functions available for use in

You can retrieve the parent directory from a path by identifying the first and last backslash. The start position for the first backslash should be 3 in order for it

This can be done by using the is operator. Here is a simple function demonstrating this method: Public Function RemoveObject(Collection As Collection, Object As Object)Dim vTemp As ObjectDim Index As

To register your DLL’s, follow these steps:1) In the directory Related Posts Nvidia stock jumps 8.8% after analyst endorsementFederal judge rules Google a monopolyXen Security Issue Prompts Cloud Computing RebootsMatter

When you’re using a frame control with no caption, there’s a bit of a gray area above the border that normally contains the caption. To get rid of this gray

Private Declare Sub mouse_event Lib “user32” (ByVal dwFlags As Long, _ ByVal dx As Long, ByVal dy As Long, ByVal cbuttons As Long, _ ByVal dwExtraInfo As Long)Private Const MOUSEEVENTF_LEFTDOWN

Option ExplicitPrivate Type RECT Left As Long Top As Long Right As Long Bottom As LongEnd TypePrivate Enum mbBorderTypeConstants mbRaised = 0 mbSunken = 1 mbEtched = 2 mbBump =

‘ CCONSOLE Class” Creates a console window and writes to it’ Example:’ Dim cons As New CConsole’ cons.WriteString “Hello World”Private Declare Function AllocConsole Lib “kernel32” () As LongPrivate Declare Function

Private Declare Function ExtractIcon Lib “shell32.dll” Alias “ExtractIconA” _ (ByVal hInst As Long, ByVal lpszExeFileName As String, _ ByVal nIconIndex As Long) As LongPrivate Declare Function DrawIcon Lib “user32” (ByVal

You can programmatically start the Shortcut Wizard from your code, to give the end user the capability to create a new shortcut: Shell “rundll32.exe AppWiz.Cpl, NewLinkHere ” & App.Path, 1