‘ Evaluate the number of business days between two dates” Note that it doesn’t take Christmas, Easter and’ other holidays into accountFunction BusinessDateDiff(ByVal StartDate As Date, ByVal EndDate As Date,

While VB Timer functions is sufficiently precise for most tasks, it doesn’t provide the highest possible resolution most modern computer can provide. If your hardware supports high-resolution counters, you can

The Timer control is great when you want to periodically execute a piece of code while the program is doing something else. However, it also has a couple of shortcomings:

The GetTimeZoneInformation API returns a TIME_ZONE_INFORMATION variable that contains several pieces of information about system’s time date and time setting. The first Long value in this structure holds the “distance”

‘ add or subtract a number of business days from a date” Note that it doesn’t take Christmas, Easter and’ other holidays into accountFunction BusinessDateAdd(ByVal days As Long, ByVal StartDate

Question: Can I have multiple line headers on grids? Answer: No, you cannot have multiple line headers on grids in VFP, but you can simulate them by overlapping a shape

Question: I am new to VFP. I want to create a unique number for a customer ID field in a table. The VFP sample program “tastrade” simply uses NEWID() as

Question: I’m getting the first “page” of data from a table and I’m wondering about getting the next page… I’m using the query: SELECT TOP 50 ID, Name, Address, Phone,

Question: Why can’t I run an application like ws-ftp from SQL with xp_xmdshell? ws-ftp will start, but it’s not visible on the screen. Answer: xp_cmdshell runs in the space of

Question: I am using SQL Server 7 and would like to convert an uppercase string to proper case. Is there an easy way to do it? Answer: SQL Server has

Question: What is the best way to backup and/or unload a table and restore/reload to a new dbtable with new extents? Answer: If you have enough drive space, do an

Question: I have code in Visual Basic that allows a user to search the Registry and return a value from the passed key and path. Can you show me a

Question: I have a listbox with two properties called DisabledItemBackcolor and Forecolor. How can I disable single items in the listbox? List.Enabled(ItemID)=.F. disables all items (like the Enabled-Property itself). You

Question: I want to construct an SQL query or stored procedure that will order its result set based on a query parameter. Something like: SELECT *FROM customersORDER BY ? Unfortunately,

Question: How do I combine multiple text fields into a single field? For example, combining someone’s first, middle, and last name into a field called “full name”. I’ve done a

Question: When in production (several users), my Web application starts getting empty cursors when querying the Informix server. I’m sure the ‘right’ results are not empty. Also, I’ve seen, using

Question: How do I create a stored procedure to obtain a substring of a char field from the first “[” encountered until the last-1 character? For example, I have a

Question: How do I set up a field in a table to accept the current date and time? And how do I insert the current time/date into this field? Answer:

Question: I am using Hyperscript Tools for Informix on a Unix platform. To receive the current date and time, the NOW() function is used to get a value between 0

Question: I’ve written several dynamic queries in VB importing a recordset from an Informix DB. The isolation level shows “Committed Read.” Does this place locks on the DB? Answer: Committed

Question: Is there a command in Visual FoxPro 6.0 that is similar to the Microsoft Access “AutoNumber” feature? The field automatically generates a record number for each record. Answer: There

Question: Can I compare the DATE field with Visual FoxPro? How would I structure a query to select all records in a table that had a date value after 02/08/99?

Question: How can we specify in a select statement to get first “n” records from the result set? E.g., select * from employee order by emp_num I just want the

Question: I’m trying to install the of Informix for WinNT and during the process I get error number 126? Answer: Have you rebooted your system after installing the ODBC? It

Question: I am running Informix 7.3 on SCO Openserver 5. I run Ontape every morning and it has been going fine. Starting yesterday I’ve been getting the following error: Archive

Question: What is the advantage of creating temporary tables? Answer: SQL query optimizers, while usually very efficient and accurate, sometimes refuse to evaluate a query in the most efficient manner.

Question: I copied my executable file and the VFP6R.DLL, VFPRENU.DLL, FOXUSER.DBF and FOXUSER.FPT files to my user’s PC. When I try to run it, the screen form flashes and the

Question: When I use the BROWSE command it always displays the results in a normal window. Is there a command to maximize the browse window in the program? Answer: The

Question: Does Informix 9.20 have a memory leak? We’ve doubled our physical memory since upgrading, taken a number of tuning actions, but the product keeps grabbing more memory. No appreciative

Question: How can I implement an alert messaging system (such as a system for instant notification of delays in flight schedules) for WAP-enabled devices? Answer: Most phones have e-mail addresses.