devxlogo

The Latest

Using the Assert Macro

Question: I am not sure if it is good when I use the assert macro in the following code: int sum(int number)// Precondition: number => 1// Postcondition: return sum from

ReplaceWordEx – Replace whole words, with your choice of delimiters

Option Explicit’————————————————————————‘ This enum is used by both InstrWordEx and ReplaceWordEx” It uses a binary value to determine what separator characters are allowed’ bit 0 = allow spaces’ bit 1

InstrWordEx – Find a whole word, with your choice of delimiters

‘————————————————————————‘ This enum is used by both InstrWordEx and ReplaceWordEx” It uses a binary value to determine what separator characters are allowed’ bit 0 = allow spaces’ bit 1 =

Contact List in Public Folder

Question: I’m looking to make an online contact list without creating a whole new ASP page for my company. I was thinking that I could simply put the Outlook contact

Copying Table Rows

Question: I have two databases and two tables in them have the same structure (same columns etc.). How do I copy some rows from one database to another? Both tables

SMTP Mail Send Problem

Question: We are sending over 50K of outgoing e-mails an hour. Today the queue fills and we can only handle about 20K an hour. At some point the mail server

Microsoft SQL Server 7.0 DTS and Informix

Question: I’m curious if you or anyone else has successfully created a data warehouse in SQL Server 7.0, using DTS to import/extract info from Informix, running Elite time/billing application? Answer:

Send on Behalf Of/Reply Problem

Question: If I set up a delegate and they send a message on my behalf, the reply goes to my delegate. How can I force the reply to come to

Allow Users to Reset Your HTML Form

You can use HTML forms to provide an efficient interface for collecting user information. You can include various types of controls like textbox, check box, buttons, listbox, and so forth

Maximum Number of Objects on a Form

Question: Is there any way to get more than 255 objects on a VB form? Answer: No, there’s not a way to pass the limit of 255 objects per form.

Using Format Function to Right Justify

Question: When using printer.print statements to send output directly to the printer, it used to be possible in QB PDS to use something like “printer.print format(number, “###,###.00”) to get right

Using Variables in SQL

Question: I have connected a form to the DB using an ADODC. I connect fine, I can read the DB if I put a literal in my sql: recordsource =

Database Integration

Question: I am developing an application in VB6 that uses its own DB. I need to link my application’s DB with clients’ DBS or even ERP systems. Therefore, I need

Initializing Array of UDT’s

Question: Here’s some simple code in Test.bas: Public Type MY_RECORD Field1 as String Field1 as StringEnd Typein frmTest.frmGeneral DeclarationsPrivate mArrayOfRecords() as MY_RECORDForm_Load ‘this line of code BOMBS If IsEmpty(mArrayOfRecords) then

Copying Part of a String

Question: I have a little problem which I can’t solve. I will give the question with an example. I’m working with Excel. In a cell the string “100dpi.txt” is written.

Checking If a File is in Use

Question: How can I check to see if a file is in use/open? Answer: An easy way to do this is to attempt to open the file for writing. If

Manually Positioning Buttons in a Java Applet

You can use Java’s layout managers to maintain the relative position of objects in an applet without manually repositioning them as the applet’s size changes. However, you may occasionally want

Where Should Template Definitions Appear?

Normally, you declare functions and classes in a .h file and place their definition in a separate .cpp file. With templates, this practice isn’t really useful because the compiler must

Assign ID and Name Attributes to Form Controls

While working with controls in HTML forms, you can assign ID as well as NAME attributes to the controls. You can then access both ID and NAME attributes through client-side

The First Rule of Code Optimization

I recently received a question from a reader who asked how to sort a large file. My solution was based on the qsort() algorithm, which is the only sorting algorithm

Floating Point Literals

In following expression: if (ticket_price > 7.50) What’s the type of the literal 7.50? One might think that it’s float. However, the actual type is double. To force the compiler

Validate Form Input on the Client Side

If you are developing Web pages that provide HTML forms to the user, then you may notice that many times invalid data gets submitted. To reduce such invalid input, you