devxlogo

Tip Bank

ODBC Installation

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

Multiple Line Headers on Grids

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

SP to Obtain a Substring

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

Implementing Push Technology in WAP

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.

Comparing Date Fields

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?

Auto-Incrementing Key Field

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

Determining the Client

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

Committed Read Isolation Level

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

Asset Failed: Slot 1 Not Free in Page

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;