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:

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

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

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.

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

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 =

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

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

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.

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

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

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

It’s customary to use output statements as a debugging aid. For example, displaying the name of a function that is currently in scope or printing a variable’s value on the

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

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

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

The operators static_cast and reinterpret_cast are similar: they both convert an object to an object of a different type. However, they aren’t interchangeable. Static_cast uses the type information available at

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

Performance tuning of Servlets is a major criteria as a servlet is expected to simultaneously handle dozens, if not hundreds, of threads depending on the requests. These coexisting threads have

When a Java applet or application loads a JDBC driver, the code is dynamically retrieved from the network. Loading the Sybase JDBC driver requires a simple line of code: Class.forName(“com.sybase.jdbc.SybDriver”);

When performance is an issue, static arrays perform better than dynamic storage structures. However, if a static structure won’t work, consider using Java’s Vector class instead of the LinkedList class.

When writing Java-based services we occasionally require dependencies. That is, our services must start in a certain order. You can specify what services your code is dependent on by overriding

You can use a name for a Java method that is different from the name the DLL uses when it exports the function. For example. you may need to conform

When using CSS (Cascading Style Sheets) positioning, you can apply a number of techniques to make your code faster. When accessing and setting the position of an element, instead of

Question: Is there any way to manipulate the border of a select list? It works fine on all the other existing form elements except the select. The solution must be

Question: Will the VBScript in the coming version Visual Basic 7 be platform independent? Answer: Unless Microsoft decides to radically change things, Visual Basic 7.0 will not use Visual Basic

Question: Is it advantageous to use ANSI SQL syntax or SQL Server syntax? For example, Inner Joins: Select * from T1 inner Join T2 on t1.id=t2.idSelect * from T1,T2 where

Question: I have a table that contains about six million records. Each record contains some sensitive data or data that be accessible by the public. What would be the best

Question: I used PowerBuilder with another database tool at my previous employer. Unfortunately, I have transferred to another company that uses Oracle and Oracle Developer. Can I use PowerBuilder with

Question: How can I refresh or redraw a menu? Answer: If you make one of the menu items nonvisible and then make it visible again, it should refresh the menu