‘ 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:

When an exception is thrown and no matching handler can be found for it, C++ invokes the function terminate(). By default, terminates invokes the function abort(). Some compilers guarantee that

Question: I’ve got a struct which is declared as having two fields: int position;char tile-id[6]; When I use this in a vector, I can use the [] notation to initialise

Private Declare Function SendMessageLong Lib “user32” Alias “SendMessageA”(ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParamAs Long) As LongConst LVM_SETCOLUMNWIDTH = &H1000 + 30Const LVSCW_AUTOSIZE

Question: How do I program Informix to insert newline characters into CHAR(500) fields? Answer: A char field is defined as ending with a newline, so I don’t think you can

Question: When accessing DBACCESS from a script, what are the consequences of leaving out the hyphen? What should we adopt as a standard, hyphen or no hyphen? Example: dbaccess mystores

Question: How do I import my user’s .PST files directly into Exchange without having to log in as the user and import the files via Outlook? Answer: You might be

(Note: This tip assumes that you have an ActiveConnectionsetup to your DSN.) This function creates an XML document from an ADO Recordset, programmatically. Public Function CreateXML(strRoot As String,strSQLStatement As String,

The unhandled or unexpected script error is a real issue these days. Script errors can be seen even on many of the professionally designed Web sites and Web-based customer applications.

The following code converts an ADO recordset into an HTML table by using the GetString function of the recordset. This method does not involve the looping or MoveNext method; it

Here is a simple way to export an HTML table to Excel with a single line of code. For the technique to work, you must have Excel installed on the

Using the Buffer propertyof the Response object to buffer Active Server Pages (ASPs) generally isn’t a very good idea.When you buffer an ASP, none of thepage is outputted until the

A major problem with using images on Web sites is thatimages take much longer to load than text. So you haveto choose your image formats carefully. Two image formats are

Opening a new browser window is a handy but sometimes misused feature. Eventually, your user ends up with tons of open browser windows they just forget about. Sometimes a Web

Question: Why would a program not yield any errors, and yet not run on one system, while resulting in a perfect run (unchanged) on another system? Specifically, a switch statement

Question: I need to migrate Informix data to an Oracle database. The current application front end imports with CSV files. Can Informix export to a CSV file? Answer: There is

Question: Is there a function in Informix equivalent to Oracle’s instr() that returns the position of a character within a string? Also, is there a function that counts the number

Question: We are trying to get our application to work with Informix using ODBC, and we are having repeated failures. We cannot seem to access “memo” (large text) fields of

Question: From a Windows system I am trying to connect to an Informix database running on a Sun Solarix box, which was just moved behind a firewall. The Windows machine