Question: My Informix 7.30 dies occasionally and returns the following message: 16:01:06 Checkpoint Completed: duration was 0 seconds.16:06:06 Checkpoint Completed: duration was 0 seconds.16:11:06 Checkpoint Completed: duration was 0 seconds.16:16:06

Question: How do I know if I am already in a transaction when I call a procedure from another one? Answer: I’m not aware of an easy way to do

Question: Should I make a call to GetObjectContext() in every function in my DLL? Obviously, you are going to do that in your “main” methods, but does calling GetObjectContext() in

Question: When should you use reference to pointers like those found in function arguments (class_name * & )? Answer: When you want the callee to change the pointer itself, not

When you need to compare two User Defined Type (UDT) variables to check whether they are equal, the only approach that you can follow in plain VB is to compare

Question: Since template code is generated at compile time, it implies that there should be a separate set of code for each template objects created. Does that mean templates increase

Question: Where can I find a list of reserved words in C++? Answer: Most C++ books include a list of reserved keywords. Here’s the list: asm do if return typedefauto

Question: With XSL, can I change the value of global parameters inside the templates named temp? Answer: No. Parameters and variables in XSLT, once defined, essentially are fixed for a

Question: What does the ‘* 1’ mean in this constant declaration? Public Const gcsDelimiter As String * 1 = “|” Answer: The * in your example defines the size of

Oracle 8I gives developers a new feature to allow execution of native dynamic SQL. This is an alternative to the DBMS_SQL package previously required. Now developers can use dynamic SQL

The sp_who internal procedure allows users to view current activity on the database. This command provides a view into several system tables (e.g., syslocks, sysprocesses, etc.). The sp_who command returns

Question: Can I use computed values from a select list in a WHERE clause? For example: select age + 10 as AGE_10 from employee where AGE_10 > 50 Answer: This

Question: The table I am using stores date values as strings due to conversion data. The format is 2000-07-01 for July 1, 2000. I need to be able to age

Question: I am writing a SQL statement in Access that is a union query. I am getting an error saying “The number of columns in the two selected tables or

Question: How do I delete a column, and all the values in it? Truncating will delete only the values, not the column itself. And I don’t want to drop the

Question: I need a container of different objects. I have made all derived classes of the same base class and pushed them onto the container. The problem then arises in

Question: What is the SQL command for retrieving the current date? Answer: The GETDATE() function returns the current date and time. Write it like this: SELECT GETDATE() AS CurrentDateCurrentDate —————————

I’ve been trying to find a way to assign helpstrings for Enums in Visual Basic. The Class builder utility does that only for methods, events, and properties, but not for

This is something that expert VB developers know very well, yet every know and then an otherwise perfect VB app stops with a fatal overflow error because of Integer overflow.

Unlike other languages – such as C and Delphi – VB lacks of the capability to increment and decrement a variable. Adding this feature, in the form of reusable Function

‘ Comb Sort an array of any type” CombSort is faster than all but QuickSort and close to it.’ On the other hand, the code is much simpler than QuickSort’

Type SAFEARRAYBOUND cElements As Long ‘ # of elements in the array dimension lLbound As Long ‘ lower bounds of the array dimensionEnd TypeType SAFEARRAY cDims As Integer ‘ Count

Option Explicit’ Class Name : BTree’ Author : John Holfelder’ Date : 17-Apr-2000 12:08 pm’ Description : This class is a way of creating Binary search’ trees. Instead of pointers

Suppose you create a vector and fill it with elements: vector MyVector;MyVector.reserve(20);for (int i=0 ; i tmp(MyVector);MyVector.swap(tmp); The vector temp has the same number of elements that MyVector has. By

One of the common sources for bugs and security risks is using a fixed size char array as a buffer for inputting data. For example: char buff[20];cout > buff; //

The standard C library declares the function calloc() in as follows: void *calloc(size_t elements, size_t sz); calloc() allocates space for an array of elements, each of which occupies sz bytes