The Latest

DevX - Software Development Resource

Send Emails From an Oracle Stored Procedure

The following code is for those who need to receive e-mails from the database to report a correct ending backup, a corrupted backup, a database fail, or any message database/admin

DevX - Software Development Resource

Draw Lines in a List View

This code adds the appearance of a grid control to a traditional listview, drawing lines between rows and columns: Private Declare Function SendMessageLong Lib Related Posts The Future of Visual

DevX - Software Development Resource

Find the Word Count in a Given String

An easy way to find the number of words in a given string: Dim varArray as VariantvarArray = Split( Related Posts LG Chem Builds $3.2B EV Battery Facility in TennesseeBest

DevX - Software Development Resource

Logon Improvements

If your application connects to Microsoft SQL Server, you can use two features to make your login easy and low maintenance. The first choice is to use OLE DB instead

DevX - Software Development Resource

Create New Controls at Run Time

This undocumented feature of VB6 lets you create new controls at run time. In previous versions, one had to create a control array at design time in order to be

DevX - Software Development Resource

Error Message Passing Throughout Nested Components

Nowadays, components are popularly used in VB projects. These components can sometimes make it hard to determine which component has an error when the application stops running. This is especially

DevX - Software Development Resource

Get a Jump on XML Development

he newest addition to the pantheon of web technologies is yet another markup language. XML, otherwise known as the Extensible Markup Language, resembles other markup languages like SGML and HTML.

DevX - Software Development Resource

The LogNTEvent class

LogNTEvent is a class that lets a VB app write directly to the NT event log. The zip file includes a demo project and a sample DLL that contains the

DevX - Software Development Resource

Running an EXE Using a Trigger

Question: I want to run an .exe using a trigger. Is there any stored procedure for running an .exe? For example, I want to run Notepad. Answer: The stored procedure

DevX - Software Development Resource

Informix Ontape Backups

Question: I need to do an ontape Level 0 backup but I need to bypass the “Press Enter to Continue.” Simply put, I want to type “Ontape -s -L 0”

DevX - Software Development Resource

Looking for Informix Server Sites

Question: I am trying to learn Informix. I have been developing Informix code to produce HTML files—effectively using Informix as a CGI. I want to do the following: Find someone

DevX - Software Development Resource

Informix SQL

Question: Are Transact SQL stored procedures currently running on a SQL Server 7.0 database compatible with a Informix database? Answer: No, you’ll have to translate them into Informix’s stored procedure

DevX - Software Development Resource

Log Error

Question: I am receiving this error in my log: connections rejected: no calls allowed for sqlexec.listener-thread err: = -27002 oserr: = 0errstr = : No connections allowed in Dynamic server

DevX - Software Development Resource

Use printStackTrace() method to generate stack

Stack trace is a kind of call stack, which maintains the call sequence of methods at any given point in time. Throwable class in Java provides a method called “printStackTrace()”

DevX - Software Development Resource

Use Of ‘Connect By’ clause for Hierarchal Query

The Connect By clause is useful for tables which have 2 or more columns with parent-child relationships. While displaying rows, we can use ‘LEVEL’ pseudo column to indent the results

DevX - Software Development Resource

Passing Objects in a Function

In Java, objects are passed to a function by reference, so you can manipulate the object data in the function and have that reflected outside the function also. If you

DevX - Software Development Resource

All the Changes, All the Time: Part I

his 10-Minute Solution was prompted by a question to the Ask the SQL Pro site regarding how best to capture changes that have occurred in a database. I will address

DevX - Software Development Resource

Paranoid and Proud of It: Planning Your Backups

n my first article on this subject, I discussed the need to have a healthy dose of paranoia when planning how to protect your systems and information. I also demonstrated

DevX - Software Development Resource

New PL/SQL Features in Oracle 8i: Part II

n my last article, “New PL/SQL Features in Oracle 8i: Part I“, I described some of the new features in Oracle 8i that extend the power, performance, and flexibility of

DevX - Software Development Resource

Surviving the Web Shift

he Web has changed software development forever, and it doesn’t take a prophet to know that this trend will continue. Even now, client/server and object-oriented programmers are tripping over basic