Sometimes in our database structures we’ve got to store information in such a way that it allows us to increase/decrease the type of data we store. For example, we have

Here is the code ready to use and written in C, to create a JDK 1.1 Java Virtual Machine. #include int main() { JDK1.1InitArgs data; JNIEnv *env; JavaVM *jvm; jclass

When a SubQuery is used in a FROM clause instead of a Table name, Oracle executesthe subquery and then uses the resulting rows as a view in the FROMclause. It’s

When querying in Oracle, use ROWNUM pseudocolumn to limit the number of returned rows. Pseudocolumns behave like table columns but are not actually stored in tables. (Other pseudocolumns are RowId,

I read a SQL tip titled “Using Distributed Queries on SQL Server 7.0.” I think this is a great follow up to that tip. This is especially useful for those

When validating a set of sequential steps, the Select Case structure can beused to step through each validation method. As each Case is cycledthrough, the validation method is called to

I needed to retrieve image fields on SQL Server 7.0 with VB6, and I couldn’t find any article about it. So, I assume others have had the same problem. I’ve

Question: We’re trying to: Get the Logon Windows NT id for an Exchange mail box Get the Security Identifier (SID) corresponding to the Windows NT id (using advapi32.dll api’s) Map

Question: I have developed a WAP application using the Nokia SDK, and all appears well. Our project team leader uses the emulator from phone.com and it does not display the

MDI forms do not allow you to remove the Min/Normal-Max/X or Control Box.Many times you want the MDI Form to remain in the Maximized state. One way to accomplish this

Question: Our company uses NetFolders to share the company calendar, which has extensive listings. We are about to install Exchange 5.5. What’s the best way to move the calendar intact

You can easily create ActiveX controls that work as containers for other controls, by setting their ControlContainer property to True. However, VB doesn’t offer any event for detecting when the

Question: I am using Windows 2000 and would like to access the IRDA port in raw mode. That is, not use the Winsock API but instead just send serial data.

Question: We have a Web-enabled application running. The ASP has been written to generate a WML/HTML response. This has been tested using a simulator from Phone.com. What should I do

Question: I am developing for an AT&T phone made by Mitsubishi. It correctly formats and displays WML cards until I try to use input boxes or any other type of

Question: I have come across the following situation: if any method of a class has a static variable (not a static class member!), it seems to be shared by all

‘ Enable extended matching to any type combobox control” Extended matching means that as soon as you type in the edit area’ of the ComboBox control, the routine searches for

‘ Returns a string array containing all the elements’ of the specifid ListBox or ComboBox control” Example:’ Dim strArray() As String’ strArray = ListBoxToArray(Combo1)Public Function ListBoxToArray(ctrl As Control) As String()

Private Type POINTAPI X As Long Y As LongEnd TypePrivate Type RECT Left As Long Top As Long Right As Long Bottom As LongEnd TypePrivate Declare Function ClipCursor Lib “user32”

Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, _ lParam As Any) As LongPrivate Declare Function LockWindowUpdate

‘ Move an item of a listbox to another index” If FROMINDEX = -1 then it moves the current highlighted itemSub MoveListboxItem(ctrl As ListBox, ByVal FromIndex As Long, _ ByVal

‘ — The ListBoxTooltip class” Usage in the client form:” Dim lstTT As New ListBoxTooltip” Private Sub Form_Load()’ Set lstTT.ListBox = List1′ End Sub’ Private Sub Form_Unload(Cancel As Integer)’ Set

SQL Server’s SOUNDEX and DIFFERENCE functions can be used to performqueries based on phonetic comparisons. Although they may share similarpurposes, they have some differences. SOUNDEX takes a character string and

The fseek() function provides random file access. It’s declared in as follows: int fseek(FILE *fstream, int offset, int whence); The function sets the file pointer associated with fstream to a

The overloaded operator mechanism is “syntactic sugar” for ordinary function calls. You can always use the explicit name of an overloaded operator function to resolve ambiguities or document your intention.

The standard function ftell() reports the current file pointer position. The file pointer is a numeric value that represents the current position in the file in the form of offset

Instead of using the following form to rewind a file: fseek (fstream, 0, SEEK_SET); You can use the standard function rewind() as a shorthand. rewind() is declared in as follows:

Instead of using the following form to rewind a file: fseek (fstream, 0, SEEK_SET); You can use the standard function rewind() as a shorthand. rewind() is declared in as follows: