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

Question: Can Exchange Server run with Windows 98 or does it require NT? I want to use Outlook as a common pool of contact information within my office. However, when

Question: We use a GG in the NT domain to assign permissions to Exchange Admin. I have added a backup person to this group, thinking that they would then have

Question: A user on my site clicks to retrieve a URL outside of my site, but the link is dead and the user receives a 404 error. Do you know

Question: One machine on our NT 4 network (using Exchange 5.5 and Outlook 2000) cannot start Outlook. The error message is always along the lines of “Network Problems are preventing

Question: How do I return only the first four lines (a quotation) of a txt-file to my asp-file? Answer: Use the FileSystem Object to open the text file and then

Question: How do I pick out the first letter in a word and convert it to an uppercase? Answer: Use this code: strWord = UCase(Left(strWord,1)) & Mid(strWord,2) This will convert

Question: The code below creates a file, Basket.doc, in the current directory. I am using a compiler with a component I would like to place in fWrite() to let me

Question: I am using VC++ 5.0, and have a base class with several virtual functions. The derived class may/may not implement the function. If it does, it first calls the

Question: I am trying to create an array of 256 hexidecimal values but am havingsome problems. How do I create a valid array using hexadecimals? Answer: Whether you use hexadecimal

Question: I am trying to write a template that somewhat resembles how an inner class works in Java: template class Callback{public: Callback(T& t) : parent(t) { } void Execute() {

Question: Can a constructor in Java be declared as protected? Answer: Yes, Java constructors can be declared as protected. You will usually declare protected constructors when you do not intend

Question: I have a text field in a table that returns the entire field when queried. As soon as I create a view in SQL Enterprise Manager though, the text

Question: Can you tell me if there’s a way that I can force the mouse to move to a certain position on the screen, e.g. 20 pixels down, 15 pixels

Question: What is the future of Informix with Oracle and others seeming to pull so far ahead? Answer: Granted, I am a dyed-in-the-wool Informix bigot, but here’s my take. Disclosure:

Question: How are public folders archived? I have not been able to find a way to set the archival schedule on a public folder. Answer: Public folders aren’t archived, per