‘ the Greatest Common Divisor of two integers’ (it uses the Euclide’s algorithm)’ if either argument is zero you get a “Division by Zero” errorFunction GCD(ByVal n1 As Long, ByVal

‘ A random number in the range (low, high)Function Rnd2(low As Single, high As Single) As Single Rnd2 = Rnd * (high – low) + lowEnd Function

‘ number of Combinations of N objects in groups of M” Note: requires the FACTORIAL routineFunction Combinations(ByVal Objects As Long, ByVal GroupSize As Long) As Double Combinations = (Factorial(Objects) /

‘ the Least Common Multiple of two integers’ (it uses the Euclide’s algorithm)’ if either argument is zero you get a “Division by Zero” error” Note: if your app also

‘ The fractional part of a floating-point number’ note that negative numbers return negative valuesFunction Fract(number As Variant) As Variant Fract = number – Fix(number)End Function

‘ Base 10 logarithmFunction Log10(number As Double) As Double Log10 = Log(number) / 2.30258509299405End Function

‘ Return True if the number is primeFunction IsPrime(ByVal number As Long) As Boolean ‘ manually test 2 and 3 If number > 3 Then If number Mod 2 =

Question: I would like to display a “Quote of the Day.” In order to do this, I need to retrieve the numbers of records in a recordset and then randomly

Question: Using VBScript, how can I use the @@Identity SQL Statement to set the keyfield of a record just entered to a variable? Answer: You can issue multiple SQL statements

Question: I’m looking for a copy of snip.exe. This program registers/unregisters components/DLLs under a given directory. Answer: I don’t know about SNIP, but how about an even easier method? Copy

Question: I am trying to back up my server, but there are no freeware products that will save the ACLs off the files on the backup. Tape backup is not

Asking how to select into a variable using dynamic SQL is a frequent question on newsgroups because SQL Server will not let you select into a variable using the EXEC()

Question: Does it make a difference in placing an OUTER or simply a JOIN or a WHERE? Using WHERE: select tb01_field01,tbl01_field02 from tb01,tb02 where tb01_field01 = tb02_field01 Using JOIN: SELECT

Question: Is there any way to recover e-mails deleted from Exchange through Outlook 2000? Answer: Yes, if you have Deleted Item Recovery enabled. If you do, you should see a

Question: What file extensions do I need to copy to a NT Workstation in order to install the Exchange Administrator Console? Answer: Let’s not make life any more difficult than

Question: Does Informix have a function that converts datetime chars for numbers? Answer: Datetime is stored internally as an integer that represents the number of seconds from a certain starting

Question: In Access, I can get the date that was this day of this week a year ago (i.e., if today is Monday, 5/15/00, a year ago was Monday, 5/17/99)

Question: I am writing a SQL statement that dynamically dumps the databases on the SQL servers. However, when I run the procedure as a stored procedure it falls out of

Question: I am using VB6 with ADO 2.1. I am trying to insert a date value into a column that is of the Date datatype. I am receiving a date

Question: Does Informix keep a log of runtime errors? If it does, where can I find it? Answer: Yes. It’s probably in your $INFORMIXDIR, but it does not have to

Question: Can I find information regarding the user and 4GL program or process that is locking an SE database record? I am using SE 5.08. Answer: I’m not sure about

Question: How do I find the top n records within a table for version 7? I have seen some similar SQL queries but cannot adapt them to version 7. Answer:

In the olden days, the use of floating point numbers imposed a significant computation and speed overhead compared to integer arithmetic. For this reason, many optimization guidebooks and IT veterans

A CPU cycle is roughly equivalent to the time needed for performing one instruction. On modern CPUs, a cycle takes about a nanosecond. In other words, a Pentium III 900

Although the Standard Library doesn’t define functions that convert Fahrenheit degrees to Celsius degrees and vice versa, you can implement them by yourself. These functions are particularly useful in localization

Some applications have special memory requirements. For example, they allocate large amounts of memory at once and then use it in parts, or they allocate only objects of the same

Many believe that a byte is by definition, an eight-bit data unit. Technically, this definition isn’t correct. A byte is a data unit with an unspecified number of bits. Indeed,

Question: I know there are two ways to insert a new record. One way is to execute a Insert statement, the other way is use the recordset.AddNew method. In terms

Question: I am developing a s/w with an Access database, using ADO. Now, I want to search a table with multiple columns. As in find method (ADO), it allows only

Question: I hope you can help me. My company is looking for training classes for XML on the West Coast (preferrably Portland, Seattle, or San Francisco area) I have been