Tip Bank

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: 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: 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: 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: 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: 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: 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: 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 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