‘ 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.

Question: The request.servervariables(“HTTP_USER_AGENT”) method does not seem to return the type of client (e.g., Netscape or Nokia handset) for mobile devices. Is this the correct way to find the type

Question: Do I necessarily need a WAP gateway in order to view WML documents that reside on my Web server, or what is the WAP gateway for? Answer: You don’t

Question: My NT production system is down. Here’s a breakdown: Update terminations, with error Inf -603, commit failed on table rfblg; RDBIF_SQL error on BSEG Running onchecks report BLOB Problems;

Question: I have a user who uses Outlook 2000 with Windows 98 both at home and at the office. In both instances, Outlook 2000 is configured to leave a copy