Tip Bank

DevX - Software Development Resource

Calculating While Querying

Question: I have two fields in my query: SELECT minutes, cost FROM SomeTable However, I would like to calculate the cost/minutes for each row selected. So I tried the following:

DevX - Software Development Resource

Remove Unsightly Frame Gaps in Netscape

When you create an HTML frameset using the FRAMEBORDER=”0″ attribute, the frames look fine in Internet Explorer. However, there’s an unsightly white gap between non-white pages when you view the

DevX - Software Development Resource

Combobox and ADO Resultset

Question: After retrieving a resultset, using VB6, from SQL Server, I am easily able to populate a grid by setting the resultset to the grid (i.e. Set DataCombo1.DataSource = GetRs).

DevX - Software Development Resource

Linking a Listbox to a Database

Question: How can I put a column from my database into a listbox using VB 6.0? Answer: Here’s a quick way to load a listbox using ADO in VB 6.0.

DevX - Software Development Resource

Object Creation in VB

Question: I’ve read about what happens behind the scenes when VB creates an instance of a COM object. But, what exactly does happen when VB creates an instance of a

DevX - Software Development Resource

Split Function

Question: How is the data laid out in the array and how do you know the size of the array! Answer: Each string that results from the Split function is

DevX - Software Development Resource

Setting Daily Events

Question: I want to kick off a function once a day (for examle, at midnight). The timer seems a very inefficient way to do this. Is there any way of

DevX - Software Development Resource

Variant Naming Specification

Question: I know a recordset object should be named rstName, but don’t know all about variant naming specifications. I looked for it on MSDN for a long time, but couldn’t