The Latest

DevX - Software Development Resource

Use LookupTable Object to Avoid Performance Problems

The LookupTable object is marked as ThreadingModel=Both and doesn Related Posts Baltimore port crisis ignites infrastructure concernsR Comes to the Enterprise with Microsoft R ServerAsus ROG Ally Z1 Extreme discounted

DevX - Software Development Resource

Creating a Drop-Down List File in ASP

Using this tip, you can create a drop-down list, which is populated from a database, and include it in a Web (ASP) page. This will basically increase the performance via

DevX - Software Development Resource

ADO in VB

Question: I am trying to upgrade a program from DAO to ADO that will take a flat file and create a new database, add the needed fields and then populate

DevX - Software Development Resource

Writing a Query Showing ID Status

Question: I am a SQL beginner and I am trying to write this query. I have a table with four columns: ID STATUS DESCRIPTION CURRDATE1 open Test1 6/1/001 open Test1

DevX - Software Development Resource

Grouping By One Field When Selecting Several

Question: These are the fields of my table: id, email, firstname, and lastname. There can be multiple records for a single email. I only want to group by email and

DevX - Software Development Resource

Selecting with Distinct

Question: I am trying to query a database with the following: SELECT DISTINCT SystemName, OwnerID, Location, Productver, StartDate, EndDate, ProjectNameFROM DevicesORDER BY SystemName I only want to have the DISTINCT

DevX - Software Development Resource

Mobile E-mail and Automobile E-mail Trend

Question: I’ve heard that Nokia’s strategic aim is to make sure that every automobile on earth has its own e-mail address by 2010. Have you heard that too? Answer: I’ve

DevX - Software Development Resource

Binding a Grid to a Cursor

Question: Is it possible to have a grid bound to a cursor? If so please tell me how. Answer: A grid is bound to a cursor the same way that

DevX - Software Development Resource

Problem with Multiple Table Joins

Question: I have two tables Region(RegionId-PK, RegionName) and District(DistrictId-PK, DistrictName, RegionId-FK). When I open a recordset (rs) like : Dim rs as new ADODB.Recordsetrs.Open “SELECT District.*, Region.RegionName FROM District INNER

DevX - Software Development Resource

Passing a Parameter to a Stored Procedure

Question: How do you pass a parameter to a stored procedure from within another stored procedure? Answer: To call a stored procedure from inside another stored procedure, let’s take an

DevX - Software Development Resource

Handling Multiselect Lists

When using a select list that will allow multiple selections, the selections will be provided to you in the Request object as a comma-separated list. Using the new Split function,

DevX - Software Development Resource

Rebooting the Web Server

If you’re doing a lot of development using server-side components, you’ll have found that once the DLL has been used by IIS, you have to reboot the Web services in

DevX - Software Development Resource

Time Synchronization Under NT 4

Question: How do I synchronize all NT 4 workstation system clocks on a network with a central point of contact? Answer: The NT 4.0 Server Resource Kit contains a file

DevX - Software Development Resource

The MB TipOfTheDay Control

Many commercial programs have a Tip of the Day dialog, that shows a tip or trick whenever the application starts. With the MB TipOfTheDay Control you can add this nice

DevX - Software Development Resource

Peek – Read a value of any type from memory

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal bytes As Long)’ read a value of any type from memoryFunction Peek(ByVal address As

DevX - Software Development Resource

StringFromBSTR – Convert a BSTR to a VB string

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal bytes As Long)’ convert a BSTR into a VB StringFunction StringFromBSTR(ByVal pointer As Long)

DevX - Software Development Resource

StringFromAddr – Read a string at a given address

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal bytes As Long)Private Declare Function lstrlenA Lib “kernel32” (ByVal lpString As Long) As _

DevX - Software Development Resource

The age of a person

You can quickly evaluate the age of a person using the following function: Function Age(BirthDate As Date, Optional CurrentDate As Variant) As Integer If IsMissing(CurrentDate) Then CurrentDate = Now Age

DevX - Software Development Resource

Calculating the Difference Between Two Times

When you need to compute the time that elapsed between two dates, use the standard function difftime(). This way, you avoid potential bugs such as leap years or Y2K issues.

DevX - Software Development Resource

Converting a Number to a String

The standard strstream family of classes enables you to convert numeric values into their string representation easily. You need to instantiate an strstream object, insert the numeric value to it

DevX - Software Development Resource

Linkage Specification

Linkage between C++ and non-C++ code fragments can be achieved using a linkage-specification. For example: extern “C” int func(int arg1); // func has C linkage The quoted string in the

DevX - Software Development Resource

Pass Template Parameters by Reference

In the following declaration of the template min, the template parameter T is passed by value: template bool equal(T first, T sec){// Related Posts Stuxnet Speculation Grows: Is Worm a

DevX - Software Development Resource

Formatting Tables in HTML Pages

The best way to tackle alignment/wrapping issues with invisible tables is tomake the tables visible. To do this, you should set the border property oftables that contain form fields or

DevX - Software Development Resource

Bool Values

Question: How do I make 1 bool take 1 bit instead of 1 byte? Answer: Instead of an array, you should use an STL container that is specifically designed to