Question: I hope that you might be able to help me with the problem I am experiencing. I am developing an application in VB6 using ADO Data Control. I need

Here is a simple way by which you can dynamically change the title of the browser window (or an HTML page). There are certain scenarios where you can use this

A transaction can be defined as a related set of operations that read and modify data in a single batch. Every transaction should follow the ACID rule, where ACID stands

Consider the following class: class Book { private: char ISBN[11]; int year bool in_stock; char name[100]; //

Question: What exactly is an opaque pointer? Answer: The term “opaque pointer” is used in component-based programming, e.g., COM and CORBA. It refers to a pointer to an object of

Question: Are there power bit set classes around that can do what Verilog, VHDL can do so easily? a[3:2,0] = b[4:1] & c[5]; // collections of width n mixed with

Question: How does dynamic_cast work? How is it implemnted in compilers? Answer: dynamic_cast accesses the runtime type information that C++ automatically generates for every polymorphic class. This information is stored

Question: If I write C++ code in UNIX, does my code convert to C and compile? Answer: Not necessarily. The first C++ compiler, cfront, was actually a C++ to C

Question: How do I customize the mouse’s right-click menu? That is, instead of Cut, Copy, Paste, Select All, Delete in Edit-Masks, etc., I would like to display my custom menu,

Question: I use SQL 6.5 in an industrial setting. I have an application that writes a new record into the database every time a pallet blocks a photoswitch. After 24

Question: Is there a function that gives me a simple way to know whether a string contains a number or not? I’ve already done something with ASCII values, but this

Question: How do I count the records for a specific field? For example, I’m building a table for homes in a county. In the table are fields for cities and

Question: How do I use the Group By statement in SQL Query? Answer: Group By is a way to collapse a result set around a textual value summarizing its contents

Question: I want to set up a hot backup between two SQL servers on two different NT machines. In other words, if one of these servers goes down I want

Question: Could you please explain how to trap the e-mail ID from the In-box, so that I can filter my incoming junk mails? Answer: Filtering junk mail is tricky business

Question: Why do Journal entries within a (slightly) customized contacts database in Public folders only appear to the user who logged the Journal entry? All other fields in the contact

Question: I need to have a result from a SELECT query with all the rows containing “word1” in column 1 and all the rows containing “word2” in column 2. If

Private Declare Function GetShortPathName Lib “kernel32” Alias _ “GetShortPathNameA” (ByVal lpszLongPath As String, _ ByVal lpszShortPath As String, ByVal cchBuffer As Long) As LongConst MAX_PATH = 260′ Convert a long

You need just one-line function to evaluate the number of days in a month (while taking leap years into account, of course). The trick is to use the DateDiff and

The DatePart() function can return the number of days from the beginning of the current year, but there is no VB built-in function that returns the number of days left

Private Declare Function GetLongPathName Lib “kernel32” Alias _ “GetLongPathNameA” (ByVal lpszShortPath As String, _ ByVal lpszLongPath As String, ByVal cchBuffer As Long) As LongConst MAX_PATH = 260′ Convert a short

‘ convert a date value into a string in the format’ YY years, MM months, DD days, HH hours, MM minutes, SS.HH seconds)’ you can also opt for time short

Question: I have two columns in a table called “bak”: distance, and trig. The distance value is equal to 1/trig. When I perform the following query: update bakset distance =

Question: How can I get the number of records returned by a query without cycling through all the records and counting each one? Answer: Have you tried SELECT COUNT(*) FROM

Question: How can I get Exchange to forward e-mail to an AOL or ATT account automatically? We have traveling users who have AOL or ATT accounts and would like all

Question: I am a student. Is there a way to load a database into Oracle to run my exercises? Answer: I’m not sure I can help you because there’s more

Question: I need your assistance to solve the following: I am using an RDO connection to connect to a SQL 7.0 database, and I am using the server-side cursor technique

Question: How do I merge two values from separate fields using SQL? An example would be taking the LastName field and placing it before the FirstName field like this: “LastName,

Question: How do I do a “group by” SQL statement? I want to return all rows and columns with ** records. Here is the data sample: columnA columnB columnCAAA 2334

Question: I am having trouble getting the following type of join to work. I have three tables: Application, College_hist, and School_Info. Application has student ID numbers that identify the person