Your tech-expert for enterprise. software. security. small business. finance. tools.

DevX is the leading provider of technical information, tools, and services for tech-interested professionals.

Popular Posts:



SQL Injection Tips, Part 1

SQL injection is probably the most common and easiest hacking technique out there. Now, don’t think I condone it, I’m


Simplifying Null Check in Java

To avoid null exceptions, we usually validate against null and emptiness as shown: if(object != null && !object.equals(“”)) {} We

Automation of Tasks

Automation of tasks is a good concept. Consider the example below in which you create a task and schedule it


Extract Faces Using Amazon Rekognition

AmazonRekognitionClient amazonRekognitionClient = new AmazonRekognitionClient(Amazon.RegionEndpoint.);byte[] imageData = System.IO.File.ReadAllBytes(inputImageFile);DetectFacesRequest facesRequest =

All Articles

Creating Nested Queries

Question: My question is with regards to VB’s ability to handle complexSQL. I have the application I am developing set up in the followingway: I copy the SQL created into the recordsource of a data control and then refresh the data control. The problem I am having is with SQL

Read More »

Including Single Quotes in Queries

Question: How do you include a single quotation mark in a query?Example:“Select * From BATCH Where BATCH.NAME = ‘O’Connel’” Answer: Simply replace the single quote with two single quotes together. Since most databases (if not all) use single quotes to delimit strings, you have to put two of them together

Read More »

Advantages/Disadvantages of Using Sub Main

Question: Can you please tell me when do you use Sub Main and the advantages of using it? Answer: In certain programs, initialization code has to run before any windows load. In many cases, this code isn’t specifically related to a window, so it is put in a separate .BAS

Read More »

Putting Controls on MDI Forms

Question: I have a project I am working on including an MDIform with a toolbar. I am wanting to put a combobox on the toolbar, but VB4 will not let me putcombo boxes on an MDI form. What can I do? Answer: One popular solution is to put the combo

Read More »

Data Controls and Open Connections

Question: I have five data controls on a form that access five tablesfrom the same database. I want to open the database just once.Does having five data controls mean that the databse is openedfive times? Is there any way to open the databse programatically and assign the resultant recordset to

Read More »


Question: How do I write a help file in Word 6, and then, how do I compile it? I can’t find any documentation on it. Answer: This is unfortunately not included in the printed manuals. However, if you look on your CD, there is a thing called Books Online, or

Read More »

Join Our Newsletter

Subscribe to receive our latest blog posts directly in your inbox!