The Latest

DevX

Where Did It Go?

Have you ever wondered why your ActiveX DLL with a form doesn’t show up in the taskbar? Because you’re showing the form modally (.Show vbModal). VB4 only allows DLLs with

DevX

Migration from FOCUS 6.0 to SQL Server 7.0

Question: Are there any tools coming with SQL Server 7.0 for this migration from FOCUS 6.0? If not, what is the best way to accomplish this migration? Answer: Yes, DTS

DevX

Business Rules and Semantic Object Models

Question: What are business rules in relation to a DBMS. Do you have any posssible examples for a university database? Also: Do you have any hints to drawing a Semantic

DevX

SQL and Using Text and Combo Boxes

Question: I write a statement such as frmStatistics.datStatistics.RecordSource = “SELECT * FROM tblSpecialGroup Where Sex = ‘M’ AND Date BETWEEN ‘” & “051099” & “‘” & ” And ” &

DevX

Replication: Many Clients, One Central DB

Question: Being new to SQL Server 7.0 I wanted to get other opinions on this: My company has many clients using a proprietary db schema that will replicate transactions to

DevX

Event in a form

Question: I’m a beginner VB programmer and am having problems figuring out how to handle events in forms. I have a class that raises an event for each step in

DevX

BitSet – Set a bit in a number

‘ Set a bit in a value” NOTE: requires Power2()Function BitSet(ByVal value As Long, ByVal bit As Long) As Long ‘ simply OR with the bit mask ‘ Range checking

DevX

Power2 – A power of 2

‘ Raise 2 to a power’ the exponent must be in the range [0,31]Function Power2(ByVal exponent As Long) As Long Static res(0 To 31) As Long Dim i As Long

DevX

ShiftRight – Shift a Long to the right

‘ Shift to the right of the specified number of times” NOTE: requires Power2()Function ShiftRight(ByVal value As Long, ByVal times As Long) As Long ‘ we need to create a

DevX

RotateRight – Rotate a Long to the right

‘ Rotate a Long to the right the specified number of times” NOTE: requires Power2()Function RotateRight(ByVal value As Long, ByVal times As Long) As Long Dim i As Long, signBits

DevX

RotateLeft – Rotate a Long to the left

‘ Rotate a Long to the left the specified number of times” NOTE: requires Power2()Function RotateLeft(ByVal value As Long, ByVal times As Long) As Long Dim i As Long, signBits

DevX

BitToggle – Invert a bit in a value

‘ Toggle a bit in a value” NOTE: requires Power2()Function BitToggle(ByVal value As Long, ByVal bit As Long) As Long ‘ simply XOR with the negation of the bit mask

DevX

RotateRightI – Rotate an Integer to the right

‘ Rotate an Integer to the right the specified number of times” NOTE: requires Power2()Function RotateRightI(ByVal value As Integer, ByVal times As Long) As Integer Dim i As Long, signBits

DevX

RotateLeftI – Rotate an Integer to the left

‘ Rotate an Integer to the left the specified number of times” NOTE: requires Power2()Function RotateLeftI(ByVal value As Integer, ByVal times As Long) As Integer Dim i As Long, signBits

DevX

ShiftLeft – Shift a Long to the left

‘ Shift to the left of the specified number of times” NOTE: requires Power2()Function ShiftLeft(ByVal value As Long, ByVal times As Long) As Long ‘ we need to create a

DevX

BitClear – Clear a bit in a value

‘ Clear a bit in a value” NOTE: requires Power2()Function BitClear(ByVal value As Long, ByVal bit As Long) As Long ‘ simply AND with the negation of the bit mask

DevX

BitTest – Test the value of a bit

‘ Test the value of a bit” NOTE: requires Power2()Function BitTest(ByVal value As Long, ByVal bit As Long) As Boolean ‘ simply AND with the bit mask ‘ Range checking

DevX

Build List of Components in Hierarchy

It is sometimes useful to be able to obtain a complete list of the components in a container hierarchy. A getComponents() method is provided in the java.awt.Container class, but it

DevX

Pausing SQL Server

Pausing SQL Server prevents new users from logging in and gives you time to send a message to current users asking them to complete their work and log out before

DevX

Minimize the Use of Pointers and Dynamic Memory Allocation

Pointer-based operations are less frequently needed than they might seem. For instance, examine this class declaration: class PointerMisuse{private: CDC * m_pDeviceContext;public: PointerMisuse(); ~PointerMisuse();};PointerMisuse::PointerMisuse(){ m_pDeviceContext = new CDC;}PointerMisuse::~PointerMisuse(){ delete m_pDeviceContext;} Even

DevX

Beware of Single Quotes When Working With SQL

When concatenating a SQL statement such as INSERT, you may have trouble if your field value contains an apostrophe (‘) such as in “Commedia Dell’Arte.” SQL thinks the apostrophe is

DevX

Identify Host That Called Remote Method

When creating remote objects for use with Java’s Remote Method Invocation (RMI), you’ll often extend java.rmi.server.UnicastRemoteObject. When you do extend UnicastRemoteObject, it becomes easy for the remote methods to determine

DevX

Generate Beeps in Your Application

Many applications use an audible “beep” sound to signal that an error has occurred or to get the user’s attention for some reason. For example, a user interface that allows

DevX

Assigning Integers to an Enum Type

In C, it is valid to assign integers to an enumerated type. For example: /*** valid in C but not C++ ***/enum Status {good, bad};void func(){ Status stat = 1;