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