Tip Bank

DevX - Software Development Resource

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:

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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.